Knowledge Center

14 Aug, 2020

How to migrate Closed (Won or Lost) Opportunities?

Posted on 14 Aug, 2020 by Admin, Posted in Dynamics 365 Dynamics-365 Sales

How to migrate Closed (Won or Lost) Opportunities? Blogs

How to migrate Closed (Won or Lost) Opportunities?


In this blog I have explained how to migrate historical Closed (Won or Lost) Opportunities.


We will use comma separated (CSV) file as import file. Here are some important things you need to consider:

  1. Get your import file ready: Make sure your data is as complete and accurate when you create the import file.
  2. Make sure that the import file has “Status” & “Status Reason” fields information.
  3. Format of your date and crm environment should be same: make sure that “Source” and “Target” date formats are same. Because if “Source” system format is different than “Target” then system will throw an error.
    1. To check it, go to Settings > Data Management > Imports.
    2. Click on Setting icon at top right side of the import page.
    3. Select Options.
    4. Check your date format and crm environment date format are same or not, if it is not change it select your date format.

Step by Step

  1. Go to Settings > Data Management > Imports.
  2. On the command bar select Import Data > Import Data.
  3. Browse and select the import file and click on Next.
  4. Now, it will show you file upload summary, click on Next.
  5. Select data map, here I am selecting the Default one.
  6. Now select record type as Opportunity, Click on Next.
  7. In step 5, we had selected Data Map to default, it will automatically map source fields to crm fields. Here we need to check its mapping and map or un-map according to our requirement. Click on Next. (Unmapped fields will be ignored.)
  8. Now it will show you Review Mapping Summary. If you want to change some mapping them click on “Edit“, if not then click on Next.
  9. This is the final step, here you can configure some setting such as “Allow Duplicates”, “Select owner of imported records” and “Data map name”, choose accordingly. After that click on Submit.
  10. Now import is submitted, to verify that the wizard was successful, select Imports, and then review the report. Otherwise, select Finish.


This is a Required Field


Recent Updates

11 Jun, 2024

How to create a routing rule set to route cases in Dynamics 365

In this blog we will discuss how to create a routing rule to automatically route the cases to queue in…

06 Jun, 2024

Restoring Deleted Records in Dataverse Tables

In this blog post, I will be discussing how we can restore the deleted records from any table in Dataverse.…

15 May, 2024

Associated Grid Control Component in Dataverse

The Associated Grid Control enables us to improve the simplicity and readability of forms by displaying related record details across…