[Mailman-Users] Mailman subscription/unsubscription reports

[Odhiambo Washington]

On Sun, 9 Dec 2018 at 03:47, Mark Sapiro <mark at msapiro.net> wrote:

> On 12/7/18 2:12 AM, Odhiambo Washington wrote:
> > On Fri, 7 Dec 2018 at 07:27, Mark Sapiro <mark at 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 <mark at 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."