The views and opinions expressed in this blog are those solely of the author(s) and do not necessarily reflect Microsoft’s current policy, position, or branding. For official announcements and guidance on Dynamics 365 apps and services, please visit the Microsoft Dynamics 365 Blog.
Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
This page provides a list of published documentation, known issues, solutions, and tips and tricks to help you import, export, or migrate data for Microsoft Dynamics AX 2012.
This page contains the following sections:
Data Import/Export Framework
A new example of how to use the Data Import/Export Framework is available at: Importing a General Journal using Data Import/Export Framework AX 2012.
The Data Import/Export Framework was release as part of AX 2012 R3. It includes the following features:
For more information about the Data Import/Export Framework, see the Data import/export framework user guide and What's New: Data import/Export Framework.
Test Data Transfer Tool
The Test Data Transfer Tool is used to install the AX 2012 R3 demo data. For a tutorial on how to use it, see Walkthrough: Import demo data for AX 2012 R3 by using the Test Data Transfer Tool.
To learn more about how to import, export, or migrate data into Microsoft Dynamics, review the following resources.
Choose the best tool for your task
This section lists common issues encountered when importing, exporting, and migrating data.
Important: If you encounter a problem when importing, exporting, or migrating data, we recommend that you use Issue Search on Microsoft Dynamics Lifecycle Services to research it. Issue Search is a search engine that you can use to quickly search for KB articles, hotfixes, and workarounds for reported issues in Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 R2. You can see which reported issues are in the process of being fixed and see notifications when a hotfix is released for a specific functional area in Microsoft Dynamics AX. You can download released hotfixes, see which code objects are affected, and see the code changes introduced by the hotfix. In order to use Issue Search, you must have a CustomerSource or PartnerSource account, and have created a project. For more information, see the Lifecycle Services User Guide.
Version: The following issues are found in the version of the Data Import Export Framework for AX 2012 RTM and Feature pack from InformationSource
Issue: Some customers have recently been unable to install some hotfix packages for Microsoft Dynamics AX 2012 R2 if they are running a release before CU7, have a DMF model in the FPK layer, and are installing a hotfix released after CU7. Customers see the error "Violation of PRIMARY KEY constraint 'PK_ModelElementData_ElementHandle'".
Resolution: Follow the instrucitons in the blog post Violation of PRIMARY KEY constraint 'PK_ModelElementData_ElementHandle' error installing some hotfixes on Microsoft Dynamics AX 2012 R2.
Issue: After installing the Data Import/Export Framework you get a number of compile errors related to missing macros.
In the AOT, examine the macros node. There should be AxdAdvancedLedgerEntryDCT and AxdCustomerTransactionDCT macros in the node. If you do not see these macros, then do a compare on the DataContainerTypes macro to make the macros visible.
Issue: When you enter Setup > Data import/export framework parameters you get the error message: "Assembly containing type Microsoft.Dynamics.AX.DMF.ServiceProxy.DmfEntityProxy is not referenced".
Create the structure c:\Windows\Microsoft.NET\Assembly\GAC_MSIL\Microsoft.DynamicsAX.DMF.ServiceProxy\v4.0_1.0.0_31bf3856ad364e35\and then paste the file Microsoft.Dynamics.AX.DMF.ServiceProxy.DLL, from C:\Program Files\Microsoft Dynamics AX 2012 Data Import Export Framework Server Component.
Restart the AOS, and compile into CIL.
Issue: Importing Ledger Dimensions in Data Import/Export Framework in AX 2012 R2 does not function. You get the message "Financial Dimension 0 does not exist" when importing ledger dimension values.
Contact support for a workaround.
Unable to select ODBC connections created as System DSNs. You get the message: “System.NullReferenceException: Object reference not set to an instance of an object.”
Create a User DSN instead.
Issue: Creating a custom entity that imports to a table with a primary index that allows duplicates will import only one record.
For additional troubleshooting information that is regularly updated, see Lifecycle Services Issue Search.
Suggested alternate search terms:
Data Import Export Framework: DMF, DIEF, DIXF
RapidStart for Retail (InformationSource)
We recommend the following blogs:
If you’re still having trouble, you can get assistance in the following ways:
You can enter a support request on CustomerSource or PartnerSource by selecting Support > New Technical Support Request.
You can also contact Microsoft Dynamics Technical Support by phone using these links for country/region-specific phone numbers:
For specific issues like yours, we recommend that you go ask for help on the AX community forum, or file a support case.
The forum is here:
Hi, i'm getting some trouble while migrating routes. I'm getting an error saying that "Operation number XXXXX does not exist". This is happening when i try to migrate the "Resourse requierement entity". That operation exists and i have uploaded it through the operations entity. Do you know what may i be doing wrong?
Another doubt i have is about which field name should i use to indicate the resource or resource group id. I mean, after i choose the "RelationshipType" i need to indicate the id of the resourse, group, capability, skill. In AX 2012 R2 that field was the "WrkCtrId" however it doesn't appear anymore on the new entities.
Hope you can help me, thanks for your time!
Business Applications communities