How do I delete all users from list?

[steveb]

Hello,

I did an inaccurate import, now I want to delete all the users in the list. There are 56 pages of them, so I don't want to have delete each user individually.

Is there a way in LMP?

If not, do I have to go in and use a SQL query?

Thanks in advance,

Steve

[DW]

Steve,

You could delete just the most recent import (as long as others were not made on the same day) on List 1 (for example) with a custom MySQL command as folllows:

Code: [Select]

delete from lm_users where list = '1' and refurl = 'Imported' and dateadd = '2007-04-09';
Regards

[steveb]

I'll give that a try.

I did notice that the refurl is blank for all of the users I imported. The field is NOT set to 'Imported'.

Thanks!

Steve

[DW]

Steve,

Another way might be to use the Import feature with a text file containing a single line (doesn't even have to be an email address).  Choose the file to upload, upload it and enable "DELETE all users on this list before importing".

Regards