[ic] need help exporting orders

DB 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?
>>>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


More information about the interchange-users mailing list