Hello>

Is there anyway of defining the data loader in code to convert my extracts fields to a number data type

right now when I run the data loader to extract a file that has decimals, it chops the trailing 0.

For example,

345343.5

Should be 345343.50

Below is an example of the code:

<bean id="csvInvestmentExtractProcess"
          class="com.salesforce.lexiloader.process.ProcessRunner"
          singleton="false">
  <description>csvAccountExtract job gets investment info from salesforce and saves info into a CSV file."</description>
        <property name="name" value="csvInvestmentExtract"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.debugMessages" value="false"/>
                <entry key="sfdc.debugMessagesFile" value="S:\SFDC\Process1\status\sfdcSoapTrace.log"/>
                <entry key="sfdc.endpoint" value="https://www.salesforce.com"/>
                <entry key="sfdc.username" value="test@test.org"/>
                <entry key="sfdc.password" value="c22d48685a1a3f532658a86b909fc97f"/>
    <!-- <entry key="process.encryptionKeyFile" value="S:\SFDC\Process1\conf\key.txt"/> -->
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.entity" value="Investment__c"/>
                <entry key="sfdc.extractionRequestSize" value="500"/>
                <entry key="sfdc.extractionSOQL" value="Select Id, Name, IsDeleted, LastModifiedById, LastModifiedDate, SystemModstamp, CreatedById, CreatedDate, Account_Name__c, Active__c, Balances_as_of__c, Capital_Gains_Distribution__c, Commitment__c, Fund_Type__c, Fund__c, ISN__c, Inception_Date__c, Income_Dividends__c, Initial_Investment__c, Liquidation_Date__c, Market_Value__c, MemberId__c, NAV__c, Notes__c, PoA_Instructions__c, Power_of_Attorney__c, RecordTypeId, SID__c, Share_Balance__c, Sub_Account__c, Transfer_to__c, Statement_Label__c, Month_end_Share_Balance__c, Month_end_Market_Value__c, Month_end_NAV__c, Month_end_Balances_as_of__c, StateStreetId__c from Investment__c"/>
                <entry key="process.operation" value="extract"/>
                <entry key="process.mappingFile" value="S:\SFDC\Process1\maps\investmentExtractMap.sdl"/>
                <entry key="dataAccess.type" value="csvWrite"/>
                <entry key="dataAccess.name" value="S:\SFDC\Process1\data\export\investment.csv"/>
            </map>
        </property>
    </bean>

Hello>

Is there anyway of defining the data loader in code to convert my extracts fields to a number data type

right now when I run the data loader to extract a file that has decimals, it chops the trailing 0.

For example,

345343.5

Should be 345343.50

Below is an example of the code:

<bean id="csvInvestmentExtractProcess"
          class="com.salesforce.lexiloader.process.ProcessRunner"
          singleton="false">
  <description>csvAccountExtract job gets investment info from salesforce and saves info into a CSV file."</description>
        <property name="name" value="csvInvestmentExtract"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.debugMessages" value="false"/>
                <entry key="sfdc.debugMessagesFile" value="S:\SFDC\Process1\status\sfdcSoapTrace.log"/>
                <entry key="sfdc.endpoint" value="https://www.salesforce.com"/>
                <entry key="sfdc.username" value="test@test.org"/>
                <entry key="sfdc.password" value="c22d48685a1a3f532658a86b909fc97f"/>
    <!-- <entry key="process.encryptionKeyFile" value="S:\SFDC\Process1\conf\key.txt"/> -->
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.entity" value="Investment__c"/>
                <entry key="sfdc.extractionRequestSize" value="500"/>
                <entry key="sfdc.extractionSOQL" value="Select Id, Name, IsDeleted, LastModifiedById, LastModifiedDate, SystemModstamp, CreatedById, CreatedDate, Account_Name__c, Active__c, Balances_as_of__c, Capital_Gains_Distribution__c, Commitment__c, Fund_Type__c, Fund__c, ISN__c, Inception_Date__c, Income_Dividends__c, Initial_Investment__c, Liquidation_Date__c, Market_Value__c, MemberId__c, NAV__c, Notes__c, PoA_Instructions__c, Power_of_Attorney__c, RecordTypeId, SID__c, Share_Balance__c, Sub_Account__c, Transfer_to__c, Statement_Label__c, Month_end_Share_Balance__c, Month_end_Market_Value__c, Month_end_NAV__c, Month_end_Balances_as_of__c, StateStreetId__c from Investment__c"/>
                <entry key="process.operation" value="extract"/>
                <entry key="process.mappingFile" value="S:\SFDC\Process1\maps\investmentExtractMap.sdl"/>
                <entry key="dataAccess.type" value="csvWrite"/>
                <entry key="dataAccess.name" value="S:\SFDC\Process1\data\export\investment.csv"/>
            </map>
        </property>
    </bean>