Bad character encoding when exporting data

[blirette]

Character encoding doesn't seem to work properly when exporting data. It might be related to the file metadata too since Excel doesn't seem to show accentuated characters properly, but another app like TexWrangler display them properly (see screenshots).

This causes problems to non "tech-savy" users.

Microsoft Excel 2015.29.1 for Mac

TextWrangler 5.5.2

[blirette]

@jamiefolsom Is this something you can fix or it's someone else job? Thanks for the info!

[jamiefolsom]

Hi @blirette -- I believe this is due to excel not parsing the correct characters correctly. It appears to me that the text editor in the second case is handling that file properly, but that excel is not. It may be possible to force Excel to treat the file as UTF-8. Does that make sense?

[blirette]

@jamiefolsom We need to generate a file that gets interpreted correctly across all apps. It must be a header problem in the file generated or something like that.

[blirette]

Can you fix this @jamiefolsom or it'll take a lot of time? I can live with that if you tell me the problem is deeply rooted in the encoding of the data in the database or it's lost somewhere between all the data transfers. I just hope this won't get worst once we separate the data backend from the frontend. Lemme know what you think. Thanks!

[blirette]

@jamiefolsom Could you enlight me on this? Thanks!

[blirette]

This is still a problem. The CSV file isn't displayed properly of Sara's version of Excel too.