Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Re-import data with GUID

    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  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Re-import data with GUID

    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 

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Re-import data with GUID

    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

  • Suggested answer
    Kishor Kumar Profile Picture
    Kishor Kumar 3,702 on at
    RE: Re-import data with GUID

    Hi Isabell when you remove the data from excel while importing back, then the data will not be there in CRM 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

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans