[#321] Encoding for tracker csv export

Description

Summary:

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.

General Information
Submitted by:
Ralf Habacker
Date Submitted: 2011-08-16 07:31
Last Modified by:
Franck Villaume
Last Modified: 2021-04-13 17:24
Date Closed: 2021-04-13 17:24
Permalink: https://fusionforge.org/tracker/a_follow.php/321
Actions
Monitor
Votes: 0/1 (0%)
Internal Fields
Data Type: Feature requests
Assigned to: Ralf Habacker (rhabacker)
State: Closed
Priority: 3
Extra Fields
Resolution:
Accepted
Difficulty:
Simple
Target release:
6.2
Follow-up tabs
Message  ↓
Date: 2021-04-13 17:24
Sender: Franck Villaume

merged in master.

Date: 2021-04-13 11:17
Sender: Ralf Habacker

see https://scm.fusionforge.org/anonscm/git/fusionforge/users/rhabacker.git branch ticket-321 for an associated patch

Date: 2021-04-13 10:02
Sender: Ralf Habacker

> The csv download at task already provides appropriate support and could possibly be reused.

A further looks showed that with tracker and pm there are already some options to specify the output format, but no option to select the encoding.

Date: 2021-04-13 09:50
Sender: Ralf Habacker

The csv download at task already provides appropriate support and could possibly be reused.

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

No related commits.

Field Old Value Date By
status_idOpen2021-04-13 17:24
Franck Villaume
close_dateNone2021-04-13 17:24
Franck Villaume
priority12021-04-13 17:24
Franck Villaume
assigned_tonone2021-04-13 17:24
Franck Villaume
DifficultyNone2021-04-13 17:24
Franck Villaume
Target releaseNone2021-04-13 17:20
Franck Villaume
status_idClosed2021-04-13 11:17
Ralf Habacker
close_date2021-04-13 10:022021-04-13 11:17
Ralf Habacker
status_idOpen2021-04-13 10:02
Ralf Habacker
close_dateNone2021-04-13 10:02
Ralf Habacker
ResolutionNone2021-04-13 10:02
Ralf Habacker
priority32018-04-22 09:01
Franck Villaume
File Added200: tracker-downloadcsv.diff2011-08-16 07:31
Ralf Habacker

No relations found.