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.





1 comment:

  1. Here is the investors contact Email details,_   lfdsloans@lemeridianfds.com  Or Whatsapp +1 989-394-3740 that helped me with loan of 90,000.00 Euros to startup my business and I'm very grateful,It was really hard on me here trying to make a way as a single mother things hasn't be easy with me but with the help of Le_Meridian put smile on my face as i watch my business growing stronger and expanding as well.I know you may surprise why me putting things like this here but i really have to express my gratitude so anyone seeking for financial help or going through hardship with there business or want to startup business project can see to this and have hope of getting out of the hardship..Thank You.

    ReplyDelete