Differences between revisions 9 and 11 (spanning 2 versions)
Revision 9 as of 2015-09-04 01:34:26
Size: 2728
Editor: msapiro
Comment: Minor link cleanup and addition of wayback machine link to dead one.
Revision 11 as of 2019-05-29 14:35:06
Size: 2528
Editor: msapiro
Comment: Add links to Python 3 mailman-subscribers script.
Deletions are marked like this. Additions are marked like this.
Line 16: Line 16:
 * Script the above process to automate it. See [[http://starship.python.net/crew/jwt/mailman/#throughtheweb]] for an example. Note that this script still works with Mailman through at least 2.1.14, but for 2.1.10 and later, it prints %40 instead of @ in email addresses. An updated version of this script is available at [[http://www.msapiro.net/scripts/mailman-subscribers.py]] and [[http://fog.ccsf.edu/~msapiro/scripts/mailman-subscribers.py]]. This revised script addresses the issue above and additionally, can extract essentially all the member flags and other member info except preferred language from the Membership List pages into a CSV format file for import to a spreadsheet. The revised script also has an option to reset the 'hidden' flag for all members. You can use a small shell script to do this for all lists on your server [[http://justin-hopkins.com/blog/2009/05/16/how-to-get-a-csv-of-subscribers-on-all-your-mailman-lists]] (If this link doesn't work, get it from [[https://web.archive.org/web/20120815144046/http://justin-hopkins.com/blog/2009/05/16/how-to-get-a-csv-of-subscribers-on-all-your-mailman-lists|the wayback machine]])

Converted from the Mailman FAQ Wizard
 * Script the above process to automate it. See [[https://www.msapiro.net/scripts/mailman-subscribers.py]] and [[https://fog.ccsf.edu/~msapiro/scripts/mailman-subscribers.py]]. There are now Python 3 versions of the script at [[https://www.msapiro.net/scripts/mailman-subscribers3.py]] and [[https://fog.ccsf.edu/~msapiro/scripts/mailman-subscribers3.py]].  This script can extract essentially all the member flags and other member info except preferred language from the Membership List pages into a CSV format file for import to a spreadsheet. It also has an option to reset the 'hidden' flag for all members. You can use a small shell script to do this for all lists on your server [[http://justin-hopkins.com/blog/2009/05/16/how-to-get-a-csv-of-subscribers-on-all-your-mailman-lists]] (If this link doesn't work, get it from [[https://web.archive.org/web/20120815144046/http://justin-hopkins.com/blog/2009/05/16/how-to-get-a-csv-of-subscribers-on-all-your-mailman-lists|the wayback machine]])

3.62. How do I extract (export) a list of my list's members (subscribers)?

The preferred way to do this is via the command line tool bin/list_members, but many list owners do not have access to this tool.

Here are the other ways to get a membership list.

  • Use the email 'who' command. Send blank email with subject 'help' (without the quotes) to the listname-request@example.com address for more info.

  • Visit the roster via the listinfo page (or if you are already logged in, directly at something like http://www.example.com/mailman/roster/listname) and copy/paste/edit the result.

The above two methods have the drawback that 'hidden' members (those who have opted to be excluded from those lists) are not shown (this drawback was removed in Mailman 2.1.10 for those who authorize with a list admin/moderator password). Also, the roster shows only email addresses, not names. The 'who' result does include names. Beginning with Mailman 2.1.19, a site can optionally enable the display of names on rosters, but a list admin can't control this.

This is one of many Frequently Asked Questions.

MailmanWiki: DOC/How do I extract (export) a list of my list's members (subscribers)? (last edited 2019-05-29 14:35:06 by msapiro)