[Bug 21712] New: Report anonymized patron records

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 21712] New: Report anonymized patron records

bugzilla-daemon
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: [hidden email]
          Reporter: [hidden email]
        QA Contact: [hidden email]
                CC: [hidden email], [hidden email]

See bug 21336 comment17.

--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21712] Report anonymized patron records

bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712

Marcel de Rooy <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |21336
           Assignee|[hidden email]-commun |[hidden email]
                   |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.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21712] Report anonymized patron records

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712

--- Comment #1 from Marcel de Rooy <[hidden email]> ---
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 <[hidden email]>

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21712] Report anonymized patron records

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712

Marcel de Rooy <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |Needs Signoff

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21712] Report anonymized patron records

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712

Katrin Fischer <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #2 from Katrin Fischer <[hidden email]> ---
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.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21712] Report anonymized patron records

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712

Marcel de Rooy <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email]

--- Comment #3 from Marcel de Rooy <[hidden email]> ---
(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.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21712] Report anonymized patron records

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712

--- Comment #4 from Katrin Fischer <[hidden email]> ---
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.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21712] Report anonymized patron records

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712

--- Comment #5 from Michal Denar <[hidden email]> ---
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.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21712] Report anonymized patron records

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712

--- Comment #6 from Marcel de Rooy <[hidden email]> ---
(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.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21712] Report anonymized patron records

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712

--- Comment #7 from Marcel de Rooy <[hidden email]> ---
(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.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
Reply | Threaded
Open this post in threaded view
|

[Bug 21712] Report anonymized patron records

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21712

--- Comment #8 from Michal Denar <[hidden email]> ---
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.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/