How to update existing records using DIXF?

(0) Share

Report

Posted on by Community Member

When I update an existing record (say, a customer) by using DIXF the record is updated with the values from the sourcefile - BUT - all target fields that are not included in my file are blanked.

So DIXF can only be used for updating if the sourcefile includes ALL the information on the target - or what?

This means that the typical task of updating a single field on a target entity after a data migration requires:

a) The original sourcefile enriched with the field missing in the data migration (assuming that the target records have not changed since the migration) or

b) Writing a job to read the sourcefile, locate the relevant record and updating it (aka the old-fashioned way)

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Bashir Ahmad 5,248 on at

Like (0)

Report
Copy link

Link copied!

This may Help:

technet.microsoft.com/.../jj225596.aspx

Was this reply helpful? Yes No
André Arnaud de Cal... 303,728 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Karsten,

I can't verify right now, but it is possible if the file only contains some fields to update only those fields using DIXF. I have done it in the past.

Can you provide information if the source mapping contains all fields or only those who are in the source file?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

The sourcefile contains only the fields (in the header record) for which there are values to be updated.

The source/staging-mapping obviously only contains to/from-maps for the fields actually in the file. The header record holds names that exactly match the staging fields so the DIXF auto-mapping matches all of the sourcefields.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

I'm experiencing the same issue and I haven't found a way how to get around it. For some reason some of the fields in the entity will stay altough not included in the source file and others will disappear. For example, using DMFProductEntity for updating lets say the EcoResProductTranslation_Name if I will not include InventTableModuleInvent_UnitId (the invent Unit ID) in the source file it will disappear on the product. Did you find a solution for this issue?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Any solution to this? Our company is looking to do a phased migration.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

The only (not tried) solution that came to mind back then was to change the mapping from staging to target (DIXF/Setup/Target entities/Modify target mapping) to include only fields that will need to be updated. Let me know if you were successful with this approach

Stanislav

Was this reply helpful? Yes No