Importing data in header and line table

mkpjsr

hi experts

how to import data in sales header and sales line table using a single csv excel file.

means importing data into two different header and line table from a single excel sheet using single dataport

plz guide me the steps.

kamel.hedi

Hi,

1. In the dataport, you should have 2 DataItems :
DataItem Name
Sales Header <Sales Header>
Sales Line <Sales Line>

2. In the Properties of dataport, set :
DataItemSeparator : <<NewLine><NewLine>> (It's the default value)

3. Your file csv should be like this : (Header and Line are separated by <<NewLine><NewLine>>)

Order 6001 49525252 Beef House
Order 6002 49525252 Beef House

6001 10000 Item 1908-S VERT Chaise dactylo LONDRES, bleue
6001 20000 Item 1906-S VERT Socle mobile ATHENES
6001 30000 Item 80100 VERT Papier d'impression
6002 10000 Item 1964-S VERT TOKYO Gastestuhl, Blau
6002 20000 Item 1996-S VERT Tableau ATLANTA, socle
6002 30000 Item 80100 VERT Papier d'impression