handle BOM

[eroux]

maybe we could:

• export csv files that have a UTF8 BOM header (https://en.wikipedia.org/wiki/Byte_order_mark)
• make sure that csv files that have BOM can be imported with no problem

that might make the UTF8 issue disappear in Excel / Number

[berger-n]

thanks to this small command line tool uconv it's easy to add a UTF8 BOM header to a downloaded csv then upload it again it works as is (see attached files W2NB4_bom.csv W2NB4_nobom.csv)

so I've just added the header when exporting the csv and it works importing it back: https://editor.bdrc.io/outline/bdr:W2NB4

it needs to be done server-side as well, doesn't it? when downloading the file from the /outline menu (which basically is just a link to editserv)

[eroux]

Thanks a lot! oh, you're right, I'll open an issue on editserv

[eroux]

the server should now return a csv with an UTF8 BOM, @berger-n can you just make a quick test to make sure everything's fine?

[berger-n]

looks perfect! thanks (no difference with server file after removing then adding BOM)

[eroux]

great, thanks!