web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Dynamics AX 2012 Data ...
Microsoft Dynamics AX (Archived)

Dynamics AX 2012 Data Import/Export Framework mapping issue

(0) ShareShare
ReportReport
Posted on by aip00

I am attempting to move data from AX 2009 to AX 2012 using the new Data Import/Export Framework. The Framework is installed in AX 2012 without issues. And I am able to migrate most of the table over to AX 2012 via ODBC.

There is one table in AX 2012, EventRule, that contains a type "Container" field. I created a custom entity in AX 2012 and was trying to pull the data to the Staging table. However I encountered an issue that the framework could not pull the Container data from AX 2009 to AX 2012. The error up front says "Package execution failed please check eventlog in DMF service box". The Data Import/Export Framework server log shows that the Framework DLL tried to convert the Container field into String field in AX 2012. But the source to staging mapping shows that they are mapped correctly (from type Container field to type Container field).

Has anyone encounter any issues in the Framework while trying to pull table with Container fields to AX 2012?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

    Hi Andrew,

    I like this question as we had the same issue when using the first beta of DMF. We had to copy documents and notes as well (DocuRef). This is a similar storage. I have not looked at this yet in the latest version.

    We created a table where the references to the table were stored with the key values of the table in stead of the record-id reference. then copied all data into this table and enriched with e.g. cutomer number or vender number etc.

    This table was exported by the standard definition groups and imported in the new version (same table structure). From this table the reference records were queried and the data was copied to the docuref table again.

    In the new Data Import/Export Framework you can import and export the DMF tables more easy as well.

    So you can create the staging table as suggested above in both AX2009 and 2012. Then fill the table in AX2009. Export by use of the standard definition groups. Import into the staging table and then process further as it was loaded by use of a file or ODBC.

  • aip00 Profile Picture
    aip00 on at

    Hi Andre,

    I tried. I could not import the binary file created in AX 2009 into AX 2012. May I ask how you did it for DocuRef?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

    Hi Andrew,

    I checked it. Please ignore some of my words above. Importing the data in AX2012 by use of the AX 2009 file format was not working as we got messages as well. They used some direct SQL statements to get the data in AX2012. There was some help from a SQL administrator. Unfortunately the scripts are not saved...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans