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! Zbigniew Szalbot ------------------------------------------------------ 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
