Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Can you associate imported records to parent record or create that new parent record?

(0) ShareShare
ReportReport
Posted on by

We want to import Appointment activities which will have a parent contact.  Could we include the contact on the import file for the appointments where it will find the existing contact to associate it with or create a brand new contact if it doesn't exist?

  • Pradeep Rai Profile Picture
    5,482 Super User 2025 Season 1 on at
    RE: Can you associate imported records to parent record or create that new parent record?

    Yes you are correct CRM Learner 8.

    Thanks,
    Pradeep.

    Please mark this as VERIFIED if it helps.

  • CRM Learner 88 Profile Picture
    on at
    RE: Can you associate imported records to parent record or create that new parent record?

    So to make sure I understand..  using the Out of the Box Import Wizard we can only associate the types of records we import to a parent if it exists.  if it doesn't exist it will not create new records, we would have to import that entity itself, correct?

  • Suggested answer
    Kenneth Ariel Chaves Herrera Profile Picture
    on at
    RE: Can you associate imported records to parent record or create that new parent record?

    Hi, here you can find information that can help when importing data:

    Import data (Dynamics 365 Marketing) | Microsoft Docs

    I hope this helps.

  • Verified answer
    Pradeep Rai Profile Picture
    5,482 Super User 2025 Season 1 on at
    RE: Can you associate imported records to parent record or create that new parent record?

    Hi,

    In CRM when we import file and if associated record does not exists in CRM system then that record will not be created.

    For e.g.

    pastedimage1630349011846v1.png
    I was trying to create the task records with above data but after import it only create records where lookup reference found.

    i.e. "Task With Contact" this will be created in CRM system after import.

    And below error message appears for "Task Without Contact" task record.
    pastedimage1630349521575v1.png

    Now, here if you have less number of records then you can import all records which have the lookup reference and then for all failed records first resolve the lookup reference then import the failed records.

    One more way we have using SSIS package.

    Please let me know if you need any information about SSIS package.

    Thanks,
    Pradeep.

    Please mark this as VERIFIED if it helps.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,923 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,788 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans