Bug 3332 - Edit whole category of patrons
Summary: Edit whole category of patrons
Status: CLOSED MOVED
Alias: None
Product: Koha
Classification: Unclassified
Component: Patrons (show other bugs)
Version: rel_3_0
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Galen Charlton
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-06-16 03:25 UTC by Chris Cormack
Modified: 2012-10-25 23:31 UTC (History)
3 users (show)

See Also:
Change sponsored?: Sponsored
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Cormack 2010-05-21 01:09:14 UTC


---- Reported by mjr@ttllp.co.uk 2009-06-16 15:25:30 ----

Libraries with some patrons that subscribe as a group need to have their dateexpiry or other attributes updated all at once.  It's possible but fiddly to do this from the database command-line.  I will add an interface to do this from the staff admin.

It will probably be accessed from Administration: Patron Categories and require both parameters (from Patron Categories) and borrowers (from Patrons) permissions.

Comments welcomed, at least until we start coding.



---- Additional Comments From dschust1@gmail.com 2009-06-16 15:40:29 ----

(In reply to comment #0)
> Libraries with some patrons that subscribe as a group need to have their
> dateexpiry or other attributes updated all at once.  It's possible but fiddly
> to do this from the database command-line.  I will add an interface to do this
> from the staff admin.
> 
> It will probably be accessed from Administration: Patron Categories and require
> both parameters (from Patron Categories) and borrowers (from Patrons)
> permissions.
> 
> Comments welcomed, at least until we start coding.
> 

Will this include patron attributes that the individual library sets up?



---- Additional Comments From henridamien@koha-fr.org 2009-06-16 15:55:21 ----

Am I misleading myself or this strongly looks like batch edition of mysql records ?
would it be possible to add conditional updates ? UPDATE table set WHERE condition
It would be valuable for updating children to Adults and so on.
But maybe I am dreaming.



---- Additional Comments From mjr@ttllp.co.uk 2009-06-16 16:05:11 ----

At this time, I intend to include patron attributes.

This ticket is just to update an entire categorycode's patrons at once.  Children could be converted to adults if there were a categorycode for each cohort.

I could allow conditional updates, but how best to design an interface for that?  Raw SQL doesn't seem like a good idea, but a full query builder might be beyond our sponsorship budget just now.

One other thing: this will be published as a contrib patch for 3.0 and may be ported to 3.2 at a later date.




---- Additional Comments From nblake@masscat.org 2009-07-24 13:27:27 ----

MassCat has contracted with LibLime to create a tool in the staff interface that will allow batch editing or deletion of a subset of patron records.  So a library could search for a set of patron records based on any element of the patron record and then make changes, such as making a child an adult or a student an alumni, or delete a whole set of records, such as a graduating class.  My understanding is that the coding is underway.  My hope is that it will make it to 3.2, but I am not sure of that.



---- Additional Comments From mjr@ttllp.co.uk 2009-07-24 13:39:37 ----

(In reply to comment #4)
> [...] My understanding is that the coding is underway.  My hope is that it
> will make it to 3.2, but I am not sure of that.

I'm happy to learn that someone else is working on this, but a little disappointed that there was no publication before we started on it.

Can MassCat tell us the contract dates for this?

Is the coding available as a git branch somewhere?

Thanks, MJR




---- Additional Comments From nblake@masscat.org 2009-07-24 13:42:41 ----

I'm actually a little surprised and concerned that LibLime didn't update this bug with information when we formalized the plan to perform the development.  Let me get in touch with them and get some information regarding dates and ask them to update this bug.



---- Additional Comments From mjr@ttllp.co.uk 2009-09-07 10:18:33 ----

It seems that this work is being done twice already: by LibLime and by PTFS.  I'm making this as a duplicate of the other sponsored bug.


*** This bug has been marked as a duplicate of http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3468 ***



--- Bug imported by chris@bigballofwax.co.nz 2010-05-21 01:09 UTC  ---

This bug was previously known as _bug_ 3332 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=3332

Actual time not defined. Setting to 0.0
The original reporter of this bug does not have
   an account here. Reassigning to the person who moved
   it here: chris@bigballofwax.co.nz.
   Previous reporter was mjr@ttllp.co.uk.
The original assignee of this bug does not have
   an account here. Reassigning to the default assignee
   for the component, gmcharlt@gmail.com.
   Previous assignee was mjr@ttllp.co.uk.
This bug was marked DUPLICATE in the database it was moved from.
    Changing resolution to "MOVED"
CC member jwagner@ptfs.com does not have an account here
CC member mjr@ttllp.co.uk does not have an account here
CC member nblake@masscat.org does not have an account here