[Mailman-Developers] Exporting member info (including options)
aaron at campusactivism.org
Mon Aug 16 23:04:28 CEST 2010
I'm figuring out where to get the information from the config.pck
(pickle file) for each list to populate the MySQL table.
It seems like the MySQL format is extracting some of its fields from the
user_options fields, is this true?
If this is true, it is confusing because several of the user_options are
listed in their own field AND in the user_options field.
***MySQL field -- Pickle Source***
address -- members object
hide -- useroptions (16)
nomail -- useroptions (128) - am I right about this?
ack -- useroptions (4)
not_metoo -- useroptions (2)
digest -- digest_members object
plain -- useroptions (8)
password -- password object
lang -- language object
name -- usernames object
one_last_digest -- one_last_digest object. I guess the email would be
listed here if I had any people using this setting.
user_options -- user_options
delivery_status -- This seems to be a combination of user_options
settings "1" and "2", am I right?
topics_userinterest -- there is a topics_userinterest object which I'm
delivery_status_timestamp - I don't see this listed in config.pck.
Where is this? I guess I'm not too worried about it as it seems like a
temporary thing to do with bounces.
I'm skipping the following fields which store information about bounces
as I'm fine with losing my bounce data.
BTW, I exported the pickle into JSON so I could use it in PHP.
Used a python script from:
import sys, optparse, cPickle, os
import simplejson as json
# Setup the arguments this script can accept from the command line
parser = optparse.OptionParser()
to the file containing pickled data.")
to where the json data should be saved.")
# Load in the pickled data from either a file or the standard input stream
unpickled_data = cPickle.loads(open(opts.pickled_data_path).read())
unpickled_data = cPickle.loads(sys.stdin.read())
# Output the json version of the data either to another file or to the
More information about the Mailman-Developers