Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

How to update records using import tool

Posted on by Microsoft Employee

Hi all,

The issue related the update of records using import tool is still present.

I'm looking for a solution in different forums but I haven't still found anything working.

I have read that Dynamics CRM should understand if the record has to be updated on the base of the Entity ID provided in the source file: it seems this is not right.

I get always the same error:

"A record was not created or updated because a duplicate of the current record already exists."

The system is clearly trying to insert the record, while it should have to be updated.

I tried with a simple .csv file with AccountId, Account Name, Primary Contact (I've to update the Primary Contact).

Do you have any suggestion to help me?

Thank you very much

Best regards

Fabio

*This post is locked for comments

  • yleclerc Profile Picture
    yleclerc 1,545 on at
    RE: How to update records using import tool

    You don't need to map those columns (A-B-C). They will be detected by the import tool. No need to map them.

    Like Aric says: Export, make changes, reimport.

    That is the best way to update records without errors!

  • Suggested answer
    Aric Levin Profile Picture
    Aric Levin 30,188 on at
    RE: How to update records using import tool

    Hi Fabio, when you export for re-import, do not make any changes to the actual file, except for the available fields that can be modified. Columns A-C contain the Guid and record information that you are trying to re-import, so converting to CSV, removing "unnecessary" columns or such, is probably the cause of your problems.

    Basically, Export file, make changes, reimport file.

    Hope this helps.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to update records using import tool

    Fine, I'm going to try!

    Could you tell me how have I to map columns "Checksum row" and "Edit date" during the import? Have I to select "Ignore"?

    Thanks

  • Suggested answer
    yleclerc Profile Picture
    yleclerc 1,545 on at
    RE: How to update records using import tool

    Hi Fabio,

    For best practices, you should remove unnecessary columns before exporting.

    Also, once you open the xlsx file, do not remove columns A-B-C (they are normally hidden when you open the file). They are used by the CRM to map the records you want to update. If you remove those columns, the CRM will detect the records like new ones and that would explain the duplicate detection.

    You can import NEW records with a custom file. But to update them, you need columns A-B-C in order for the record mapping to work.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to update records using import tool

    Hi Yvan,

    yes, I did these steps:

    1) exported a view as .xlsx file

    2) converted it in .csv file

    3) removed columns not involved in the update

    4) use the file in the import tool

    As preaviously said, the "Account" column with the account GUID is present.

    Sorry, why A custom cs file should make records detected as duplicates if all information are correctly mapped in the tool?

    Thanks!!

  • Suggested answer
    yleclerc Profile Picture
    yleclerc 1,545 on at
    RE: How to update records using import tool

    Hi Fabio,

    Did you previously export your account list from CRM?

    If you use a custom csv or xlsx file, it will be detected as duplicates.

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans