search

forcedotcom / dataloader

Salesforce Data Loader
BSD 3-Clause "New" or "Revised" License
483 stars 293 forks source link

CLI export columns are in all caps #1095

Closed ImranMoTown closed 6 months ago

ImranMoTown commented 6 months ago

When I export data using the DataLoader command line interface, all the column names of the exported data are in all caps. This presents a problem since the systems that I am importing in are case sensitive. I have tried using the sdl file to lower case them but even export columns defined in the sdl file are uppercased in the output.

I would expect the output column headers to match the case of the Salesforce API name of the column

ashitsalesforce commented 6 months ago

Hi @ImranMoTown , to be sure of your ask, do you want the header columns of the exported data through a SOQL extraction operation to be case sensitive?

ImranMoTown commented 6 months ago

If I have a salesforce field with API name "EmployeeIDc" it appears as a header in my exported csv file as "EMPLOYEEIDC". I would like it to have the same casing as the field name in salesforce. So the column header should be "EmployeeID__c"

ashitsalesforce commented 6 months ago

Got it. I have checked in the fix to address the issue. It will be available in the next release of data loader, most likely v61.0.0, available with Summer '24 release.

ImranMoTown commented 6 months ago

That's great, Thank-you so much for your help, looking forward to testing it out.

ashitsalesforce commented 6 months ago

Here is a patch containing the fix for your testing purposes while you await the next release. dataloader_v60.0.2.zip

MD5 (dataloader_v60.0.2.zip) = c01c1ea95d4e44a4e47f0ea94aad53fe

ImranMoTown commented 6 months ago

Worked great, Thank-you again.

On Fri, Apr 19, 2024 at 10:01 AM ashitsalesforce @.***> wrote:

Here is a patch containing the fix for your testing purposes while you await the next release. dataloader_v60.0.2.zip https://github.com/forcedotcom/dataloader/files/15042179/dataloader_v60.0.2.zip

MD5 (dataloader_v60.0.2.zip) = c01c1ea95d4e44a4e47f0ea94aad53fe

— Reply to this email directly, view it on GitHub https://github.com/forcedotcom/dataloader/issues/1095#issuecomment-2066762831, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHM4RB3U4N554HFACPC6BWDY6EWTNAVCNFSM6AAAAABGNQ5YO6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANRWG43DEOBTGE . You are receiving this because you were mentioned.Message ID: @.***>