Import data from excel with foreign key

I'm trying to import data from an excel table but with no success.

I have these 3 entities:

1. Entity Module (whose data I want to import)

2. Static entity Product (with 2 records: House, Family)

3. Static entity Level (with 3 records: High, Medium, Low)

Module has the following columns/attributes:



 Product -> reference attribute: Product identifier

 Level -> reference attribute: Level identifier

How can I import/bootstrap data from Module.xls and set attributes Product and Level as 'foreign key'?


Kind regards,


Hi Maria,

Create those two FK columns as Integers in the Module entity and bootstrap data from the excel. 

Right click on entity --> Advanced --> Create action to bootstrap data from excel

Once data is imported from excel, update the data type of these two entity attributes to the static entity identifiers.




Hi Maria,

see below post with solution - 

Hope this will help you.


Rahul Sahu

@maria- I am new too and tried simulating the solution. i checked the below link. 

Bootstrap foriegn keys.

Check if this helps

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.