Column

Field Name

Required

Instruction

Max. Field Length

Valid Values

Sample Entries

A

SCHOOLYEAR

Strongly Recommended

Enter the year (YYYY) that the school year ends.

For example, if the school year starts on 8/20/2018 and ends on 5/30/2019, then enter 2019.

Note: HMH recommends that this field be populated with the last 4 digits of the school year end date; this ensures that future features can be applied to the appropriate school year, especially when a school year rollover is in place.

(For future use as more features become available)

4

0–9

2019

B

ROLE

Y

Enter the role of the user.

1

T (or t) = Teacher

S (or s) = Student

T

C

LASID

Y

Enter the user's unique Locally Assigned Staff/Student Identifier (LASID) number. This ID is assigned by the district or school from the Student Information System; the ID entered when the user is created is permanently assigned to the user record.

Note:

●      It is critical that this ID be unique across all users and all locations within your district.

●      Uppercase, lowercase, and all UTF8 versions of a character are considered the same; for example, "e" is treated the same as "E" and treated the same as any UTF-version over the letter "e" including, ë, è, é, and ê (upper and lower case):
"TèyE_123e" is considered a match with "TEYE_123E"

●      Once entered, the LASID cannot be changed.

●      HMH does NOT recommend the use of special characters or LASIDs that use last names because last names can change for many reasons (custody, marriage, divorce), which can lead to the removal of old accounts and creation of new accounts. IDs should be numeric and come from your student information system.

●      If there is a chance that staff and student LASIDs overlap within your organization, you may want to add a prefix such as "STF" to the staff LASID.

●      If you operate as an independent school, do not have a SIS, or are a private/Catholic school, consider these recommendations. (Click for details.)

75

A–Z, a–z, 0–9, spaces, and *symbols acceptable

*See Supported Symbols for complete list.

STF_1234567

D

SASID

N

Enter the user's unique Secondary Assigned Student/Staff Identifier (SASID) number.

Note: Typically this only pertains to students.

75

A–Z, a–z, 0–9, spaces, and *symbols acceptable

*See Supported Symbols for complete list.

A_1234567

E

FIRSTNAME

Y

Enter the first name of the user.

255

**See details regarding truncated values.

A–Z, a–z, 0–9, spaces, and *symbols acceptable

*See Supported Symbols for complete list.

John

F

MIDDLENAME

N

Enter the middle initial of the user.

255

**See details regarding truncated values.

A–Z, a–z, 0–9, spaces, and *symbols acceptable

*See Supported Symbols for complete list.

A

G

LASTNAME

Y

Enter the last name of the user.

255

**See details regarding truncated values.

A–Z, a–z, 0–9, spaces, and *symbols acceptable

*See Supported Symbols for complete list.

Grant

H

GRADE

Y

Enter the grade associated with the user.

●      Students can be assigned to only a single grade.

●      Teachers can be assigned to a single grade or a grade range, such as 6–8.

–      Do not use Excel to open a USERS.csv file containing grade ranges. Excel converts numeric grade ranges to dates. For example, a grade range entry of "1–8" gets converted to "8-Jan".

–      Teachers often need access to grade-level material above or below the grade level(s) that they teach; it may be easier to assign your teachers additional grade levels or even the full range of grade levels for the school (such as (PK–12).

5

PK, K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, or 12

Teachers only: hyphens (–) acceptable (used for ranges, such as 6-8)

3

I

USERNAME

Y

Enter the username each user must enter to sign into the application.

For single sign on (SSO) users, see the list of SSO considerations. (Click link to learn more.)

Note:

●      It is critical that this username be unique across all users and all locations within your district.

●      If your users access HMH Player®, the username must be globally unique.

●      If you operate as an independent school, do not have a SIS, or are a private/Catholic school, consider these recommendations. (Click for details.)

●      Ed allows for username changes.

Warning: Unlike Ed, TC and HMO accounts do not allow for username changes.

–      If a username is changed for a TC or an HMO user account, a new account is created and the old account goes inactive.

–      If a username is changed for an Ed user account, the username for that account is changed.

–      See Data Impact of Changing Usernames for more details.

5–75

A–Z, a–z, 0–9, and *symbols acceptable

Note: Spaces are not allowed.

*See Supported Symbols for complete list.

John.Doe@DistrictA.ca.usd

J

PASSWORD

N

Enter the password each user must use to sign into the application.

For single sign on (SSO) users:

●      Leave the password field blank (NULL).

●      Before proceeding, see the list of SSO considerations. (Click link to learn more.)

For district-controlled passwords:

●      Before rostering, turn off email notification setting for users. (Click link for details.)

●      Set this field to a value of your choice.

●      Provide classroom teachers with their credentials and the credentials of their students.

●      Provide instructions for classroom teachers to follow if they forget or misplace the login credentials.

●      Warn users that even if they change a password in the UI, the password may be changed back on next import.
For SFF import files, passwords reset back if that user account has any changes. Example (Click to view.)

For districts allowing users to control their own passwords:

●      Leave the password field blank (NULL). For the first upload, this creates a random password; for subsequent uploads, this retains the existing password.

●      Provide your teachers with the following instructions:

–      Manage Teacher Passwords:
If the password was set to null, it is not accessible. Upon first login, teachers must click Reset Password. Teachers receive an email with reset instructions, allowing them to change their passwords. Be sure to allow emails from *.hmhco.com.

–      Manage Student Passwords:
Teachers can do one of the following:

○      Change the students’ passwords themselves and provide the passwords to the students.

○      Set temporary passwords for students and provide students with the temp passwords. After successful login with temp passwords, students are prompted to create their own passwords.

Min. Field Length =

8

Teachers and Administrators:

A–Z, a–z, 0–9, and *symbols acceptable

Note: Spaces are not allowed.

*See Supported Symbols for complete list.

Case sensitive

Must contain at least one of each:

●      uppercase character (A–Z)

●      lowercase character (a–z)

●      number (0–9)

●      special character (! @ # $ % ^ & ( ) _ - + = { } [ ] | \ : ; " ' / ? < > , .)

For improved security, HMH strongly recommends the following:

●      Do not match USERNAME.

●      Avoid the same password for all users.

●      Use passphrases instead of passwords. (Click for details.)

IloveTheGreenBayPackers1991!

Min. Field Length =

5

Students:

A–Z, a–z, 0–9, and *symbols acceptable

Note: Spaces are not allowed.

*See Supported Symbols for complete list.

Case sensitive

For improved security, HMH strongly recommends the following:

●      Do not match USERNAME.

●      Avoid the same password for all users.

●      Use passphrases instead of passwords. (Click for details.)

MyNameIsJames

K

ORGANIZATIONTYPEID

Y

Enter the letters "MDR".

3

Currently "MDR" is the only ORGANIZATIONTYPEID accepted.

MDR

L

ORGANIZATIONID

Y

Enter your Market Data Retrieval (MDR) number, also known as the school PID.

See Locate MDR PIDs for more details.

Note:

●      PIDs are not the same as SIS Local Building IDs.

●      If a user is associated with multiple schools, see Multi-Org Account Linking for SFF.

8

0–9

123456

M

PRIMARYEMAIL

Student: N

For students, leave blank.

100

A–Z, a–z, 0–9, apostrophes, hyphens, periods, underscores, and at sign (' - . _ @) acceptable

Teacher: Y

For teachers, enter the teacher's email address.

Note: Recommended practice is to use official district or school email address.

jgrant@ccpsmail.com

N

HMHAPPLICATIONS

Strongly Recommended

Enter the code indicating the HMH product(s) available to the teacher, as follows:

Note:

●      ORDER MATTERS: The code must be entered in the order shown in the table above.

●      Abbreviation Table: You can still use MYHRW as well as other codes. (Click for details.)

●      Plan to provide new users with their login credentials: Depending on the platform and how you want users to log in, you must make a plan to provide your new users with instructions on how to log in. (Click for details.)

11

TC = ThinkCentral only

HMO = Holt McDougal Online only

ED = Ed only

TC.HMO = both ThinkCentral and Holt McDougal Online

TC.ED = both ThinkCentral and Ed

HMO.ED = Holt McDougal Online and Ed

TC.HMO.ED = ThinkCentral and Holt McDougal Online and Ed

***Blank (NULL) field = ThinkCentral and Holt McDougal Online and Ed

***Only leave blank if you plan to use all three platforms.

TC.HMO.ED