Question: Can list administrators do batch replacements of the entire mailing list membership list?
I'm considering using Mailman to distribute email newsletters to an organization whose email addresses are stored in a database. For several reasons, I don't want people (un)subscribing from Mailman; instead, I want to make sure that their email addresses are disabled in the database, and then the list administrator will replace the existing Mailman list with a completely new list generated from the database in plain text or any other format.
The reasons:
- As people are removed from the database, I need to make sure that their email addresses are removed from the Mailman list.
- I need to minimize the administrative effort, and since we need to make the changes in the database, I would rather not duplicate the work by editing the Mailman list.
-- Bob Treitman bob@softpro.com
Yes. I've automated this before at a company that used the database in a very similar way. You can dump out the email addresses into a text file - and only the email addresses - one email address per line. Then use the Mailman command-line commands to sync up the list with the text file.
You can get the text file on a Linux box several ways: making direct ODBC calls to the database, or having the server dump it out to the Linux box running Samba.
I also scanned the unsubscribe's that came into the list and passed those back in a text file for the admin to play with.
Good Luck - Jon Carnes
On Mon, 2002-09-30 at 16:18, Bob Treitman wrote:
Question: Can list administrators do batch replacements of the entire mailing list membership list?
I'm considering using Mailman to distribute email newsletters to an organization whose email addresses are stored in a database. For several reasons, I don't want people (un)subscribing from Mailman; instead, I want to make sure that their email addresses are disabled in the database, and then the list administrator will replace the existing Mailman list with a completely new list generated from the database in plain text or any other format.
The reasons:
- As people are removed from the database, I need to make sure that their email addresses are removed from the Mailman list.
- I need to minimize the administrative effort, and since we need to make the changes in the database, I would rather not duplicate the work by editing the Mailman list.
-- Bob Treitman bob@softpro.com
Mailman-Users mailing list Mailman-Users@python.org http://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/
participants (2)
-
Bob Treitman
-
Jon Carnes