Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Updating existing contacts on import

Posted on by 212

Hello,

So last week we had an event with around 500 people. We now need to add all the people that attended the event into a campaign created in CRM to know who came and note that on their contact record. I have created the relationship between contacts and campaigns to allow adding contacts to campaigns instead of leads because our company does not use leads.

Some of the contacts on the excel sheet template to upload are existing contacts in CRM, others need to be created. This only has their basic information and the name of the campaign they need to be attached to. However, when importing, I can either ignore the existing contacts, or the system creates a new duplicate contact with the same name and the updated campaign.

How can I set it to update existing contacts that are matched by CRM upon import and create the contacts that are not found in CRM? I swear this used to be available, to match existing contacts and create those that aren't matched...

Mass updating or exporting the existing contacts would take way too long to take my list of attendees, search them in CRM one by one, then add them to a list of ones that need to be exported to be updated, then create the contacts that need to be created, which is not the point of trying to do what I am doing and save time and energy.

Thanks

*This post is locked for comments

  • ScottDurow Profile Picture
    ScottDurow 50,177 on at
    RE: Updating existing contacts on import

    Hi,

    AFAIK there has never been anyway out of the box to do this kind of upsert using imports.

    You can use tools such as Kingswaysoft's SSIS toolkit or scribe to do it fairly easily.

    If you want to do it in Excel you can download the contacts that are reported as duplicates and then update the data and re-upload.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans