Importing Historical Events

Liz Gehret -

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 past events, download the sample file linked in this article - this includes all of the different fields that you can use. You'll notice that each field has its own column - make sure that each header matches exactly! If any of your headers don't have the exact formatting that is listed below, all of the information in that field will not be uploaded. We recommend that you copy and paste from the example file into a blank excel sheet to ensure the formatting of your headers is correct.

Required Fields

 

Every event file you upload must have these six fields:

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 Presentation

Employer On-site

Group Appointment

Info Session

Mock Interview

Networking

Speaker/Panel

Virtual Session

Workshop

Other

Recommended Fields:

These fields are recommended, but not necessary. You can choose which ones to include, and the list below will give you some information about each one.

status: What is the status of the event? Must be one of the following (case-sensitive):

pending

in_progress

approved

declined

description: A description of the event (free text is accepted in this field).

import_identifier: This is a 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 but it must be totally unique. We recommend an identifier such as: schoolhistoricalevent100, schoolhistoricalevent101, schoolhistoricalevent102, schoolhistoricalevent103.

invite_only: Was this event invite only? Must be Yes or No

attendee_limit: A limit for the number of attendees (must be a number).

Example file:

 

How to Upload your Events File:

  1. Once your file is prepared, select File > Save As > UTF-8 encoded CSV from Excel (or your preferred CSV file management tool).  
  2. Use the Importer tool to upload/edit your institution's historical events.
    • You will need to select Job Type = Events
Was this article helpful?
1 out of 2 found this helpful
Have more questions? Submit a request