Ask Search:
Erin YamaokaErin Yamaoka 

Why am I getting an invalid number error when inserting using Data Loader?

I am trying to insert records into a Big Object using data loader. My probability field is of data type Number with Length=3 and Decimal Places=4. My upload is failing across the board due to this field, the error message is "Invalid Number" and then lists examples like 98.4 or 58.2. I checked the spreadsheet there aren't any weird leading or trailing values - I have no idea why this is failing. The file is encoded in UT8.

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

Any ideas?
Best Answer chosen by Erin Yamaoka
Erin YamaokaErin Yamaoka
Just got off with Salesforce Support and there's an issue with uploading into Big Object number fields. The work around is to go to Settings in Data loan and check the "Bulk API" option. Works perfectly now. The CSR informed me that they're working on documentation for this.

All Answers

Erin YamaokaErin Yamaoka
Number field in big objectErrors
Arijit MajeeArijit Majee
Hi Erin,

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.
Erin YamaokaErin Yamaoka
Thanks for the response Arjit! I just checked in notepad - no special characters
Arijit MajeeArijit Majee
Hi Erin,

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.
Erin YamaokaErin Yamaoka
Thanks for trying Arijit! Same error, just for the one row =/ *Erin Yamaoka* Director, Product and Professional Services TaroWorks Mobile: +1 312 590 9493 erin@taroworks.org │Skype: erinyamaoka LinkedIn │YouTube www.taroworks.org
Narender SinghNarender Singh
Hi Erin,

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.
Erin YamaokaErin Yamaoka
Thank you Narender! I tried changing the definition of the field to test the same issue:

    <fields>
        <fullName>Probability__c</fullName>
        <label>Probability</label>
        <required>true</required>
        <type>Number</type>
        <scale>1</scale>
        <precision>4</precision>
    </fields>

but am still receiving the same error across the board for all values being uploaded like 48.8. Any other thoughts?
Erin YamaokaErin Yamaoka
Just got off with Salesforce Support and there's an issue with uploading into Big Object number fields. The work around is to go to Settings in Data loan and check the "Bulk API" option. Works perfectly now. The CSR informed me that they're working on documentation for this.
This was selected as the best answer
Narender SinghNarender Singh
Ahh! Thanks for sharing the solution! :D