How to batch remove users with bounced email addresses?

We are using OJS 3.3.0.8 and would like delete some users. We manually sent an email in small batches to all users and around 300 of them bounced, because the email address is no longer in use. Can I use SQL to batch remove users whose emails are listed in a csv file of bounced emails?

Hi @Lolekbolek ,
This can be useful:
https://docs.pkp.sfu.ca/admin-guide/en/securing-your-system#cleaning-lots-of-users

3 Likes

Thank you, @dagosalas.

I see there the command that I can use:

$ php tools/mergeUsers.php myUsername spamUser1 spamUser2 spamUser3 […]

A tiny question - should I first match each email address to a username or would an email address qualify as spamUser1?

In this case, the usernames of the spam accounts are used. Preferably, create a user in OJS that does not have privileges.

1 Like

Thank you, @dagosalas.

$ php tools/mergeUsers.php myUsername spamUser1 spamUser2 spamUser3 […] did the trick.

1 Like

This topic was automatically closed after 13 days. New replies are no longer allowed.