search

INDIGO-Initiative / database-app

MIT License
2 stars 1 forks source link

CSV file with all data on pipeline projects has weird symbols #149

Open Juliana211 opened 2 years ago

Juliana211 commented 2 years ago

Hi! I just wanted to flag that the Excel file that I download from our INDIGO backend has some weird symbols. I guess this is a problem about Excel. For example, you can download the csv file for pipelines and look at rows 19, 22, 23. The names of those pipeline projects have this issue. Thanks!

odscjames commented 2 years ago

This is /app/pipeline and click "Download List" - /app/pipeline_download

It's a character set issue - it's opening in the wrong character set. On my laptop the names render correctly.

The content-type does not seem to include a character set (I thought we had done that on other CSV's?), we'll try that first.

content-type:application/csv;charset=UTF-8
odscjames commented 2 years ago

Just adding header did not work, but we will still include that as setting charset explicitly is correct thing to do.

Try adding BOM later?