+ Start a Discussion

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.






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.