Zbigniew Szalbot wrote: >Hi, > >On Mon, 21 Apr 2008 09:29:57 -0700, Dragon <[EMAIL PROTECTED]> >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) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ------------------------------------------------------ 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/ Unsubscribe: http://mail.python.org/mailman/options/mailman-users/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=show&file=faq01.027.htp
