When I went through the DMF to export the Worker table in an excel spreadsheet, the records successfully exported. However, when I download the package
and open the excel spreadsheet, I only see the column names of that table and zero records beneath it. Repro steps: 1. System administration 2. Data management 3. Create a Export job using Excel as the Target data format and Worker as the Entity name. 4. Download package 4. Open spreadsheet
Application:APP8 D365.
No error at all. it successfully exports. But no records in the excel file -please suggest.what to check?
Have you created any custom fields on the Worker table? If so, these have to be propagated fully in System Admin to update the entity store else it can end up with blank records on Export.
Hi karanSurya,
I did notice two interesting aspects in your screenshot.
1) You are using Talent, but did create the question in the Finance and Operations forum.
2) There is a data classification (confidential) in Excel. I haven't seen this before.
I'm moving the thread to the Talent forum as there might be something specific related to this product.
Can you disable Skip staging and then export the data and check in View staging data if you see data there.
Hi karanSurya,
I have tried the steps you mentioned in PU24, worker entity completed successfully and exported 500+ records successfully, can see them in excel as well. If you have a standard VM with USMF data for the same D365 version, can you try to export and see if you see any data.
If you don't see any data, suggest that you open the ticket with Microsoft. I create a new worker under Human resources, didn't assign any position etc. clicked hire. Tried exporting data and even that record shows up. you may want to try to create manual record and see if that gets exported. Trying to see if it's data issue or Data Entity issue.
Thanks,
Satish Panwar
Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.
hi Andre,
i am not using contractors.
My issue is that we woker table with data which we are exporting through DATA management -records were successfully exported -see in the above screen shots. But when i open excel sheet -no records at all.
Hi Karan,
If you did setup employees, then open in Excel using the contractors entity will indeed not show anything as it has a filter on contractors. The workers entity will show all. The employee entity will show all workers setup as employee. You can either use one of these tho then.
no
Did it say any records processed in the execution history log?
hi Andre ,
thank you very much for your reply ,
We set up all of our Workers as Employees.
Hi KaranSurya,
Can you check if you can find contractors in your current legal entity? Or are all workers set up as employee?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,275 Most Valuable Professional
nmaenpaa 101,156