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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Re-import data with GUID
Microsoft Dynamics CRM (Archived)

Re-import data with GUID

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I have exported  14 000 records from a customized entity and made changes in my data and now I want to import it again. My question is how do I handle the "do not modify"-fields in the mapping? I have chosen Default (Automatic Mapping) in the step for Select Data Mapping and mapped the Record Types to my customized entity but the "do not modify"-fields show up as Not Mapped and I do not know what to map them to since these are GUID's and I thought they would map themselves? 

Another question regarding this import, if I delete one of the records completely from the excel file I am re-importing, will that record be deleted in CRM then?

Any help will be highly appreciated, thank you!!

/Isabell

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Kishor Kumar Profile Picture
    Kishor Kumar 3,710 on at

    Hi Isabell when you remove the data from excel while importing back, then the data will not be there in CRM Isabell

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Have you made any changes to first 3 columns of the exported files. If not then your import will run without issues. Refer this:

    blogs.microsoft.co.il/.../updating-crm-records-via-excel-export-in-microsoft-dynamics-crm-2011

    Regarding your second question. If we remove a record from excel  then that record won't get deleted when you reimport. Only thing that will happen is that record won't get updated

  • Community Member Profile Picture
    Community Member on at

    Hi,

    Thanks for answering! The problem seemed to be that I was trying to import a csv file, when I changed it to a xlsx it worked and I didn't have to map any fields. One question though, the import didn't give me any successes , any errors or not even any number in total processed and I don't understand why?  

    And sorry if I am mistaken here, but you seem to say the opposite thing about the records being deleted in CRM if I delete them in the excel file and then re-import them?

    Thanks! /Isabell 

  • Community Member Profile Picture
    Community Member on at

    Okay, I found out how this works. The reason anything didn't get updated is because I imported the same exported file for the second time. When I exported a new one and imported the same changes it got updated and worked correctly.

    I also tried deleting a record from the excel file in order to see if it got deleted in CRM, but it didn't. So it seems to be the way Saad said, the record doesn't get updated, nor deleted.

    Thanks! /Isabell  

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

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 November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans