<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3059" name=GENERATOR>
<STYLE>@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page WordSection1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-reply
}
.MsoChpDefault {
mso-style-type: export-only
}
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 vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=268470708-02092011><FONT face=Arial
size=2>Thank you for these suggestions, which I will have a go at. I also
received this suggestion from ByWater Solutions:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=268470708-02092011><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=268470708-02092011>
<DIV><SPAN><FONT color=#0000ff>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.</FONT></SPAN></DIV>
<DIV><BR><SPAN></SPAN></DIV>
<DIV></SPAN><SPAN lang=en-gb><FONT face=Arial size=2>Suzanne
McKeon</FONT></SPAN> <BR><SPAN lang=en-gb><FONT face=Arial size=2>Information
Centre Manager</FONT></SPAN> <BR><SPAN lang=en-gb><FONT face=Arial size=2>Royal
London Hospital for Integrated Medicine</FONT></SPAN> </DIV></DIV>
<P><SPAN lang=en-gb><FONT face=Arial size=2>Tel. ext.: 82300 direct: 020 3448
2300</FONT></SPAN> <BR><SPAN lang=en-gb><FONT face=Arial size=2>Email:
Suzanne.McKeon@uclh.nhs.uk </FONT></SPAN></P>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> koha-bounces@lists.katipo.co.nz
[mailto:koha-bounces@lists.katipo.co.nz] <B>On Behalf Of </B>Scott
Kushner<BR><B>Sent:</B> 01 September 2011 19:10<BR><B>To:</B> Ian
Walls<BR><B>Cc:</B> koha@lists.katipo.co.nz<BR><B>Subject:</B> Re: [Koha] Report
of patrons by categories<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">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: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">It
was..<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><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: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; 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: 12pt">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><PRE>------------------------------------------------------------------------
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).
</PRE></BODY></HTML>