Author Topic: Transfering existing list into middle of messages  (Read 1747 times)

sales5

  • Posts: 4
    • View Profile
Transfering existing list into middle of messages
« on: October 05, 2004, 08:49:59 pm »
Can you set a newly imported subscriber and/or your list of subscribers so they receive your messages in the same position as the old responder without using two lists, one for your existing subscribers and another for new subscribers?

To elaborate, say I have subscribers who have already received 10 mailouts from an existing different responder. I want them to continue with message 11, (new subscribers from my subscribe page I want them to start with message 1 as usual). I want to have 1 list, not 2 lists of the same messages with one starting at message 11 and the other starting with message 1.

Can I do this and how?

Thanks,
Sean

DW

  • Administrator
  • Posts: 3787
    • View Profile
    • https://legacy.listmailpro.com
Transfering existing list into middle of messages
« Reply #1 on: October 07, 2004, 06:48:58 pm »
Sean,

This is currently only possible with a Custom MySQL command run after Import with PhpMyAdmin, often available from your control panel.

To set the user to receive followup 11 next dailymail you must set their "cseq" and "cdel" values to "11" and "0" respectively.

Let's say the date is Dec 31st, 2003 and you're using List 1.

Import your users then run the following query in PhpMyAdmin:

Code: [Select]
update lm_users set cseq = '11', cdel = '0' where list = '1' and dateadd = '2003-12-31' and refurl = 'Imported'
Note that ANY users on this list that were imported on this date will be modified, so don't run it if you have imported users who you DON'T want this to affect.

The next release features welcome, confirmation, signup-xtra.php, and the ability to set the followup for new imports.
Dean Wiebe
ListMailPRO Author & Developer - Help | Support | Hosting