Importing student data is a vital step in implementing Handshake. It's the most efficient way to ensure you're populating accurate student information. 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
While students have other identifying attributes that must be unique in Handshake, such as
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
- Anyone who uploads data into Handshake will need access to the Importer. If you don't have access, you must review the brief training course here.
- Once you have completed the training course, email your University Success Manager so they can add you to the tool!
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
Add a description to your 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.
Check out these links to learn more about the student data import - or reach out to our Support team
- FAQs About the Student Data File
- Importer Overview: Upload Data into Handshake
- Common Importer Errors
- How to Re-Upload Failed Rows
- CSV File Requirements and Formatting
- Troubleshooting: Leading 0's Missing from your Import (typically in the card_id field)
- Troubleshooting: Importer Date Formatting
- Importer Help Center