4 replies to this topic

[Clay]

I'm going into one of my mailing lists through the CPanel interface...  What I want to do is to export a list of all of the members of the list.  According to the mailman administrator documentation (http://list.org/site.html), this can be done through the command line, but I don't have command line access and even if I did, I don't know how to do that.  

Does anybody know how I can export a list of all of the subscribers of one of my lists?

Thanks,
Clay

[NyteOwl]

If you submit a ticket ASO will enable SSH access for you then you just type mailman/bin/list_members at the prompt after you log in.

cPanel often customizes mailman. so you might check their web site too.

[Heather Balczarek]

Hi, NyteOwl! Remember this post?

NyteOwl, on 08 July 2006 - 04:16 PM, said:

...just type mailman/bin/list_members at the prompt after you log in.

This is not working on my account (even a find from the root of the jailshell does not turn up list_members or any mailman/bin directories).

In the interest of keeping this forum useful (and helping me   ) do you know if there's another way to export the list via the shell?

Thanks!

[NyteOwl]

Sorry it didn't work. I haven't had occasion to use mailman through cPanel for a while so they may have changed things around; as I said cPanel often customizes the installs of software managed through their interface. The paths even change between versions so if that path isn't found you might have better luck either submitting a ticket or having a go on the cPanel forums.

[David Citron]

The best we could come up with is using wget (available in your SSH account and also as a part of Cygwin) and parsing the output. Yeah, I know--it's hard-core  

If you configure the members list so that all members show on one page (i.e. disable pagination by setting the members per page value very high), then you can use something like:

wget -O - --post-data 'adminpw=${your_admin_password}' http://${your_server}.asmallorange.com/mailman/admin/${your_mailing_list_name}/members | egrep "_realname" | sed 's/^.*value="\([^"]*\)".*value="\([^"]*\)".*$/\1,\2/' | sed 's/%40/@/' > mailing_list.csv

Be aware that this will send your admin password in clear text. As such, you may want to run this directly on the server (ssh access) or, alternately, look into wget/ssl.