changed the universe:> I would like to be able to send a commit and close event to WebCatalog > from an AppleScript process. We want our customer to be able to FTP an > updated database, file exported from Filemaker Pro, whenever they get new > information from their sources.Why with Applescript? You can let your customer upload into a special folder and check this folder with WebCat for the existence of a file, whenever a user enters the shop. I am currently working on a procedure which lets my customer upload a new database at any time with any name and blocks the access for all users while the update is running. I used this kind of stuff already with 4D-databases, here is the workflow:If a user enters the shop and an uploaded file is present in the upload-folder: #1 rename the original start-template to entry.tpl_disabled #2 rename a predefined warning-page from entry.tpl_update to entry.tpl #3 send this page, it says Database gets updated, try again in a minute. (any user gets now THIS entry.tpl while it is active...) #4 close the database #5 move it to a backup-folder, set the name to date and time. #6 move the new file to its correct position (and set the original name). #7 rename the warning-page to entry.tpl_update #8 rename the original page back from entry.tpl_disabled to entry.tpl (from now on users get the right entry page again)This is reliable and fast, a customer can use any filename and does not see other files in the shop.Here is an example for the file organization: ---------------------------------------------------------- MyShop => root of the shop template1 template2 templateX entry.tpl => your entry page entry.tpl_upload => your warning-page Products.db => your active database ProductsUpload => ftp-folder for the customer newprices.txt => uploaded file, any name ProductsBackup => folder for old databases 26.05.98_12:31:26.txt => old database 13.05.98_16:21:11.txt => old database 02.04.98_23:05:08 .txt => old database ----------------------------------------------------------If your customer is merely skilled you can give him ftp to the backup folder too - if something goes wrong with the update, he can download the last backup (I believe, he cannot find it right now ;-) and upload it again. And if you want a sophisticated solution you can even make him an admin-interface to shuffle files and a panic-button which restores the most recent database before the last upload...Anyway - the new WebCat plugin does not need AppleScript. You should turn off AppleScript on your webserver, for security and performance... Peter __________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21
Peter Ostry
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
New public beta available (1997)
[OT] DOD again (2003)
re:check boxes (1997)
Separate server for jpg/gif files (1998)
WebCat2final1 crashes (1997)
RE: error count with $purchase (1997)
Gold on the list ... Was Authorize.net? (2003)
[isfolder] and [filename] (1997)
RE: IIS4b2 and WebCatalog b19 (1997)
https validation (2001)
My solution... (1996)
international time (1997)
[isfolder] and [filename] (1997)
Special characters & [sendmail] (1998)
Pgp&emailer (1997)
writing db to disk (1997)
serial number (1998)
TeaRoom (1997)
Date Bug (1998)
Creating main- and sub-category search (1997)