ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: chris6 on January 15, 2006, 03:28:48 am

Title: Removing User
Post by: chris6 on January 15, 2006, 03:28:48 am

I want to export all my users on List 1 at follow up 52 and then remove all the user at follow up 52 from the system. How do I do this?
Gail

Title: Removing Users
Post by: chris6 on January 16, 2006, 12:55:21 pm

Hi Dean
Any chance of a reply to this soon.
Gail

Title: Removing User
Post by: DW on January 17, 2006, 01:47:44 am

I apologize for the delay.  I'm going to have to update the ListMail files to contain the option to export based on the Seq #.  I meant to redo the export feature sooner but have been really busy with other features and the new site.

I will update this post when I have a chance to put this in.

To remove the users on seq 58 you would need a custom query in PhpMyAdmin as follows, example for list 1.  Note that this will delete users who have received followup 57 but not (yet, if it exists) 58.

DELETE FROM lm_users WHERE list = '1' and cseq = '58';

To simply flag the users as Removed instead (these can later when I get the seq feature in for you - give me an hour or two -  be exported) use the following query:

UPDATE lm_users SET cnf = '2' WHERE list = '1' and cseq = '58';

Regards

Title: Removing User
Post by: DW on January 17, 2006, 05:26:08 am

Please re-download v1.85 and replace edituser.php to be able to export based on Seq #.

Regards