[Bug 21712] New: Report anonymized patron records
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 Bug ID: 21712 Summary: Report anonymized patron records Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: m.de.rooy@rijksmuseum.nl QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com See bug 21336 comment17. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |21336 Assignee|koha-bugs@lists.koha-commun |m.de.rooy@rijksmuseum.nl |ity.org | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21336 [Bug 21336] GDPR: Handle unsubscribe requests automatically by optional (administrative) lock, anonymize and remove -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 --- Comment #1 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- Created attachment 81489 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=81489&action=edit Bug 21712: Report anonymized patron records The solution is rather limited but effective on itself. It only needs an enabled pref BorrowersLog. We log a specific ANONYMIZE action in Koha::Patron::anonymize. Now we only need to add a SQL report like: select object AS borrowernumber, timestamp AS date_anonymized from action_logs where module='MEMBERS' and action='ANONYMIZE' Depending on your needs, you could give this report a date parameter to show all actions from a given date onwards. Test plan: [1] Add a patron. [2] Enable BorrowersLog [3] Run in perl this line: use Koha::Patrons; Koha::Patrons->find(BORROWERNUMBER)->anonymize; Or (much more work): enable GDPR, unsubscribe, set reflection delay to zero and anonymize delay to zero and run cleanup_database.pl. [4] Check if the log contains a ANONYMIZE action for this patron. Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi Marcel, can you explain how this will help with destroying the paper records? What kind of information is logged? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |black23@gmail.com --- Comment #3 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- (In reply to Katrin Fischer from comment #2)
Hi Marcel,
can you explain how this will help with destroying the paper records? What kind of information is logged?
It is a rather simple solution just based on logging the borrowernumber. If we need more information to find back a paper record, we could extend it. Perhaps with surname, firstname or so? Perhaps Michal Denar could respond here too? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I think we'd need the name as they are often filed alphabetically and wihout the borrowernumber. Maybe the cardnumber too. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 --- Comment #5 from Michal Denar <black23@gmail.com> --- Hi, if librarian use anonymisation tool, list of relevant users could be feature of this tool. If library prefer use automatic way of anonymisation, would be nice to generate some kind report for identify paper contracts. Useful informations to find right contract are: - surname - name - home branch optional: - date of birth - adress - barcode from library card I prefer report as part of auto anonymisation workflow. List will be generate before anonymisation on based on same select query. But this is my point of view. Mike -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 --- Comment #6 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- (In reply to Michal Denar from comment #5)
I prefer report as part of auto anonymisation workflow. List will be generate before anonymisation on based on same select query.
This actually has my preference too. But I am waiting now first on some moving of the code on 21336 before spending more time. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 --- Comment #7 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- (In reply to Marcel de Rooy from comment #6)
(In reply to Michal Denar from comment #5)
I prefer report as part of auto anonymisation workflow. List will be generate before anonymisation on based on same select query.
This actually has my preference too. But I am waiting now first on some moving of the code on 21336 before spending more time.
Note that if we add more fields to the log, we actually have a privacy issue there. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 --- Comment #8 from Michal Denar <black23@gmail.com> --- I want to take this back to movement. If we want to make anon process automatic and need to destroy paper contracts too, procees should be: - automatic anon - some kind of log with relevant info for search of paper contracts - some trigger that destroy log if all papers contracts from bach was destroyed. Any ideas how to handle it? Thanks -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Patch doesn't apply --- Comment #9 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- 21336 is moving again, so i am coming back here soon hopefully -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 Bug 21712 depends on bug 21336, which changed state. Bug 21336 Summary: GDPR: Handle unsubscribe requests automatically by optional (administrative) lock, anonymize and remove https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21336 What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Master |RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712 Marcel de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|m.de.rooy@rijksmuseum.nl |koha-bugs@lists.koha-commun | |ity.org -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org