Re: List Management Question

 
From: "Samer Bechara" <farrooda@PROTECTED>
Date: April 29th 2009
I am facing this problem myself at the moment. However, I have to figure out a solution yet. Taking a look at the mysql backend, the database design is a bit weak. There should be a table for subscribers, a table for lists, and another table that maps subscribers to lists.

Currently, if I need to email multiple lists, a user who has subscribed to multiple lists will receive the same message more than once. However, with a better database design, it would make this much easier.

I am willing to work on the backend database design, however, I need someone to help me with scripting, as my perl skills are not very advanced.



Lennie Jarratt wrote:
List Management Question
I keep running into the following scenario and was wondering if anyone else has dealt with this yet.

Organization has multiple lists.  They want to send out an email blast to all lists or select which lists to send to with one simple send instead of copying and sending a message to each list. 

I was handling this for one client by adding hidden user fields so they have 1 list.  That way when they send, they choose who to send it to with the filters.  They then have issues with manually adding new names.  It's a political campaign so they get names at events that need to be added manually.

What I have thought about to handle this is to create a mapping table that identifies the lists a user belong to removing and removing the list name from the subscribers table.   This would also necessitate changes to the send and subscribe functions.

First, has anyone else worked with this?  Or has anyone else run into this?

Thanks in advance.

Lennie
--
Twitter: http://twitter.com/ljarratt
Facebook: http://www.facebook.com/people/Lennie_Jarratt/1182350486

"The necessity of the times, more than ever, calls for our utmost circumspection, deliberation, fortitude, and perseverance." - Samuel Adams

Post:
mailto:dadadev@PROTECTED

Unsubscribe:
http://dadamailproject.com/cgi-bin/dada/mail.cgi/u/dadadev/

List Information:
http://dadamailproject.com/cgi-bin/dada/mail.cgi/list/dadadev

Archive:
http://dadamailproject.com/cgi-bin/dada/mail.cgi/archive/dadadev

Mailing List Powered by Dada Mail

Mailing List Powered by Dada Mail

Post:
mailto:[list_settings.discussion_pop_email]

Unsubscribe:
http://dadamailproject.com/cgi-bin/dada/mail.cgi/u/[list]/

List Information:
[PROGRAM_URL]/list/[list_settings.list]

Archive:
[PROGRAM_URL]/archive/[list_settings.list]

  • This mailing list is a public mailing list - anyone may join or leave, at any time.
  • This mailing list is a group discussion list (unmoderated)
  • Start a new thread, email: dadadev@dadamailproject.com

This is the developer discussion mailing list for Dada Mail.

If you are just looking for support Dada Mail, consult the message boards at:

https://forum.dadamailproject.com

Documentation for Dada Mail:

https://dadamailproject.com/d

Specifically, see the Error FAQ:

https://dadamailproject.com/d/FAQ-errors.pod.html

To post to this list, send a message to:

mailto:dadadev@dadamailproject.com

All subscribers of this list may post to the list itself.

Topics that are welcome:

  • Constructive critiques on the program (I like, "x", but, "y" needs some work - here's an idea on how to make this better...)
  • Bug/Error reports
  • Bug fixes
  • Request For Comments on any changes to the program
  • Help customizing Dada Mail for your own needs
  • Patches
  • Language Translations
  • Support Documentation/Doc editing, FAQ's, etc.
  • Discussion of any changes that you would like to be committed to the next version of Dada Mail -

Dada Mail is on Github:

https://github.com/justingit/dada-mail/

If you would like to fork, branch, send over PRs, open up issues, etc.

Privacy Policy:

This Privacy Policy is for this mailing list, and this mailing list only.

Email addresses collection through this mailing list are used explicitly to work within this email discussion list.

We only collect email addresses through our Closed-Loop Opt-In system.

We don't use your email address for any other purpose.

We won't be sharing your email address with any other entity.

Unsubscription can be done at any time. Please contact us at: justin@dadamailproject.com for any help regarding your subscription, including removal from the mailing list.

All mailing list messages sent from us will include a subscription removal link, which will allow you to remove yourself from this mailing list automatically, and permanently.

All consent to use your email address for any other purpose stated at the time of the mailing list subscription will also be revoked upon mailing list removal.