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

[bugzilla-daemon at bugs.koha-community.org]

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

--- Comment #6 from Joy Nelson <joy at bywatersolutions.com> ---
Yes, sorry, I meant stray commas.  It is the publisher that is getting out of
whack and Excel is not smart enough to ignore the comma inside double quotes. 
grrr

And Excel is rarely my spreadsheet of choice.  But for some libraries it is
what they are required to use.  ;-)  


(In reply to Owen Leonard from comment #5)
> I don't see any stray quotes. All quotes look like they are matched
> correctly. However, I do see that publisher data is getting split
> incorrectly. I would think that Excel would ignore a common within double
> quotes, but it looks like it doesn't.
> 
> I thought I would try exporting a report containing title, author, and
> publisher to see if the resulting CSV file had the same structure and found
> that the CSV file saved doesn't use commas at all, it uses semicolons. I
> wonder if that's why those exports work for you.
> 
> Does this problem happen for you in versions > 3.18.x? If so, please update
> this bug's version information.

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