Webmaker/Events export

From MozillaWiki
Jump to: navigation, search

How to export a CSV event data file

Default method

  1. Visit https://events.webmaker.org/#!/events
  2. Log into an Admin account
  3. At the bottom of the page, click on the "Download Events CSV" button to save the file on your computer. Be patient! This might take a while since you're grabbing the entire database. :)

Alternate method (fastest)

(* Note: You must already be logged in and have admin access.)

Formatting the file

  • It's best to open the file with a tool like Excel, Open Office, or Google Docs Spreadsheet, rather than a text editor. If all of the fields show up in a single column, you can use the "Text to Columns" tool (in Excel) to make the data more manipulable.
  • You may need to add a ".csv" extension to the filename (eg: "events.csv" not "events"). Excel will be confused if that's missing and render very poorly.
  • Note: many of the date and location fields will be null. This has to do with how the data was entered by the user. Date fields with "null" are historical, and can most likely be removed, depending on your needs.

Admin account requests

If you wish to apply for an admin account, you can email Chris De Cairos or Jon Buckley with the email address of the webmaker account to give admin privileges to, and the reason why you are requesting an admin account.