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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Pawar Pravin 5,237 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

Dynamics365 Rocker 7,755 on at

Like (0)

Report

Hi Talha,

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

You can find it in SDK under tools folder.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Talha,

Do you have any duplicate detection rule running in backed? If yes unpublished the duplicate detection rule and try to import again.

Was this reply helpful? Yes No