[Koha-bugs] [Bug 24330] When importing patrons from CSV, automatically strip BOM from file if it exists
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Jan 30 16:17:36 CET 2020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24330
Martin Renvoize <martin.renvoize at ptfs-europe.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #98156|0 |1
is obsolete| |
--- Comment #8 from Martin Renvoize <martin.renvoize at ptfs-europe.com> ---
Created attachment 98173
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=98173&action=edit
Bug 24330: When importing patrons from CSV, automatically strip BOM from file
if it exists
We have a partner that exports UTF-8 CSV files, and is experiencing the same
thing as the author of this article:
https://www.freecodecamp.org/news/a-quick-tale-about-feff-the-invisible-character-cd25cd4630e7/
In short, Excel is inserting an invisible UTF-8 character at the start of the
file, so that the column name "cardnumber" is actually named
"\x{feff}cardnumber", causing "cardnumber" to be blank.
A simple solution is provided here:
https://stackoverflow.com/questions/24390034/remove-bom-from-string-with-perl
Test Plan:
1) Download the example.csv file
2) Attempt to import it using the patron import tool
3) Note the invalid column name error
4) Apply this patch, restart all the things!
5) Attempt the import again
6) Assuming you have a branchcode MPL and a cataegory code S, the patron should
import!
Signed-off-by: David Nind <david at davidnind.com>
Signed-off-by: Yew Chung College Library <library at yccece.edu.hk>
Signed-off-by: Martin Renvoize <martin.renvoize at ptfs-europe.com>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list