OpiumTrail Posted January 7, 2003 Posted January 7, 2003 A quick question regarding the Mailman mailing list management software: Where is all the data stored? If all else fails, I guess I can download the source code for it and figure it out the hard way, but can anybody answer this question straightaway? Thanks, Richard. Quote
rayners Posted January 7, 2003 Posted January 7, 2003 Well, as best I can tell from looking at a local installation I tinkered with many moons ago, the data for each list is stored in db files in a directory under the Mailman installation (e.g. /usr/local/mailman/lists/ on my FreeBSD box at home). Is there any data in particular you want access to? Quote
OpiumTrail Posted January 7, 2003 Author Posted January 7, 2003 Mainly, I would like to be able to perform queries on the member list. The mailing list I'm creating involves a great deal of synchronization between the on-line list and e-mail addresses collected by hand at gigs etc. (this is a mailing list for a rock band, by the way). The manager of the band would like to be able to query the list of members and I would, at the very least, like to be able to export all the members to a text file to allow it to be imported en masse into a spreadsheet or word processor. Thanks, Richard. Quote
rayners Posted January 7, 2003 Posted January 7, 2003 Well, one way you could go about exporting the list of list members would be to just go to the web admin interface for the list, hop over to Membership Management, and just copy-n-paste right out of the Membership List table. And theoretically, you should be able to copy just the cells in the address column and paste them whereever you'd like (I just did it in Phoenix, but I haven't tried any other browsers). Quote
rayners Posted January 7, 2003 Posted January 7, 2003 Oh, and the listinfo web interface for the list can also be configured to report the list of member emails (spam protected or not). Quote
OpiumTrail Posted January 7, 2003 Author Posted January 7, 2003 Thanks. That's exactly what I've been doing. I was wondering if there was some way to automate it or get direct access to the raw data... if only I could view those pesky .db files! Richard. Quote
rayners Posted January 7, 2003 Posted January 7, 2003 I imagine you'd probably run into some problems trying to access the db files directly (permissions and such). I suppose you could write a little script to grab the web page with all the email on it, and then reformat it however you'd like. Should be relatively easy with regular expressions. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.