Finance | Project Operations, Human Resources, ...

Validation to update during import - DMF (Data management)

(1) Share

Report

Posted on by RSX

204

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?

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Martin Dráb 240,171 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

CL365JB2024 26 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No