search

forcedotcom / dataloader

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

Data Loader 61.1.0 Ignoring 'Allow field truncation' #1191

Open GweiloHKG opened 3 days ago

GweiloHKG commented 3 days ago

A Contact custom field, HKCC_COMPANY_NAME_C, is defined with maximum length 50.

Data Loader v61.1.0 running on Windows 11, has the option 'Allow field truncation' enabled (tick present).

When performing an Update of Contact, 23 (out of 5,129) records have more than 50 characters defined in HKCC_COMPANY_NAME_C. Prior to Data Loader v61.1.0, these records would update successfully. The custom field's contents would be truncated at 50 characters. No errors would be reported.

With v61.1.0, the records are reported as errors and no update is performed for those records.

error070224114949623.csv 20240702 Field Too Long.zip Screen Capture

ashitsalesforce commented 2 days ago

Hi @GweiloHKG , I am unable to reproduce the issue on Windows 11 using your config.properties and data loader v61.1.0. I used the following CSV file:

HKCC_COMPANY_NAME,LastName
"The Hongkong and Shanghai Banking Corporation Limited",Banker

I was able to successfully insert a single Contact record using the above CSV with its HKCC_COMPANY_NAME__C field value truncated to The Hongkong and Shanghai Banking Corporation Limi. Can you try the operation with the above value?