Why am I getting an invalid number error when inserting using Data Loader?
Start of CSV: Poverty Line Identifier,PPI Result,PPI Table ID,PPI Table Line,Poverty Line Name,Probability,ID
$1.25/day/2005 PPP_BurkinaFaso_2003,PPIR-0000027338,178,PPIL-00009620,$1.25/jour/2005 PPP_BurkinaFaso_2003,48.8,SPA-57712
200% of National_Ghana_2006,PPIR-0000027863,222,PPIL-00010548,Legacy 200% of National_Ghana_2012,89.1,SPA-650178
No Need to share internal data :) Check the value from this spreadsheet probability cell. Dataloader will generate failure file. Open the failure CSV file and copy the probability cell value and paste on Notepad.The copy it back and try again to load the data. there may be any special character. check in notepad before copying the value to the cell.
Take one row and copy that row in a notepad. Create a new CSV file and add that row from notepad to CSV file. Try to insert that new CSV file with 1 row with dataloader and check whether you are still getting the error message.
sometimes, these excel cell stores number like 10.6. or 10.6` or 10.600000000 which usually causes issue during insert job.
By looking at it, ideally you shouldn't be getting this error.
Let's try this, first with just a single row:
Create a new CSV for test import.
Copy the first row from the original csv, and in the probability column, update the probability number after the decimal in this format: .XXX
So for example, if the value is 48.8, so you change it to: 48.800
Try updating the record with this new csv and let me know if it works.
but am still receiving the same error across the board for all values being uploaded like 48.8. Any other thoughts?