function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
billkatbillkat 

App Loader, fails to export as UTF8 over certain number of records

Using App Loader 18, on Windows Vista.

Read and write as UTF8 is ticked.

Tried both Soap API, and the Bulk API.

 

When we export a small selection of records from a custom object, the data is as expected - in correct UTF8 format.

For example a particular field is rendered properly as "β-Amyloid"

 

But when we export the whole 140,000 records, UTF8 characters are munged.

The same field then is rendered as "β-Amyloid"

 

Any ideas? This is a serious show-stopper for us if we can't get it right.

Thanks all.

billkatbillkat

Sorted, kind of. The App Loader export file does contain UTF8 characters, but is not itself a UTF8 file.

 

The file editor auto-detects charset based on the first 20k of file contents. Didn't find a UTF8 char so rendered it as latin.

 

Forcing a BOM into the first line of the output file lets the editor recognise it as UTF8. Have to do this as a separate step, post App Loader operations.