Skip to main content

Notifications

Dynamics 365 Community / Forums / Human Resources forum / No Records in the exce...
Human Resources forum

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

Posted on by 32
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:
  • Maxlude Profile Picture
    Maxlude 55 on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 290,900 Super User 2024 Season 2 on at
    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 Profile Picture
    Khushhal Garg 1,514 on at
    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.

    3122.pastedimage1565914422930v1.png

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,643 on at
    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 Profile Picture
    karanSurya 32 on at
    RE: No Records in the excel sheet when worker table is exported.

    7802.exportissue.PNG0447.imoprtissue.PNG4152.exportissue2.PNG

    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 Calavon Profile Picture
    André Arnaud de Cal... 290,900 Super User 2024 Season 2 on at
    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 Profile Picture
    karanSurya 32 on at
    RE: No Records in the excel sheet when worker table is exported.

    no

  • Andrew Xu Profile Picture
    Andrew Xu 3,877 on at
    RE: No Records in the excel sheet when worker table is exported.

    Did it say any records processed in the execution history log?

  • karanSurya Profile Picture
    karanSurya 32 on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 290,900 Super User 2024 Season 2 on at
    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans