Re: Somewhat Dynamic HTML
Re: Somewhat Dynamic HTML
- Subject: Re: Somewhat Dynamic HTML
- From: has <email@hidden>
- Date: Thu, 7 Mar 2002 13:00:20 +0000
Landis wrote:
>
I've got an Excel spreadsheet that I'm thinking of turning into a
>
Filemaker Pro database. But either way it's got data in it that I'm
>
hoping to put on the web.
>
>
I have a website that has many pages that are almost identical with
>
pictures from different area of North America. So in my spreadsheet
>
(for example) I've got a region, a state, an area:
>
>
West, California, San Francisco Bay Area
>
>
But I need to make relative links to all the other areas, and all the
>
other states and regions. And I'd like to be able to easily add more
>
pages to it later, or be able to easily change the template and
>
remake the whole site.
>
>
I don't have access to the server so I need to create static HTML
>
pages. No running Filemaker Pro Server, or Cold Fusion. Is this
>
possible in AppleScript? Am I in over my head? Is there something
>
out there that can do this already? Would I be reinventing the wheel?
I believe there's a low-cost commercial app that can publish static pages
from a FMP database - can't remember the name offhand (I've seen posts
mentioning it appearing on macscripter.net's front page a number of times,
and I'm sure a Google search'd find the site simply by using those
keywords). Whether or not it'd be powerful enough for you I dunno though;
it looked pretty basic (though maybe the next version will be more
powerful).
Also, iirc the Manilla CMS supports static, in addition to dynamic,
publishing. Much more powerful, a bit more expensive. I'm sure the Frontier
users on this list can tell you more about it than I can.
--
As for AppleScript solutions, I've written a template-based renderer called
AWPS primarily for static webpage rendering. It's pure AppleScript, OO,
very flexible and requires no 3rd-party additions. It's got a very friendly
and easy-to-use templating system, and it should be pretty nippy too (at
least in AS terms, though I haven't done much speed testing/optimisation
yet).
Basically it's a framework into which you add your own AS code to drive it;
if you already know AppleScript and can read a simple setup manual [to be
completed], you're sorted. If you're already competent at application
scripting then I don't think you'd have much trouble hooking it up with
your own Excel/FMP scripts.
You can find a really simple demo at:
http://www.barple.connectfree.co.uk/
It's not really finished, but aside from fixing a [minor] bug and testing
it on different AS versions it seems to work just fine. Besides, I'm sure I
could be prodded into finishing it off if someone were actually interested
in using it...:)
HTH,
has
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.