Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Data Re-Import does not work for some records stating there are duplicates RRS feed

 > 

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    It just ended up being duplicate detection rules preventing some updates. Once I turned off the rules the updates worked. I just didn't think that on a "re-import" update process that it would bother with the dedup rules. it doesn't make sense.

    All set, thanks

    • Marked as answer by malobk Friday, January 16, 2015 3:21 PM
    Friday, January 16, 2015 3:21 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am trying to update my Account records by exporting them and re-importing. I have been successful with re-importing many thousands of records but there are some which are refusing to be updated. The error I get is "a record was not created or updates because a duplicate of the current record already exists".

    This doesn't make sense to me because I'm selecting the option to prepare the data for re-import: "Make this data available for re-importing by including required column headings."

    I can't find anything special about these records nor did I find anything special about the records that were successfully imported.

    Thanks.

    Sunday, August 31, 2014 4:56 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    It sounds like there are duplicate ID's in the worksheet.  I suspect a data migration issue meaning when the data was initially added to CRM someone inserted id's.  You can check the excel spreadsheet when you export the data to see if there are duplicates.  You'll just need to unhide the locked fields or copy all the data into a new worksheet and check for duplicates.  

    Regards, Donna

    Thursday, January 15, 2015 9:20 PM
  • Question
    Sign in to vote
    1
    Sign in to vote

    It just ended up being duplicate detection rules preventing some updates. Once I turned off the rules the updates worked. I just didn't think that on a "re-import" update process that it would bother with the dedup rules. it doesn't make sense.

    All set, thanks

    • Marked as answer by malobk Friday, January 16, 2015 3:21 PM
    Friday, January 16, 2015 3:21 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    it doesn't make sense.

    Agreed. I found this out too some time ago with the help of CRM support. I think this is a very odd design decision by the developers. It's probably more of an oversight.
    Friday, January 16, 2015 5:28 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Just went thru the same thing.  You're matching on GUID - why would duplicate rules possibly apply?  :P
    Tuesday, January 26, 2016 11:11 AM