CRM Online 2015 Account Record update

Hi,

I have imported All my accounts into our CRM Online 2015. There are around 100 accounts that do not have addresses.

I have added the columns so that when i exported the Accounts, it has all the necessay fields i want to update. I have modified all the records.

I need to import it back in now, but when i do, it fails, as the are duplicates.

How do Import the Records back in, but instead of trying to Create, just Update the existing records. The data in question all have a Unique Identifier, which is "AccountNumber"

Thanks
Luke
EnsingerITAsked:
Who is Participating?
 
Feridun KadirPrincipal ConsultantCommented:
During the export process, in the export to Excel dialog select the option, Make this data available for re-importing by including required headings.

Then, in the exported file update the data as needed. Do not change the structure of the file, add new columns or unlock the security. Then import the file, CRM should detect that it was exported for re-import and offer the option to update existing records instead of creating new ones.
0
 
Ronak PatelCommented:
Hi,

Check this :
Importing and Updating Records in Microsoft Dynamics CRM


Hope this helps.

Regards,
Ronak
0
 
EnsingerITAuthor Commented:
Hi Ronak,

I have looked at this, but it not very clear. It explains what to do, but not how to do them

Thanks
Luke
0
 
EnsingerITAuthor Commented:
Thanks, I actually did this, then read you comment! Cheers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.