On Fri, 29 Oct 2004 17:13:15 -0400 DB <suppressed> 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)" Bye Racke -- LinuXia Systems => http://www.linuxia.de/ Expert Interchange Consulting and System Administration ICDEVGROUP => http://www.icdevgroup.org/ Interchange Development Team _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.