[ic] need help exporting orders

[DB <suppressed>]

> 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