@@ -, +, @@ 2.1. Go to the patron module 2.2. Click on “new patron” 2.3 Fill the form Surname, First name, Card number, Library (Choose the same 'TST' library for all users that will be created) 2.4. Save Create other users (~10 ) 3.1. Go to the Report module 3.2. Click on Create from SQL 3.3. Type a Report name and paste the following query to the SQL field: borrowers.cardnumber, borrowers.surname, borrowers.firstname, borrowers.categorycode, borrowers.branchcode, borrowers.dateexpiry borrowers borrowers.branchcode= <> 6.1. Open the file from step 5 6.2. Edit data 6.3. Remove half of the users from the file 6.4. In the 'branchcode' column, replace each value with a lowercase branchcode (for example 'tst') 6.5. Save the file in .csv format 6.6. Go to Tools > Patron imports 6.7. upload the file 6.8. Click on Overwrite the existing one with this 6.9. Click on Replace only included patron attributes 6.10. Click on “Import” --> Koha opens the results --> Koha freezes and it leaves the message 'Processing' --> the results are displayed correctly --- koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) --- a/koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc +++ a/koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc @@ -222,7 +222,7 @@ return map; }, {}); let libraries = [% To.json(libraries) | $raw %].map(e => { - e['_id'] = e.branchcode; + e['_id'] = e.branchcode.toLowerCase(); e['_str'] = e.branchname; return e; }); @@ -466,7 +466,7 @@ let r = '
'; - r += " " + escape_str(libraries_map[row.library_id].branchname); + r += " " + escape_str(libraries_map[row.library_id.toLowerCase()].branchname); return r; } } @@ -540,7 +540,7 @@ "searchable": true, "orderable": true, "render": function( data, type, row, meta ) { - let library_name = libraries_map[data].branchname + let library_name = libraries_map[data.toLowerCase()].branchname if( !singleBranchMode && data == logged_in_library_id ) { return "" + escape_str(library_name) + ""; } else { --