AX 2012 | Import Data From an ODBC Through DIXF

Microsoft Dynamics AX 2012 Data Import/Export Framework provide the functionality to import data from an ODBC data source into Dynamics AX. In this post we will illustrate how to import Vendor data from MS SQL database into AX. First we will create sample database that contain vendors data. Then create an ODBC data source, Set up DIXF to import the data to the vendor entities.

Convert Field Values During The Importing Process Through DIXF

In the last two articles we discussed how to:

• Configure DIXF To Automatically Generate Unique Key Using Number Sequence.
• Assign Default Values Automatically During the importing process through DIXF.

Today we will discuss how we can convert the field values during the importing process.

Sometimes we may need to convert some of the master data values, especially when we planing to import data from a legacy to new system. For example, assume that one of your clients request to reclassify the vendors from a business line to a new one. in this case you can set up DIXF to convert the old business line value to the new value instead of change the business line for these vendors manually.

The following example we'll show how to convert the Vendor Line of Business during data import process.However we can use the same approach to change the values for any other fields.

Assign Default Values Automatically During the importing process through DIXF

During the preparation to import data, we often find ourselves having to fill a lot of values that are often the default values. For example, language, currency, customer group or group of suppliers etc....

In this article i will show you how we can assign default values during the importing process through DIXF.

The following example illustrate how to automatically assign default values for vendor currency and vendor group during the importing process. However we can use the same approach to assign default values for any other fields.

Configure DIXF To Automatically Generate Unique Key Using Number Sequence

Do we really need to manually add the reference numbers in the source file when we planning to importing data through the Data import export framework ? No we don't need to do that anymore :)

In this article i will show you how we can Configure DIXF to automatically generate unique key using number sequence during the importing process.

The following example illustrate how to generate vendor accounts automatically during the importing process. However we can use the same approach to generate the unique key for any entities.

Importing purchase orders using DIXF

In this post we will illustrate how to import purchase orders through data import export framework. we will use one excel file which contain purchase order header in first sheet and purchase order details in another sheet.


to import the purchase order please do the following steps:

AX 2012 | Import Released products using DIXF

This post illustrate how to import released products using the data import export framework in Dynamics AX 2012. We are going to import some of the released products information, you can add or remove fields as needed.

To import the released products please follow the steps below :

Vedio | Import main accounts using data import / export framework

Video | Import Assets using data import / export framework | AX 2012

Video | Import Customer accounts using DIF | AX 2012

Video | Import Vendor accounts using DIF | Dynamics AX 2012

Import Projects using Data Import framework AX 2012 R3

Video | Import Financial Dimensions using Data Import framework | AX 2012 R3

If you don't like to read the long steps in my article about how to import financial dimension using Data Import framework in AX 2012 R3. you can just watch the video :)

Import Workers using Data Import framework AX 2012 R3

This post illustrate how to import Workers using the data import framework in Dynamics AX 2012 R3.We are going to import some of the Worker information you can add or remove fields as needed.

Import Assets using Data Import framework | AX 2012 R3

This post illustrate how to import Assets using the data import framework in Dynamics AX 2012 R3. We are going to import some of the asset info you can add or remove fields as needed

Import Vendor Groups using Data Import framework | AX 2012 R3

This post illustrate how to import Vendor Groups using the data import framework in Dynamics AX 2012 R3

Import Main Accounts using Data Import framework | AX 2012 R3

This post illustrate how to import the Main Accounts using the data import framework in Dynamics AX 2012 R3

Import Vendors using Data Import framework | AX 2012 R3

This post illustrate how to import Vendors Accounts using the data import framework in Dynamics AX 2012 R3

Import Customers using Data Import framework | AX 2012 R3

This post illustrate how to import Customers basic information using the data import framework in Dynamics AX 2012 R3

Import Financial Dimension using Data Import framework | AX 2012 R3

This post illustrate how to import the financial dimension using the data import framework in Dynamics AX 2012 R3. Follow the steps bellow to import the financial dimension values to Dynamics AX 2012. If you prefer to watch Video rather than reading the following steps, please visit my YouTube Channel.

DIXF Part III: Import main accounts using import / export framework | AX 2012 R2

In this tutorial i discussed how we can import main accounts using the data import / export framework in Dynamics AX.

Hope that my language will get better in the next tutorials :)