Validation to update during import - DMF (Data management)

(1) Share

Report

Posted on by RSX

124

Hi,
I have a grid and four fields in it - id, name, comments, once I select the id. The name and comments auto populates from the master form.

Now, I have created an data entity for that table, My requirement is if I'm importing the excel sheet with only column of id, it should check from the master form and auto populate the name and comments during import.
Where should I update my code in data entity, what is the approach I should follow here?

Categories:

Development / Customization / SDK

All responses (3)

Answers (0)

Suggested answer

Juan Bravo V. 24 on at

Like (1)

Report

Validation to update during import - DMF (Data management)

The logic that you applied in your UI Form shall be also included in the entity you have created, I assume this entity will only contain the ID, and a reference to the other tables. if so, the logic applied in the UI form shall be considered if you want to Import from DMF.

Br,

Juan
Bharani Preetham Pe... 3,495 Super User on at

Like (0)

Report

Validation to update during import - DMF (Data management)

Agree with Martin. If you try to write some code in mapentitytodatasource it will work but this will cause duplicate records. I would ask you to give us full understanding here.
Martin Dráb 223,212 Super User on at

Like (0)

Report

Validation to update during import - DMF (Data management)

Are you sure that you want to duplicate Name and Comments in the non-master table? If the data changes in the master table, the other table will still contain the old values (e.g. the deprecated name). It may be what you want, but it also may be a bug in your design. Maybe you should keep just ID in the other table and get Name and Comments by joining with the master table.