Author Topic: Sequence Number for All Members  (Read 1624 times)

lambertb

  • Posts: 29
    • View Profile
Sequence Number for All Members
« on: February 20, 2006, 07:57:31 am »
Hi,

I just imported about 800 people who were part of a series on my other system

They will all have a sequence number of "1" if I turn on follow ups.  I want to put them all to number "8".  and then back fill 1-7 for the new subscribers who come along behind them.

If I put in 1-7 right now, the people will get #1.  I will also have to click on all 800 to manually do it.

Is there a way to insert into the SQL table the sequence number of 8 for all subscribers in there now?  Even if they have never "technically" had 1-7 on my listmail system?

Brian

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Sequence Number for All Members
« Reply #1 on: February 20, 2006, 03:05:42 pm »
Brian,

While this is possible in a near-future update, currently you must run a custom SQL query using PhpMyAdmin (often available in your hosting Control Panel), such as:
Code: [Select]
update lm_users set cseq = '8' where list = '1';
Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting

lambertb

  • Posts: 29
    • View Profile
What about different lists?
« Reply #2 on: February 20, 2006, 03:51:37 pm »
Great! Thanks!

Will that apply to all my lists?

What if I have 10 lists.  

List 1: needs to be at 8

List 2: needs to be at 12?

List 3: needs to be at 1?

etc

Thanks Dean!

Brian

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Sequence Number for All Members
« Reply #3 on: February 20, 2006, 04:21:48 pm »
Code: [Select]
update lm_users set cseq = '8' where list = '1';
In the above query the Seq # is 8 and the list is 1.  You can change these to your liking to update users on other lists.

Regards
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting