Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Importing Contacts to Accounts: Duplicate lookup reference found.

(0) ShareShare
ReportReport
Posted on by

I'm trying to import contacts into accounts that already exist on CRM, and have been de-duplicated. However, I'm still getting import failures because of error 0x80040352 - A duplicate lookup refernce was found.

My theory is that because we have accounts that have similar names, it thinks they're the same account. For example: Alamo Realty and Alamo Construction.

The only time I got it to work was when I tested a .csv with one row, mapping to an account that has absolutely no similarities to any other account names.

I've spent hours researching this and have gotten nowhere. Help would be GREATLY appreciated!

*This post is locked for comments

  • Richard708 Profile Picture
    Richard708 10 on at
    RE: Importing Contacts to Accounts: Duplicate lookup reference found.

    This inactive accounts solution does not work for me.  I have no inactive accounts according to the inactive accounts view, advanced search shows no inactive accounts, I have created new views where status is not active and nothing shows.  I have two companies where any contact I import gets the duplicate reference error.  Any kind of account search shows only one account (active) with that name.  I have changed the reference look-up on the import to ensure they are using the account name and contact company (no "primary key" usage).  Still getting the error.

  • Suggested answer
    Donna Edwards Profile Picture
    Donna Edwards 2,996 on at
    RE: Importing Contacts to Accounts: Duplicate lookup reference found.

    I generally encourage people to create a workflow that adds (concatenates) the word  inactive to one of the name fields for contacts and accounts rather than delete the record.  The reason I prefer not to delete is that you lose all related activities and other records when you delete unless you have merged the record with another.  

    If you do choose to delete records that meet certain conditions, you can create a bulk delete job in CRM to do that for you on a scheduled basis.

    Hope this helps.

  • Cada Profile Picture
    Cada on at
    RE: Importing Contacts to Accounts: Duplicate lookup reference found.

    Thanks :) Just had to delete the inactive records.

  • RE: Importing Contacts to Accounts: Duplicate lookup reference found.

    I have our team of data administrators put a ^^ into the contact Last Name or the Account Name of the record that will be deactivated.  We then keep them for one week after the merge so that we can restore if we accidentally deactivated the wrong account.  Each week we run an Advanced Find that searches for all deactivated accounts where Account Name CONTAINS ^^ and was modified more than 7 days prior.  We do the same for Contact Records using Last Name CONTAINS ^^ and modified more than 7 days ago.  We delete all those records that show up in the Advanced Find.  Problem is - you have to watch out if people improperly use the ^^ when deactivating records that they have not merged.  It would be much better to have a way to "see" the Merged = Yes/No field.

  • Dapadon Profile Picture
    Dapadon 5 on at
    RE: Importing Contacts to Accounts: Duplicate lookup reference found.

    Just read your error and resolution, I've been trying for 4hours... parsing in / deleting & analysing. Then i read your post... i have'nt even tried it yet but I guarantee thats the answer as I've recently merged a couple of accounts - specifically those that the error report mention. So... i just wanted to say, thanks a bunch for going to the effort of adding this blog / support case :) all the best, Colin.

  • Verified answer
    RE: Importing Contacts to Accounts: Duplicate lookup reference found.

    I figured it out actually. Well, I called and walked through it with someone. What it was is that there are still inactive duplicate accounts in the system from when we merged them earlier on.

    Apparently Dynamics will still try to match a contact with an inactive account - I wasn't aware of that.

    So I never looked at the inactive view to see if that was the case. You have to completely delete them after doing any duplicate merging process before trying to upload contacts.

  • RE: Importing Contacts to Accounts: Duplicate lookup reference found.

    HI,

    You can try the following

    first you can download xml  template file. For the same goto setting >>  template choice which entity you want to import data.

    Fill the file and import data ..

    I hope this would work.

    Thank You !

  • RE: Importing Contacts to Accounts: Duplicate lookup reference found.

    Oh, and I have CRM 2011 online.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans