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: [email protected] [mailto:[email protected]]
On Behalf Of Ian Walls
Sent: Thursday, September 01, 2011 2:06 PM
To: Chris Cormack
Cc: [email protected]
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 <[email protected]> wrote:
2011/9/2 James Ghiorzi <[email protected]>:
> 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
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
--
Ian Walls
Lead Development Specialist
ByWater Solutions
Phone # (888) 900-8944
http://bywatersolutions.com
[email protected]
Twitter: @sekjal
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
