XMLPORT import sales header with lines

kenneth73

Hi

I have to import a flat file like this into sales orders :

1014;5700199142530;1
1014;5700199142547;8
1014;5700199285695;2
1231;5700199142646;2
1240;5700199142547;1
1240;5700199142561;2
1241;5700199142615;3
1245;5700199142615;3
1245;5700199142646;1
1245;5700199285695;1
1268;5700199142646;1
1240;5700199142615;6
1240;5700199142622;1
1240;5700199142707;1
1241;5700199142622;1

Customer;EAN(ItemNumber);Qty

It have to create 1 sales order per customer. With lines (EAN;QTY)
Like you can see, for example 1241 appears 2 times, but not together.

Have someone a tip for how to handle this. ( Best Practice )

THANKS...

davmac1

I would read the lines without validation into a temp table, then sort them by customer no., and process the file, doing the validation then.
For each new customer, create a new sales header.