[Koha] Report of patrons by categories

[Suzanne.McKeon at uclh.nhs.uk]

Thank you for these suggestions, which I will have a go at. I also
received this suggestion from ByWater Solutions:
 
There is not a bulk edit feature for patrons at this time.  You can do
this directly in the database using SQL statements if you have access.
Or you can run a report of the patrons you need to edit, export that
report, modify the results and reimport those patrons into Koha using
the patron import tool.

Suzanne McKeon 
Information Centre Manager 
Royal London Hospital for Integrated Medicine 

Tel. ext.: 82300 direct: 020 3448 2300 
Email: Suzanne.McKeon at uclh.nhs.uk 

 

________________________________

From: koha-bounces at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Scott Kushner
Sent: 01 September 2011 19:10
To: Ian Walls
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Report of patrons by categories



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


------------------------------------------------------------------------
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 at 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).

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20110902/255571fe/attachment-0001.html>