[Koha-bugs] [Bug 31933] Import patrons fails when patron attribute value contains a comma

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

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

Jacob O'Mara <jacob.omara at ptfs-europe.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED

--- Comment #2 from Jacob O'Mara <jacob.omara at ptfs-europe.com> ---
After some more extensive searching it appears that the issue lies in how smart
quotes are being handled within the spreadsheet editor itself prior to
uploading to the koha db as I was getting some weird results once saving the
csv in LibreOffice and opening in text editor.

The easiest way we discussed to solve this is possibly just to disable smart
quotes entirely in the spreadsheet editor and amend the documentation notes to
specify the issues between escape quotes and smart quotes. Commas etc then seem
to work as expected once disabled and in the format you specified below,
bounded within one cell:

"COURSE:Government, Economics and Commerce","CSCODE:ABC1234"

we could probably do some kind of regex fix for the smart quotes issue as you
suggested but Martin believes this is something we should discuss further
first. 

It appears the error handling does in fact catch the mismatch of columns:values
and probably won't need any additional tinkering.

Let me know what you think.

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