I use filepicker to upload a CSV, sometimes it contains accent marks used in Spanish, the data parsed into the array of objects do not recognize this character
#File Picker CSV, array of objects not recognizing accent marks
onyx sundial
rugged larkBOT
Hey There,
We've registered your query, and our team will get back to you soon.
Regards,
Pranav
rugged larkBOT
Hello! What is your Appsmith version? Can you share a screenshot of this issue
and a sample CSV file so we can test this on our side?
onyx sundial
this is the CSV file example
the array of objects in filepicker.files[0].data looks like this
[
{
"franchise_name": "Cinnzeo Bakery Caf�",
"availability": "Available",
"country": "United States",
"state_province": "FL",
"city": "Miami",
"zip_postal": "",
"comment": "none"
},
{
"franchise_name": "Cinnzeo Bakery Caf�",
"availability": "Available",
"country": "United States",
"state_province": "CA",
"city": "Los Angeles",
"zip_postal": "",
"comment": ""
},
{
"franchise_name": "Cinnzeo Bakery Caf�",
"availability": "Available",
"country": "United States",
"state_province": "TX",
"city": "Houston",
"zip_postal": "",
"comment": ""
}
]
when I use this array to display in in a list for a preview to the user it looks like this,
and it is saved as that in the database
rugged larkBOT
What is your Appsmith version?
onyx sundial
it is v1.11.0-SNAPSHOT
rugged larkBOT
I have been able to reproduce this issue. Thanks for reporting this. Could you
please help us file a bug using the following link?-
https://github.com/appsmithorg/appsmith/issues/new/choose
Please include your use case and how this bug fix will be useful for you. Once
you created the GitHub issue, please send us the link to it so we can forward it
to our development team.
