Skip to Content
0
Former Member
Jan 07, 2015 at 06:19 AM

import into multiple tables

280 Views

Hi

Can we import into multiple tables through a single impex data line ? For example, I have an order with multiple tracking numbers (one for each line) and I want to do something like below:

INSERT Order;orderId;trackingNumbers; ;12345;DHL12345#DHL12346;

Order to Tracking number is a one to many relation in items.xml.

I understand that collection delimiter cannot be used here because trackingnumber has its own table called TrackingNumber and the above 2 DHL values should be inserted into this table.