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
-
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
-
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:
delete from lm_users where list = '1' and refurl = 'Imported' and dateadd = '2007-04-09';
Regards
-
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
-
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