How can I subscribe to more mailinglist with double-opt-in?

xpkiller · Post by **xpkiller** » Tue Nov 03, 2009 4:37 pm

Hi,

I have a problem.
I want to use double-opt-in but I can allowe for users to select from mailinglists more than one.
Well if I create froms and actions I have to create action based mail and there I have to select a mailinglist name.
How can I create a from with a lot of mailinglist selectable with double-opt-in?

Thanks your help!

Regards,
Peter

xpkiller · Post by **xpkiller** » Tue Nov 10, 2009 11:32 am

Nothing answer..
then I have to create forms, actions, mails separately for all mailinglist.

Post by **maschoff** » Wed Nov 11, 2009 8:47 am

We have written a script action for our commercial product EMM, but I am not sure if it works with OpenEMM as well. If you like I can post instructions and code here.

xpkiller · Post by **xpkiller** » Wed Nov 11, 2009 12:44 pm

If possible, I would see instruction and code.
May be help me.

Thank you!

(email: xpkiller-at-freemail-dot-hu)

Post by **maschoff** » Wed Nov 11, 2009 1:06 pm

Ok, I will split this post since it is rather big:

Topic: Subscription to several maillists via one form

subscription form "subscribe-form.html":

Code: Select all

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
   <title>Multiple Subscribe</title>
<script language="javascript" type="text/javascript">
<!--
function chkFormular()
{
 if(document.mailform.EMAIL.value.indexOf('@') == -1) {
   alert("Please enter a valid email address!");
   document.mailform.EMAIL.focus();
   return false;
  }
 if(document.mailform.agnSUBSCRIBE1.checked == false && document.mailform.agnSUBSCRIBE2.checked == false) {
    alert("Please select a maillist.");
    return false;
  }
}
//-->
</script>
</head>
<body bgcolor="#FFFFFF">
<form action="#" method="post" name="mailform" onSubmit="return chkFormular()">
<input type="hidden" value="1" name="agnCI">
<input type="hidden" value="testform" name="agnFN">
<input type="hidden" value="2" name="GENDER">
<input type="hidden" value="1" name="MAILTYPE">
<input type="hidden" value="1" name="agnMAILINGLIST1">
<input type="hidden" value="2" name="agnMAILINGLIST2">
<input type="text" value="" name="EMAIL">Email<br><br><br>
<input type="checkbox" name="agnSUBSCRIBE1" value="1">Maillist 1<br>
<input type="checkbox" name="agnSUBSCRIBE2" value="1">Maillist 2<br><br>
<input type="submit">
</body>
</html>

Post by **maschoff** » Wed Nov 11, 2009 1:18 pm

EMM form "testform" which is triggered by the web form of subscribe-form.html starts an action which steps

1. Subscribe (use double-opt-in, check for duplicates, key column "email")
2. Load recipient data
3. Script action

Code for script action:

Code: Select all

#set ($send = "0")

## maillist 1
$BindingEntry.setMailinglistID(1)
$BindingEntry.setCustomerID($customerID)

#if($BindingEntry.getUserBindingFromDB(1) == true)
   #if($BindingEntry.getUserStatus() == 5)
      #if ($send == "0")
         #set ($mail=$MailingDao.getMailing(XXXXXX, 1))
            #if($mail)
               $mail.sendEventMailing($customerID.intValue(), 0, "5", null, $ScriptHelper.getApplicationContext())
            #set ($send = "1")
      #end
   #end
#end

## maillist 2
$BindingEntry.setMailinglistID(2)
$BindingEntry.setCustomerID($customerID)

#if($BindingEntry.getUserBindingFromDB(1) == true)
   #if($BindingEntry.getUserStatus() == 5)
      #if ($send == "0")
         #set ($mail=$MailingDao.getMailing(XXXXXX, 1))
            #if($mail)
               $mail.sendEventMailing($customerID.intValue(), 0, "5", null, $ScriptHelper.getApplicationContext())
            #set ($send = "1")
      #end
   #end
#end

#set($scriptResult = "1")

where MailinglistID probably have to be adjusted (if not 1 and 2) and XXXXX is the mailingID of the double-opt-in mail for the corresponding maillist.

This script checks for every maillist whether the recipient is on this maillist with user_status 5 (="wait for confirm"). If so, it triggers the sending of the double-opt-in mail. Furthermore, it checks if the recipient already got a mail. If this is the case the following maillist(s) is/are ignored, because one mail is enough to subscribe to all selected maillists.

Post by **maschoff** » Wed Nov 11, 2009 1:22 pm

If the recipient clicks on the confirmation link in the double-op-in mail (all double-opt-in mails may use the same link) an EMM form has to be called which triggers another script action:

Code: Select all

## Maillist 1
$BindingEntry.setMailinglistID(1)
$BindingEntry.setCustomerID($customerID)

#if($BindingEntry.getUserBindingFromDB(1) == true)
   #if($BindingEntry.getUserStatus() == 5)
        $BindingEntry.setUserStatus(1)
        $BindingEntry.setUserRemark("Opt-in by User")
        $BindingEntry.updateStatusInDB(1)
   #end
#end

## Maillist 2
$BindingEntry.setMailinglistID(2)
$BindingEntry.setCustomerID($customerID)

#if($BindingEntry.getUserBindingFromDB(1) == true)
   #if($BindingEntry.getUserStatus() == 5)
        $BindingEntry.setUserStatus(1)
        $BindingEntry.setUserRemark("Opt-in by User")
        $BindingEntry.updateStatusInDB(1)
   #end
#end

#set($scriptResult = "1")

where MailinglistID probably has to be adjusted again.

This script checks the given maillists and sets user_status to 1 ("active") if the recipient exists and has user_status 5.

Post by **maschoff** » Wed Nov 11, 2009 1:24 pm

As a bonus script action for unscubscribe-confirm page:

Code: Select all

## Mailingliste 1
$BindingEntry.setMailinglistID(1)
$BindingEntry.setCustomerID($customerID)

#if($BindingEntry.getUserBindingFromDB(1) == true)
   #if($BindingEntry.getUserStatus() == 1)
        $BindingEntry.setUserStatus(4)
        $BindingEntry.setUserRemark("Opt-out by User")
        $BindingEntry.updateStatusInDB(1)
   #end
#end

## Mailingliste 2
$BindingEntry.setMailinglistID(2)
$BindingEntry.setCustomerID($customerID)

#if($BindingEntry.getUserBindingFromDB(1) == true)
   #if($BindingEntry.getUserStatus() == 1)
        $BindingEntry.setUserStatus(4)
        $BindingEntry.setUserRemark("Opt-out by User")
        $BindingEntry.updateStatusInDB(1)
   #end
#end

#set($scriptResult = "1")

This script checks for every maillist if binding exists and if status is active. If so, recipient is unsubscribed.

xpkiller · Post by **xpkiller** » Sun Nov 15, 2009 8:11 pm

Unfortunately it is not working for me

I cannot check your script because it is chinese for me. I'm a php and perl developer and I don't understand your script therefore I was able to copy/paste only but it says "error".
I have seen registration is started in database but it haven't sent any email for user.