+ Start a Discussion
VDid.ax1020VDid.ax1020 

Dataloader - Export an object and change field headers?

I am trying to figure out if it is possible to run an export on an object from salesforce.com using the dataloader but also changing the field headers in the process?

 

E.g. I have a custom Object called Invoice

Field: Amount__c needs to translate to column header Amount in my csv extract

or id needs to translate to colum header REF_NUM in my csv extract

 

Is it possible to programatically do this? The reason why I need this is we would like to essentially feed our Oracle Billing system directly from Salesforce without having to rename all the columns and reformatting.

 

Thanks,

V

 

sfdcfoxsfdcfox

You can do this if you set up the Data Loader to run in CLI mode. See the file located here: https://na3.salesforce.com/help/doc/en/salesforce_data_loader.pdf ... you can make a mapping file to map salesforce fields to have them named as you desire on output.