Question

How to insert multiple records to 1 to many association entity, using CSV import

0

Hi All, I am importing CSV file to mendix entity using CSV import java action. Out of 100 columns in a CSV file I have to insert 75 columns as 15 (5*15) records to an associated object and remaining to main 25 columns to main entity. Parent entity have One to many association with child entity. How to achieve this. Thanks in Advance!! Surya.

asked 2021-10-19

Suryanarayana Vundru

1 answers

Kshitij Karandikar · Answer 1 · 2021-10-20

Use the child entity as the Mendix object for import.

In the column(s) where you need to import to the main (parent entity), use following settings in column details :
Type - Reference
Reference - The association between parent and child
Object type - The parent entity
Attribute - The attribute you want to import the column data into

Make sure you have atleast one column from the main entity to be unique and can be used as key. You can do this by choosing Key - Yes, only for associated object. This would prevent duplicates in the main entity to be created on import.