Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Mass deletion of users

  • Jmantysalo
  • Jmantysalo's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
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
  • Jmantysalo's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
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
  • Jmantysalo's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
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
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 6 months 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.
The topic has been locked.
  • Jmantysalo
  • Jmantysalo's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
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.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 6 months 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.
The topic has been locked.
  • Jmantysalo
  • Jmantysalo's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
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.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 6 months 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.
The topic has been locked.
  • Jmantysalo
  • Jmantysalo's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
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?
The topic has been locked.
  • Jmantysalo
  • Jmantysalo's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
2 years 5 months 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?
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 5 months 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.
The topic has been locked.
  • Jmantysalo
  • Jmantysalo's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
2 years 5 months ago #220784 by Jmantysalo
Replied by Jmantysalo on topic Mass deletion of users
The following user(s) said Thank You: DenisChenu
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose