Duplicate Data detected error on importing data while there is no data.

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi All,

exported a zipcodes file from the production site and edited the required fields and then tried to import the file, on importing the file the updated rows in excel file (.xlsx) got imported and the other removed. and on import, it displays a duplicate record error but there is no duplicate seen.

Here is a screenshot of the error.

1234.Screenshot_5F00_6.png

Please help ASAP, or suggest something to solve this issue.

Thanks.

*This post is locked for comments

All responses (4)

Answers (0)

Suggested answer

gdas 50,085 on at

Like (0)

Report

RE: Duplicate Data detected error on importing data while there is no data.

Hi Talha,

Do you have any duplicate detection rule running in backed? If yes unpublished the duplicate detection rule and try to import again.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Duplicate Data detected error on importing data while there is no data.

@Pravin Pawar
Yes it got multiple values with same name as it is a zipcode assigned to user file.
Suggested answer

Dynamics365 Rocker 7,755 on at

Like (0)

Report

RE: Duplicate Data detected error on importing data while there is no data.

Hi Talha,

You can use Configuration migration tool to import/export data.

You can find it in SDK under tools folder.
Pawar Pravin 5,227 on at

Like (1)

Report

RE: Duplicate Data detected error on importing data while there is no data.

Hi Talha,

There is an issue on instance where you are trying to import records. There is one lookup value in excel sheet which is having more than one record with same name. Can you please use unique id instead of name for mapping purpose.

Please do refer following url for reference

www.powerobjects.com/.../importing-lookup-values-using-crm-2011-data-import-wizard

mydynamics365tips.wordpress.com/.../importing-lookup-records