[Koha-bugs] [Bug 14169] Item Search csv export

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Mar 29 15:51:35 CET 2019


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14169

Peggy Thrasher <p.thrasher at dover.nh.gov> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CLOSED                      |REOPENED
         Resolution|INVALID                     |---

--- Comment #8 from Peggy Thrasher <p.thrasher at dover.nh.gov> ---
The issue is the spaces before the double quotes.


Original from Koha:

"Starry night : Macomber, Debbie.", "2013", "Ballantine Books,", "",
"34505003358304"

produces these fields (each field in a subsequent column):
Starry night : Macomber, Debbie.        
 "2013" 
 "Ballantine Books      
, ", 34505003358304"

Removing spaces before double quotes results in:

"Starry night : Macomber, Debbie.","2013","Ballantine
Books,","","34505003358304"

which produces these fields:

Starry night : Macomber, Debbie.        
2013    
Ballantine Books,               
34505003358304

It seems that there isn't a universal standard for CSV files, but
https://en.wikipedia.org/wiki/Comma-separated_values says:

According to RFC 4180, spaces outside quotes in a field are not allowed;
however, the RFC also says that "Spaces are considered part of a field and
should not be ignored." and "Implementors should 'be conservative in what you
do, be liberal in what you accept from others' (RFC 793, section 2.10) when
processing CSV files."
1997, "Ford" ,E350

Reports that are downloaded from Koha in CSV format do not have the extra
space.  Can this code use the same functions as reports?

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list