Data Entity import issue from excel-addin

(0) Share

Report

Posted on by BADRI NARAYANAN G

211

Hi Friends,

I have one problem when publishing data through excel Add-in for F/O.I have a entity HcmEmploymentV2 which i am using for exporting data from excel to d365 application.

When i enter a new record in excel and then click on publish button the message "Data changes analyzed" is displayed but its not publishing the data.I tried to add all the required fields and then publish data but still the same thing happens.

Please help me on this.

Thank you

Badri

I have the same question (0)

All responses (7)

Answers (1)

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Badri,

Can you tell which exact columns are made visible on the Excel sheet and which fields do have what values filled?

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (1)

Report

Hi Badri,

You need to click on the first row and then select New button from the right side of the excel.

Add the new records and then click on publish.

Thanks,

Girish S.

Was this reply helpful? Yes No
BADRI NARAYANAN G 211 on at

Like (0)

Report

Hi Andre,

Thanks for your reply.

These are columns made visible in excel.If i add a new record its saying data changes analysed but its not publishing the newly added data.

Thank you

Badri

Was this reply helpful? Yes No
BADRI NARAYANAN G 211 on at

Like (0)

Report

Thanks Girish.Now its publishing the record but its throwing this error.

A row created in data set EmployeesV2 was not published. Error message: 'Write failed for table row of type 'HcmEmployeeV2Entity'. Infolog: Info: Cannot edit a record in Worker calendar assignment (WorkCalendarEmployment). Employment: Badri Narayanan USSI 4/27/2023 10:53:26 am 12/31/2154 11:59:59 pm, Standard. The record already exists..'

Warm Regards

Badri

Was this reply helpful? Yes No
Verified answer

GirishS 27,827 Moderator on at

Like (2)

Report

I think we already discussed this in this thread. https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/485650/error-while-importing-data-from-excel-addin-for-hcmemployment-entity/1337229.

I think we already given more suggestions.in the above thread.

You can do one thing, create a runnable class and use that HcmEmploymentV2 entity and insert that employee on that HcmEmploymentV2 entity. So that you can debug the code and find out which Employment Id in WorCalendarEmployment Table is causing the issue.

Thanks,

Girish S.

Was this reply helpful? Yes No
BADRI NARAYANAN G 211 on at

Like (0)

Report

Hey Girish,

As suggested i debugged it in the build environment.Actually it had a RECID being created in another company.So whenever we were creating a new record it was creating based on the RECID and hence it was getting duplicated.So i removed that record from SQL and tried to insert again in Excel Add-in and it worked.Now i am able to import data from excel Add-in to F/O.

Your suggestion points were directly helpful to resolving the issue i could not thank you enough.Thanks a lot.

Warm Regards

Badri

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Great!

Please mark the helpful answers as verified so that others can make use of this thread.

It's done by clicking "Did this answer your question" >> Yes on the particular reply.

Thanks,

Girish S.

Was this reply helpful? Yes No