Confirmed users
27
edits
Webmaker/Events export: Difference between revisions
Jump to navigation
Jump to search
→Formatting the file
| 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. | ||