Tracker csv export is done in utf-8 format which results in encoding problems when importing in Microsoft excel, which many of our customers do.
https://fusionforge.org/tracker/index.php?func=detail&aid=320&group_id=6&atid=107 suggested to use UTF-16LE with bom, but this combination interpreted by some excel variants. My test results:
Microsoft Excel 2010 : UTF-16LE encoding without byte order mark, Windows-1252 encoding
Microsoft Excel 2003 : Windows-1252 encoding
The appended patch extends the download link with the possibility to specify an optional encoding and byte order mark for example
http://xxxx&encoding=UTF-16LE&bom=1
http://xxxx&encoding=UTF-16LE
http://xxxx&encoding=Windows-1252
where xxxx is something like https://fusionforge.org/tracker/?func=downloadcsv&group_id=6&atid=114
After some more specification/feedback I can provide an additional patch for choosing the type of export in the frontend.
|