From c332b6f5781632de21b5afb16e97c641e6bfe1a9 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 17 Feb 2016 16:21:50 +0000 Subject: [PATCH] [PASSED QA] Bug 15840: Catch errors if userid already exists when importing patrons Import borrowers tool explodes if userid already exists. This error should be caught to avoid the script to explodes. TEST PLAN --------- 1) back up DB 2) drop DB, create empty DB 3) Apply patch 15842 4) web install all the sample data 5) login as system user and import patron data -- sample provided to trigger error. -- you will get a DBIx::class exception "Duplicate entry ' for key 'userid'" 6) Apply this patch 7) Repeat steps 2-5 -- patrons won't be inserted but an error will be nicely displayed in the error list. 8) run koha qa test tools Note that it would be easy to insert the patrons anyway and generate a userid based on the surname and firstname. Signed-off-by: Mark Tompsett Signed-off-by: Katrin Fischer --- koha-tmpl/intranet-tmpl/prog/en/modules/tools/import_borrowers.tt | 5 +++++ tools/import_borrowers.pl | 7 +++++++ 2 files changed, 12 insertions(+) diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/import_borrowers.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/tools/import_borrowers.tt index fa955da..f31d7da 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/import_borrowers.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/tools/import_borrowers.tt @@ -90,6 +90,11 @@ [% IF ERROR.borrowernumber %] (for patron with borrowernumber [% ERROR.borrowernumber %])[% END %] [% END %] + [% IF ERROR.duplicate_userid %] +
  • + Userid [% ERROR.userid %] is already used by another patron or is empty. +
  • + [% END %] [% END %] diff --git a/tools/import_borrowers.pl b/tools/import_borrowers.pl index e92137e..0ca2537 100755 --- a/tools/import_borrowers.pl +++ b/tools/import_borrowers.pl @@ -253,6 +253,13 @@ if ( $uploadborrowers && length($uploadborrowers) > 0 ) { next; } + # generate a proper login if none provided + if ( $borrower{userid} eq '' || !Check_Userid( $borrower{userid} ) ) { + push @errors, { duplicate_userid => 1, userid => $borrower{userid} }; + $invalid++; + next LINE; + } + if ($borrowernumber) { # borrower exists -- 1.9.1