Bulk delete from CPDB?

More
4 years 4 weeks ago #95437 by bkgray
bkgray created the topic: Bulk delete from CPDB?
At the end of the school year, I will need to remove 150 or so graduating students from the central participant database. It's easy to add participants via a CSV import, but there does not appear to be a similar way to remove them.

My plan is to generate a file of MySql statements to delete the appropriate records from the appropriate tables. It looks like I will identify the records in lime_participants by the email address, and then delete records from lime_participants, lime_participant_attributes and lime_participant_shares based on the participant_id field.

I don't plan to delete tokens or responses from individual surveys. Is there anywhere else in the database that I need to look to delete the participants who have left the school?

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now