[OPEN-ILS-GENERAL] Converting large numbers of patron records to inactive

[George Tuttle]

It leads to the questions: what is your library's policy and what is the
reason for marking patrons inactive? I would tend to think the main reason
would be for accurate statistics -- so your patron count wouldn't be
inflated with accounts that have expired years ago.

 

Thanks.

 

George Tuttle

Computer Services Librarian

Piedmont Regional Library System

770-867-2762 x113

770-891-0654 (cell)

770-867-7483 (fax)

gtuttle at prlib.org

LOGOFEB2013

 

 

From: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Rogan Hamby
Sent: Thursday, May 09, 2013 11:11 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Converting large numbers of patron records
to inactive

 

I think Jason's is a bit more elegant but if you have a specific need for
that kind of criteria that can be done a slightly more involved SQL
statement to run periodically too (daily).  

 

On Thu, May 9, 2013 at 10:59 AM, Jason Etheridge <jason at esilibrary.com>
wrote:

> Would it be possible to have a set of criteria like:

<snip>

If not not using expire dates set far in the future, it may be simpler
to just base it off of expire date.  If the account has been expired
for over X amount of time, then flag the account inactive.  What do
you think?  We could do that with a one-line SQL command made to run
periodically.

--
Jason Etheridge
| Support Manager
| Equinox Software, Inc. / The Open Source Experts
| phone: 1-877-OPEN-ILS (673-6457)
| email: jason at esilibrary.com
| web: http://www.esilibrary.com





 

-- 

 

Rogan Hamby, MLS, CCNP, MIA

Managers Headquarters Library and Reference Services, 

York County Library System

 

"You can never get a cup of tea large enough or a book long enough to suit
me." 
―  <http://www.goodreads.com/author/show/1069006.C_S_Lewis> C.S. Lewis

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20130509/61e9c9cf/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 8450 bytes
Desc: not available
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20130509/61e9c9cf/attachment.png>