[ic] need help exporting orders

AirDelights.com airdelights at earthlink.net
Thu Jul 29 12:51:14 EDT 2004


Can you email me your code for the export DB?
steve at airdelights.com

----- Original Message -----
From: "DB" <DB at M-and-D.com>
To: <interchange-users at icdevgroup.org>
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
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>



More information about the interchange-users mailing list