Webmaker/Events export: Difference between revisions
< Webmaker
Jump to navigation
Jump to search
| Line 13: | Line 13: | ||
==Formatting the file== | ==Formatting the file== | ||
* It's best to open the file with a tool like Excel or Google | * It's best to open the file with a tool like Excel, [https://www.openoffice.org/download/index.html 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. Firefox doesn't add this extension by default. | * 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. Firefox doesn't add this extension by default. | ||
* 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. | * 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. | ||
Revision as of 19:07, 16 July 2014
How to export a CSV event data file
Default method
- Visit https://events.webmaker.org/#!/events
- Log into an Admin account
- At the bottom of the page, click on the "Events CSV" button and save the file on your computer.
Alternate method (fastest)
- Open this link: https://events-api.webmaker.org/events?csv=1 and save the file!
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. Firefox doesn't add this extension by default.
- 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.