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: [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Scott Kushner Sent: 01 September 2011 19:10 To: Ian Walls Cc: [email protected] 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: [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 ------------------------------------------------------------------------ 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 [email protected]. 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).
_______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
