Re: filemaker - orderfile
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12973
interpreted = N
texte = >This is a bit off topic but I was wondering how I can merge the orderfile >to Filemaker pro db and have the H and L imports be seperateFileMaker cannot deal with that. I suggest that you do an [appendfile] to 2 separate files at the time of $Purchase (on the ThnkYou.tmpl page). You would write all the header information to 1 file, and the lineitems information to another. As each order comes thru, you are basically building a related database. Then when you want to get everything into FileMaker, you would import both databases and create a portal between them.Another way to do it is to use [ListFiles] to grind thru all the order files in your Completed folder, and use [OrderFile] to get at the information in each order, then write it all out to the 2 related FileMaker files.The following is off the top of my head and untested, but it's the idea:[WriteFile Headers.txt]Order date time name phone ShipToCountry [/WriteFile] [WriteFile LineItems.txt]Order sku quantity price textA unitShipCost [/WriteFile][ListFiles CompletedOrders/] [OrderFile CompletedOrders/[FileName]] [AppendFile Headers.txt][FileName] [date] [time] [name] [phone] [ShipToCountry] [/AppendFile] [LineItems] [AppendFile LineItems.txt][FileName] [sku] [quantity] [price] [textA] [unitShipCost] [/AppendFile] [/LineItems] [/OrderFile] [/ListFiles]After you hit this template, there will be 2 files containing all the order information, related by the Order field (which stands for Order# or perhaps cart). Each time you hit this template, it erases the old related files and creates new ones from whatever order files exist in the CompletedOrders folder. If you own WebMerchant, you should use CompletedOrders/ and if you only own WebCatalog you should use Orders/ instead.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>This is a bit off topic but I was wondering how I can merge the orderfile >to Filemaker pro db and have the H and L imports be seperateFileMaker cannot deal with that. I suggest that you do an
[appendfile] to 2 separate files at the time of $Purchase (on the ThnkYou.tmpl page). You would write all the header information to 1 file, and the lineitems information to another. As each order comes thru, you are basically building a related database. Then when you want to get everything into FileMaker, you would import both databases and create a portal between them.Another way to do it is to use
[listfiles] to grind thru all the
order files in your Completed folder, and use
[orderfile] to get at the information in each order, then write it all out to the 2 related FileMaker files.The following is off the top of my head and untested, but it's the idea:[WriteFile Headers.txt]Order date time name phone ShipToCountry [/WriteFile] [WriteFile LineItems.txt]Order sku quantity price textA unitShipCost [/WriteFile][ListFiles CompletedOrders/] [OrderFile CompletedOrders/[FileName]] [AppendFile Headers.txt][FileName]
[date] [time] [name] [phone] [ShipToCountry] [/AppendFile]
[lineitems] [AppendFile LineItems.txt][FileName] [sku] [quantity] [price] [textA] [unitShipCost] [/AppendFile] [/LineItems] [/OrderFile] [/ListFiles]After you hit this template, there will be 2 files containing all the order information, related by the Order field (which stands for Order# or perhaps cart). Each time you hit this template, it erases the old related files and creates new ones from whatever
order files exist in the CompletedOrders folder. If you own WebMerchant, you should use CompletedOrders/ and if you only own WebCatalog you should use Orders/ instead.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 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:
[WebDNA] Succesfull migration from WebDNA/AppleServer to WebDNA/Apache (2018)
WebStar Secure on other machine (1997)
Admin Edit prob. (1997)
Webstar 1.3.1 PPC (1997)
Generating unique SKU from [cart] (1997)
[WebDNA] Froala Editor working with WebDNA (2016)
Error 11 (1996)
Subtotal Not Calculated on Invoice.html (1998)
How many Databases can I open? (2003)
[WebDNA] CMS in WEBDNA (2009)
Mozilla/4. and Browser Info.txt (1997)
using showpage and showcart commands (1996)
enhanced ErrorMessages.db (2002)
Showif, Hideif reverse logic ? (1997)
Upgrading old WebCat Database Files (1997)
Kaaaaahhhhhhhnnnnnnn! (1997)
.. more on sliding discounts... (1997)
WebCat2b13MacPlugIn - [include] (1997)
Add more fields to an existent data base (1997)
User/pass with tcpconnect (2000)