User Import

Student Learning & Licensure (SL&L) User Imports

Purpose: Institutional Administrators will create and manage accounts for all users. Account creation is required before SL&L Users can be placed in course sections. Administrators will use institutional ID and email accounts to establish accounts and will also designate the initial password for each account (SL&L will require a password change from each user on first login).

Accepted File Formats – The import supports the following file types:

*.csv UTF-8

All files must have the correct file extension.

User Import Fields

The User Import allows an administrator to create an SL&L account for an individual. This creates the ability for individuals to log in and also to tie an assessment to a specific user.

All fields must be in the header row of each upload. Optional fields may be left blank or removed from the spreadsheet. Fields can be uploaded in any order. Please note that completing the optional fields will enable the functional use of a correlated filter in your reports, allowing you to filter aggregated assessment results based on the populated criteria. Much of this information may be found in your human resources system, in the case of creating faculty/administrator accounts, or in your student information system, in the case of creating student accounts.

The sample file has the fields in the following order:

User ID

• Explanation: Student / Faculty Institutional ID, unique identifier
  Example: A43243
  Field Type and Length: Alphanumeric, 50
  Sample file column: A
  Import Status: Required
  Note: User ID is the unique identifier for the user and is the reference value used to update the rest of the user’s information. It is recommended that this is the same value that appears in Student Information System. For users not part of the institution, the administrator can assign an ID using a value relevant to the user, such as the first part of their email address. User ID cannot include special characters, such as the @ symbol.

Firstname

• Explanation: Account Owner’s First Name
  Example: Robert or Mary Jean
  Field Type and Length: Alphanumeric, 75
  Sample file column: B
  Import Status: Required

Middlename

• Explanation: Account Owner’s Middle Name
  Example: Robert or Mary Jean
  Field Type and Length: Alphanumeric, 75
  Sample file column: C
  Import Status: Optional

Lastname

• Explanation: Account Owner’s Last Name
  Example: Smith or Smith-Jones
  Field Type and Length: Alphanumeric, 75
  Sample file column: D
  Import Status: Required

Gender

• Explanation: Gender of Account Owner
  Example: male or female
  Field Type and Length: Alphanumeric, 20, lowercase only
  Sample file column: E
  Import Status: Optional

Email

• Explanation: Account Owner’s institutional Email address
  Example: rsmith@livetext.com
  Field Type and Length: Alphanumeric, 100
  Sample file column: F
  Import Status: Required

Role

• Explanation: Role status determines the user’s account type

  Accepted Values:

  • student
  • faculty
  • admin
  • external

  Field Type and Length: defined options
  Sample file column: G
  Import Status: Required
  Note: Role will determine the users’ privileges and user landing page when logging in to their SL&L account.
  Users with the student role can only be added to sections as a member.
  Users with the role of faculty can be added to sections as the instructor or be added to sections in the membership import. Deans, Department Chairs, faculty leaders or staff that need to see data or assist in setting up courses should be loaded as faculty. Their admin privilege can be given to them by the SL&L Administrators. This is initially done during training and can be updated as needed.
  Users with the admin role can import users, hierarchy, courses, sections and membership files. They will also be able to see all information in their College/School and assign out admin privileges to other users. Only the people administering SL&L should be given the role of admin.
  Users with the external role are used in SL&L's Field Experience. External users have limited access and cannot be added as the faculty of a course. They can be used in Internship sections as a member. These users do not work directly for the institution. These users are typically field supervisors, mentor teachers, etc.

Password

• Explanation: Account Owner’s Password
  Example: B45gl12cd
  Field Type and Length: Alphanumeric, 50
  Sample file column: H
  Import Status: Required
  Note: This will be the password users will use their first time they login through sll.watermarkinsights.com. After the initial login, users will be prompted to change their password. This field is required even if users will be using SSO or if they will be logging in through their LMS. Passwords cannot be updated via subsequent data imports.

Major

• Explanation: Program or Area of study
  Example: Secondary Education, Engineering, or Nursing
  Field Type and Length: Alphanumeric, 50
  Sample file column: I
  Import Status: Optional

Race/Ethnicity

• Explanation: Account Owner’s Ethnicity
  Example: Hispanic or Latino

  Accepted Values:

  • Hispanic or Latino
  • American Indian or Alaskan Native
  • Asian
  • Native Hawaiian or other Pacific Islander
  • White
  • Black or African American
  • Middle Eastern or North African
  • Two or more races
  • Non-Resident Alien
  • Not Specified / Declined to Specify

  Field Type and Length: defined options
  Sample file column: J
  Import Status: Optional

Race Details

• Explanation: Any string, intended to provide the ability to be more granular or specific about a user’s race or ethnicity
  Example: (free text)
  Field Type and Length: Alphanumeric, multiple entries (separated by commas)
  Sample file column: K
  Import Status: Optional

First Generation Student

• Explanation: Defines a user as a first generation student

  Accepted Values:

  • Yes = “Yes” or “Y” or “1”
  • No = “No” or “N” or “0”

  Field Type and Length: defined options
  Sample file column: N/A
  Import Status: Optional

Transfer Student

• Explanation: Defines a user as a transfer student

  Accepted Values:

  • Yes = “Yes” or “Y” or “1”
  • No = “No” or “N” or “0”

  Field Type and Length: defined options
  Sample file column: N/A
  Import Status: Optional

Pell Eligibility

• Explanation: Defines a user’s eligibility for Pell grants

  Accepted Values:

  • Yes = “Yes” or “Y” or “1”
  • No = “No” or “N” or “0”

  Field Type and Length: defined options
  Sample file column: N/A
  Import Status: Optional

Year of Admission

• Explanation: Defines a user’s first year of attendance
  Format: YYYY
  Field Type and Length: defined format, 4 digits
  Sample file column: N/A
  Import Status: Optional

Class

• Explanation: Year of study at the institution
  Example: Freshmen, Sophomore, 1st Year, Doctoral
  Field Type and Length: Alphanumeric, 50
  Sample file column: K
  Import Status: Optional

Academic Program

• Explanation: Academic Program, area of study
  Example: Elementary Education, Mathematics, Neuroscience
  Field Type and Length: Alphanumeric, 50
  Sample file column: L
  Import Status: Optional

LTI User ID

• Explanation: User ID for the person’s account in the LMS to accomplish SSO from an LTI External Tool Consumer
  Example: 9b2888eb71f24105879dc5cbfff107dd
  Field Type and Length: Alphanumeric, 50
  Sample file column: M
  Import Status: Recommended (Required if using LTI integration)

SSO UID

• Explanation: Alternate ID for the person in the institution’s central user database to accomplish SSO from some other portal or centralized authentication mechanism
  Example: 876651340
  Field Type and Length: Alphanumeric, 50
  Sample file column: N
  Import Status: Recommended (Required if using Single Sign-On)

SAT

• Explanation: SAT Score
  Example: 1600
  Field Type and Length: Numeric, 10
  Sample file column: O
  Import Status: Optional

ACT

• Explanation: ACT Score
  Example: 36
  Field Type and Length: Numeric, 10
  Sample file column: P
  Import Status: Optional

GRE

• Explanation: GRE Score
  Example: 140
  Field Type and Length: Numeric, 10
  Sample file column: Q
  Import Status: Optional

MCAT

• Explanation: MCAT Score
  Example: 528
  Field Type and Length: Numeric, 10
  Sample file column: R
  Import Status: Optional

GMAT

• Explanation: GMAT Score
  Example: 800
  Field Type and Length: Numeric, 10
  Sample file column: S
  Import Status: Optional

LSAT

• Explanation: LSAT Score
  Example: 180
  Field Type and Length: Numeric, 10
  Sample file column: T
  Import Status: Optional