DIEF (formerly DMF) - Refresh target entity new custom fields in target table

(0) Share

Report

Posted on by Community Member

Hi All,

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?

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Verified answer

André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (0)

Report

Hi Karsten,

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi André,

This solved the problem. Thank you very much!

BR Karsten

Was this reply helpful? Yes No
Alexey Lekanov 518 on at

Like (0)

Report

Hi, Andre.

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?

Best regards,
Alexey.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (0)

Report

Hi Alexey,

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.

Was this reply helpful? Yes No
Alexey Lekanov 518 on at

Like (0)

Report

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.

Best regards,

Alexey.

Was this reply helpful? Yes No
TCB5 1,825 on at

Like (0)

Report

Hello,

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?

Thanks!

Trisha

Was this reply helpful? Yes No
TCB5 1,825 on at

Like (0)

Report

Nevermind, I found the tables, they all start with DMF. Thanks!

Was this reply helpful? Yes No
André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (0)

Report

Hi Trisha,

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Thanks

Soren

Was this reply helpful? Yes No
André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (1)

Report

Hi Soren,

You can check the target Query DMFCustomerTargetEntity. You also have to add the new fields here before regenerating the target mapping.

Was this reply helpful? Yes No