Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Data import - remove d...
Customer experience | Sales, Customer Insights,...
Answered

Data import - remove duplicate detection settings from existing environment/entity

(0) ShareShare
ReportReport
Posted on by Gerald Dahl 40

I want to import records into my account entity that have unique account names but the same contact. I've turned off all sorts of duplicate detection globally and also adjusted settings to remove duplicate detection at the entity level for account and contact. Imports fail and when I review the report (see lock on screenshot below) it seems to indicate that duplicate detection is still on. How do I turn this off?

7080.forum.png

I made a new sandbox environment and removed all the duplicate settings before I ever imported anything, and then I was able to import duplicates. But with my existing entity it seems as if the out of the box controls aren't doing the job. I wonder whether or not a deeper cure requiring C# is required, but that's beyond my present ability. Any tips would be appreciated. Thanks, GERALD DAHL

  • Verified answer
    Gerald Dahl Profile Picture
    Gerald Dahl 40 on at
    RE: Data import - remove duplicate detection settings from existing environment/entity

    FYI I discovered that because I had an inactive contact with the same name that my imports were failing. After I deleted the inactive contact with the same name then I had success with imports. Thank you.

  • Suggested answer
    Satish Tiwari - CRM Profile Picture
    Satish Tiwari - CRM on at
    RE: Data import - remove duplicate detection settings from existing environment/entity

    Yes, I would except it to work.

  • Gerald Dahl Profile Picture
    Gerald Dahl 40 on at
    RE: Data import - remove duplicate detection settings from existing environment/entity

    Thanks Satish, I've tried this, but, I thought of something new that I might need to try.

    I see that I have two lookups in Accounts that point to Contacts, one is Primary Contact and another is a custom field that I created called relatedContact. (When I created relatedContact I wasn't aware that Primary Contact was also there.)

    I think I will try to delete relatedContact and then use Primary Contact instead whenever I have a need to identify and refer to an individual as a relatedContact.

    Do you think if I delete the relatedContact field and its data and its relationships and if I set the duplicate rules as you have illustrated that I will be able to import duplicate records without getting the warning I am currently getting which says 'A duplicate lookup reference was found'?

    Thanks,

    GERALD DAHL

  • Suggested answer
    Satish Tiwari - CRM Profile Picture
    Satish Tiwari - CRM on at
    RE: Data import - remove duplicate detection settings from existing environment/entity

    Hello Gerald,

    Can you check highlighted options are unchecked under duplicate detection settings ?

    pastedimage1594547662371v1.png

    Here is the direct link to access setting, just replace orgname to actual one - 

    orgnam.crm.dynamics.com/.../duplicatedetectionsettings.aspx

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans