User Import

Student Learning & Licensure (SL&L) User Imports

Purpose: Institutional Administrators will create and manage accounts for all users.  Accounts 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 a SL&L account for an individual. This creates the ability for individuals to log in. This also creates the ability 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 use 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 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
               ⦁ 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
 
Video

Was this article helpful?
1 out of 2 found this helpful

Articles in this section

How to Contact Support
Click the "Submit A Request" button at the top right or bottom of the screen to create a case.
Watermark Academy
Click to access the Watermark Academy for free webinars, workshops, certifications, and free on-demand training