Tel. ext.: 82300 direct: 020 3448
2300
Email:
Suzanne.McKeon@uclh.nhs.uk
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@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On
Behalf Of Ian Walls
Sent: Thursday, September 01, 2011 2:06
PM
To: Chris Cormack
Cc:
koha@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@bigballofwax.co.nz>
wrote:
2011/9/2 James Ghiorzi <JGhiorzi@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@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@bywatersolutions.com
Twitter:
@sekjal
------------------------------------------------------------------------ This email is confidential and is intended solely for the person or Entity to whom it is addressed. If this is not you, please forward the Message to mail.administrator@uclh.nhs.uk. We have scanned this email before sending it, but cannot guarantee that malicious software is absent and we shall carry no liability in this regard. We advise that information intended to be kept confidential should not Be sent by email. We also advise that health concerns should be Discussed with a medical professional in person or by telephone. NHS Direct can also provide advice. We shall not be liable for any failure to follow this advice. University College London Hospitals NHS Foundation Trust (UCLH).