Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Upgrading to Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
I am using DIEF and the Customer entity for migrating customer data into AX2012.
In my installation I have several custom fields on CustTable but they do not appear in the staging-to-target mapping. It seems that the table DMFTargetXML defines all the fields in target tables but it holds no entries related to my custom fields.
The query DMFCustomerTargetEntity has CustTable as datasource and it contains all my custom fields (forced by flipping the 'Dynamic' property on the Fields-node).
What is the procedure for updating an existing entity with custom fields?
If you open the form Modify target mapping, you can click the button 'Mapping Details'. At the top, you have the option 'Generate mapping'. Click this button for (re)generate the fields and mappings. You will then have the option to start from scratch or only look for the changes.
André Arnaud de Calavon
This solved the problem. Thank you very much!
Nice try :) But it didn't solve the problem for me.
In "mapping details", even after regeneration, the customized fields are not there. When trying to add one manually (pressing "New"), I see all the customized fields at the dropdown of "Target field" column, but none of them at dropdown of "Staging field", so that, basically, I'm unable to match these fields. Any idea about how I can add these custom fields to the staging table?
Did you add the new fields in your Staging table? You have to do this manually if the entity already exists. Did you use the same fieldname as the target? Please check this first.
Ok, it's fixed now. You have to go to AOT and add the fields to the table named whatever the "Staging table" name is, and then regenerate. Thank you.
Can either of you help me to find the staging table so I can add my custom fields. I've added custom fields to the InventTable and need to do an import now. Any idea what the staging table is called so I can add the same fields there?
Nevermind, I found the tables, they all start with DMF. Thanks!
You can also lookup the name of the staging table in the target entities form. In this form you will also see the object names of the target query and entity helper class.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics