Mass deletion of users

More
1 month 1 week ago #219581 by Jmantysalo
I should delete about 150 survey admins from the system. (Old accounts automatically generated by shibboleth login -- I did my own plugin for that.) I suppose that some of them has surveys but most do not. Ideas? For example, if I try to drop them from DB, will the system just delete all of them (no foreign key constraints), delete those that have no surveys (normal constraint) or even delete surveys (on delete cascade)?

Note: If I asked something and forgot to say version, I am using LS 5.x.

Please Log in to join the conversation.

More
1 month 1 week ago #219625 by Jmantysalo
Replied by Jmantysalo on topic Mass deletion of users
What tables contains references to users? I just noticed that lime_permissions is not cleaned when I normally deleted a user. Shadow user is not shown, so this is not a big thing.

Note: If I asked something and forgot to say version, I am using LS 5.x.

Please Log in to join the conversation.

More
4 weeks 1 day ago #219999 by Jmantysalo
Replied by Jmantysalo on topic Mass deletion of users
Just raising this up... I guess that the spirit of GDPR requires me to think about this issue.

Note: If I asked something and forgot to say version, I am using LS 5.x.

Please Log in to join the conversation.

More
4 weeks 21 hours ago #220061 by DenisChenu
Replied by DenisChenu on topic Mass deletion of users
User id are inside
1. Survey as owner_id
2. permission as user id
3. Participant (global) (unsure where).
github.com/LimeSurvey/LimeSurvey/blob/56.../useraction.php#L287

Maybe best is to create a remote control function ?
gitlab.com/SondagesPro/RemoteControl/extendRemoteControl

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development . I don't answer to private message.

Please Log in to join the conversation.

More
3 weeks 6 days ago #220132 by Jmantysalo
Replied by Jmantysalo on topic Mass deletion of users
Participant? I have thought that list of admins and list of people in CPDB are totally different. (In my case there is no CPDB at all, so this is theoretical for me.)

So, only two places where I should remove accounts. I guess I can do that.

Of course the more complicated issue is surveys without an owner, but for that I think there can be no mechanical solution.

Note: If I asked something and forgot to say version, I am using LS 5.x.

Please Log in to join the conversation.

More
3 weeks 6 days ago #220136 by DenisChenu
Replied by DenisChenu on topic Mass deletion of users
Best seems to move owner to 1 if owner is deleted ?

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development . I don't answer to private message.

Please Log in to join the conversation.

More
3 weeks 6 days ago #220138 by Jmantysalo
Replied by Jmantysalo on topic Mass deletion of users
It is technically easy solution. But I guess we must go through them one by one and think what should be preserved for some reason, and what should be deleted for GDPR and generally for cleaning up unnecessary surveys. So this is question that has both technical and political sides.

Then, about user account: a user might be the owner of survey group. So it is harder that just two DB tables.

Note: If I asked something and forgot to say version, I am using LS 5.x.

Please Log in to join the conversation.

More
3 weeks 6 days ago #220140 by DenisChenu
Replied by DenisChenu on topic Mass deletion of users
Ah !

Whene user deteleted : seems it was not deleted from User group too (LimeSurvey issue).

> a user might be the owner of survey group

Right … must be fixed too.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development . I don't answer to private message.

Please Log in to join the conversation.

More
3 weeks 6 days ago #220141 by Jmantysalo
Replied by Jmantysalo on topic Mass deletion of users
OK. Is it possible for the update script to also clean up DB for possible shadow data like this?

Why there are no foreing keys in the DB in the first place?

Note: If I asked something and forgot to say version, I am using LS 5.x.

Please Log in to join the conversation.

More
1 week 2 days ago #220780 by Jmantysalo
Replied by Jmantysalo on topic Mass deletion of users

> a user might be the owner of survey group
Right … must be fixed too.

It there an issue opened about this in the bug tracker?

Note: If I asked something and forgot to say version, I am using LS 5.x.

Please Log in to join the conversation.

More
1 week 2 days ago #220782 by DenisChenu
Replied by DenisChenu on topic Mass deletion of users

> a user might be the owner of survey group
Right … must be fixed too.

It there an issue opened about this in the bug tracker?Not
 

Not by me :)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development . I don't answer to private message.

Please Log in to join the conversation.

More
1 week 2 days ago #220784 by Jmantysalo
Replied by Jmantysalo on topic Mass deletion of users

Note: If I asked something and forgot to say version, I am using LS 5.x.
The following user(s) said Thank You: DenisChenu

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now