Log in to AnswerLog in to Follow
UserImage.jpg
ujwala
11Views
6Comments
Solved
foreign key reference from excel
Question
14 Days of OutSystems

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


0
0
21 Jun

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

0
0
21 Jun

Please find the attached sample OML.

ExcelBootStrapSample.oml

0
0
21 Jun

Sample Excel File

Category.xlsx

0
0
21 Jun

Replying to Vinod Patidar's comment on 21 Jun 2022 09:53:56

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.

0
0
21 Jun

Hi Ujwala,

First You need to delete all records from entity. 

Thanks

Vinod

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