AX7/D365/Operations: Data import using data entities

Posted on Updated on

Purpose:

The purpose of this document is to demonstrate how we can import data using data entities in Dynamics 365 for Operations.

Prerequisites:

  • Access to Dynamics 365 for Operations instance via remote desktop.
  • To be provisioned as an administrator for the instance.

Business requirement:

Ability to import/migrate legacy business data to Dynamics 365 for Operations.

Process:

1. Navigate to Workspaces > Data management > Import.
2. Enter job details as shown below. We have selected a custom data entity Raw material in this scenario. You can safely use any standard data entity instead.

DataEntity6

3. Click Upload to select and upload the source data file.
4. Click View map to generate field mappings.
5. On Map source to staging screen, click Mapping visualization.
6. Define the mapping. Click Save.

DataEntity7

7. Now go back to the job screen and click Import.
8. At the end of the execution, you should see the Execution summary.

DataEntity8

9. You can verify the data loaded by navigating to the relevant form. In this case Raw Materials details master form.

DataEntity9

Advertisements

One thought on “AX7/D365/Operations: Data import using data entities

    Mamatha Guntu said:
    June 21, 2017 at 8:19 am

    Additional :

    If you are not sure of which form to navigate to check the data.
    Click ‘view staging data’ of the entity in the execution, select a staging record, and click ‘Target’. This will redirect to the form where you can check the imported data.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s