Data Import/Export Frame Work in AX 2012

Data Import/Export Frame Work

If we want to Export/Import Data Using DIXF and DMF frame work, then we will follow these Bellow steps:

we  will work  Mainly on five Forms.

Step1: Now first we will set the Path certain directory. And it should be Shared.

And It Should Be set by Admin Level.

Data Import Export Frame Work>>Setup>>Data Import/Export Framework Parameters>>

Here Select our File. Like: DIXF && Validate.

Step2:  Set source Data Formats.

àCreate Source File and Type and Make sure to Choose File Format.

àHere Source File Type is 3 types:

1.File      ---------------->It is used to importing. Using File Formats like: Delimited, Fixed Width, XML, Excel.

2.Ax       ---------------->It is used to Exporting.

3.ODBC ---------------->It is used to Importing Data through ODBC (Open Data Base Connectivity) like: SqlServer (or) Oracle (or) MySQL etc.

Step3:  we are working Processing Group from.

In this processing Group form we have 9 tabs.

1.New.

2.Delete.

3.Entities.

4.GetStagging Data.

5.Copy data to Target.

6.Exection History

7.Export to Ax.

8.Export to File.

9.company.

II àStep1:  First  worked on Importing Data Using Csv File Format.

Here first Create Source File and Type Must File. File means ---> Delimited (or) Fixed Width.

And Set Column Delimiter and Row delimiter. Like; :|{CR}{LF},

Step2:  Go to Data Import Export Frame work>>Common>Processing Group>>

Create New Group and Click Entities Button.

When we create Group name and save that one , Then Automatically Entities Button Is Enabled.

Once clicked Entities Button the Sub Form will be Opened.

àIn this Sub form have 7 major Tabs.

1.New

2.Delete.

3.Select.                                         -------------------->Using Exporting.

4.Generate Source mapping.

5.Modify Source mapping.

6.Validate.

7.View target mapping.

8.preview Source File.

Step3:  Here We Selecting Entity and Source data format and then Click Generate Source File.

Step4:  And Generate Wizard. And select entities Related Fields.

Step5:  Clicked Generate Sample File Button. And Generate Sample File, save that file Particular drive and add some data Regarding Importing.

And Then click Finish Button.

Step6:  Select sample File (Before We save File).

When we will select sample file Automatically Enable Generate Source Mapping and Modify Source Mapping.

Then click Generate Source mapping button.

If you want any Modification We will click Modify Source mapping.

Here Apply Mapping Using Conversion and Mapping Details.

Step7:  Before We go to Staging tab we will check Preview Source File.

Step 8: Close That Sub Form. And Open Main Form.

Then Get staging Data Tab is enable.

Click That tab and Open Dialog Form there was One Job Id and Description.

And Click Ok.

Then Open Staging Data Execution Form.

Then Click Run Button and open Batch Form.

Click ok.

Step 9: When we will close Run Base Form the Copy Data to target button Enable.

This is the Final Step of Importing data Using CSv.

if you Click Ok. Target Data Execution Form will be open

Then click Run. it opens batch Form.

Then Click ok.

Step 10: Data Success Fully Imported.

Here We Can Check Execution History also.

As A  Developer. We  should Know About Which Forms and tables are Using.

Main Form ---->Processing Group Form

1.DMFDefinitionGroup                  --------->Form

2.DMFDefinitionGroup                  --------->Table

3. DMFDefinitionGroupDataArea -------->Table

Entities Form----->Sub Form.

1.DMFDefinitionGroupEntity.   ------->Form.

2.DMFDefinitionGroupEntity.   ------->Table.

3.DMFEntity.                                 -------->Table.

Modify Source Mapping Form.

1.DMFSourceXMLToEntityMap ------> Form.

2.DMFSourceXMLToEntityMap ------>Table.