Can you email me your code for the export DB? suppressed ----- Original Message ----- From: "DB" <suppressed> To: <suppressed> Sent: Thursday, July 29, 2004 9:39 AM Subject: [ic] need help exporting orders > > At 05:55 AM 7/28/2004, you wrote: > >>>Looking for a simple way to export orders out of interchange and into excell > >>>or access. Does anyone have any suggestions or links to instrunctions on > >>>how to do this? > >>>thank you, > >>>steve at airdelights.com > >> > >> > >>I use a perl script to extract transaction and orderline data into a > >>pipe-delimited text file which I then import into a spreadsheet. I'm sure > >>much better ways exist but this does the trick for me. I can share if > >>anyone wants (and promises not to laugh at the code). > > > > Why don't you just use the export features of Interchange? > > > > The admin UI can export tables as PIPE delimited text files or > > you could export tables as XLS spreadsheet. > > > > No need to write any code for it. > > > > > > Best regards, > > > > Ton > > > > -- > > Alamerce Nederland --- Cornerstone of eBusiness > > Phone +31-40-2374381 info at alamerce.nl http://www.alamerce.nl > > > > eCommerce Solutions -- Consulting -- Website & Interchange Hosting > > I wanted to import each item from orderline along with the info from > each transaction, all in one row for each order... that's what the code > does. I saw no builtin way to do that > > DB > _______________________________________________ > interchange-users mailing list > suppressed > http://www.icdevgroup.org/mailman/listinfo/interchange-users > _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.