Sequence Number for All Members

[lambertb]

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]

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

[lambertb]

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]

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