[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[ic] How to create delimted text file for each order


Hi - I spent some time searching the archives and docs but I'm still in
need of some help. I'm running IC 5.4.0

When an order is placed, I'd like to have a tab-delimited text file
created and stored on the IC server with the order number as the
filename (for example 1000.txt). The file should use following format
where {tab} and {lf} indicate where I want tabs and newlines to be.
Obviously this file contains data from both the transactions and
orderline tables.


order_number{lf}
fname{tab}lname{lf}
sku_1{tab}qty_1{lf}
...
sku_n{tab}qty_n{lf}
order_total{lf}


This is a very simple example, but if I could see how to do this then
I'm sure I could build on the example to include more information in the
file. Any hints are welcomed!

DB
_______________________________________________
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.