web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Records not updating f...
Microsoft Dynamics CRM (Archived)

Records not updating from import

(0) ShareShare
ReportReport
Posted on by Rob Pearce 140

I am trying to bulk update records in CRM 2016 by exporting to excel, modifying the records, then re-importing.  The success rate is very erratic - some records succeed, some don't (they are recorded as partial success, but the field is not updated - see screen shot from test environment where I was trying to change the company name)

Screen-shot.PNG. 

This is true even for the same record type with the same field (e.g. company name on a lead).  I can not find any common thread amongst the failures that would allow me to diagnose the problem.

Can anyone suggest common reasons that the update function fails?  Any help would be most appreciated.

Thanks,

Rob

*This post is locked for comments

I have the same question (0)
  • Tushar2016CRM Profile Picture
    Tushar2016CRM 1,130 on at

    Thanks Rob !

  • Rob Pearce Profile Picture
    Rob Pearce 140 on at

    That was it.  i did not realize the dedupe rules would fire, even though it was matching the records on a GUID.  Now that I know that, the update process works fine.

    Many thanks!

  • Verified answer
    Tushar2016CRM Profile Picture
    Tushar2016CRM 1,130 on at

    HI ,

    Kindly check if you have any duplicate detection rules set up which might not be allowing the changes into MS CRM .

    Similar thing might happen you have any plugin or workflow running in the background which might by causing this .

    Thanks

  • Rob Pearce Profile Picture
    Rob Pearce 140 on at

    No - I made sure that all the fields in the export/import are neither option sets or lookups.  

  • Suggested answer
    TheMarkChristie Profile Picture
    TheMarkChristie 10,328 Moderator on at

    Hi Rob,

    Is any of the data that you are importing linking to an optionset or Lookup? If so make sure there are no duplicate records in those entities

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans