I wrote a daily scheduled script that pulls a CSV ...
# suitescriptb
burkybang
04/26/2021, 3:50 PMI wrote a daily scheduled script that pulls a CSV file from a server and imports it via a saved CSV import. It failed recently because a person's name has a "Ã" character in it. Is there a best practice for how to handle unsupported special characters?
b
battk
04/26/2021, 4:09 PMÃ isnt unsupported
🤔 1
battk
04/26/2021, 4:09 PMmake sure that the encoding of the file matches the encoding of the import
🎖️ 1
b
burkybang
04/26/2021, 4:13 PMOkay, then maybe it's some other character. There seems to be some kind of white space character after the Ã. I don't see it when viewing the CSV file as text, but it's there when opening in Excel.
b
battk
04/26/2021, 4:15 PMexcel does a lot of formatting things that dont translate well to plaintext csv
b
burkybang
04/26/2021, 4:16 PMYes, I definitely know that, but this is the position that NetSuite is complaining about.
b
battk
04/26/2021, 4:17 PMagain, first thing i would check is the encoding
b
burkybang
04/26/2021, 4:17 PMYes, trying to do that now
burkybang
04/26/2021, 4:21 PMAlright, I think that was it. My import was set to Western (Windows 1252), but the file is UTF-8. Thank you