You need to sign in to do that
Don't have an account?
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
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!