[Mailman-Users] Re: Integrating Mailman lists with SQL database via command line/scripts

[Jon Carnes]

Then you are really going to like the next version (mm v2.1).  You can set
mm v2.1 to use your own database instead of the default one that Mailman
currently uses.

Currently, I pump user info out of Mailman by using the command line
scripts:
  config_list (list config items)
  dumpdb (complete database dump, all specs and members and their
information)
  list_lists (list of all the mailing lists running on the site)
  list_members (list of the email addresses in a mailing list)
  remove_members (delete an email from a mailing list)

And I pump info back into Mailman by using the command line scripts:
  add_members (add an email address to the list)
  clone_member (add an email address to the list with specific user
settings)
  config_list (upload configuration changes to the list)
  sync_members (one of my favorites - syncs a mailing list with a text file
of email addresses)

I use scripts to dump and mingle data from my SQL databases with the
Mailingman lists.  Works fine, and now that I've started playing with Python
and accessing the SQL databases directly from within Python, things are
really getting fun!

Jon Carnes
----- Original Message -----
From: "David Chaplin-Loebell" <dcl at klatha.com>
To: "Jon Carnes" <jonc at nc.rr.com>
Cc: <mailman-users at python.org>
Sent: Thursday, March 14, 2002 7:46 AM
Subject: Re: [Mailman-Users] (no subject)


> Can you elaborate?  Is there documentation of this feature? I'd love to
> build tighter integration between my customer database (in MySQL) and my
> MailMan lists.
>
> On Thu, 14 Mar 2002, Jon Carnes wrote:
>
> > Mailman allows you to manipulate the lists using outside files or
databases.
> > You will have to maintain a list of emails to "not send".
>
>
> ------------------------------------------------------
> Mailman-Users mailing list
> Mailman-Users at python.org
> http://mail.python.org/mailman/listinfo/mailman-users
> Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py