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?

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Benjamin Fallar III 245 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Mahendar Pal 45,095 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Benjamin Fallar III 245 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Brandon Sambat on at

Like (0)

Report

Thank you for verifying the suggestions and solutions. Welcome to the communities.

Was this reply helpful? Yes No