Microsoft Dynamics 365 | Integration, Dataverse...

Duplicate connection records are getting created

(0) Share

Report

Posted on by EmployeeOcta

Hi All Experts,

i am choosing some connection records using advanced find from the CRM by using some filter criteria and exporting the same into the excel file.

Now i am modifying the records into the excel file without doing anything to three hidden columns.

After importing the records the import log shows that the number of records which are imported into the CRM are same as in the excel file.

BUT,

When i am using advanced find the exact double records are getting displayed there.

is it expected behavior or how is it. I think this could be a bug from Microsoft.

All responses (7)

Answers (0)

AriaConsulting on at

Like (0)

Report

RE: Duplicate connection records are getting created

THen I think there's no option outside of a ticket to MS. When I import records ensuring to follow those step in my environment it works fine.
EmployeeOcta on at

Like (0)

Report

RE: Duplicate connection records are getting created

1. Are you leaving the hidden fields/columns in the file (columns A-C) alone when you are working with it and re-uploading it? Yes , i am leaving the hidden columns as it is.

2. Are you ensuring that all 3 steps of the dupe detection are addressed as I posted and that you are definitely selecting to NOT allow dupes when re-uploading? Yes. i am ensuring this.
AriaConsulting on at

Like (0)

Report
RE: Duplicate connection records are getting created

2 questions:

Are you leaving the hidden fields/columns in the file (columns A-C) alone when you are working with it and re-uploading it?

Are you ensuring that all 3 steps of the dupe detection are addressed as I posted and that you are definitely selecting to NOT allow dupes when re-uploading?
EmployeeOcta on at

Like (0)

Report

RE: Duplicate connection records are getting created

I am pasting the column names which we are taking here into consideration.

Since i cannot paste the data so i believe this will be helpful.

Connected To Role (To) Connected From Role (From) Owner

I am exporting connection records into the excel and changing the Connected To field with some other user name and after changes are done i am again reimporting the excel file.
AriaConsulting on at

Like (1)

Report

RE: Duplicate connection records are getting created

Unfortunetly, if everythings is correct as you say, I would bee to see the upload file and watch you do the upload process in order to see if I can spot what the problem might be.
EmployeeOcta on at

Like (0)

Report

RE: Duplicate connection records are getting created

Hello Lorne,

I am not having duplicate detection rule applied on connection entity records.

But rest of the settings which needs to be taken care are correct .

I am trying to export some connection records data and modifying Connected To field and reuploading that,

But my problem is that it's creating duplicate records.
Suggested answer

AriaConsulting on at

Like (0)

Report
RE: Duplicate connection records are getting created

It's not a bug. You need to,

have duplicate records detection enabled

have duplicate records detection rules

have duplicate records detection jobs (I only have one for accounts in this environment)

And most importantly when you're doing the reimport and the dialogue comes up and there is a radio button for "allow duplicates" make sure you choose "no".