1082631 - Export contribute mailing list emails for April 2013

Status: RESOLVED FIXED

(Community Building :: Systems and Data, task)

Description

[Pierros Papadeas [:pierros]]

We need an export of all /contribute signups (emails and area of interest) for the month of April 2013.

The info lives inside https://mail.mozilla.org/private/contribute/
Export is done in a gzip and we need to parse it to export it.

Comment 1

[Pierros Papadeas [:pierros]]

Sample data (2 emails in total) can be found here: https://etherpad.mozilla.org/contribute-mails-sample

Comment 2

[Pierros Papadeas [:pierros]]

Export should be in CSV (or JSON) format that contains:
- Sender email (with 'at' properly replaced with @)
- Timestamp in 2014-08-10 12:00 format
- Area of interest

Comment 3

[Sebastian Hengst [:aryx] (needinfo me if it's about an intermittent or backout)]

Attachment: get-involved-conversion-bug1082631-v1.py

v1 of the script. Uses Python 3. Please tell me if you can use it like that or if you need modifications.

Comment 4

[Pierros Papadeas [:pierros]]

Attachment: parse-v2.py

Hey aryx!

Thanks for the script. I tweaked a little bit for csv export and some errors given our data (not your fault!).

Comment 5

[Pierros Papadeas [:pierros]]

Email list is now produced and cleaned up. 11407 emails (!)