No Records in the excel sheet when worker table is exported.

(0) Share

Report

Posted on by karanSurya

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?

Categories:

Other

All responses (16)

Answers (0)

Maxlude 55 on at

Like (0)

Report

RE: No Records in the excel sheet when worker table is exported.

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.
André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at

Like (0)

Report

RE: No Records in the excel sheet when worker table is exported.

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.
Suggested answer

Khushhal Garg 1,514 on at

Like (0)

Report

RE: No Records in the excel sheet when worker table is exported.

Can you disable Skip staging and then export the data and check in View staging data if you see data there.
Suggested answer

Satish Panwar 14,645 on at

Like (0)

Report

RE: No Records in the excel sheet when worker table is exported.

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.
karanSurya 32 on at

Like (0)

Report

RE: No Records in the excel sheet when worker table is exported.

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.
André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at

Like (0)

Report

RE: No Records in the excel sheet when worker table is exported.

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.
karanSurya 32 on at

Like (0)

Report

RE: No Records in the excel sheet when worker table is exported.

no
Andrew Xu 3,877 on at

Like (0)

Report

RE: No Records in the excel sheet when worker table is exported.

Did it say any records processed in the execution history log?
karanSurya 32 on at

Like (0)

Report

RE: No Records in the excel sheet when worker table is exported.

hi Andre ,

thank you very much for your reply ,

We set up all of our Workers as Employees.
André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at

Like (0)

Report

RE: No Records in the excel sheet when worker table is exported.

Hi KaranSurya,

Can you check if you can find contractors in your current legal entity? Or are all workers set up as employee?