Re: Filemaker Pro & Webcatalog
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 25109
interpreted = N
texte = We built a point of purchase system for a group of art galleries. The system contains the full inventory of all their works of art for each location.Nightly, the system in Cleveland and the system in Seattle have the data and images extracted from them and imported into the master system in Columbus. Data is exported from the master system and moved to our webserver to update the inventory data on their website.The importing and exporting on site is done with applescript and triggered by cron. The moving of the files is done with Retrospect. And on the web server a Webcatalog trigger loads a .tpl page that checks for the new data, copies and renames (with the date) the old database, closes the old database and replaces the data with the new data.Images are batch processed and named appropriately with Debabelizer.This requires no manual interventions and was built with a number of warning signals that would send out email to the administrator if the data file was not found or was not of an appropriate size or if the files had the wrong modification date, etc.WebCatalog is an excellent tool for doing a wide variety of tasks, but you can get some extraordinary results when combining it with other tools.Of course you can use FTP to move your files, but you might already have Retrospect for backups. It's a snap to script it to move files around for you over the net automatically -- and its fast!Unless the routine changes from one day to the next, you should be able to automate every aspect of it.Paul>I am developing a solution for one of our clients that uses Filemaker >Pro in house to automate their work flow. They would like to up date >thier Webcatalog database in 'batches' at intermittent intervals, from >once a day to once a week. They also can only connect at 56k. The have >30 odd different databases to maintain. > >There 'IS person' would FTP a file exported from FileMaker that would >end up as an [include] file with a [replace &append=T] context and all >the properly formatted code for such a function. > >Once they uploaded the include file(s) to a designated folder they would >go to a web page with a [listfiles] context of that folder. They could >then use radio buttons to choose which files to [append] and submit that >to a page that would include those file(s) and of course execute them. > >That page that would execute the include files would loop through them >until all were updated then move those [include] files to an other >folder as an archive. > >Does anyone have a better idea? Has anyone had to do this? > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to
. > >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Interactive Ink, Inc._\_\_ \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business - _\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\_ _/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
We built a point of purchase system for a group of art galleries. The system contains the full inventory of all their works of art for each location.Nightly, the system in Cleveland and the system in Seattle have the data and images extracted from them and imported into the master system in Columbus. Data is exported from the master system and moved to our webserver to update the inventory data on their website.The importing and exporting on site is done with applescript and triggered by cron. The moving of the files is done with Retrospect. And on the web server a Webcatalog trigger loads a .tpl page that checks for the new data, copies and renames (with the date) the old database, closes the old database and replaces the data with the new data.Images are batch processed and named appropriately with Debabelizer.This requires no manual interventions and was built with a number of warning signals that would send out email to the administrator if the data file was not found or was not of an appropriate size or if the files had the wrong modification date, etc.WebCatalog is an excellent tool for doing a wide variety of tasks, but you can get some extraordinary results when combining it with other tools.Of course you can use FTP to move your files, but you might already have Retrospect for backups. It's a snap to script it to move files around for you over the net automatically -- and its fast!Unless the routine changes from one day to the next, you should be able to automate every aspect of it.Paul>I am developing a solution for one of our clients that uses Filemaker >Pro in house to automate their work flow. They would like to up date >thier Webcatalog database in 'batches' at intermittent intervals, from >once a day to once a week. They also can only connect at 56k. The have >30 odd different databases to maintain. > >There 'IS person' would FTP a file exported from FileMaker that would >end up as an [include] file with a [replace &append=T] context and all >the properly formatted code for such a function. > >Once they uploaded the include file(s) to a designated folder they would >go to a web page with a [listfiles] context of that folder. They could >then use radio buttons to choose which files to [append] and submit that >to a page that would include those file(s) and of course execute them. > >That page that would execute the include files would loop through them >until all were updated then move those [include] files to an other >folder as an archive. > >Does anyone have a better idea? Has anyone had to do this? > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to . > >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Interactive Ink, Inc._\_\_ \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business - _\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\_ _/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Paul Uttermohlen
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:
problem with [Format Days_To_Date] (2000)
Negative Range Error (2003)
Export database record - append to other database (2005)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
can WC render sites out? (1997)
[WebDNA] Re-sending emails (2017)
Why no lf in grep? (2004)
html delivery (1997)
auto adding SKUs w/DB helper (1998)
WebCatalog occasionally stopping (2001)
problems with 2 tags shakur (1997)
RE: [WebDNA] IF statement evaluation bug report, WebDNA 8.5.1 (2019)
File upload (2002)
WebCat editing, SiteGuard & SiteEdit (1997)
using listfiles to build a database? (2000)
Carraige returns [sendmail] (2004)
Weird Math and SV (1997)
Any limit to [include] (1997)
Remote Administration (1998)
Some pointers please (2008)