ListMailPRO Email Marketing Software Forums
ListMailPRO Email Software
& Marketing Forums
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Home
Help
Search
Login
Register
ListMailPRO Email Marketing Software Forums
»
ListMailPRO Email Marketing Software Forums
»
General Help & How-To
»
Sequence Number for All Members
« previous
next »
Print
Pages: [
1
]
Go Down
Author
Topic: Sequence Number for All Members (Read 1587 times)
lambertb
Posts: 29
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
Logged
DW
Administrator
Posts: 3787
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
Logged
Dean Wiebe
ListMailPRO
Author & Developer -
Help
|
Support
|
Hosting
lambertb
Posts: 29
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
Logged
DW
Administrator
Posts: 3787
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
Logged
Dean Wiebe
ListMailPRO
Author & Developer -
Help
|
Support
|
Hosting
Print
Pages: [
1
]
Go Up
« previous
next »
ListMailPRO Email Marketing Software Forums
»
ListMailPRO Email Marketing Software Forums
»
General Help & How-To
»
Sequence Number for All Members