function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
hitzhitz 

Data Loader Long Amount value export issue

Hi Experts,

 

I am trying to export records using Apex data loader but found some issues. please refer below sample

 

Record In Salesforce

Transaction: Invoice# Amount Balance 1009988$346,748,512.48

$346,748,512.00

 

 


If i export same record using Apex data loader (abc.csv) then amount value got change to hexadecimal format.

"NAME","AKRITIV__AMOUNT__C"
"1009988","3.4674851248E8"

 

Please help. how can i fix this

 

Best Answer chosen by Admin (Salesforce Developers) 
Sonam_SFDCSonam_SFDC

Salesforce treats numeric values as "double" data types for custom fields.

The schema spec does allow xsd:double to shift into scientific notation.
http://www.w3.org/TR/xmlschema-2/#double

Since we're java on the serverside, so, software shifts into e notation when java does

  • If m is less than 10-3 or greater than or equal to 107, then it is represented in so-called "computerized scientific notation."

http://java.sun.com/j2se/1.5.0/docs/api/java/lang/Double.html#toString(double)

If you need the long number versus the scientific notation format (ie, a data feed into another system) you can use the following workaround:

1. Create a formula text field for each long number field.

2. Copy the numeric value to the text field. This will display the full decimal value in the API.

3. Configure the data loader to use the new fields.

All Answers

Sonam_SFDCSonam_SFDC

Salesforce treats numeric values as "double" data types for custom fields.

The schema spec does allow xsd:double to shift into scientific notation.
http://www.w3.org/TR/xmlschema-2/#double

Since we're java on the serverside, so, software shifts into e notation when java does

  • If m is less than 10-3 or greater than or equal to 107, then it is represented in so-called "computerized scientific notation."

http://java.sun.com/j2se/1.5.0/docs/api/java/lang/Double.html#toString(double)

If you need the long number versus the scientific notation format (ie, a data feed into another system) you can use the following workaround:

1. Create a formula text field for each long number field.

2. Copy the numeric value to the text field. This will display the full decimal value in the API.

3. Configure the data loader to use the new fields.

This was selected as the best answer
hitzhitz

Hi Sonam,

 

Thanks you so much.
LAVAN_SFLAVAN_SF

Or else you can open the results through the "Open in external program" and do right click on the currency column change the format as number or dollar what you want it shows the full value.