AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 28.10.2015, 20:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
kurthatlevik: DAX2012R3CU9 – DIXF – Automate import/export without customizations
Источник: https://kurthatlevik.wordpress.com/2...ustomizations/
==============

The Microsoft Dynamics AX 2012 Data Import/Export Framework(DIXF) is an AX module import and export data in Microsoft Dynamics AX. We often use it in data migration projects to load legacy data from old systems. I was wondering if I could use DIXF as an automated integration, without any customizations. I wanted to see if I could have a folder where new customers are dropped in a folder, and then the DIXF automatically picked up the file, and imported it.

My first step is to have a small and minimalistic Excel sheet, that users can paste in the new customer records. This is how my Excel sheet looks like:

Most of these customers exists from before, but the last record is a new customer that don’t exists in my database.



The recommended process of setting up an import/export process is described here.



The first step is to create a source data format:



I then determine what entity to use, and create a target entity



When I do this, the mapping is done automatically for me, and I don’t have to understand all the database related complexity.

My next step is to create the processing group



 

I then click on the Entities in the processing group, and I select my created entity and that I want to use my created Excel source data format. I also select a sample file to see if the mapping is OK.



I then just check the mapping from Excel to the staging format, and make the necessary corrections.



My next step is to go back to the processing group, and to make the necessary batch job for automatic processing.



As you see here, I set the “type” to Directory, that DIXF will scan for new files. I also specify directories for processing, completed and error. I have therefore created the following directory structure for each integration:



The other important thing is the “Execute target step”. This this used for also executing the step that transfers data from the staging table to the target tables.

I then want this to be work in batch, so I enable the batch processing.



And then I need to wait for an entire minute……… I then saw that the file was moved from the 1_new folder, and ended up in the ¤_Completed folder.



I also see in the execution history, that the files was imported into the staging tables, and then imported into the target tables.



In my customer overview, I now see that I have a new customer, but is also made sure that other related data as addresses, and phone etc was created.



This concludes how you can use DIXF to automatically import data. What I can now do to import data, is just to create my Excel file, and then dump it into the right folder (.\1_New), and then the batch system take care of the test.

If you wonder all entities that are “out-of-the-box” supported from Microsoft, then take a look here. If still something is missing, you can always ask a developer to assist in creating the DIXF entities you need.

Happy DIXF’ing J

 




Источник: https://kurthatlevik.wordpress.com/2...ustomizations/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
Теги
dixf

 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
DIXF. Data Import Export Framework пошаговые руководства в картинках demoded DAX: Функционал 0 23.09.2015 01:01
kurthatlevik: DAX2012R3CU9 – DIXF – Automate import/export without customizations Blog bot DAX Blogs 0 21.08.2015 16:11
Dynamics AX Sustained Engineering: Announcing an update to enable the use of SQL Server 2014 with the AX 2012 R2 CU7 version of the Data Import/Export Framework (DIXF) Blog bot DAX Blogs 0 23.03.2015 22:12
kurthatlevik: Import/Export: Reinventing the wheel Blog bot DAX Blogs 0 27.12.2013 18:11
axsa: Microsoft Dynamics AX 2012 Data Import/Export Framework standalone version for AX 2012 R2 without installing full CU7 Blog bot DAX Blogs 0 04.12.2013 04:13
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 04:15.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.