Thread

Thanks for the links, Sue. Is the instructions SQL? If so, I do not know how to use SQL. Going around in circles.

Hi, DavSam - the wiki article is SQL code, but all you have to do is copy and paste the code line into a template and then visit the template.  That will give you a list of everyone on your mailing list that you can then cull duplicates from.  Once done, just copy and paste it back into your mailing list recipients list and you’re all fixed up

How do I do a “template”? Hate to ask you!

Just use a regular EE template. The name doesn’t matter at all.

Instructions? I’m an enduser not a programmer. I maintain the site for a nonprofit org and just want to verify that we are not sending more than one copy of the enewsletter to subscribers.

DavSam, in that case you might want to consider hiring someone from the Professionals network to do this task for you.

It’s a job that would take at most 15 minutes to do, even less.

You might also consider posting in the Freeform forums, since the problem appears to be caused by Freeform duplicate entries.

Isn’t forum for people who need help? Or is it for elite programmers only? Is there step by step instructions in your tech support/FAQ anywhere? I would think looking for duplicates from a mailing list module portion of Expression Engine is a very basic concern easily addressed by a basic export facility but apparently this is not the case here unless there is simple instructions you can direct me to?

DavSam - what sort of text editor do you have access to? Are you on a Windows or Mac? Do you know how to create a template group and add a template?

NotePad? Use Windows. Don’t know how to ‘create a template group and add template.’

Hi, DavSam,

Ok, follow these instructions:

1.  Login to your ExpressionEngine Control Panel
2.  Click “Templates” in the navigation at the top
3.  You’ll see a template group listed and a bunch of templates.  Click “Create New Template”
4.  Name the new template “email_export”
5.  Click on the name of the template “email_export” to edit it.
6.  Paste this code, and only this code, into the template:

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

7.  Click “Update” under the text entry area (textarea)
8.  That page will reload, in the top right click “View Rendered Template”

This should contain a list of all of the email addresses in your mailing list.  If it does not, then we will need to figure out your mailing list ID and make sure that it is correct, which we can walk you through as well.

After following instructions and clicking “View Rendered Template”, I get an empty page, URL: http://www.jdcc.org/index.php/site/email_export/

Do I need to figure out mailing list ID, if so, can you walk me through it?

I use FreeForm.
From signup_form template, does this help:

<div class="listbox">
<b>Check or Uncheck the lists you would like to subscribe to:</b>

  <input type="checkbox" name="mailinglist[]" value="news" checked="checked"/>Be informed when the JDCC website has been updated (monthly)

  <input type="checkbox" name="mailinglist[]" value="onetimenews" checked="checked"/>News Flash updates (occasional)

  <input type="checkbox" name="snail_mail_list" value="snail_mail_list" checked="checked"/>Mailing list (for any mailings through the US Post Office)
{!--
  <input type="checkbox" name="monthly_updates" value="monthly_updates" checked="checked"/>Be informed when the JDCC website has been updated (monthly)

  <input type="checkbox" name="occasional" value="occasional" checked="checked"/>News Flash updates (occasional)

  <input type="checkbox" name="snail_mail_list" value="snail_mail_list" checked="checked"/>Mailing list (for any mailings through the US Post Office)
--}
</div><!-- end listbox -->

No, I don’t think this has got anything to do with Freeform. A few questions: What version and build of EE are you on? (You can find that in the footer of your control panel). When you go to your “Modules” tab, do you see the Query module there? Is it enabled? We’ll be needing it.

Version: 1.6.8, Build: 20091002

Yes, I do see Query   SQL query module for templates   1.0
Status shows as installed. Does that mean enabled?

Yes, that means it’s installed. No open your Control Panel > Utilities > SQL Manager > Database Query Form. Paste the following line of code in there:

SELECT * FROM exp_mailing_lists

and tell us the result, please.