forcedotcom
Does not Support UTF-8 characters
I see that the Custom MetaData loader does not support uploading a file with special characters (such as á, ã, ä, ç, é, í, ó, ö, ô, ú). I got the following error message: "An error has occurred while importing data. Please make sure input csv file is correct. BLOB is not a valid UTF-8 string". I tried saving the file as UTF-8 encoding and still it is not being supported. I got the following error message "Header must contain at least one of these two fields - DeveloperName, Label."(The message is not accurate either because I removed the special character lines and I'm able to upload the file). Please let me know if you have a solution/workaround. Thanks for your help!!
I'm also having this issue. Has anyone ever posted a response, anywhere, to this problem?
save the excel file as CSV UTF-8(comma delimited)(*.csv) from saveas option
save the excel file as CSV UTF-8(comma delimited)(*.csv) from saveas option
It still gives the error : Header must contain at least one of these two fields - DeveloperName, Label
Anyone has idea how to upload the csv with special characters in custom metadata loader?
Any one have success to this... Loading Special character via Custom Metadata loader
Hi,
I have solution for the CSV UTF-8(comma delimited) Issue. It is because of Byte Order Mark character present while parsing CSV UTF-8 file. I have added the code. 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. (note: this code will not alter any existing functionalities of using normal csv file)
Any one have success to this... Loading Special character via Custom Metadata loader
I have solution for the CSV UTF-8(comma delimited) Issue.
To resolve this I saved the CSV in excel, opened it in Sublime Text and then File>"Save With Encoding" and choose UTF-8, NOT "UTF-8 with BOM". I'm guessing Excel saves with BOM which causes this issue in the first place
