How to parse text to utf-8

[leosantosx]

Hi, there.
I have a button to import a file csv, but when the file is imported comes with utf-8 error

How do I resolve this error?

[victoria]

Hello @leosantosx! Is your button a file picker component or regular button component? Would you mind sharing a screenshot of the right panel of this button?

[leosantosx]

@victoria

button a file picker component

My button is a picker file (upload button)

[victoria]

Would you mind sharing your CSV with us at support@retool.com so we can test it?
Alternatively, a screenshot of your left panel showing btn_importar_vouchers.parsedValue would be super helpful!

[leosantosx]

the file is in portuguese
File csv: https://mfresh.s3.amazonaws.com/retool/template_voucher_pdv_modelo.csv

demo:

[victoria]

Aha! I was able to get this to work by using Mac's built-in Numbers app to export with UTF-8 encoding!

Export to... > CSV... > Advanced options > Text Encoding: UTF-8

I also read online (here's a Stack Overflow thread with a few different ideas) that throwing this CSV into Google Sheets and exporting from there works as well.

[victoria]

Here's the exported version of your CSV I used!

utf8template_voucher_pdv_modelo 2.csv (278 Bytes)

[leosantosx]

thank you very much, it worked!

[victoria]

Que bom que funciono! Glad it’s working for you. Happy to help 😊