Need a copy of summit attendees database

RESOLVED FIXED

Status

mozilla.org Graveyard
Server Operations
RESOLVED FIXED
8 years ago
3 years ago

People

(Reporter: abuchanan, Unassigned)

Tracking

Details

(Reporter)

Description

8 years ago
For bug 574200, I need a copy of the summit attendees database.  I looked on the backup-drop, but couldn't find it.

You could drop it on khan:/home/abuchanan/

Thanks
You actually don't need the full DB, you just need the following fields for any row where coming=1

 - firstname
 - lastname
 - pref_email
 - city
 - country
 - ircnick
beltzner, you can hook alex up yourself...

Login to the rsvp admin interface. Click "View as CSV" in the bottom left. Take that CSV and put it into Numbers or Excel. Sort by "coming". Remove rows from people not coming. Remove unnecessary columns. Export back out as csv.
I'll give it to Alex.
Status: NEW → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED
Do note that the `reservations` database includes legal names for people rather than what they might actually be called (due to flight tickets)... Some people may not appreciate their legal name showing up on some database somewhere, so keep that in mind. Maybe allow people to opt-out, similar to that of the summit buddy opt-out?
I don't think that needs to be a concern - people can login and change their name if they want to.
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.