Importing student data is a vital step in implementing Handshake. It's the most efficient way to ensure that accurate student information is populated under your Handshake instance. This in turn empowers filtering, outreach, and analytics for Career Services and populates necessary student job qualifications.
Step 1: Review the CSV File Format
Handshake accepts comma separated value files for upload. Review the expected format here:
Step 2: Make Key Decisions
Chose the Right Attribute for your Student's "username"
A student's primary unique identifier is their username
While students have other identifying attributes that must be unique in Handshake, such as email_address
or card_id
, the username
is expected to never change, to never be recycled, to always belong to that user.
Choosing this identifier carefully will help ensure that the utmost quality data is maintained, and it prevents assigning a new student to an account that already exists, violating a student's privacy.
Decide the username before your initial student upload.
Choose the Right Attribute for your Student's "auth_identifier"
auth_identifier
is the value on the student record that ties your SSO integration to the uploaded student record. This value should be the same as the sso identifier
you put into Handshake.
Choose the Right Attribute for your Student's "card_id"
card_id
is only needed if you plan to use the Handshake Checkin Kiosk / Card Swipe. If you do not use this, there is no need to include.
If you are using the kiosk, the card_id
is the value that Handshake uses to tie the student's card back to their student record when they swipe their card to check in for events, fairs, or appointments. This value must be unique and not change per student. Please ensure that you are only sending us the unique portion of the card. The value must be contained within the output of the card swipe.
Step 3: Review the Importer Training Module for Access
Step 4: Extract and Transform your SIS Data to CSV
- Download the Student CSV Example to ensure the headers match exactly.
- Extract and transform your student registrar data from your Student Information System to meet the CSV specs.
Step 5: Upload your File to the Importer
-
Login to the Importer
-
Set the Importer job type to Students
-
Add a description to your job
-
Click
Save Job
For common problems with the upload see here
Step 6: Review and Iterate on your Feedback
The Importer should give you detailed automated feedback on the formatting of your file. It can take a few uploads to perfect the formatting, so if you're seeing warnings or errors, there are a few things to check:
- File Type: Ensure you have a valid file type
- Headers: Confirm all headers & fields match the exact formatting requirements (The Importer will notify you if it finds data that we don't map).
- Missing Fields: Determine if values in your file are not registering. If they don't register, they will fail to import.
- Gut Check: Conduct a quick gut check on the data you are importing:
- How many students are you bringing in? How many are you archiving? etc
- Are you planning to create new accounts or update existing accounts?
- What new majors, minors, colleges, and/or campuses were found? Should this create new ones or could these be duplicates/typos?
You can expect to see feedback like this:
Step 7: Submit file for Import
- When your file is ready to import, click "Submit and Request Run'
- Our support team will be notified to open a request with you to get your data reviewed and imported.
More Questions?
Check out these links to learn more about the student data import - or reach out to our Support team