D365 Trick to see all the error details in one form without going one by one in a big file import from Data management

Dear Microsoft BizApps Community,

Welcome to my next blog on an amazing trick to get all the error details in one form without going one by one in a big file import from Data management

Problem statement

While a Consultant import any data from data management, sometimes it is partially succeeded due to some error in the file itself, and if it is a big data 100, 1000 and more than that, then it is impossible to check all the error details in one go, we always need to check one by one to see the error details

Solution

“Every problem has its own amazing solution”- Lets explore this one

We just need to see this import from a table browser and the query is written below

First take your server link then add the below details- only thing we need to do is to give the legal entity number where I have added “USMF”

https://uat.sandbox.operations.dynamics.com/?mi=SysTableBrowser&prt=initial&limitednav=true&TableName=DMFStagingValidationLog&cmp=USMF

Lets check

Here in my case- around 1271 record got failed from 20000 records while importing, however its impossible for me to check the error details for 1271 records, because I only have possibility to check one error record at time and error come in the below window.

Now, I am using the solution provided above, this will show all the error details in one table form, we can export the same as well in excel and analyze for further use

That’s it!! It’s a super time saving and accurate,

This is it for this article, stay tuned for my next article on a different topic