Bug 772110

Summary: CSV export has incorrect headers
Product: [Community] PressGang CCMS Reporter: Dana Mison <dmison>
Component: Web-UIAssignee: Matthew Casperson <mcaspers>
Status: CLOSED CURRENTRELEASE QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 1.xCC: cbredesen, jwulf, lnewson, topic-tool-list
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-07-02 00:26:51 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Dana Mison 2012-01-06 02:05:21 UTC 
/CustomSearchTopicList.xhtml


/CustomSearchTopicList.xhtml

The columns in the CVS export do not match the data.  Some of them I didn't see any data in any of the samples I looked at so I don't know if they are correct, although in some cases the heading is one that is clearly a different column.

To avoid issues with commas in fields, the fields that could have commas should be enclosed in quotes.  Most spreadsheet apps give you the option to ignore delimiters in quoted strings.

Also the fields that contain multiple entries currently have [] around each entry.  This is harder to parse than simply using a different delimiter.  Something like | could be more useful.

What the columns are labelled:
Topic ID,
Topic Title,
Topic Text,
Topic URL,
Assigned Writer,
Audiences,
Book,
Common Names,
Concerns,
Engineering Priority,
IA Priority,
Nav Priority,
PM Priority,
Release,
SME Priority,
SME Reviewers,
Special Tags,
Technologies,
Topic Lifecycle,
Topic Types,
Writer Priority

What they appear to be:
Topic ID,
Topic Title,
Topic Text,
Topic URL,
,
Concerns,
Technologies,
Topic Types,
Topic Lifecycle,
,
,
,
IA Priority,
,
,
Assigned Writer,
,
,
Release,
,
Common Names
Comment 1 Matthew Casperson 2012-01-31 03:14:06 UTC 
Fixed in 201201131-1311

Columns now line up, and multiple tags are listed as id: name separated by commas.