<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>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, <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>It was..<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal>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"; <o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] <b>On Behalf Of </b>Ian Walls<br><b>Sent:</b> Thursday, September 01, 2011 2:06 PM<br><b>To:</b> Chris Cormack<br><b>Cc:</b> koha@lists.katipo.co.nz<br><b>Subject:</b> Re: [Koha] Report of patrons by categories<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>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.<br><br>Cheers,<br><br><br>-Ian<o:p></o:p></p><div><p class=MsoNormal>On Thu, Sep 1, 2011 at 1:50 PM, Chris Cormack <<a href="mailto:chris@bigballofwax.co.nz">chris@bigballofwax.co.nz</a>> wrote:<o:p></o:p></p><p class=MsoNormal>2011/9/2 James Ghiorzi <<a href="mailto:JGhiorzi@lib.co.san-benito.ca.us">JGhiorzi@lib.co.san-benito.ca.us</a>>:<o:p></o:p></p><div><p class=MsoNormal>> Dear Suzanne,<br>><br>> Welcome to the list. You should be able to change expiration date if you<br>> have an account that has set system parameters enabled. Once you have that<br>> you go to the more hypertext link, then the administration link and than the<br>> patron categories link. This is where you can set a patrons expiration<br>> date. However I think this will not effect current patrons.<br>><o:p></o:p></p></div><p class=MsoNormal>James is right, this will change the default expiry date for a<br>category. However he is also right this won't change the expiry dates<br>of existing patrons.<br>At the moment (in Koha 3.4.4) we have batch item modifications and are<br>tidying off batch biblio modifications. But there is currently no tool<br>for batch patron modifications.<br><br>If you have access to your database though, (or know someone who does)<br>you can ask them run some sql like like this<br>UPDATE borrowers SET dateexpiry = '2012-01-01' WHERE categorycode='A';<br><br>You might like to check <a href="http://bugs.koha-community.org" target="_blank">bugs.koha-community.org</a> to see if there is an<br>enhancement request for batch modifying patrons, and if not add one.<br>September 22 is the cut off date for new features for 3.6.0 so there's<br>still time :)<br><br>Chris<br>_______________________________________________<br>Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br><a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br><a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><o:p></o:p></p></div><p class=MsoNormal><br><br clear=all><br>-- <br>Ian Walls<br>Lead Development Specialist<br>ByWater Solutions<br>Phone # (888) 900-8944<br><a href="http://bywatersolutions.com" target="_blank">http://bywatersolutions.com</a><br><a href="mailto:ian.walls@bywatersolutions.com" target="_blank">ian.walls@bywatersolutions.com</a><br>Twitter: @sekjal<o:p></o:p></p></div></body></html>