Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Import contacts with company names that do no exist in Accounts or Contacts

(0) ShareShare
ReportReport
Posted on by

In the CRM template to import Contacts, if I want to import a company name, the template says that the company name as the data type Lookup and the company name record must already exist in Accounts or Contacts in Dynamics CRM or in the source file. When I imported new contacts in CRM Online 2015 from an Excel source file including company names that do not exist either in Accounts or Contacts, I always get the error message "Recursive parent-child contact loops are prohibited, (0x8004050a)". How can I import new company names for Contacts (that do not exist either in Accounts or Contacts) using only an Excel source file without getting any error ?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Import contacts with company names that do no exist in Accounts or Contacts

    Hi Wayne, I have been given a contact list to import. Some of the companies do exist as accounts in CRM, and others do not. Do I need to run two separate import processes, one of which creates accounts and the other does not?

  • Francois-CRM Profile Picture
    Francois-CRM on at
    RE: Import contacts with company names that do no exist in Accounts or Contacts

    Hi Mahendar, thank you for your support. The references you gave me helped me to understand the importation process of Accounts and Contacts from a ZIP file.

  • Francois-CRM Profile Picture
    Francois-CRM on at
    RE: Import contacts with company names that do no exist in Accounts or Contacts

    Hi Wayne, I  just refreshed once again my CRM Online window and all the importations I tried 90 minutes ago finally imported correctly. Thank you for your support.

  • Francois-CRM Profile Picture
    Francois-CRM on at
    RE: Import contacts with company names that do no exist in Accounts or Contacts

    Hi Wayne, Thank you for your quick response on monday. I applied your solution in CRM Online 2015 this morning. Each time I try to import both accounts and contacts from a Zip file, the importation status remains at Submitted - waiting. I also found that the template for Contacts has been changed since last friday adding a new required field "Contact type". So I performed a new test to only import new contacts without the company name, adding the Contact type field iwht hte value Contact. This importation worked correctly last friday, but this morning, the importation also remains submitted with the status reason "Waiting". What else should I consider to be able to only import Contacts with success ?

  • Verified answer
    Mahendar Pal Profile Picture
    Mahendar Pal 45,095 on at
    RE: Import contacts with company names that do no exist in Accounts or Contacts

    Hello,

    In case you are importing data and referencing some parent records which does not exists in CRM import will fail, so parent record should exists in CRM

    OR

    you can import that parent record file  with child entity record file using zip format to create both entity record and setup association as well, so for example you can import contact and account by combining them in zip file. You can refer below post for complete steps.

    Refer: blogs.msdn.com/.../crm-2011-data-import-wizard-importing-related-accounts-and-contacts.aspx

    Hope it will help you.

  • Verified answer
    Wayne Walton Profile Picture
    Wayne Walton 13,726 on at
    RE: Import contacts with company names that do no exist in Accounts or Contacts

    Make a new Excel files called Accounts, and push all the Account names there.  Zip up the Contact and Account files into one file and then give that to CRM to load.  CRM will then load those Accounts, and then the Contacts relating to those Accounts.

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,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans