You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Digital Products > SkillGauge - Internal > Implementation > Qualtrics360 > Creating a roster file for SkillGauge - Qualtrics360
Creating a roster file for SkillGauge - Qualtrics360
print icon
INTERNAL USE ONLY

Preparing Your Subjects File

GETTING A TEMPLATE FILE

  1. Go to the Participants section of the Participants tab.
    Selecting the Import Subjects option from the Add Subjects dropdown menu
  2. Make sure you are in the Subjects subsection.
  3. Click Add Subjects.
  4. Select Import Subjects.
  5. Click Example CSV to download a template file.
    Selecting the Example CSV option in the Import Subjects pop up window

PREPARING THE FILE

Example of a file with proper headers

  • Keep your header row! The only thing you should change in the header are Metadata 1 and Metadata 2. Instead of these headers, feel free to add any metadata you want, such as Office, Location, Department, and more.
  • Every row is a separate subject.
  • Every subject needs a first name, last name, email, and a unique identifier (such as an employee ID). The email will later serve as their login ID.
  • When you save the file, keep it as a CSV or TSV.
  • Add as many rows of subjects as you need. Your max file size is 100M

Attention: If this file has a UniqueIdentifier column, please see the Unique Identifiers page for additional instructions.

Qtip: If your license has SSO, make sure you upload your participants to the directory with their usernames before you upload participants! Once someone’s in the directory, you can upload them directly into the project without including the UserName column.

 

Preparing Your Evaluators File

Warning: Do not complete this section until you’ve uploaded your subjects!

Qtip: If your license has SSO, make sure you upload your participants to the directory with their usernames before you upload participants! Once someone’s in the directory, you can upload them directly into the project without including the UserName column.

GETTING A TEMPLATE FILE

  1. Go to the Participants section of the Participants tab.
    Selecting the Import Evaluators option from the Add Evaluators dropdown menu
  2. Make sure you are in the Evaluators subsection.
  3. Click Add Evaluators.
  4. Select Import Evaluators.
  5. Click Example CSV to download a template file.
    Selecting the Example CSV option from the Import Evaluators pop up window

PREPARING THE FILE

Example evaluator file with proper headers

  • Keep your header row! The only thing you should change are Metadata 1 and Metadata 2. Instead of these headers, feel free to add any metadata you want, such as Office, Location, Department, and more.
  • Every row is a separate subject-evaluator relationship. For example, let’s say you want to add 2 evaluators for Jane Smith and 3 evaluators for John Doe. Even if some of these evaluators are the same people, you will fill out 5 new rows.
  • The FirstName and LastName columns are for the evaluator. These columns should reference the same person whose email is in the Evaluator Email column and whose unique identifier is in the EvaluatorUniqueIdentifier column.
  • The SubjectUniqueIdentifier column should match each UniqueIdentifier you designated when you prepared the subject file.
  • The Relationship column refers to the relationship of the evaluator to the subject. For example, if John Doe is Jane Smith’s manager, and John Doe is the evaluator, the Relationship should say Manager. If Jane Smith is evaluating John Doe, the Relationship should say DirectReport.
  • The metadata columns are for the evaluator. Try to keep rows where the evaluator recurs consistent.
  • When you save the file, keep it as a CSV or TSV.
  • Add as many rows of relationships as you need. Your max file size is 100M.
Feedback
0 out of 0 found this helpful

scroll to top icon