[ic] need help exporting orders
DB at M-and-D.com
Thu Jul 29 12:39:03 EDT 2004
> 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?
>>>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,
> 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
More information about the interchange-users