https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31933 Jacob O'Mara <jacob.omara@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED --- Comment #2 from Jacob O'Mara <jacob.omara@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.