[Mailman-Users] sync_members script

[Dragon]

Zbigniew Szalbot wrote:

>Hi,
>
>On Mon, 21 Apr 2008 09:29:57 -0700, Dragon <dragon at crimson-dragon.com>
>wrote:
> > Zbigniew Szalbot wrote:
> >
> >>Hello,
> >>Just wanted to ask how you manage the following situation:
> >>
> >>There is a list of people you keep in an sql database. This database is
> >>edited/updated daily. From time to time you want to contact these people,
> >>so you export them as a flat file and import into Mailman (for example by
> >>using sync_members script).
> >>
> >>You do the mailing and some addresses are removed from Mailman. When you
> >>next time sync members from you sql database with Mailman, the
> > sync_members
> >>script will add the previously removed members again, won't it (as they
> >>will not exist in mailman but will be in a flat file exported from sql
> >>database)?
> >>
> >>How do you handle this situation? When you get information about
> >>Mailman-unsubscribed emails, do you remove them then from your sql
> >>database? Is there any other way round it?
> >>
> >>Thanks!
> >>
> >>Zbigniew Szalbot
> > ---------------- End original message. ---------------------
> >
> > If you are running a responsible opt-in mailing list, I think it is
> > your responsibility to make sure that the unsubscribes are propagated
> > back into your SQL database.
>
>Absolutely - I was just hoping I wouldn't have to do it by hand... Sure if
>I had the unsubscribed addresses in a flat file, it would be easy to run an
>sql query to remove them from the sql database. I am just not thrilled
>about opening each unsbuscribed message and copying the email address into
>a file.
>
>Thanks!
---------------- End original message. ---------------------

Why do it manually? Mailman lets you send unsubscribe notices to the 
list owner. You could add another address to the list owner setting 
that would receive the e-mails and then pipe them to a script to 
extract the data automatically.

At least that is how I would do it.

Dragon

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  Venimus, Saltavimus, Bibimus (et naribus canium capti sumus)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~