Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : Bulk delete from CPDB?

Bulk delete from CPDB? il y a 1 an 6 mois #95437

  • bkgray
  • Portrait de bkgray
  • Hors ligne
  • Fresh Lemon
  • Messages : 8
  • Karma: 2
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?
L'administrateur a désactivé l'accès en écriture pour le public.
Modérateurs: ITEd
Temps de génération de la page : 0.120 secondes
Donation Image