Are there any plan to add functionality in the near future to this module?

Reason i ask is simple i'm missing quite some functions like:

• importing csv files and assigning to newsletters (conversion and initial setup)
• newsletter statistics
• localized unsubscribe
• better styling support
• custom fields

if there is nothing in the planning i want to use the standard module as basis to build the additional functions we've been using for years now as a seperate module (so it doesn't impact the core system) and donate it back so you can decide to replace current module or append or ...

peter

Hi Joe

Since there are planned enhancements on its way it will be difficult to keep things aligned.

Main thing i was missing for my clients is the ability to import a textfile with email addresses and assign them to one or more newsletters.

Created a simple pageI've copied the eLetter module and all pages and put everything in a new project.

Currently there is an ASPX page with a file upload for the importer and the code behind which is pretty simple.

i like simple to will just add the code here (watch for changed namespace because of project copy)

ASPX page

<%@ Page Title="" Language="C#" MasterPageFile="~/App_MasterPages/layout.Master" AutoEventWireup="true" CodeBehind="LetterImport.aspx.cs" Inherits="PraveMarketing.UI.LetterImport" %>

• 
  id='chk<%# DataBinder.Eval(Container.DataItem,"LetterInfoGuid").ToString() %>' checked="checked"
  title='<%# DataBinder.Eval(Container.DataItem,"Title") %>' name='chk<%# DataBinder.Eval(Container.DataItem,"LetterInfoGuid").ToString() %>'  />
  '><%# DataBinder.Eval(Container.DataItem,"Title") %>
  
  
  






 

           onclick="btnUploadAndImport_Click"  />





 

 

CODE BEHIND


using System;
using System.Collections.Generic;
using System.Globalization;
using System.Web.UI;
using System.Web.UI.WebControls;
using mojoPortal.Web.Framework;
using mojoPortal.Web.Editor;
using mojoPortal.Business;
using mojoPortal.Business.WebHelpers;
using mojoPortal.Net;
using Resources;
using mojoPortal.Web;
using System.IO;
using System.Text;


// resource
//  lnkLetterImportLink Import CSV file
namespace PraveMarketing.UI
{
    public partial class LetterImport : NonCmsBasePage
    {
        private SiteSettings siteSettings = null;
        private SubscriberRepository subscriptions = new SubscriberRepository();
        private List siteAvailableSubscriptions = null;
        protected string siteRoot = string.Empty;
   
        protected void Page_Load(object sender, EventArgs e)
        {
            BtnUpload.Text = Resource.BtnUploadText;
            BindList();
        }

        private void BindList()
        {
            siteSettings = CacheHelper.GetCurrentSiteSettings();
            siteRoot = SiteUtils.GetNavigationSiteRoot();
         
            siteAvailableSubscriptions = NewsletterHelper.GetAvailableNewslettersForCurrentUser(siteSettings.SiteGuid);
            if (siteSettings == null) { return; }
       
            if (siteAvailableSubscriptions == null) { return; }

            rptLetters.DataSource = siteAvailableSubscriptions;
            rptLetters.DataBind();
            if (rptLetters.Items.Count == 0) { this.Visible = false; }

        }

        protected void btnUploadAndImport_Click(object sender, EventArgs e)
        {
            if (FileUpload1.HasFile)
            {
                string dataFolder = Server.MapPath(siteSettings.DataFolder);
                string fileName = "import.txt";
                string fullCleanedFileNameWithPath = dataFolder  + fileName;
                FileUpload1.SaveAs(fullCleanedFileNameWithPath);
                //read the file into a list of String and Subscribe them
               string[] emails = File.ReadAllLines(fullCleanedFileNameWithPath);
               foreach (string emailaddress in emails)
               { DoSubscribe(emailaddress); }

            }

        }
        private void DoSubscribe(string emailAddressToSubscribe)
        {
                foreach (LetterInfo available in siteAvailableSubscriptions)
                {
                    string controlID = "chk" + available.LetterInfoGuid.ToString();
                    if (Request.Params.Get(controlID) != null) //only found if checked
                    {
                        DoSubscribe(available, emailAddressToSubscribe);
                    }
                }
        }

        private void DoSubscribe(LetterInfo letter, string email)
        {
            LetterSubscriber s = subscriptions.Fetch(siteSettings.SiteGuid, letter.LetterInfoGuid, email);
            if (s == null)
            {
                s = new LetterSubscriber();
                s.SiteGuid = siteSettings.SiteGuid;
                s.EmailAddress = email;
                s.LetterInfoGuid = letter.LetterInfoGuid;
                    s.UseHtml = true;
                    s.UserGuid = new Guid();
                    s.IsVerified = true;
                s.IpAddress = SiteUtils.GetIP4Address();
                SiteUser siteUser = SiteUser.GetByEmail(siteSettings, email);
                //if user exist use userguid else guid.empte
                if (siteUser != null) { s.UserGuid = siteUser.UserGuid; }
                subscriptions.Save(s);
                LetterInfo.UpdateSubscriberCount(s.LetterInfoGuid);
            }
        }
    }
}

 

RESOURCE ENHANCEMENT

BtnUploadText Upload txt file

 You may use this in your next version.

My next step is to implement a detailed analysis so we can see who has received the eletter and who has read it using a simple handler with a 1px image added to the html message

 

peter