function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
sforcenewbiesforcenewbie 

DataLoader export - csv file only has headers

Hello,

 

I am running DataLoader through the command line and everything works with following messages however when I open the csv file I only see headers with no data rows?

 

4467 [extractAsset] INFO com.salesforce.dataloader.process.ProcessRunner  - Checking the data access object connection
4468 [extractAsset] INFO com.salesforce.dataloader.process.ProcessRunner  - Setting field types
9407 [extractAsset] INFO com.salesforce.dataloader.process.ProcessRunner  - Setting object reference types
23059 [extractAsset] INFO com.salesforce.dataloader.process.ProcessRunner  - Creating Map
23062 [extractAsset] INFO com.salesforce.dataloader.action.OperationInfo  - Instantiating operation ui action: extract
23063 [extractAsset] INFO com.salesforce.dataloader.controller.Controller  - executing operation: extract
23070 [extractAsset] DEBUG com.salesforce.dataloader.client.PartnerClient  - Beginning web service operation: query
25817 [extractAsset] INFO com.salesforce.dataloader.action.progress.NihilistProgressAdapter  - Processed 10 of 10 total records. Rate: 18000000 record
s per hour. Estimated time to complete: 0 minutes and 0 seconds.  There are 10 successes and 0 errors.
25830 [extractAsset] INFO com.salesforce.dataloader.action.progress.NihilistProgressAdapter  - The extract has fully completed.  There were 10 success
ful extracts and 0 errors.

 

<bean id="extractAsset"
      class="com.salesforce.dataloader.process.ProcessRunner"
      singleton="false">
  <description>Extract Asset from salesforce and saves info into a CSV file."</description>
    <property name="name" value="extractAsset"/>
    <property name="configOverrideMap">
        <map>
            <entry key="sfdc.debugMessages" value="false"/>
            <entry key="sfdc.debugMessagesFile" value="C:\dev\work\xxx\logs\sfdcSoapTrace.log"/>
            <entry key="sfdc.timeoutSecs" value="600"/>
            <entry key="sfdc.loadBatchSize" value="200"/>
            <entry key="sfdc.entity" value="Asset"/>
            <entry key="sfdc.extractionRequestSize" value="2000"/>
            <entry key="sfdc.extractionSOQL" value="Select a.UsageEndDate, a.SystemModstamp, a.Status, a.SerialNumber, a.Quantity, a.PurchaseDate, a.Product2Id, a.Price, a.Name, a.LastModifiedDate, a.LastModifiedById, a.IsDeleted, a.IsCompetitorProduct, a.InstallDate, a.Id, a.Description, a.CreatedDate, a.CreatedById, a.ContactId, a.AccountId From Asset a LIMIT 10"/>
            <entry key="process.operation" value="extract"/>
            <entry key="dataAccess.type" value="csvWrite"/>
            <entry key="dataAccess.name" value="C:\dev\work\xxx\data\assetData1.csv"/>
        </map>
    </property>
</bean>

 

I have the other properties in config.properties.

 

Thanks

ShwetaSShwetaS

Hi,

 

Please try inserting the following tag in your beanfile:
<enter key ="dataAccess.writeUTF8" value="true"/>

 

You can also refer the following URL for more details about using Data Loader via Command Prompt
http://www.developerforce.com/media/Cheatsheet_Setting_Up_Automated_Data_Loader_9_0.pdf.

 

 

Shweta
Salesforce Developer Support

If my answer solved your question, please mark it solved so I can help as many community members as possible!