- Posts: 348
- Thank you received: 41
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Mass deletion of users
- Jmantysalo
- Topic Author
- Offline
- Platinum Member
Less
More
2 years 6 months ago #219581
by Jmantysalo
Mass deletion of users was created 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)?
The topic has been locked.
- Jmantysalo
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 348
- Thank you received: 41
2 years 6 months 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.
The topic has been locked.
- Jmantysalo
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 348
- Thank you received: 41
2 years 6 months 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.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
2 years 6 months ago #220061
by DenisChenu
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.
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
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.
The topic has been locked.
- Jmantysalo
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 348
- Thank you received: 41
2 years 6 months 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.
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.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
2 years 6 months ago #220136
by DenisChenu
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.
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.
The topic has been locked.
- Jmantysalo
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 348
- Thank you received: 41
2 years 6 months 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.
Then, about user account: a user might be the owner of survey group. So it is harder that just two DB tables.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
2 years 6 months ago #220140
by DenisChenu
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.
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.
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.
The topic has been locked.
- Jmantysalo
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 348
- Thank you received: 41
2 years 6 months 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?
Why there are no foreing keys in the DB in the first place?
The topic has been locked.
- Jmantysalo
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 348
- Thank you received: 41
2 years 5 months ago #220780
by Jmantysalo
Replied by Jmantysalo on topic Mass deletion of users
It there an issue opened about this in the bug tracker?> a user might be the owner of survey group
Right … must be fixed too.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
2 years 5 months ago #220782
by DenisChenu
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.
Replied by DenisChenu on topic Mass deletion of users
Not by me
It there an issue opened about this in the bug tracker?Not> 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.
The topic has been locked.
- Jmantysalo
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 348
- Thank you received: 41
2 years 5 months ago #220784
by Jmantysalo
Replied by Jmantysalo on topic Mass deletion of users
OK, I did
bugs.limesurvey.org/view.php?id=17659
The following user(s) said Thank You: DenisChenu
The topic has been locked.