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)Why do all this page renaming? A more efficient solution would be to put a pair of showif and hideif contexts into the entry.tpl page that will display the normal entry.tpl page content when there's nothing in the upload-folder, and perform the four steps below, when there *is* something in that folder:1- Display Databases updating, try again in a minute ...2- Use [closedatabase] to close the database that's being updated3- Use [copyfile] to copy the original db file to a backup folder, setting the name to date and time.4- Use [movefile] to move the new file to its correct position and set the name to the original db name, thus replacing the original db file with the newly-uploaded replacement db file.Of course, there's a lot more to it than this, especially if there's more than one database that needs to be replaced in this manner. But for a single customer with a single database, it will work fine -- assuming that the customer actually uploads a properly formatted database file and not something else ... :)Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Kenneth Grome
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:
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
Loosing Quantity (2000)
emailer (1997)
Change to 5.0 per website licensing (2003)
Yet another frames Question (1999)
Mac webcatalog3_0_5b11 more dead lock throws (1999)
Progress !! WAS: Trouble with formula.db (1997)
UPDATE PROBLEM (1997)
emails sent twice (2001)
Email Formatting and Encryption (1998)
There's a bug in the math context ... (1997)
document contains no data (1999)
Followup question re: checksum for credit cards? (1997)
[CART] inside a [LOOP] (1997)
Searching multiple Databases (1997)
[ShowCart] and GET vs. POST (1997)
Generating Report Totals (1997)
[dos] command and [math] (1998)
ErrorMessages.db suggestion (1997)
How To question on setting up downloads (1997)