ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: steveb on April 09, 2007, 05:14:39 am

Title: How do I delete all users from list?
Post by: steveb on April 09, 2007, 05:14:39 am

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

Title: How do I delete all users from list?
Post by: DW on April 09, 2007, 02:22:53 pm

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

Title: How do I delete all users from list?
Post by: steveb on April 10, 2007, 05:35:57 am

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

Title: How do I delete all users from list?
Post by: DW on April 10, 2007, 05:11:09 pm

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