web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Duplicate Data detecte...
Microsoft Dynamics CRM (Archived)

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

(0) ShareShare
ReportReport
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)
  • Pawar Pravin Profile Picture
    Pawar Pravin 5,237 on at

    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

  • Suggested answer
    Dynamics365 Rocker Profile Picture
    Dynamics365 Rocker 7,755 on at

    Hi Talha,

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

    You can find it in SDK under tools folder.

  • Community Member Profile Picture
    Community Member on at


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

  • Suggested answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    Hi Talha,

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
RichardM Profile Picture

RichardM 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans