[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