Sunday, August 24, 2014

DIXF Part I:Export Customers to DAT File | Dynamics AX 2012

Purpose: The purpose of this article is to illustrate how to use Data import/export framework(DIXF) to export Customers Accounts to DAT File.

The DAT file used to transfer master data from Microsoft dynamics AX instance to another.

To Export the Customers Accounts please do the following steps :

  1. Go to Data import export framework ---> Source Data Format.
  2. Click New in the source name write "DAT" in the description write "DAT File" and from the Type drop-down list select "AX" then Close the Form.
  3. Go To Data import export framework ---> Processing Group.
  4. Click New ---->Write "CustDat" in the Group Name-->Write Description ---> Click the Entities Button.
  5. Select Customer from the Entity Field ---> Select DAT from Source data format (the source which was created in step 2)--> then click Close.
  6. Select "CustDAT" form the Processing Group ----> then Click the "Get Staging data" button to export the customer data from the original table to temporary table.
  7. Write proper description for the staging data job --> Then click "OK" button.
  8. Click "Run" button in the "Staging data execution" form.
  9. Click "OK" Button.
  10. The message inform you about the the record number that have been inserted in the staging Table --> then Click "Close" Button.
  11. Select "CustDAT" form the Processing Group ----> then Click the "Export To AX" button to export the customer data from the Staging table to the DAT file.
  12. write the file name with full path (Always use folder ) ----> then Click "OK" Button.
  13. when you check the path you will find that the export process was generated to files one .dat and the other one is .def

To get the updates and new posts please follow the blog by clicking the Join this site Button in the top-right side under my personal information. 

See Also

Troubleshoot issue with a Data Import/Export Framework installation from cumulative update 7 for Microsoft Dynamics AX 2012 R2.