In the first example, is what a CSV file looks like. (A1:Text)First Name, (A2:Text)Last Name, (A3:Text)Company, (A4:Text)Phone Number,(A5:Text)Annual Revenue

To be clear, CSV files do not contain formatting information, and therefore Excel has to 'guess' what is meant by the source data.įirst Name,Last Name,Company,Phone Number,Annual Revenue Verify that the data is or is not being truncated in a program such as WordPad, Notepad, or even OpenOffice (which is not as 'smart' as Excel, thankfully). I would invite you to try opening the file in something other than Microsoft Excel, which is notorious for it's 'smart' CSV processing this often causes trailing decimals to be lost, and is also responsible for mangling large numbers (4159017010, the phone number for Technical Support, would render as 4.159017e+09 or some such). The field values should always use the scale and precision specified when using the API. The Apex Data Loader should return the same values as you would get by running a report. Right now when I run the data loader to extract a file that has decimals, it chops the trailing 0.ĬsvAccountExtract job gets investment info from salesforce and saves info into a CSV file.' Is there anyway of defining the data loader in code to convert my extracts fields to a number data type

Apex data loader user guide