574213 - Need a copy of summit attendees database

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Alex Buchanan [:abuchanan]]

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

Comment 1

[Mike Beltzner [:beltzner, not reading bugmail]]

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

Comment 2

[Reed Loden [:reed]]

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.

Comment 3

[Michael Morgan [:morgamic]]

I'll give it to Alex.

Comment 4

[Reed Loden [:reed]]

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?

Comment 5

[Mike Beltzner [:beltzner, not reading bugmail]]

I don't think that needs to be a concern - people can login and change their name if they want to.