Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

(0) Share

Report

Posted on by Benjamin Fallar III

245

Hi,

I have an excel import template with data to import to a custom entity.

The excel import file contains a lookup field.

When importing the error is duplicate lookup field values.

When I check the lookup fields there is no duplicate values. I'm using a lookup text value (not guid)

What is the comparison used here. For example, I have a lookup list

400

400L

Are they considered duplicate when performing a data import?

All responses (6)

Answers (1)

Brandon Sambat on at

Like (0)

Report

RE: Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

Thank you for verifying the suggestions and solutions. Welcome to the communities.
Benjamin Fallar III 245 on at

Like (0)

Report

RE: Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

Oh boy, yes there is a duplicated inactive record. Thanks for that!
Verified answer

Mahendar Pal 45,095 on at

Like (1)

Report

RE: Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

Hi,

I will suggest you to recheck all the view for simply advanced find "new" to get all the data for Provider Group Code to make sure there is no duplication.

Also have you checked if there is any inactive records for Provider Group Code which have 400R1.
Benjamin Fallar III 245 on at

Like (0)

Report

RE: Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

Hi, thats what I used and followed to... but still encountering issue.

Let me get you more detailed context.

So I have custom entity called Benefit Plan Provider Group, at let's say it contains the following records

Provider Group Code

400R1

400R10

Now, I have a CSV file to import to another entity

Benefit Rate ID Provider Group Code Benefit Type

400R1UHS1200 400R1 Benefit

400R1UHS2000 400R10 Benefit

400R10DPAC808050 400R10 Benefit

In the CSV, the field Provider Group Code is a lookup that mapped to the Provider Group entity.

When I import the file here is the error

"A duplicate lookup reference was found" for column 400R1

Duplicate reference found for transformation output parameter mapped to: Benefit Plan Provider Group Code. Output Parameter Value: 400R1

Hope you can help me on this.
Suggested answer

Bipin D365 28,977 Moderator on at

Like (0)

Report

RE: Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

Hi,

I did quick test and it worked as expected on my crm instance

I created Country entity and added below record in it.

Then I added 2 record in csv file as shown below.

As you can I am setting Country field value to 400 and 400L. I am creating Case record from import.

And record imported successfully without issue.

Please check error logs and provide screenshot to investigate your issue.

Please mark my answer verified if i were helpful
Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report

RE: Dynamics CRM 365 Online Data Import for lookup with duplicate field values issue

Hi,

No these won't be duplication, please make sure to check error log which particular column is showing as duplicate record.

I hope you are already aware of this but in case you want to refer your lookup which present in the system as duplicate records, you have following two options

1. Use some unique field instead of the lookup name to map lookup field.

joshimandarblog.wordpress.com/.../

2. Use GUID of the lookup record instead of the name field.

Let me know if my understanding is not clear.