[Koha-bugs] [Bug 32706] New: User search problem caused by branchcode errors

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Jan 23 23:00:45 CET 2023


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32706

            Bug ID: 32706
           Summary: User search problem caused by branchcode errors
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Patrons
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: hammat.wele at inlibro.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com

Searching users alphabetically fails when there are two similar branchcode
types for the same value in the database: one written in uppercase and the
second in lowercase

Prerequisites
1. Create a new library with library code written in uppercase
1.1. Go to Administration > Libraries
1.2. Click on New library
1.3. Fill in the form
Library code = uppercase code (for example TST )
Name = type a name (for example Test category )
1.4. Save
2. Create several patrons in the TST library
     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. Export users
     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:
SELECT
    borrowers.cardnumber,
    borrowers.surname,
    borrowers.firstname,
    borrowers.categorycode,
    borrowers.branchcode,
    borrowers.dateexpiry
FROM
    borrowers
WHERE
       borrowers.branchcode= <<branchcode|branches>>
ORDER BY borrowers.cardnumber asc
4. Click on Save report then on 'Run report'
5. Choose the branch from step 1.3 and Click on Run the report
5. Download report results
6. Import user folders with lowercase 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”


Test plan
1. Go to the Patron module
2. Click on a letter of the alphabet 'different' from the users created in 
step 2.2
     --> Koha opens the results
3. Choose a last name letter from one of the users created in  step 2.2
     --> Koha freezes and it leaves the message “Processing”

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


More information about the Koha-bugs mailing list