search

Capgemini / xrm-datamigration-xrmtoolbox

Export and import data for Microsoft Dataverse as an XrmToolBox plugin. Supports JSON and CSV.
MIT License
8 stars 4 forks source link

Import Order Line, "Parameter name: Required field SalesOrder Id is missing" message display #40

Open GHSunnyGH opened 3 years ago

GHSunnyGH commented 3 years ago

SalesOrder Id has been contained in the xml file of order line，but when I imported the file for the first time with CDS Data Migrator, it says 'Warning:DataCrmStoreWriter PersistUsingUpdateCreateRequests : Create Entity Issue salesorderdetail:a836c0a9-05d4-eb11-bacc-000d3aa1256e - Error:Value cannot be null. Parameter name: Required field SalesOrder Id is missing'. But I click the “Execute”button again, the data can be imported normally.(The content of the file has not been changed yet.) What's the reason？Is there any problem with the operation?

In addition, the ‘description’ field cannot be updated by the field content in the xml file. The value of the ‘description’ field in the product entity is used to populate the field.

image

GHSunnyGH commented 3 years ago

When importing data of entity ‘customeraddress’，field 'Parentid' was included in the import file, but ‘Error:Parent id not set for address type 1071’ happened. How to avoid this problem?

image

tdashworth commented 3 years ago

Hi @GHSunnyGH, thank you for raising this issue.

Please can you provide the Schema and Import/Export config files used so that we can reproduce the issue?

Many thanks.

GHSunnyGH commented 3 years ago

Hi @tdashworth, please refer to attachment. Thanks for your support. Schema&ConfigFile.zip

tdashworth commented 3 years ago

Thanks, @GHSunnyGH. I don't think I'll have time to look at this today but I will try to get back to you on Monday 😄

GHSunnyGH commented 3 years ago

Hi @tdashworth, not urgent, thanks for your help.

tdashworth commented 3 years ago

Hi @GHSunnyGH, I've had a brief look but I'm not sure why this could be. I'm not familiar with entity with regards to exporting and importing them.

If you are comfortable, I would recommend you debug this following these setups using your own data and config. Don't forget to turn up the log level. https://github.com/Capgemini/xrm-datamigration/wiki/Setup#Setup-Steps

One last question, is your data in JSON or CSV format?

GHSunnyGH commented 3 years ago

Hi @tdashworth, my data is in JSON format.

tdashworth commented 3 years ago

Oddly enough I was also getting this yesterday. How many records were you trying too import?

I have a feeling it could be to do with you limits as it continued to work shortly afterwards.

GHSunnyGH commented 3 years ago

This error occurs even if only one record is imported.