Re: Converting order file to database

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16303
interpreted = N
texte = >I know that >the Completed Orders folder is already in tab delimited format - but how >do I automatically append these orders to one tab delimited file that I >can then search using WebCatalog commands?The order files are tab-delimited, but not in a format that is suitable for a database, because the first line is very different from the subsequent lines. You can put some WebDNA into your ThankYou.tmpl page that stuffs all the header information into one database, and all the lineitem information into a related database. You would use embedded [Append] contexts to accomplish this.If you want something more sophisticated that works with the files after WebMerchant has dealt with them, let me know privately and we can arrange to write something for you on a consulting basis.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Converting order file to database (Grant Hulbert 1998)
  2. Converting order file to database (Kelly Grady 1998)
>I know that >the Completed Orders folder is already in tab delimited format - but how >do I automatically append these orders to one tab delimited file that I >can then search using WebCatalog commands?The order files are tab-delimited, but not in a format that is suitable for a database, because the first line is very different from the subsequent lines. You can put some WebDNA into your ThankYou.tmpl page that stuffs all the header information into one database, and all the lineitem information into a related database. You would use embedded [append] contexts to accomplish this.If you want something more sophisticated that works with the files after WebMerchant has dealt with them, let me know privately and we can arrange to write something for you on a consulting basis.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Grant Hulbert

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:

Quick ShowIf question (1997) Unable to open the demo file (1998) [WebDNA] Ubuntu 14.04 & WebDNA (2017) CMSBuilder (2004) Configuring E-mail (1997) Formulas.db + Users.db (1997) WebCat and MySQL (2004) Exclamation point (1997) Trouble with carts (2000) Quick Question About Sorting (1997) Autoreturn Submit? (1997) Nested tags count question (1997) Emailer and encryption (1997) Sending mail (was forms and variables) (1998) Automatic Forwarding using WebCat (1997) Country & Ship-to address & other fields ? (1997) [WebDNA] remove html comments (2009) [OT] - HTTP_REFERER (2004) Domain serial issue (2008) Trouble with formula.db + more explanation (1997)