Re: FileMaker and WebCat
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23135
interpreted = N
texte = >Probably a very dumb question... > >One of my clients runs their back office on FileMaker from where I get the >data to drive their website - running out of Webstar and WebCatalog. > >I have a pretty clunky way of transferring this data and I wonder if anyone >has a better idea? > >I export out of FileMaker into a tab delimited text file, which I then open >in a text editor where I add a header containing the field names. I save >this as the data table which WebCatalog reads. > >FileMaker does not appear to have any export options which can be read >directly by WebCatalog without this process. > >Julian ClaytonWell, I have been working with a similar problem myself. I have a huge multiuser Filemaker solution that is exporting tab-sep .db files. I have first set up a script in Filemaker that exports all the fieldsI I need (at the time being). Then this tab sep file is imported into another filemaker database that has all the hdr names set at the first record). All imported files will be added from record 2 to 5000 etc. Then this is again exported to a tab-sep file with the correct name set to the file and moved by retrospect to the webservers directory for the .db files. After the export is done, I have a script that searches for the record that has the word SKU set in the SKU field (all other values for the proper records are 13charachter EAN-numbers parsed with a countryspecific code (.uk,.de, etc so there will be no risk of mixing header data with product data). Then the script omits the found record (actually the starting record) and deletes all other records. This way this database is cleaned for everything except the header data. This procedure has run several times each day for 8 months now without any trouble.
Associated Messages, from the most recent to the oldest:
>Probably a very dumb question... > >One of my clients runs their back office on FileMaker from where I get the >data to drive their website - running out of Webstar and WebCatalog. > >I have a pretty clunky way of transferring this data and I wonder if anyone >has a better idea? > >I export out of FileMaker into a tab delimited text file, which I then open >in a text editor where I add a header containing the field names. I save >this as the data table which WebCatalog reads. > >FileMaker does not appear to have any export options which can be read >directly by WebCatalog without this process. > >Julian ClaytonWell, I have been working with a similar problem myself. I have a huge multiuser Filemaker solution that is exporting tab-sep .db files. I have first set up a script in Filemaker that exports all the fieldsI I need (at the time being). Then this tab sep file is imported into another filemaker database that has all the hdr names set at the first record). All imported files will be added from record 2 to 5000 etc. Then this is again exported to a tab-sep file with the correct name set to the file and moved by retrospect to the webservers directory for the .db files. After the export is done, I have a script that searches for the record that has the word SKU set in the SKU field (all other values for the proper records are 13charachter EAN-numbers parsed with a countryspecific code (.uk,.de, etc so there will be no risk of mixing header data with product data). Then the script omits the found record (actually the starting record) and deletes all other records. This way this database is cleaned for everything except the header data. This procedure has run several times each day for 8 months now without any trouble.
Stein Grebstad
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:
Caching [include] files ... (1997)
Duplicate Carts (2000)
delete after x (1998)
Getting real time CC's out of Australia (1998)
Nested vs conditional (1997)
Multiple Ad databases? (1997)
Multiple Stores and WebCatalog Prefs (1997)
OLD ORDERS (1998)
Using [Showif] tag. Mac (1997)
A little syntax help (1997)
multi-paragraph fields (1997)
Error: could not create email file in EMailFolder. Folder may (2003)
Bug: MySQL WebDNA 6 int bigint fail case (2004)
Emailer (1997)
[WebDNA] add hours over 24 (2014)
A question on sub-categories (1997)
Nested tags count question (1997)
[Sum] function? (1997)
mod_webcatalog2.so (2003)
problems with 2 tags (1997)