Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Answered

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

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
    Pradeep Rai 5,490 Super User 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.

  • 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
    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
    Pradeep Rai 5,490 Super User 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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans