> Date: Mon, 1 Dec 2014 17:39:30 -0800 > From: m...@msapiro.net > I do this differently. I just run a daily cron does something like: > > #! /bin/bash > /home/mark/.cron/get_memb | \ > /usr/local/mailman/bin/sync_members -w=yes -g=no -a=no -f - gpc-announce
This sounds like a good idea (especially if it ever ceases to be announcement-only). > get_memb happens to be a python script which uses the MySQL-python > package <https://pypi.python.org/pypi/MySQL-python/> to access the MySQL > database and extract a list of > > First Last <email> > > entries for all current members of my bike club from our database and > gpc-announce is the "all club" announcement list. > > The get_memb script is specific to our database, but it could basically > be anything, even just a straight MySQL query, that produces the desired > list (In our case, the logic of determining whether a record in the > table is that of a current member is complex and in some cases involves > looking at dates in other records, thus the python script). That sounds so similar to my situation that I'm going to push my luck, and ask if I could see an anonymised version of your get_memb script - would that be all right? Even the "who is a member?" part would be useful as, while mine would be different, it would help me with learning the necessary Python. Thank you Jon ------------------------------------------------------ Mailman-Users mailing list Mailman-Users@python.org https://mail.python.org/mailman/listinfo/mailman-users Mailman FAQ: http://wiki.list.org/x/AgA3 Security Policy: http://wiki.list.org/x/QIA9 Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ Unsubscribe: https://mail.python.org/mailman/options/mailman-users/archive%40jab.org