Thread

Hi,

I’m using EE V1.6.7, build 20090320.

I now have 790 email addresses subscribed to one newsletter list in the Mail List Module, and I was wondering if there was an upper limit on the number of email addresses that should be kept within one list. I’ve noticed that EE connection has started to ‘time-out’ when I now send emails to my email contacts in the Communicate tab, which suggests to me that there is a practical upper limit.

Also, is it possible to export the email addresses from Mailing List Manager, or are they forever locked within Expression Engine?

Many thanks,
Tim

Hi, Tim. It depends on your host. Some hosts restrict you to x number of emails in a particular time, so you can send the email in batches. Yes, you can certainly save the email addresses.

See: http://expressionengine.com/wiki/Export_Mailing_List/ (one way of doing this).

Does that help?

Thanks Sue.

I’ve managed to extract a list of the email addresses using this code:

{exp:query sql="select email from exp_mailing_list where list_id = '2' order by email asc"} 
{email}
 
{/exp:query}

Is it also possible to include the ip address with email address? I can see the ip address within the Mailing List module, so that field is held within EE some where.

Many thanks,
Tim

Hi, Tim. You can add ip_address to your query. Does that help?

Hi Sue,

This query did return an ip address:

{exp:query sql="select email from exp_mailing_list where list_id = '2' order by email asc"} 
{email}, {ip_address}
 
{/exp:query}

...but for some reason it was the same ip address for every email address! It gave ‘86.176.33.102’ every time, which isn’t my ip address nor is it what I see in the Mailing List Module itself.

What I was hoping to achieve by all this was to identify multiple email addresses to one ip address. I could then identify spammers who seem to have infiltrated our sites newsletter list. However, I need to be able to export all the mailing list info so that I can sort it in excel.

Also, for added security, is it possible to put a ‘capatcha’ check when requesting visitors submit their email address? Currently the spammers seem to be getting around the comfimation email request that EE sends out.

Many thanks,
Tim

Hi, Tim. I don’t see a method for using captchas in there. If I were to test signing up, would the same IP address show? Feel free to send me a link via MSG (not PM) to see if my IP goes in there correctly.

Hi Sue,

Just to restate the problem, the ip addresses I see held with the Mailing List Module accessed via EE are different to the report generated using the coding I quoted above. Indeed the code displayed the same ip address for all the email addresses.

By all means try and sign up to the newsletter on the site and I’ll report back the IP address recorded: http://www.paulgravett.com/

Thanks,
Tim

OK, I signed up. What IP address do you see in the control panel backend?

Sue,

In the control panel I see your ip address: 66.28.213.17

In the code generated web-page it is: 86.176.33.102 (as are all the other email addresses).

Having double checked, it turns out 86.176.33.102 is in fact my ip address.

Is there some way to tweak that original code to display the values held in EE?

Thanks,
Tim

I just noticed what the problem is.

{ip_address} is a global variable.

Let’s have you do the following instead.

{exp:query sql="select email, ip_address as addr 
from exp_mailing_list 
where list_id = '2' 
order by email asc"}
{email}, {addr}
 
{/exp:query}

See the difference?

Sue,

Perfect.

Many thanks for your help with this.

Tim

No worries, sorry I didn’t catch the problem earlier. If anything else comes up, please do let us know in a new thread..