Differences between revisions 8 and 9
Revision 8 as of 2015-03-30 16:52:59
Size: 2801
Editor: msapiro
Comment: Added 'scripts/' to path in links to my scripts.
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.
Deletions are marked like this. Additions are marked like this.
Line 8: Line 8:
 * Use the email 'who' command. Send blank email with subject 'help' (without the quotes) to the <listname-request@example.com> address for more info.  * Use the email 'who' command. Send blank email with subject 'help' (without the quotes) to the `listname-request@example.com` address for more info.
Line 10: Line 10:
 * 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.  * 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.
Line 16: Line 16:
 * Script the above process to automate it. See <[[http://starship.python.net/crew/jwt/mailman/#throughtheweb|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|http://www.msapiro.net/scripts/mailman-subscribers.py]]> and <[[http://fog.ccsf.edu/~msapiro/scripts/mailman-subscribers.py|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|http://justin-hopkins.com/blog/2009/05/16/how-to-get-a-csv-of-subscribers-on-all-your-mailman-lists]]>  * 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]])

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.

Converted from the Mailman FAQ Wizard

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)