[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
Tue Mar 11 10:44:42 CET 2014


http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11811

Dobrica Pavlinusic <dpavlin at rot13.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #25629|0                           |1
        is obsolete|                            |

--- Comment #8 from Dobrica Pavlinusic <dpavlin at rot13.org> ---
Created attachment 26059
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=26059&action=edit
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)

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


More information about the Koha-bugs mailing list