[Bug 3468] New: Enhanced patron searching, patron batch edit/delete
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 Summary: Enhanced patron searching, patron batch edit/delete Product: Koha Version: rel_3_0 Platform: PC OS/Version: Windows 2000 Status: NEW Severity: enhancement Priority: P5 Component: Patrons AssignedTo: gmcharlt@gmail.com ReportedBy: jwagner@ptfs.com Estimated Hours: 0.0 Change sponsored?: Sponsored Created an attachment (id=970) --> (http://bugs.koha.org/cgi-bin/bugzilla3/attachment.cgi?id=970) Search screenshot Sponsored by East Brunswick Public Library, East Brunswick, NJ, USA. Enhance patron search by adding options to allow partial searches of email and phone, and a direct SQL query in the bottom box. (Per discussion on the listserv and IRC, display of the SQL query will be controlled by a syspref. However, it is read-only and only brings results up into the standard patron search hitlist.) Add borrower cart function to collect selected patron records for batch edit and batch delete. A syspref allows setting of a fine threshold; patrons with fines above that limit are blocked from deletion, as are patrons with current checkouts. In conjunction with another sponsored enhancement, patrons in debt collection are also blocked. Batch edit allows changes to address and other patron fields, and allows deletion (emptying) circ and OPAC note fields. Both batch edit and batch delete have "are you sure" prompts before action is taken. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 --- Comment #1 from Jane Wagner <jwagner@ptfs.com> 2009-08-02 15:25:59 --- Created an attachment (id=971) --> (http://bugs.koha.org/cgi-bin/bugzilla3/attachment.cgi?id=971) borrower cart screenshot -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 --- Comment #2 from Jane Wagner <jwagner@ptfs.com> 2009-08-02 15:26:35 --- Created an attachment (id=972) --> (http://bugs.koha.org/cgi-bin/bugzilla3/attachment.cgi?id=972) borrower cart confirm screenshot -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 --- Comment #3 from Jane Wagner <jwagner@ptfs.com> 2009-08-02 15:27:04 --- Created an attachment (id=973) --> (http://bugs.koha.org/cgi-bin/bugzilla3/attachment.cgi?id=973) borrower batch edit screenshot -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 Daniel G <dgrobani@samuelmerritt.edu> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dgrobani@samuelmerritt.edu -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nengard@gmail.com --- Comment #4 from Nicole C. Engard <nengard@gmail.com> 2009-08-19 19:38:11 --- Wasn't there some discussion on this topic - was it on the mailing list? Anyway, I'm for not showing the SQL here - and making the search look more simple - just cause it can be a bit confusing to the average circ librarian (or any non-programmer) to see SQL when searching for a patron record. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 David Schuster <dschust1@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dschust1@gmail.com -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 --- Comment #5 from David Schuster <dschust1@gmail.com> 2009-08-31 16:32:33 --- (In reply to comment #2)
Created an attachment (id=972) --> (http://bugs.koha.org/cgi-bin/bugzilla3/attachment.cgi?id=972) [details] borrower cart confirm screenshot
If there is an item still checked out what happens to this borrower and the item? or if they have fines? Does this enhancement allow you to "edit" additional borrower attributes? -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 --- Comment #6 from Jane Wagner <jwagner@ptfs.com> 2009-08-31 21:07:07 --- The feature will not delete patrons with items currently checked out. There is a syspref BatchMemberDeleteFineThreshhold where you can set a threshold for outstanding fines. Under that amount, the patron can be deleted; over it, the delete won't happen. If the patron has a hold, the hold will be deleted when the patron is deleted. Display of the SQL search option is controlled by a syspref ShowPatronSearchBySQL. The SQL search has the first part (select...) hardcoded and will strip out anything after a semicolon as a precaution. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 MJR <mjr@ttllp.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mjr@ttllp.co.uk --- Comment #7 from MJR <mjr@ttllp.co.uk> 2009-09-07 10:11:35 --- I'm confused. I see screenshot attachments, but no patch. Has the patch for this been posted? -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 --- Comment #8 from MJR <mjr@ttllp.co.uk> 2009-09-07 10:18:33 --- *** Bug 3332 has been marked as a duplicate of this bug. *** -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 --- Comment #9 from MJR <mjr@ttllp.co.uk> 2009-09-07 14:32:30 --- Not sure if this is part of this enhancement or a new separate one: The "Browse by last name" should include whatever non-latin-alnum characters actually occur at the start of a surname. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 --- Comment #10 from Jane Wagner <jwagner@ptfs.com> 2009-09-08 12:27:04 --- The screenshots are from our current development/testing; we're still tweaking a few final things, so the patch hasn't made it out yet. -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 Cookie Wolfrom <cookie.wolfrom@liblime.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |cookie.wolfrom@liblime.com -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 Jane Wagner <jwagner@ptfs.com> changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|gmcharlt@gmail.com |kohaprogrammers@ptfs.com -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 Jane Wagner <jwagner@ptfs.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 |PATCH-Sent --- Comment #11 from Jane Wagner <jwagner@ptfs.com> 2010-05-12 12:16:46 --- The fix for this bug can be pulled from the public git repository at http://github.com/Koha-PTFS, branch Bug3468 (ptfs-harley) -- Configure bugmail: http://bugs.koha.org/cgi-bin/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
participants (2)
-
bugzilla-daemon＠kohaorg.ec2.liblime.com -
bugzilla-daemon＠liblime.com