ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: rhawkins on December 16, 2004, 06:17:03 pm

Title: Import users, but prevent from receiving existing followups
Post by: rhawkins on December 16, 2004, 06:17:03 pm

Hi,

I have a list of opt-ins that I want to transfer from another autoresponder.

I want to transfer the whole autoresponder operation, so I will also be moving the existing followup messages.

I need to make sure that all the records I import do NOT receive the followup messages (because they have already had them).

Can anyone tell me exactly how I do this?

Thanks,

Rob

Title: Import users, but prevent from receiving existing followups
Post by: DW on December 19, 2004, 11:45:49 pm

This will be VERY straightforward in the next update with an option to set the followup (or end of sequence)for imported users.

For now, you need to import your users and then run a custom MySQL command.  If you know how to do this the command, if your last followup is #10 and you want them to receive #11 if and when you add it later, is:

update lm_users set cseq = '11' where list = '1' and refurl = 'Imported' and dateadd = '2004-12-19';

Title: Import users, but prevent from receiving existing followups
Post by: rhawkins on December 20, 2004, 06:34:53 am

Thanks, Dean.

1) So what I am trying to achieve is a number in the 'Seq #' field which is one higher than the number of existing followups?

2) If that is the case, presumably I could add a field containing this number to my list before import, (when it is much easier to manipulate the data). And then arrange the fields on import via the field match function mentioned in help?

3) Do I need anything in the 'Delay #' field?

Regards,

Rob

Title: Import users, but prevent from receiving existing followups
Post by: DW on December 21, 2004, 01:43:43 pm

1> Yes, that's correct.  One higher than the last Seq # will result in the user not being sent existing followups while remaining in sequence.

2> You could, presumably, do this..  If the field is in the field match dropdown. If not, I could help you put it in.  :)

3> The Delay can be left at 0 because it can be updated when you add the next followup.

Regards,