News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Trying to import Custo...

Finance | Project Operations, Human Resources, ...

Answered

Trying to import Customer Contacts: Can I find with Data Entity or Table contains all of these fields: CONTACTPERSONID, DEFINITIONGROUP, EXECUTIONID, PARTITION.

(0) Share

Report

Report

Posted on by jt1024

185

Hello all,

We're trying to use data entities to import customer contact information.

An error is being given:

Failed to insert record into staging table. The keys of the record are CONTACTPERSONID, DEFINITIONGROUP, EXECUTIONID, PARTITION. Duplicate records must be removed from the file prior to import.
'0' 'Contacts V2' record(s) inserted in staging

Any suggestions?

All responses Img

All responses (2)

Answers Img

Answers (1)

André Arnaud de Cal... 291,861 Super User 2024 Season 2 on at

Like (0)

Report

RE: Trying to import Customer Contacts: Can I find with Data Entity or Table contains all of these fields: CONTACTPERSONID, DEFINITIONGROUP, EXECUTIONID, PARTITION.

Hi Jim,

Thanks for coming back and share your solution. I have verified your answer to set the status to 'Answered'.
Verified answer

jt1024 185 on at

Like (0)

Report

RE: Trying to import Customer Contacts: Can I find with Data Entity or Table contains all of these fields: CONTACTPERSONID, DEFINITIONGROUP, EXECUTIONID, PARTITION.

We found the answer, we had to add the flag to the field in the import map to autogenerate the ContactPersonID. Then it worked.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,861 Super User 2024 Season 2

#2

Martin Dráb 230,540 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans