search

micado-eu / pa_application

application for the PA
European Union Public License 1.2
1 stars 4 forks source link

Migration in figures: Deal with different encodings #172

Open ivchicano opened 3 years ago

ivchicano commented 3 years ago

Sometimes users will not upload files with correct encoding (such as CSV saved with excel which are saved using Windows 1252 (ANSI) encoding), so on upload special characters may appear as �.

I suggest converting the files or strings to UTF-8 before saving.

gi-dorio commented 3 years ago

To add to this issue, it also seems that some csv made by excel are seen as empty when you upload them. I found out that i had to save these files as utf-8 encoded Text csv files via libre office to make the upload work as intended