807116 - Request for email list of Vouched Mozillians

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[Winston Bowden]

Hi there - 

Can I get the list of all the e-mails within accounts that match the criteria below:

* is_vouched status to set to true (they're Vouched Mozillians)

I'd like to update our email database with new sign ups.  I'll replace our old list with the new list. 

Thanks-
Winston

Comment 1

[Sheeri Cabral [:sheeri]]

mysql> select first_name, last_name, email into outfile '/tmp/vouched.tab' from auth_user inner join profile on (auth_user.id=profile.user_id) where is_vouched=1;
Query OK, 2145 rows affected (0.02 sec)

I have a tab-delimited file with first name, last name and email (I can change it to *just* e-mail), but since I haven't yet worked with you on these types of matter, plus we have new data security/safety/privacy processes, please forgive me while I test out our process.

Because it deals with e-mail addresses, we need the approvals of:
Data Safety	Security	Privacy

I have made dependent bug 807479 to track this stuff, as per the draft document. I apologize for any delay the security assurance may cause.

Comment 2

[Joe Stevensen [:joe]]

(In reply to Winston Bowden from comment #0) 
> I'd like to update our email database with new sign ups.  I'll replace our
> old list with the new list. 

Can you tell me a little more about this list and why you need email addresses?

Comment 3

[Winston Bowden]

Hi Joe, 

This is a list of vouched Mozillian's that we send to on a weekly basis.  There isn't currently an integration between our email vendor and the phonebook so we have to update our list manually on regular intervals to add new Mozillians.

Comment 4

[Sheeri Cabral [:sheeri]]

Winston - I was told earlier today that the privacy committee will be meeting next week sometime, and thus approval (or denial) won't happen until then.

Will that be problematic, or can the data wait another week to be updated? In the future this process won't take so long, but this is one of the first requests since the new data protection policy is put into place and some parts of the process need more discussion.....

Comment 5

[Sheeri Cabral [:sheeri]]

(oof, never mind, this was addressed in the dependent bug!)

Comment 6

[Sheeri Cabral [:sheeri]]

Just ran the query in comment 1 again, there are 2285 values. I will send this as securely as possible.

Comment 7

[Sheeri Cabral [:sheeri]]

Resolving. The dependent bug remains open for the ongoing monthly recurring transfer of this information.