[OPEN-ILS-GENERAL] Deleting Patron Accounts

Rogan Hamby rogan.hamby at yclibrary.net
Wed Aug 5 08:15:09 EDT 2015


It's typically done on the database level not in the staff client.  For
example a library might say "we don't have a reciprocal borrowing agreement
with county X anymore can you delete all the addresses with Zip Codes Y, Z
and Q?" and we do it.

On Wed, Aug 5, 2015 at 7:57 AM, Scott Thomas <scott at albright.org> wrote:

> I hope this question isn’t too obvious, but I can’t seem to find it:  how
> does one “turn on the deleted flag on the account?”
>
>
>
> Thank you,
> Scott
>
>
>
> *From:* Open-ils-general [mailto:
> open-ils-general-bounces at list.georgialibraries.org] *On Behalf Of *Rogan
> Hamby
> *Sent:* Tuesday, August 04, 2015 4:44 PM
> *To:* Evergreen Discussion Group <
> open-ils-general at list.georgialibraries.org>
> *Subject:* Re: [OPEN-ILS-GENERAL] Deleting Patron Accounts
>
>
>
> There are other issues that can come up with reporting and aged
> circulations but those are more workflow issues than technical ones.
>
>
>
> All of this being a very long way of saying there are pros and cons with
> every choice.  :)
>
>
>
> On Tue, Aug 4, 2015 at 3:54 PM, Jason Etheridge <jason at esilibrary.com>
> wrote:
>
> >    Thank you for replying.  One thing you mentioned has piqued my
> interest.
> > It might be easier if I gave a scenario instead of trying to describe
> what I
> > mean. Say, on January 2, 2016, I run a report on circulation for 2015 and
> > then, a month later, delete many patrons some of whom had checked out
> > materials in 2015. If I ran the same 2015 report again after the
> deletions,
> > would the numbers be different because the patrons were purged? In other
> > words, when a patron is deleted, do their countable circ transactions go
> > with them?
>
> There is a trigger on the circulation table that will convert
> circulations being deleted into "aged" (essentially anonymous)
> circulations.  Depending on how you write your report, you can get
> some statistics that way.
>
> --
> Jason Etheridge
> | Community and Migration 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.”
> ― C.S. Lewis <http://www.goodreads.com/author/show/1069006.C_S_Lewis>
>



-- 

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.”
― C.S. Lewis <http://www.goodreads.com/author/show/1069006.C_S_Lewis>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150805/4b454354/attachment.html>


More information about the Open-ils-general mailing list