Home My Page Projects FusionForge
Summary Activity Forums Tracker Lists Tasks Docs Surveys News SCM Files Mediawiki Hudson oslc

[#321] Encoding for tracker csv export

Date:
2011-08-16 07:31		 Priority:
3
State:
Open
Submitted by:
Ralf Habacker (rhabacker) 		Assigned to:
Nobody (None)
Resolution:
None		 Difficulty:
None
Target release:
None
Summary:
Encoding for tracker csv export

Detailed description
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.


Followups: Sort comments antichronologically

No Followups Have Been Posted

Attached Files:

Attachments:
Size Name Date By Download
2 KiBtracker-downloadcsv.diff2011-08-16 07:31rhabackertracker-downloadcsv.diff

Changes:

Field Old Value Date By
File Added200: tracker-downloadcsv.diff2011-08-16 07:31rhabacker
Powered By FusionForge