[Koha-bugs] [Bug 16654] New: The output from reports/cat_issues_top.pl is not proper CSV
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Jun 3 22:02:04 CEST 2016
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16654
Bug ID: 16654
Summary: The output from reports/cat_issues_top.pl is not
proper CSV
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Reports
Assignee: gmcharlt at gmail.com
Reporter: barton at bywatersolutions.com
QA Contact: testopia at bugs.koha-community.org
The output from reports/cat_issues_top.pl is *NOT* csv; it is DSV (delimiter
separated values) with the option of using commas as delimiters... and the
delimiters aren't properly escaped.
To illustrate the point
1/ Check out an item whose title contains a comma.
2/ Go to Home [34m~@� Reports [34m~@� Most-circulated items
3/ Select a date range containing today's date
4/ Select the "To a file" radio button, and use comma (,) as the delimiter.
5/ Click Submit
Open the file in the spreadsheet program of your choice. Note that the title
containing the comma spans two columns, because it was not properly quoted.
If the report is going to use CSV as a file extension, it should be exported
using Text::CSV_XS, which properly handles CSV export.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list