|Get set up as an Event Administrator first!|
This article assumes you have already registered as an Event Administrator in the new calendar, and your Department or Group has been set up on calendar.mit.edu. If you have not done so, follow the instructions at MIT Events Calendar - Register a Student Group, Organization or DLC.
The new Events Calendar product at calendar.mit.edu has many more features to showcase and promote events than our legacy calendar. Posting to the new calendar requires event administrators to register themselves and their group or department on the new platform, and events were not automatically migrated.
If you only have a few events that you need to re-post on the new calendar, it is easier to just re-post them one by one, which will also give you a chance to update the enhanced categorization, photos, and other promotional links as needed. However, if you have a lot of future events posted in the legacy calendar, it may be more efficient to export them from the old calendar, and import them into the new calendar.
- Visit the legacy calendar search page by going directly to events.mit.edu/search.html
- Search for your events by Sponsor and Date Range
- Once you have your list of future events in the search results, use the link at the top of the search results titled "save search results as a tab-delimited file" to save your events as a tab-delimited text file
- We recommend always filtering your search results by Sponsor, so you do not accidentally export another group's events
- On some browsers, clicking on the "save search results as a tab-delimited file" will open the file in a browser window; you can instead Right-Click or Ctrl-Click on the link and choose "Save link as..." to save it to your computer as a file
Now that you have the export file, you need to wrangle it into a format that can be imported by the Localist platform that powers the new Events Calendar. These instructions are for users of Excel, but the process will be very similar for users of other spreadsheet software.
- Make sure you start from a blank Workbook or without an open Workbook
- Open the file in Excel using File > Open...
- Excel will open the Text Import Wizard
- Select Delimited on the first page
- Select Tab as the delimiter on the second page
- Leave columns set to General on the third page and click Finish
- The export will now appear in your Excel workbook and is ready for updating
The rest of this process is just using Excel to "fix" the spreadsheet to confirm to Localist's import guidelines. Here is a summary of the main things that need to be changed.
Note that the export from events.mit.edu does not include column headings at the top of columns, so the above list comes in handy as a reference.
The import file accepted by calendar.mit.edu and the Localist platform if fairly flexible, and allows column headings. The above table is just for reference. You can download a template spreadsheet of the import file, Bulk Add Events.csv, if you like and don't need to manually enter the above columns.
The important steps in reformatting the file are:
- Title the columns you want to keep appropriately
- Combine multiple fields into the Description column if you need to (for example, the speaker information and URL which are in separate fields)
- Split the Bldg-Room column into separate Location and Room columns
- Localist Places (Locations) for MIT buildings are of the form "Building N", not just "N", so you will need to reformat the Location column to include the "Building " part in front of the building number
- The Department or Group column needs to include your Department or Group name, as it appears in calendar.mit.edu
- Remove any unused columns
- Double check your file to make sure there isn't any extraneous data in it, such as numbers in URL fields, which might lead to unpredicatable results
- Save the file as a CSV or XLS/XLSX spreadsheet file; Localist can handle Excel files directly
- Send your file to the Events Calendar admin team at firstname.lastname@example.org for upload