Posts tagged with: Data Import Tool

AX2012 R3- How to Import Contoso Data using Test Data Transfer Tool (Beta)

Pre-requisites:

1-      Download the test data transfer tool from the below mentioned link.

https://informationsource.dynamics.com//RFPServicesOnline/Rfpservicesonline.aspx?ToolDocName=Microsoft+Dynamics+AX+2012+Test+Data+Transfer+Tool+(Beta)+-+Updated+7th+Jan+2014%7cQJ4JEM76642V-8-1465
2-      Download demo data for AX2012 R3 from partner source site.

Steps: 

  • Extract the demo data files from DynamicsAX2012R3DemoData.exe to a specific location.

zb1

  • The output folder will contain the files of following extension types:
  1. .OUT—– data file that contains metadata for AX transactional database
  2. .OutModel —- data file that contain metadata for AX model database
  3. .XML —- data file that contains AX table data.
  •  Run the Test Data Transfer Tool.Exe file to install the utility.

zb2

  • After successful installation, the folder will look like as shown below:

zb3

  • Open AX client and import the .XPO named (MetaDataXMLGenerator.Xpo)

zb4

  • On successful import a job will be created as shown below:

zb5

  • Run the job <MetadataXMLGenerator(usr)>, a  meta data file will be generated and the path will be displayed in the infolog as shown in the snapshot below:

zb6

  • Copy the metadata file from the above path and paste it in [lists] folder (where Test Data Transfer Tool has been extracted). If the file already exists, then overwrite the file.
  • Stop MS Dynamics AX service.
  • Open command prompt using administrator and navigate to the path where the Test Data Transfer Tool is extracted).
  • Run the following command:

Dp.exe Import “C:\R3DemoData\DynamicsAXR3DemoData” DynamicsAXR3

C:\R3DemoData\DynamicsAXR3DemoData—— update the path accordingly

DynamicsAXR3—— provide the actual database name.

zb7

If we enter ‘Y’, then following screen will open up describing the count for importing the table data and Error (if they come up)

zb8

  • The process may prolong depending upon machine configuration.
  • On successful import, Open AX client and data will show up.

zb9