Share
Report
90I get this error when importing a record in Account entity, "A record was not created or updated because a duplicate of the current record already exits." I need help to resolve this so I can import parent and child records for Account.
Background:
Account Entity:
Account entity has accountid (Display Name: Account), which is a primary key (default). Has name (Display Name: Account Preferred Name), which is a text (default). Then there is parentaccountid (Display Name: Parent Account), which is a lookup field (by default).
Under Account entity, I have created new field, new_cesclientid (Display Name: CES Client ID), which is a whole number and is unique too. I created this because accountid is a GUID and hard to use it by the user in an application.
After creating this field, I wanted to load the data into Dynamcis. I was able to import this record into Account successfully (Merit Health Care System, 1518). This is a parent record.
|
(Do Not Modify) Account |
(Do Not Modify) Row Checksum |
(Do Not Modify) Modified On |
Account Preferred Name |
CES Client ID |
Active |
Parent Account |
|
3b12f2a5-fb67-ea11-a811-000d3a31c754 |
8l0ij5Gi4p3z/CF0YHtWvU2fH+v2nfwhkQy19KV5qvHrIbe846l5nQ9W4KexJQ4F7Fg08/XovN0VJxiuYJrA7w== |
3/17/2020 3:02 |
Merit Health Care System |
1518 |
Yes |
|
Issue: I had imported 3 child records but Parent Account was blank before or it was not associated. Now, I had to update the 3 child records to their Parent Account. The record is listed below and having problem importing them. I get an error message when importing, “A record was not created or updated because a duplicate of the current record already exits.” I have checked and there is no other account by same new_cesclientid (CES Client ID).
|
(Do Not Modify) Account |
(Do Not Modify) Row Checksum |
(Do Not Modify) Modified On |
Account Preferred Name |
CES Client ID |
Active |
Parent Account |
|
d0c8a61c-3767-ea11-a811-000d3a31c911 |
9u6pj1fSsnuPA1C4xtRBwqh0e0ElV/XMFlgeXEw1uk49tBcCoWx1C9Ici2d0mEp2P0RS/sPw/361r/TB3RY2ZQ== |
3/16/2020 3:39 |
Merit Urgent Care |
64 |
Yes |
1518 |
|
dcc8a61c-3767-ea11-a811-000d3a31c911 |
8ifOa6OaKCHUwn2n/zri9DL7cm51CXPRTKyjw8kO7wkEv5QmWQKwffrY8mJSF4+Jq9dkyzCiWZf5QcUaLXtrCQ== |
3/17/2020 3:14 |
Merit ER |
70 |
Yes |
1518 |
|
33d9253f-3767-ea11-a811-000d3a31c911 |
MdB++yThADkFg1lvikv0m3Thzx8FoPLqDQqpiNaAXhOGA75Yv2uZExdv7YhUsu6vB6ZAfLYZ82tWlr3p16onMw== |
3/16/2020 3:50 |
Trivent Health Care |
9834 |
Yes |
1518 |
Attached is the error message.
I greatly appreciate any help that you can provide. I am a newbie and trying out different things and going over forums. Any help in detail would be greatly appreciated.
Thanks,
Vinay
All responses (
Answers (
