92
Hi,
When i try import the released products i am getting an error
First i downloaded the released products V2 entity
Second I changed Sales price and import the file getting below error
"The column in entity Released products V2 has incorrect data. Please correct the data and try the import again.
'0' 'Released products V2' record(s) inserted in staging"
Let us know how shall we resolve this issue
In my case I've also encountered this issue due to line ending characters (as well as many of the suggestions already answered by others in this thread). Ensure that there are no blank rows at the end of your file, and that it does not contain incorrect values which can often be the case when using tab or csv files that can contain these characters in description- or note fields.
A combination of excel and notepad++ usually works for me to root out the cause. Recently I found a new issue so it might help anyone stumbling upon this thread:
Use notepad++ and ensure to show all characters (or in this case it's sufficient with line ending but better to show all).
Check if line endings are in cr ln format, if so try to change to unix format instead:
Via Edit menu - EOL conversion, select Unix
Check that line endings are now only linefeed:
Save and try again, this resolved the final issue I had with a specifically troublesome file after first removing duplicates and empty rows at the bottom, hopefully it can help.
in my case i was facing this error for having empty rows in the end of the csv file which caused the issue. Deleted those empty lines and re-submitted the file and loaded successfully. Last time it also caused due to having junk values in notes field.
It is most likely that either some mandatory field value is missing in the file or there is some data duplication. Try updating the sales unit as well since you are putting the sales price.
In this scenario only staging table is not inserted with any data. Please check your file once to ensure that all mandatory fields are updated and there are no duplicates as well.
This post is my own opinion and does not necessarily reflect the opinion or view of my company or Microsoft.
The most possible cause of the error may not be the column itself and that it could be more relatable issue with a flat CSV file.
For example, see below (Data file):
In this file, there were around 3000 records, but these three highlighted records had an issue and that was related to number field going in place of a date field (because of a comma in the preceding column, which shifted the data to 1 column rightwards) - The system was giving a deceiving error "The column REASONTEXT has incorrect data, while it was nothing wrong in the RESONTEXT column":
So, perform a sanity check on the input file and load again.
Dear Amel,
In our case, the Import failed from Excel file into staging, due to incorrect date in one of the date fields.
Issues that gave your error, and that I know about are:
* Empty rows below the excel data.Remove any excel rows that you do not need and save again.
* Incorrect numerical values into a number field. here look at the way you see them in your Excel field. left or right alligned. left usually not good for a numerical value.
* incorrect date value in a date field.
I hope this helps.
Thanks issue has been resolved after upgrading d365fo to 10.0.22
Refreshing the data entity list worked for me.
Hi all,
The above issue is a known Microsoft bug. It will be resolved by means of applying the quality update that is available as part of version 10.0.21.
Hi Imran,
I have the same issue and cannot locate the faulty column. Did you manage to solve it?
Thanks,
#1
André Arnaud de Cal...
293,280
Super User 2025 Season 1
#2
Martin Dráb
232,038
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
