Email List Export Timeout

[amgym-jt]

I am currently unable to export current members of my email list because the server times out. I export them so that i can add them to my external list that is maintained with a 3rd party source. There are only just over 1000 in this list. I tried accessing the data with the dataport, but the user information downloaded does not include list membership info.

Any suggestions?

Thanks!

Jay

[mikek]

Hi Jay,

The default exportlist functionality tries to find customer address information for each email in the list and times-out if you have
more than few hundred emails.

If you just need to export email addresses with no additional information you can use the code listed below.

- go to [site physical path] \Admin\Marketing\Email\ and make a copy of ExportList.ashx
- open ExportList.ashx with any text editor and replace code with code listed below
- save the file a try to export emails again

\Admin\Marketing\Email\ExportList.ashx

Code: Select all

<%@ WebHandler Language="C#" Class="ExportList" %>

using System;
using System.Web;
using System.Text;
using CommerceBuilder.Marketing;
using CommerceBuilder.Users;
using CommerceBuilder.Utility;

public class ExportList : IHttpHandler {

    public void ProcessRequest(HttpContext context)
    {
        int _EmailListId = AlwaysConvert.ToInt(context.Request.QueryString["EmailListId"]);
        EmailList _EmailList = EmailListDataSource.Load(_EmailListId);
        
        if (_EmailList.Users.Count > 0)
        {
            StringBuilder userData = new StringBuilder();
            userData.Append("Email\r\n");
            
            foreach (EmailListUser elu in _EmailList.Users)
            {
                userData.Append(string.Format("{0}\r\n", elu.Email));
            }
            
            string outFileName = "email_list.csv";
            PageHelper.SendFileDataToClient(userData.ToString(), outFileName);
        }
    }
 
    public bool IsReusable {
        get {
            return true;
        }
    }

}

[amgym-jt]

that worked like a charm! thanks!

any way that we can keep the customer's first name too in the export list?

thanks again!

Jay

[crazyjoe]

Thanks for this! I need to export with zip code if possible. Let me know if anyone can help with this. Thanks.