[Koha] Clearing of users

Indranil Das Gupta indradg at gmail.com
Wed Aug 2 19:39:55 NZST 2023

Hi Tom,

A couple ways:

1) Soft delete the patron records so that they are moved from borrowers
table to deletedborrowers table.

There are both pros and cons to this. Biggest advantage being your patron
related queries will speed up. And you call still pull up the details of
your soft deleted borrowers using SQL queries.

The con being that you can't directly access a soft deleted record from the
Koha staff client UI (except via custom SQL reports).

2) By using the "discharge"
 feature in Koha which will restrict the user account for an indefinite
period. See

There is one catch though, it requires you to discharge one patron at
a time, iirc, you can't do bulk discharge. However, on the plus side you
can still see the full patron record from within Koha's staff client UI.

Hope this helps,
Indranil Das Gupta
L2C2 Technologies

On Tue, Aug 1, 2023, 22:23 Tom Obrien <tobrienu at gmail.com> wrote:

> Hi all,
> I work in an academic Library. I would like to put a provision for clearing
> users who have completed their studies without deleting their account.  How
> do I deactivate their accounts  so that one can use the account to borrow
> books.
> Looking forward for your advice.
> Thank you.
> Tom
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list