User Import Format

Import files must follow a specific format:

  • The file must be a text file with an extension of .txt or .csv.
  • The first line of the import file must be a header row containing all the fields you want to import. Fields must also be in the correct order (the same order as the import data explained below). Commas separate each field name.
  • Each user record in the import file must include a value for each field specified in the header row. Commas separate each field and a carriage return separates each user record.
  • The field value for each user record must meet the following specifications:
Field Description
Username (Email) Email address used for the SAM/Cengage account.
  • 6 to 50 characters.
  • Can't be changed.
  • You can specify a different email address to receive communications.
Password
Passwords requirements:
  • 6-17 characters
  • Letters, numbers, and underscores only
  • At least one capital letter
  • At least one number

New users are asked to change this password the first time they sign in to SAM.

First Name Maximum 50 characters.
Middle Initial Optional, maximum 1 character.
Last Name Maximum 50 characters.
ID# Student ID. Optional, maximum 20 characters.
Alias

For privacy, instructors can post exam results using students' aliases instead of real names.

Optional, 6 to 20 characters.

Blackboard ID Optional.
Communication Email Optional. Enter an email address if you want communications sent somewhere other than your username.
  • Maximum 128 characters.
  • If blank, emails are sent to your username.
Note The following characters are not allowed in Name, Username, ID#, or Alias:
~ ` ^ * " $ % # ! \ / > < & ; : | ,