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.
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.
Hi André, I have the reversed issue. The custom fields are on both the target and the staging table, but I can only see them on the staging entity not the target. I've tried to delete the entity and regenerate but the custom fields on the target table still doesn't show up. I can only see the fields in the staging table. I've working on the Customer and have added the new fields to both CustTable and DMFCustomerEntity. Do you have an idea?
You can check the target Query DMFCustomerTargetEntity. You also have to add the new fields here before regenerating the target mapping.
Thanks. That was spot on.
I encountered a problem while adding new fields to DMFProductEntity. The problem concerns fields: Markup and MarkupGroupId. I added these fields to the DMF staging table with the preceding name "InventTableModule" since they are originally placed in InventTableModule :
Fields Markup and MarkupGroupId were already included in Queries in corresponding tables.
I am able to see these fields in Mapping details in both Staging field and Target field. However, I am not able to get staging data because of an error "Exception from HRESULT: 0xC0010009".
Does anyone may have an idea what could go wrong and how could I solve this problem?
I will much appreciate any advice!