Finance | Project Operations, Human Resources, ...

Data Import export framework

(1) Share

Report

Posted on by Lathi

Hi experts,

I have created an entity to load the cost price of the item in the material master data when importing by the legal entity using the data import-export framework for entry attributes did not receive any error at source (get stagging data) run file from the path, am facing the below error,

I also checked that the price field is already present in the source-target mapping.

can anyone please suggest a reason why I am getting this error? how is able to fix it

your reply is highly appreciated

Thanks in advance

All responses (8)

Answers (0)

WillWU 22,350 on at

Like (0)

Report

RE: Data Import export framework

Hi Lathi,

Please also check this old thread, you have to convert some enum values in your table by yourself.

community.dynamics.com/.../data-migration-sql-error-description-microsoft-sql-server-native-client-11-0-sql-server-conversion-failed-when-converting-the-nvarchar-value-string-to-data-type-int
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Data Import export framework

Hi Lathi,

Looks like it is trying to convert the Cost field from string to int which is causing the error. Can you try synchronizing the table "InventItemPriceSim" and check if you get any errors?
Lathi on at

Like (0)

Report

RE: Data Import export framework

Thank you so much Will, for the great assistance,

I fixed the above error but now I have encountered this new error at the time of (copy data to target), please also suggest me to fix it

Thanks
Lathi on at

Like (0)

Report

RE: Data Import export framework

Thank you so much Gunjan for the great assistance,

I fixed the above error but now I have encountered this new error at the time of (copy data to target), please also suggest me to fix it

Thanks
Suggested answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Data Import export framework

You can check source file. If there is a space after "Price". You may also try to re-generate the source file and check if that takes care of this error.
WillWU 22,350 on at

Like (1)

Report

RE: Data Import export framework

Hi Lathi,

Yes, please check if you have a space there at the "price" filed in your CSV file header,
Lathi on at

Like (1)

Report

RE: Data Import export framework

HI Gunjan,

Yes, I'm using the CSV file format to import the data, so what should I check did you meant the file?

sorry but i didn't get your point
Suggested answer

Gunjan Bhattachayya 35,421 on at

Like (1)

Report

RE: Data Import export framework

Hi Lathi,

Are you using csv as input format? If so, please check this thread. You might be facing the same issue.