Sunday, 23 June 2013

Create a custom data import export framework entity[AX 2012]

Previously I had created a simple job to import Ledger alias. This post I will look at doing the same with the Data import export framework.

There is no entity in the DIEF (Data import export framework) to import ledger alias. So, we have to create a new one.

You can follow the Microsoft technet article but I will show you some screenshots here.

http://technet.microsoft.com/en-us/library/jj933277.aspx

One big thing you will realise is that it isn’t that straight forward for a non-developer. But for a developer it should be relatively easy to create a powerful import entity.

1. Click on Data import export framework > Common > Custom entity wizard

Select or enter the table name – in this case it is DimensionAlias.

DA2013-06-17_1459

2. Suggested names and options are set. Leave the default.

DA2013-06-17_1500

3. You will get a message about ForeignKey relationships. Just click yes.

DA2013-06-17_1504

This will take some time. A few minutes.

4. You will get errors.

DA2013-06-17_1512

5. A private project will be created. In my case it didn’t create all the elements it was supposed to. But that's easy enough to finish off manually (my preferred method).

DMF2013-06-21_1941

6. Field group – If you have any generate methods. Then you have to setup a Field group for them. The suffix number you see will set the sequence

DMF2013-06-21_1937

7. Title fields – make sure you set the title fields. Otherwise you will run into some errors.

DMF2013-06-21_1939

8. DMF class required – writing code for all your generate methods.

DMF2013-06-21_1940

That is it. You are ready to set it up and start using it.

You can download the full xpo project and start using it. Hopefully this blog gives you an appreciation for Data Import/Export Framework.

Download the xpo project

2 comments:

Prologic Corporation said...

This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
healthcare, e commerce, programming, multi platform,inventory management, cloud-based solutions, it consulting, retail, manufacturing, CRM, technology means, digital supply chain management, Delivering high-quality service for your business applications,
Solutions for all Industries,packaged applications,business applications, Web services, data migration
Business intelligence, Business Development, Software Development etc.


Our address:
2002 Timberloch Place, Suite 200
The Woodlands, TX 77380
281-364-1799

prologic-corp

Blogger said...

If you need your ex-girlfriend or ex-boyfriend to come crawling back to you on their knees (even if they're dating somebody else now) you got to watch this video
right away...

(VIDEO) Win your ex back with TEXT messages?