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)

Sort by

Suggested answer

SouravDam 11,732 on at

Like (0)

Report
Copy link

Link copied!

Hi karanSurya,

Exporting excel spreadsheet will only show the related tables to the entity 'Worker' from data management and it will not generate any data. What you have to do is; once exported, you have to fit your data in that spreadsheet and then import back in system to upload data. This is how it works.

So, in this context I don't feel that you are facing any issue.

However, if you are expecting that once you export excel from system; all data should display too, then you have to perform this directly in Worker form in Human resources module. Go to 'Workers' form and click on Open in excel to generate data as available in system.

You have to click on enable editing once the template is exported. System will display data through a series of execution process.

Hope this will help you. Let know for any further clarification.

Best regards,
Sourav Dam

Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.
Sukrut Parab 71,741 Moderator on at

Like (0)

Report
Copy link

Link copied!

which worker entity you are using for export ? Do you any filters applied in your data project ?
MATTGUO 22,353 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi KaranSurya,

Are there records that can be exported in the execution form?

Do you try to use XML format to export?
karanSurya 32 on at

Like (0)

Report
Copy link

Link copied!

thank you for your suggestion:

here are the results :

I opened ‘Contractor (unfiltered)’ and this was the result:

No records were populated.

But when I opened ‘Employee (unfiltered)’ there were 3490 records.
Suggested answer

Ajit 8,788 on at

Like (0)

Report
Copy link

Link copied!

That's weird. If you are exporting from Dev or QA, can you try running the query "select * from HCMWorkerEntity" on AXDB and see if you get the results back.
karanSurya 32 on at

Like (0)

Report
Copy link

Link copied!

hi Ajit:

thank you very much for your reply,

I would like some clarity on where and how I can execute this query?

We’ve exported the HCMWorkerEntity to SQL and we were able to see all of the records this way, but we need to be able to export it via spreadsheet straight from the DMF.
André Arnaud de Cal... 307,700 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi KaranSurya,

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

Like (0)

Report
Copy link

Link copied!

hi Andre ,

thank you very much for your reply ,

We set up all of our Workers as Employees.
Andrew Xu 3,877 on at

Like (0)

Report
Copy link

Link copied!

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

Like (0)

Report
Copy link

Link copied!

no