Student Sync: Uploading Your First Student File

John Dill
- August 09, 2019 06:48

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.

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

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, contact support here so we can add you to the tool!

Step 5: Upload your File to the Importer

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