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 / Customer experience | Sales, Customer Insights,... / Export & Import is...
Customer experience | Sales, Customer Insights,...
Suggested answer

Export & Import issue in Dynamics 365 V 9.1.0000.10733

(1) ShareShare
ReportReport
Posted on by bnsp4u 22

Hi All,

we are facing an issue with importing records,

  • Exported Contact list from X environment (ex: Contacts.xlsx)
  • Trying to import the same file in Y environment.
  • Both the environment are same only Organizations are different - Online (Dynamics 365 V9.1)
  • Environment Y is a fresh organization same as X with 0 contacts

Error as below: 

The record could not be updated because the original record no longer exists in Microsoft Dynamics 365.

Note: the above error copied from Description which is available only when I give forceClassic=1 in the URL (ex: https://xxxxxxx.crm5.dynamics.com/main.aspx?forceClassic=1&newWindow=true&pagetype=entityrecord&etn=importfile&id=616df6c1-c61c-ea11-a811-000d3a07b49b), and this Description value is null in the Unified Interface form.

Thanks,

bnsp

  • Mark_Dowell Profile Picture
    Mark_Dowell 95 on at
    RE: Export & Import issue in Dynamics 365 V 9.1.0000.10733

    Brilliant, thanks bnsp! This solved my problem

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Export & Import issue in Dynamics 365 V 9.1.0000.10733

    Hey bnsp4u,

    that is actually something tricky one has to know to work with.

    When you are exporting data into Excel files from Dynamics 365 the system exports the records with their GUIDs and some other data. It is done so, because you could edit a bunch of records in your excel file, re-import into the same organization and the changes would automatically apply to the existing records. It works because the system finds these records via the data which is in the columns A, B and C in the excel file.

    Sooo:

    If you want to import an excel file into a totally empty environment and you are fully sure that both instance are exactly the same, you need to empty the Columns A, B and C inside the excel file. Open your Export file and you will notice that the table starts with column D. The first three columns are hidden. You need to "pull" them out by clicking and holding the left border of the D column. Once you have all columns visible simply empty all values in them. Then import that file into the new environment. Since there are no GUIDs etc. the system will automatically create new records.

    pastedimage1576457521000v1.png

    pastedimage1576457795023v1.png

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Daivat Vartak (v-9davar) Profile Picture

Daivat Vartak (v-9d... 225 Super User 2025 Season 1

#2
Vahid Ghafarpour Profile Picture

Vahid Ghafarpour 78 Super User 2025 Season 1

#3
Sahra Profile Picture

Sahra 43

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans