[Koha-bugs] [Bug 11811] tools/import_borrowers.pl doesn't support utf-8 encoded CSV
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Sun Mar 16 13:57:04 CET 2014
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11811
Katrin Fischer <katrin.fischer at bsz-bw.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #26102|0 |1
is obsolete| |
--- Comment #11 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
Created attachment 26375
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=26375&action=edit
[PASSED QA] Bug 11811 - tools/import_borrowers.pl utf-8 support for CSV
Decode utf-8 characters in CSV file and perform canonical decomposition
followed by canonical composition.
Use case for this is XLS file converted into CSV which includes utf-8
characters which display correctly in interface but are not searchable
in Koha's patrons search since browser does same decomposition as this
code does.
Test scenario:
1. go to Tools > Import patrons
2. create patrons using attached example files which include both
variants of my surname. You will have to fill in branchcode and
categorycode according to configuration of Koha instance which
is used in web form since those values are not included in CSV
3. import patrons and verify then utf-8 characters are correct and
that you get just one results when searching for my surname
(cardnumber ITI-00000151832). You can just copy/paste my surname
from example file (any of them) since browser does similar
decomposition as this code.
4. apply this patch and repeat import of patrons, selecting option
to overwrite existing records
5. verify that after searching for my surname you get two borrowers
(cardnumbers ITI-00000151831 and ITI-00000151832)
Signed-off-by: A. Sassmannshausen <alex.sassmannshausen at ptfs-europe.com>
Signed-off-by: Katrin Fischer <Katrin.Fischer.83 at web.de>
Passes all tests and QA script.
Tested with my own file, some German umlauts and non-Latin scripts.
All works as expected.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list