Submitting an event job through the Importer is the fastest way to upload your Career Center's historical events into Handshake. This article will help you understand the event information that can be uploaded into Handshake, and how the data must be formatted.
To start uploading your events, download the sample file. This file is also attached at the end of the article. It includes the proper formatting and all of the different fields you can use.
Each field has its own column — make sure each header matches exactly! If any of the headers don't have the exact formatting that's listed below, all of the information in that field will not be uploaded. We recommend copying and pasting from the example file into a blank excel sheet to ensure the formatting of your headers is correct.
Available fields for importing a Historical Events file
Download an example Historical Events CSV file
The fields listed below should be formatted as shown and saved as a CSV. Column headers are case sensitive and should be in all lowercase. If any of your headers differ from the formatting included below, the Importer will not identify it and it will be skipped. We recommend reviewing the example file linked above to ensure correct header formatting.
Required Fields: The column headers marked as required are necessary in the file. The column values marked as 'can't be blank' must contain values. Column values that aren't required can be left blank - this will not erase any existing data in that field.
Optional Fields: You can leave out any headers or values that are not marked as required - this will not erase any existing data in that field.
Column header | Column value |
---|---|
student_registration_start |
The date/time that student registration begins. The required formatting for all dates is yyyy-mm-ddThh:mm:ss (example: 2016-11-01T12:00:00). If you're having problems formatting any of the required dates/times, you can use this date formatting guide as a reference. If you're still having trouble, feel free to reach out to our Support team by submitting a ticket here. |
student_registration_end |
The date/time that students must complete their registration by. The required formatting for all dates is yyyy-mm-ddThh:mm:ss (example: 2016-11-01T12:00:00). |
name |
The name of the event (free text is accepted in this field). |
start_date |
When the event starts. The required formatting for all dates is yyyy-mm-ddThh:mm:ss (example: 2016-11-01T12:00:00). |
end_date |
When the event ends. The required formatting for all dates is yyyy-mm-ddThh:mm:ss (example: 2016-11-01T12:00:00). |
event_type_name |
The type of event. Must be one of the following (case-sensitive): Classroom PresentationImportant: if the event was a Virtual Session, you must also include virtual_link |
virtual_link |
If the event_type = Virtual Session. The value for virtual link must be only a single URL.
|
import_identifier |
The unique identifier for each event. This identifier will be used if you import notes or labels attached to this event in the future. The import_identifier can be anything and must be totally unique. We recommend an identifier such as: |
career_center_id |
The Handshake ID of the Career Center hosting the event. The ID can be found in your School settings > Career Centers. |
status |
The status of the event. Must be one of the following (case-sensitive): pending |
description |
A description of the event (free text is accepted in this field). |
invite_only |
Was it invite only? Must be one of the following: Yes |
attendee_limit |
Limit for the number of attendees (must be a number). |
Example file:
How to Upload the Events File
- Once your file is prepared, select File > Save As > UTF-8 encoded CSV from Excel (or your preferred CSV file management tool).
- Use the Importer tool to upload/edit your institution's historical events.
Note: You'll need to set Job Type = Events