Data Management - Import Scenario - Log Analysis

(0) Share

Report

Posted on by Aparisi82

2,188

Good afternoon dear experts

the scenario is that I am importing 282 records using Data Management and using a standard data entity.

The import is successful and according to the import, D365 states that 78 records have been created and the rest updated.

If I look at the staging table, it tells me that all 282 records have been imported without error as the status is "Completed" however there is no indication on the staging table of which records have been created and which ones have been updated directly from this job without workarounds such as database log or exporting the same data entity before and after the upload?

Now, how would I identify the 78 records created?

I have the same question (0)

All responses (6)

Answers (1)

André Arnaud de Cal... 300,731 Super User 2025 Season 2 on at

Like (1)

Report

Hi Alessandro,

If the table has the property createddatetime enabled, you can recognize the created records by this field. Data Management Framework itself does not maintain this information.

What is the (business) reason that you want to know the records which got created?

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hi Alessandro Parisi,

In addition to what André mentioned, you will know and can compare what are the new records that is imported is by taking a copy of entire existing records from the form before you do the import. This is from functional side

Regards,
Sourav

Was this reply helpful? Yes No
Aparisi82 2,188 on at

Like (0)

Report

Control on importing the file and understanding what is created and what is updated.

Was this reply helpful? Yes No
Aparisi82 2,188 on at

Like (0)

Report

As mentioned in my post this is not what I would like to do. The same table could be updated by other users in the meantime I run the import and the count therefore compromised.

I find the data management import really a "primitive" tool for running updated en-masse in the system.

Anyway thanks for the replies.

Was this reply helpful? Yes No
Verified answer

nunomaia 25 Moderator on at

Like (0)

Report

Data management for some scenarios works quite well, in another ares, yes, it misses very basic features.

Unfortunately, it don't tracks in staging records that were updated and records that were inserted.

Sometimes it required me to go destination tables and filter records by update date / time

Was this reply helpful? Yes No
Aparisi82 2,188 on at

Like (0)

Report

Thank you, to add on this , even the updated information on the staging table is misleading as actually in my scenario the majority of records being imported are not updated.

Was this reply helpful? Yes No