Troubleshooting Data Import Export Framework Dynamics AX 2012 Error: 0 records have been inserted in Staging Tables

This is one of the errors you get when you are trying to import your Data in AX 2012 through the Data Import Export Framework.

Error in DMF

It is very frustrating to trace that one record, from a large set of data that is the cause of this error. This error usually arises when your primary key is duplicated in the import data file.

Always make sure to perform the following steps before importing your Data in AX 2012 through the Data Import Export Framework. Open your file in excel and select the primary key column. Go to Condition Formatting in the Home tab and select Highlight Cell Rules-> Duplicate Values. This function will highlight the duplicated primary key records. Fix the records before importing your data in AX in order to avoid such errors.

About the author

Fatima Zafar is an Associate Software Engineer in the Dynamics Team at Systems Limited. She is extremely passionate about her work and loves to explore development platforms and tools. As a technology oriented person, she has under her belt a wide range of experiences including technical writing, tutorial development and blogging for technology and has dabbled (significantly well) with X++, .NET and MySQL. Currently working as a Microsoft Dynamics AX developer, she aims to explore as many areas of Dynamics as she can. Other than AX, her passions include graphic designing and she would like to work more on that front as well.

Leave a Comment

Name (required)
Email (required)
Comment (required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>