ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: ajlee on May 02, 2008, 12:09:30 pm

Title: reversing an import
Post by: ajlee on May 02, 2008, 12:09:30 pm

we accidently imported a group of people into a list that shouldn't be on there. is there anyway to 'reverse' that import? even if we just go back to the list from a day or two ago...

Title: reversing an import
Post by: DW on May 08, 2008, 06:25:02 am

Users can be removed using a custom tool like PhpMyAdmin commonly available from your web hosting control panel.  This is done by clicking yoru database and then "SQL", where you can enter a custom MySQL query.

To remove all users imported to list 1 on May 2nd try the following query.  Note that running these queries is non-reversible so be very careful you have the correct list and date.

DELETE FROM lm_users WHERE list = '1' AND dateadd = '2008-05-02' AND refurl LIKE '%Imported%'

If you want to see which users -would- be deleted before running DELETE:

SELECT * FROM lm_users WHERE list = '1' AND dateadd = '2008-05-02' AND refurl LIKE '%Imported%'

Regards