CLI exported data column headers are turning into lower case.

[shashankbsai]

Hi Team,

With the Data loader update to 62.0.2 whenever we are using CLI to export data using an SOQL the column header values are coming in lowercase whereas our 3rd party system SAP accept values in Uppercase only causing discrepanies.

Can you please let us know if this is a known bug or if there is a quick workaround for this?

[Pranav1216]

Hi @ashitsalesforce Can you please help on this issue or Provide us a workaround.

[ashitsalesforce]

Hi @shashankbsai and @Pranav1216 , this issue is addressed in v63.0.0 by introducing a config property to output uppercase column headers. Set the following config property in config.properties or process-conf.xml when using v63.0.0 or later:

sfdc.extraction.allCapsHeaders=true

[shashankbsai]

Hi @ashitsalesforce , We are seeing this in 62.0.2 so we will have to update the Dataloader to 63.0.0 and use the given config property in config.properties?

[ashitsalesforce]

Yes, you will need to upgrade to 63.0.0.

[shashankbsai]

Thank you we will try this and let you know.

[shashankbsai]

if you dont mind can you give us the zip file for 63.0.0 if you have it handy

[ashitsalesforce]

It is the latest release downloadable on data loader's github home page: https://github.com/forcedotcom/dataloader/releases/tag/v63.0.0

[shashankbsai]

Thanks alot!

[ashitsalesforce]

It is also downloadable from Salesforce developer site: https://developer.salesforce.com/tools/data-loader

[shashankbsai]

Hi @ashitsalesforce , We would like to check with you if there is any workaround with 62.0.2 version itself instead of updating. Our process is not compatible with the latest version.

[ashitsalesforce]

Hi @shashankbsai , there isn't any workaround with 62.0.2 version.

[Pranav1216]

Hi @ashitsalesforce First of all Thanks for helping us, When we are tying to update the dataloader version we are facing some issues while configuring Dataloader Using CLI. Can you please help us providing some documentaion or steps we can configure dataloader with encryped password / key.

[ashitsalesforce]

Are you seeing this issue? If so, try the workaround provided in the issue discussion thread.

If it is some other issue, provide the details such as console output so that we can troubleshoot further.