foreign key reference from excel

Hi,

Can anyone explain the foreign key bootstrap from excel,

I have referred couple of posts for excel import of tables having relation but could not get how to import that .


Regards


Hi Ujwala,

For Foreign Key Relationship you need to modify Bootstrap Server action. Using Aggregates you can get Id of related tables and while creating new records you can assign Id from Aggregates.

Thanks

Vinod

Please find the attached sample OML.

ExcelBootStrapSample.oml

Sample Excel File

Category.xlsx

Hi Vinod,

I have imported both excel as related column as text (category name),

Have chenged the bootstarp but after that changed the category as FK (identifier in product),Got the below error.

Hi Ujwala,

First You need to delete all records from entity. 

Thanks

Vinod

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