I 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
