forcedotcom / CustomMetadataLoader

Tool to help users bulk create and update custom metadata records in salesforce.com from a CSV file.

Other

166 stars 132 forks source link

[Bug] Tool does not parse BOM properly #72

Open Windyo opened 4 years ago

Windyo commented 4 years ago

Description

A lot of modern tools output UTF-8 with a BOM to indicate the encoding. This BOM does not get parsed by the tool and having DeveloperName as the first column will therefore not result ina mapping for it as it sees ?developerName.

Wanted Behavior

Should process BOM.

sfjag commented 3 years ago

Hi,

I have solution for the Byte Order Mark Issue. Today only completed it. Initially while creating a csv file with Chinese and Arabic characters in it, upon loading the file the output comes as '??????' characters. Then I have stored the CSV file as CSV (UTF-8) in order to prevent special characters getting changed then I faced the BOM issue. Finally I debugged the code and resolved the BOM issue in the code. Let me know if you need the code.