Author Topic: Removing User  (Read 1748 times)

chris6

  • Posts: 93
    • View Profile
Removing User
« 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

chris6

  • Posts: 93
    • View Profile
Removing Users
« Reply #1 on: January 16, 2006, 12:55:21 pm »
Hi Dean
Any chance of a reply to this soon.
Gail

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Removing User
« Reply #2 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
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Removing User
« Reply #3 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
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting