![](https://secure.gravatar.com/avatar/f0f35ad96ddcfe7bf1eb5aaff9242df9.jpg?s=120&d=mm&r=g)
How can you get a list of all user's and addresses exported to .csv or .xls from the web.
Robert P. Schwartz CAS, Inc. A wholly owned subsidiary of ITT Corporation 100 Quality Circle Huntsville, AL 35806
Phone: 256.922.4203 Fax: 256.922.4243
E-mail: robert.schwartz@itt.com<mailto:robert.schwartz@itt.com>
This e-mail and any files transmitted with it may be proprietary and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender. Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of ITT Corporation. The recipient should check this e-mail and any attachments for the presence of viruses. ITT accepts no liability for any damage caused by any virus transmitted by this e-mail.
![](https://secure.gravatar.com/avatar/56f108518d7ee2544412cc80978e3182.jpg?s=120&d=mm&r=g)
Schwartz, Robert - IS wrote:
How can you get a list of all user's and addresses exported to .csv or .xls from the web.
See the FAQ at <http://wiki.list.org/x/aYA9> which, among other things will point you to the script at <http://www.msapiro.net/mailman-subscribers.py> which runs on your workstation and can generate a .csv from the web admin interface.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
![](https://secure.gravatar.com/avatar/f0f35ad96ddcfe7bf1eb5aaff9242df9.jpg?s=120&d=mm&r=g)
I do not know how to do this from a cmd prompt. The usage says:
Usage: %(PROGRAM)s [options] hostname listname password
Do I do this from a cmd prompt. What would be the syntax for my site?
-----Original Message----- From: Mark Sapiro [mailto:mark@msapiro.net] Sent: Friday, April 30, 2010 11:44 AM To: Schwartz, Robert - IS; mailman-users@python.org Subject: Re: [Mailman-Users] get list of users
Schwartz, Robert - IS wrote:
How can you get a list of all user's and addresses exported to .csv or .xls from the web.
See the FAQ at <http://wiki.list.org/x/aYA9> which, among other things will point you to the script at <http://www.msapiro.net/mailman-subscribers.py> which runs on your workstation and can generate a .csv from the web admin interface.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
This e-mail and any files transmitted with it may be proprietary and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender. Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of ITT Corporation. The recipient should check this e-mail and any attachments for the presence of viruses. ITT accepts no liability for any damage caused by any virus transmitted by this e-mail.
![](https://secure.gravatar.com/avatar/56f108518d7ee2544412cc80978e3182.jpg?s=120&d=mm&r=g)
Schwartz, Robert - IS wrote:
You first need to download and install Python on your Windows XP box. The windows installer for Python 2.6.5 is at <http://www.python.org/ftp/python/2.6.5/python-2.6.5.msi>
Then, if your list's web admin interface were for example <http://www.example.com/mailman/admin/listname>, you would at a cmd prompt type
cd (the folder where you saved mailman-subscribers.py) python mailman-subscribers.py -c -o output-file.csv www.example.com listname password
The last line starting with python and ending with password is all one line, not wrapped as here. output-file.csv is the name of the file to receive the csv and password is the list's admin password.
You might also need to use the -u option if the admin interface URL is not of the above form.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
![](https://secure.gravatar.com/avatar/ad39ca4618d4c4ded568b0de5583b8e3.jpg?s=120&d=mm&r=g)
This did exactly what I needed. Thanks. If I want others to be able to do this, will they need to download http://www.python.org/ftp/python/2.6.5/python-2.6.5.msi?
-----Original Message----- From: mailman-users-bounces+rpschwar=knology.net@python.org [mailto:mailman-users-bounces+rpschwar=knology.net@python.org] On Behalf Of Mark Sapiro Sent: Friday, April 30, 2010 11:34 PM To: Schwartz, Robert - IS; mailman-users@python.org Subject: Re: [Mailman-Users] get list of users
Schwartz, Robert - IS wrote:
You first need to download and install Python on your Windows XP box. The windows installer for Python 2.6.5 is at <http://www.python.org/ftp/python/2.6.5/python-2.6.5.msi>
Then, if your list's web admin interface were for example <http://www.example.com/mailman/admin/listname>, you would at a cmd prompt type
cd (the folder where you saved mailman-subscribers.py) python mailman-subscribers.py -c -o output-file.csv www.example.com listname password
The last line starting with python and ending with password is all one line, not wrapped as here. output-file.csv is the name of the file to receive the csv and password is the list's admin password.
You might also need to use the -u option if the admin interface URL is not of the above form.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
Mailman-Users mailing list Mailman-Users@python.org http://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: http://mail.python.org/mailman/options/mailman-users/rpschwar%40knology.net
No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.801 / Virus Database: 271.1.1/2846 - Release Date: 04/30/10 13:27:00
![](https://secure.gravatar.com/avatar/56f108518d7ee2544412cc80978e3182.jpg?s=120&d=mm&r=g)
Schwartz, Robert - IS wrote:
How can you get a list of all user's and addresses exported to .csv or .xls from the web.
See the FAQ at <http://wiki.list.org/x/aYA9> which, among other things will point you to the script at <http://www.msapiro.net/mailman-subscribers.py> which runs on your workstation and can generate a .csv from the web admin interface.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
![](https://secure.gravatar.com/avatar/f0f35ad96ddcfe7bf1eb5aaff9242df9.jpg?s=120&d=mm&r=g)
I do not know how to do this from a cmd prompt. The usage says:
Usage: %(PROGRAM)s [options] hostname listname password
Do I do this from a cmd prompt. What would be the syntax for my site?
-----Original Message----- From: Mark Sapiro [mailto:mark@msapiro.net] Sent: Friday, April 30, 2010 11:44 AM To: Schwartz, Robert - IS; mailman-users@python.org Subject: Re: [Mailman-Users] get list of users
Schwartz, Robert - IS wrote:
How can you get a list of all user's and addresses exported to .csv or .xls from the web.
See the FAQ at <http://wiki.list.org/x/aYA9> which, among other things will point you to the script at <http://www.msapiro.net/mailman-subscribers.py> which runs on your workstation and can generate a .csv from the web admin interface.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
This e-mail and any files transmitted with it may be proprietary and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender. Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of ITT Corporation. The recipient should check this e-mail and any attachments for the presence of viruses. ITT accepts no liability for any damage caused by any virus transmitted by this e-mail.
![](https://secure.gravatar.com/avatar/56f108518d7ee2544412cc80978e3182.jpg?s=120&d=mm&r=g)
Schwartz, Robert - IS wrote:
You first need to download and install Python on your Windows XP box. The windows installer for Python 2.6.5 is at <http://www.python.org/ftp/python/2.6.5/python-2.6.5.msi>
Then, if your list's web admin interface were for example <http://www.example.com/mailman/admin/listname>, you would at a cmd prompt type
cd (the folder where you saved mailman-subscribers.py) python mailman-subscribers.py -c -o output-file.csv www.example.com listname password
The last line starting with python and ending with password is all one line, not wrapped as here. output-file.csv is the name of the file to receive the csv and password is the list's admin password.
You might also need to use the -u option if the admin interface URL is not of the above form.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
![](https://secure.gravatar.com/avatar/ad39ca4618d4c4ded568b0de5583b8e3.jpg?s=120&d=mm&r=g)
This did exactly what I needed. Thanks. If I want others to be able to do this, will they need to download http://www.python.org/ftp/python/2.6.5/python-2.6.5.msi?
-----Original Message----- From: mailman-users-bounces+rpschwar=knology.net@python.org [mailto:mailman-users-bounces+rpschwar=knology.net@python.org] On Behalf Of Mark Sapiro Sent: Friday, April 30, 2010 11:34 PM To: Schwartz, Robert - IS; mailman-users@python.org Subject: Re: [Mailman-Users] get list of users
Schwartz, Robert - IS wrote:
You first need to download and install Python on your Windows XP box. The windows installer for Python 2.6.5 is at <http://www.python.org/ftp/python/2.6.5/python-2.6.5.msi>
Then, if your list's web admin interface were for example <http://www.example.com/mailman/admin/listname>, you would at a cmd prompt type
cd (the folder where you saved mailman-subscribers.py) python mailman-subscribers.py -c -o output-file.csv www.example.com listname password
The last line starting with python and ending with password is all one line, not wrapped as here. output-file.csv is the name of the file to receive the csv and password is the list's admin password.
You might also need to use the -u option if the admin interface URL is not of the above form.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
Mailman-Users mailing list Mailman-Users@python.org http://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: http://mail.python.org/mailman/options/mailman-users/rpschwar%40knology.net
No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.801 / Virus Database: 271.1.1/2846 - Release Date: 04/30/10 13:27:00
participants (3)
-
Mark Sapiro
-
Robert P. Schwartz
-
Schwartz, Robert - IS