[Koha] Report of patrons by categories

Scott Kushner skushner at mplmain.mtpl.org
Fri Sep 2 06:09:45 NZST 2011


Yes, I ran something similar on our db once because all of the expiry dates were going to happen on the same day, a year after go-live date, 

 

It was..

 

UPDATE borrowers SET borrowers.dateexpiry = DATE_ADD("2010-10-17", INTERVAL ROUND(RAND()*720) DAY) WHERE borrowers.dateexpiry = "2010-10-17" AND borrowers.categorycode = "AR"; 

 

 

From: koha-bounces at lists.katipo.co.nz [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Ian Walls
Sent: Thursday, September 01, 2011 2:06 PM
To: Chris Cormack
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Report of patrons by categories

 

ByWater Solutions is being asked to look into batch patron modification, based on some of the work Kyle Hall has done.  I'm not sure if we've gotten the bug report filed yet, but I wanted to be sure to communicate that others have interest in such a tool, and effort is being put towards getting it integrated.

Cheers,


-Ian

On Thu, Sep 1, 2011 at 1:50 PM, Chris Cormack <chris at bigballofwax.co.nz> wrote:

2011/9/2 James Ghiorzi <JGhiorzi at lib.co.san-benito.ca.us>:

> Dear Suzanne,
>
> Welcome to the list.  You should be able to change expiration date if you
> have an account that has set system parameters enabled.  Once you have that
> you go to the more hypertext link, then the administration link and than the
> patron categories link.  This is where you can set a patrons expiration
> date.  However I think this will not effect current patrons.
>

James is right, this will change the default expiry date for a
category. However he is also right this won't change the expiry dates
of existing patrons.
At the moment (in Koha 3.4.4) we have batch item modifications and are
tidying off batch biblio modifications. But there is currently no tool
for batch patron modifications.

If you have access to your database though, (or know someone who does)
you can ask them run some sql like like this
UPDATE borrowers SET dateexpiry = '2012-01-01' WHERE categorycode='A';

You might like to check bugs.koha-community.org to see if there is an
enhancement request for batch modifying patrons, and if not add one.
September 22 is the cut off date for new features for 3.6.0 so there's
still time :)

Chris
_______________________________________________
Koha mailing list  http://koha-community.org
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha




-- 
Ian Walls
Lead Development Specialist
ByWater Solutions
Phone # (888) 900-8944
http://bywatersolutions.com
ian.walls at bywatersolutions.com
Twitter: @sekjal

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20110901/c4005e21/attachment.html>


More information about the Koha mailing list