Question

How to use reference between two entity in ExcelImporter?

1

While I am importing the Data with Excel Importer there is reference between two entity say salesQuotes_Customer but while importing the data, the table is not filled with he entries.How to solve this problem ? or How to use references from the Excel Importer module?

asked 2014-11-26

Md Naqui Qureshi

1 answers

Ronald Catersels · Answer 1 · 2014-11-26

In the template you can set the reference that needs to be set. You do have to define how to find the referenced object. So let's say you import salesQuotes. Then there needs to be an ID in the Excel line you are importing that can be used to retrieve the Customer. So if each row has a CustomerID that is available in the table Customer, this can be used to retrieve the parent and the reference can be set.

Hopes this helps,

Regards,

Ronald