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:
WebCat 5 on itools 7 Install Questions Problems Hey Nitai (2003)
[UPPERCASE] (1997)
Extra carriage returns (1999)
[WebDNA] Listfiles and sort order (2010)
[LOOKUP] (1997)
Hummm .... (2002)
talk list (2000)
# fields limited? (1997)
searchable list archive (1997)
Bug? (1997)
form data submission gets truncated (1997)
multi condition with showif (2005)
Configuration Q (1998)
Frames and WebCat (1997)
[WebDNA] Putting '&search' into URL killing all search contexts on my sites (2010)
[OT] 'Email this story to a friend' (2003)
HomePage Caution (1997)
[OT] Multi - Language (2007)
PCS Customer submissions ? (1997)
Can't add a field (1998)