Importing using the Data Import Export Framework

(0) Share

Report

Posted on by Community Member

Hi Everyone

When i import a file using the import export framework using the Vendtable , i selected all the primary strings that are mandatory , but i only want to update 1 field , eg. the Default Warehouse field , it imports the data but it updates my Vendor name with a blank, even though i didnt select the name field when i generated the source file..

Why would this happen?

Regards

Martin

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Suggested answer

Ajit 8,788 on at

Like (1)

Report
Copy link

Link copied!

I just tried and yeah you are right, it is updating the name. Here you have two options -

1. Customize DMFVendorEntityClass and update the staging table with the name, you can find name by account num.

2. Provide the vendor name as well in your file. you can export the data from AX.

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

Hi Xaere,

There are 2 types of mapping in DMF: from source to staging and from staging to target. If value is blank in the source file or there is no source to staging mapping AX will bring empty value to staging table. Then you will copy values from staging to target. At this stage AX picks up a value from the staging and it's blank in the staging, so AX updates name with blank value. To prevent AX doing this you can remove this field from staging to target mapping. In this case AX will ignore it and won't update target.

Was this reply helpful? Yes No
Ajit 8,788 on at

Like (1)

Report
Copy link

Link copied!

You are talking about 'Target mapping' right?

Here I do not have a column 'Name'.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Guys ,

To Answer you Questions

Ievgen : The problem is that i didn not select the name field during the "Generate Source File" stage, since the names are correct and i dont want to update them , if i use the DMFVendorEntity Table there are 3 Primary keys i have to include , AccountNum,VendGroup and Currency, if i want to import the Warehouse and Site, i have to also import those 3 fields,

But the proble is that even if i only select those 5 fields when generating the mapping , it still updates the Name to blank , that is what confuses me,

Could it maby be the "Run Business logic in insert or update method" or the "Run Business validations" Tickboxes?

Than you all for you replies

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ajit : Please see my comment below

Was this reply helpful? Yes No
Suggested answer

Ajit 8,788 on at

Like (0)

Report
Copy link

Link copied!

Yeah that's weird, we might have to debug. You can override 'postGetStatgingData' method of that entity class and populate name for now?

Was this reply helpful? Yes No
Sangram Shinde 2,120 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

Standard DIXF will update VendName as well while you are using Vendor Entity to import the records, you might need to debug it to check how the buffer is getting these values. But for quick fix on this you can export all the vendor records and put vendor names in your source file against account numbers so that you will have them in system as is.

Was this reply helpful? Yes No
Verified answer

Sangram Shinde 2,120 on at

Like (1)

Report
Copy link

Link copied!

Hi Martin,

Below can be the possible solutions-

1) Comment case generateparty in getReturnFields() method of entity class, do incremental CIL and check import

2) Go in Vendor entity->Modify Target Mapping->Select method 'GenerateParty' and mark the checkbox 'Call modified field method', run the import and test.

I tested with these options in my environment and it is working. (Updating vendors without making vendor name blank) I am not sure whether it will work for you but you can try these options. Please let us know the result if it works.

Was this reply helpful? Yes No