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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Testing VS production

(0) ShareShare
ReportReport
Posted on by 340

Hello,

I went to production view of an entity and export it into excel. And then I go to the same entity in development and import the data. 

The issue I always come across when begin to import data to development is the part at Map Record Types. 

The fields are not the same or I can’t scroll down to the one the production has. 

I am trying to get my testing environment to be very similar to my production environment but it doesn’t seem to be easy to do.

for example I go to production and export from recent job view take the data go to testing in recent job view I import it but when I come to the below screen I can’t find the recent job record type to match to import. 

How is can I get my testing environment to be similar to my production to do advancing coding and testing. I can’t do it in production that is not standard. How do you guys do it ?

pastedimage1571530356221v1.png

I have the same question (0)
  • LuHao Profile Picture
    40,892 on at

    Hi partner,

    The display names of the fields in the Excel file should be consistent with the display names in the imported environment.

    If there are inconsistent fields, then you need to match them or ignore this field.

    In addition, not all entities support the import feature.

    Could you try to export this entity's Excel from the development, modify it and re-import it into the development?

    Please refer to these links for details on the import features:

    1. https://coderscollection.wordpress.com/2018/03/15/setting-data-management-data-maps-data-import/
    2. https://www.encorebusiness.com/blog/how-to-use-import-in-dynamics-365-customer-engagement/
    3. https://www.quantacrm.com/2017/03/02/create-new-data-map-microsoft-dynamics-365-sales-crm/
  • Johnseito Profile Picture
    340 on at

    Hi,

    I tried just that, export it to excel of this particular view and because it doesn’t have value. I get data from production of the same view and header and import it and got many different type of error message.

    I even add data to the emptied file and import it and it wasn’t successful.

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…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Siv Sagar Profile Picture

Siv Sagar 93 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 74

#3
Martin Dráb Profile Picture

Martin Dráb 64 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans