[ic] Import orders from external data

Stefan Hornburg racke at linuxia.de
Sat Oct 30 04:20:27 EDT 2004

On Fri, 29 Oct 2004 17:13:15 -0400
DB <DB at M-and-D.com> wrote:

> In addition to the normal orders from my IC site, I also get orders from 
> an external non-IC source. These order contain all the info I need such 
> as name, address, items, payment info etc. They arrive in XML format, 
> but I can easily extract the data to some type of text format.. tab 
> delimited for example.
> I'm running 4.8.9 but will soon be upgrading to 5.2 or whatever is 
> current when I get around to upgrading.
> What would be the best way to convert these external orders into normal 
> orders in my IC site? I could import the data into the transactions and 
> orderline tables, but what about generating the order numbers? Any 
> advice or existing code?

Either you can use a script for the import or an Interchange job.
For generating order numbers you can use the same mechanism as 
Interchange (counter files) or switch Interchange to use MySQL's auto
increment for generating order numbers:

Route default sql_counter "transactions:transactions (code)"


LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

More information about the interchange-users mailing list