You need to sign in to do that
Don't have an account?
billkat
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.
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.