[Koha] Bulk patron anonymize/delete tool

Chris Cormack chris at bigballofwax.co.nz
Tue Apr 17 19:55:54 NZST 2012


On 17 April 2012 09:41, Tom Hanstra <tom at nd.edu> wrote:
> 3.6.4
>
> Thanks!
>
> Tom

Hi Tom

So I checked out 3.6.4 set up a borrower to use, and put that
borrowernumber (17) into the anonymous patron syspref

I then ran the anonymise feature and now

 select * from old_issues limit 3;
+----------------+------------+------------+------------+---------------+------------+-----------------+--------+----------+---------------------+------------+
| borrowernumber | itemnumber | date_due   | branchcode |
issuingbranch | returndate | lastreneweddate | return | renewals |
timestamp           | issuedate  |
+----------------+------------+------------+------------+---------------+------------+-----------------+--------+----------+---------------------+------------+
|             17 |          6 | 2009-01-24 | WORK       | NULL
 | 2009-01-03 | NULL            | NULL   |     NULL | 2012-04-17
19:52:30 | 2009-01-03 |
|             17 |          2 | 2008-07-23 | WORK       | NULL
 | 2009-04-19 | NULL            | NULL   |     NULL | 2012-04-17
19:52:30 | 2008-07-02 |
|             17 |          4 | 2009-05-10 | OFFICE     | NULL
 | 2009-04-19 | NULL            | NULL   |     NULL | 2012-04-17
19:52:30 | 2009-04-19 |
+----------------+------------+------------+------------+---------------+------------+-----------------+--------+----------+---------------------+------------+

They have all been changed to borrower 17,  so it seems to be working
fine for me

I'm not sure what we are doing differently.

Chris


More information about the Koha mailing list