How to use Data Import Export Framework Module in AX 2012.

on
  • Go to Data import export framework à Setup à Data import / export framework Parameters.

  • Click browse to select shared working directory then click Validate button then close the form.

  • Go to Data import export framework à Setup à Source Data format, Create new source name and make sure to choose File in the File format field then select the file format in my example I’ll use excel.
  • Go to Data import export framework à Common à Processing Group

  • Create New Group then Click the Entities Button.

  • In the entities form select the Entity, Select the Source data format, then Click the generate source file button.

  • In the wizard click next then, select the fields. Then click Generate sample file.


  • When you click on Generate sample file then Excel Sample file will be open.

  • Go to Excel sheet and enter the field details and save.

  • Then click on Finish button. When you finish make sure to save the file in the shared folder that we specified above.

  • Go back to the Processing group à Entities à Select the Entity, Specify the Sample file path then select the sheet lookup (Automatic created).

  • Then click Generate source mapping button.


  • To preview the Vendor entity details select Vendor entity then Click the Preview source file button. Then close the form.

  • In the Processing group select the Group name then click the Get staging data button to copy the file data to staging table.

  • Select Job ID and fill the Description then click OK to create job.

  • Click Run in the Staging data execution form.

  • Then click OK to Run the Batch job.

  • The records will be inserted in the staging.

  • In the processing group select the Group name then click Copy data to target button.

  • Select the Job ID that we created then click OK.

  • Click Run to import data.

  • Then click ok to run the Batch job.

  • The data will be written to target.

  • To view the imported Vendor go to the Accounts payable àCommon àVendors à all vendors form, you will found that the vendor was imported successfully.

Comments

Post a Comment