On Sun, 9 Dec 2018 at 03:47, Mark Sapiro <m...@msapiro.net> wrote: > On 12/7/18 2:12 AM, Odhiambo Washington wrote: > > On Fri, 7 Dec 2018 at 07:27, Mark Sapiro <m...@msapiro.net> wrote: > > > >> On 12/3/18 4:55 AM, Odhiambo Washington wrote: > >>> Hi All, > >>> > >>> I am running a list that has members joining and leaving. > >>> I'd like to get an inside of these changes: > >>> 1. how many members joined last month, this month.. > >>> 2. How many members left last month, this month, this year. > >> > >> > >> I had some time to play with this so check out > >> <https://www.msapiro.net/scripts/subscribe_log> (mirrored at > >> <https://fog.ccsf.edu/~msapiro/scripts/subscribe_log>) > >> > >> If this is close to useful for you, I'm willing to tweak it if you want > >> changes. > > > > > > It is definitely very very useful. Thank you very much for putting this > > together. > > > > > > > >> As it is, you can feed it a mailman subscribe log covering some period > >> and it will report the most recent join/leave event by list and user for > >> the whole log or, if specified, a most recent number of days. > >> > >> Run it under Python3 (it will work with Python 2) with the --help option > >> for more info. > >> > > > > I have tested it and notice that I need a few changesmods: > > > > 1. Give it the -l option to specify a listname (yes, my server has > several > > lists) > > 2. The current -l should probably be changed to -f for specifying the > > subscribe filename/path > > 3. Since the subscribe log has dates, maybe -d should instead be used to > > parse for and then group by month?? > > Or perhaps you can add an option to specify the month you want, like > > Jan, Feb, so a '-m Nov' will give the join/leave for November.. > > 4. To make it a little fancier, you can display the results in some > > tabulated format: > > > > Mailman Subscription Report for $Month > > ----------------------------------------------------- > > LISTNAME ---------------JOINED---------LEFT > > list1 15 2 > > list2 8 12 > > .... > > > I have updated the script at > <https://www.msapiro.net/scripts/subscribe_log> (mirrored at > <https://fog.ccsf.edu/~msapiro/scripts/subscribe_log>) > > It doesn't do exactly what you asked for, but it has a -l/--list option > which may be repeated for multiple lists and it prints a summary line > > For this list, joined = xx, left = xx > > for each list processed. If you want to see only the list name and > summary you can pipe the output through > > sed '/^ /d' > > The biggest difference is there is no month option per se, but there are > options to specify begin and end dates so for example to see only > November you would specify > > --begin=2018-11-01 --end=2018-11-30 > > -- > Mark Sapiro <m...@msapiro.net> The highway is for gamblers, > San Francisco Bay Area, California better use your sense - B. Dylan >
Hi Mark, Thank you so much. This is awesome. It's good enough for me to get the stats by month if I run it monthly, at the end of the month, with --begin referencing the right date. Thank you once again. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254 7 3200 0004/+254 7 2274 3223 "Oh, the cruft." ------------------------------------------------------ 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