The users template file contains all the students and teachers who will be using Holt McDougal Online. You may populate and submit a single users file that includes both additions and updates of user accounts, or you may populate and submit multiple users files to separate your district's data into individual files.
An example of the users.csv template in Notepad is shown below.
An example of the users.csv template in Microsoft Excel® is shown below.
➔ Open a printable version of the Holt McDougal Online users File Details by clicking the link below.
Holt McDougal Online users File Details Dictionary (PDF 494 Kb)
Note: ● When populating the import template file, required fields must be populated. Fields that are not required may remain empty, but even empty fields must be retained using commas. Do not use a space for an empty field. ● HMH recommends that quoted identifiers be used around all headers and fields. ● If your data set includes special characters, you must save your file as a UTF-8 File. (See Encode Files as UTF-8 for details.) |
Details for each of the users template fields are provided in the table below. (Fields that appear in gray are optional.)
Column |
Field Name |
Roles |
Required |
Instruction |
Max. Field Length |
Valid Values |
Sample Entries |
A |
UserType |
Teacher Student |
Y |
Enter the role of the user being added or updated. |
1 |
T = Teacher S = Student |
T |
B |
Username |
Teacher Student |
Y |
Enter the user name 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: ● The username must be unique to the district, and if the user accesses 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.)
Warning: Once the username is submitted, it cannot be changed. |
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 |
C |
Password |
Teacher Student |
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: ● 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 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: – Manage Student Passwords: ○ 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. ● 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. ● Use passphrases instead of passwords. (Click for details.) |
MyNameIsJames |
|||||
D |
First |
Teacher Student |
Y |
Enter the first name of the user. |
50 |
A–Z, a–z, 0–9, spaces, and *symbols acceptable
*See Supported Symbols for complete list. |
John |
E |
Middle |
Teacher Student |
N |
Enter the middle initial of the user. |
1 |
A–Z, a–z, 0–9, spaces, and *symbols acceptable
*See Supported Symbols for complete list. |
A |
F |
Last |
Teacher Student |
Y |
Enter the last name of the user. |
50 |
A–Z, a–z, 0–9, spaces, and *symbols acceptable
*See Supported Symbols for complete list. |
Grant |
G |
Teacher |
Y |
For students, leave blank. |
100 |
A–Z, a–z, 0–9, apostrophes, hyphens, periods, underscores, and at sign (' - . _ @) acceptable |
|
|
For teachers, enter the teacher's email address.
Note: ● Recommended practice is to use official district or school email address. ● Unless the email notification setting in the Holt McDougal Online platform is turned off, newly added teachers receive an automated email containing their log in usernames. See HMO-District Settings for details. |
jgrant@ccpsmail.com |
||||||
H |
Student ID |
Student |
N |
Enter the student's unique ID.
Note: ● Leading zeros must be preserved. See Retain Leading Zeros for more details. ● If you operate as an independent school, do not have a SIS, or are a private/Catholic school, consider these recommendations. (Click for details.) |
15 |
A–Z, a–z, 0–9 |
Student00345 |
I |
Grade |
Student |
Y |
Enter the student's grade level.
Note: Students can only be assigned to a single grade. |
2 |
PK = Pre Kindergarten K = Kindergarten 1 = Grade 1 2 = Grade 2 3 = Grade 3 4 = Grade 4 5 = Grade 5 6 = Grade 6 7 = Grade 7 8 = Grade 8 9 = Grade 9 10 = Grade 10 11 = Grade 11 12 = Grade 12 |
3 |
J |
Gender |
Student |
N |
Enter 1 for female, 2 for male, or leave blank for unknown. |
1 |
1 = Female 2 = Male leave blank = Unknown |
1 |
K |
Ethnicity |
Student |
N |
Enter 0–7 to indicate the student's ethnicity.
Note: Multiple values must be separated by a pipe ( | ). |
1 character between pipes ( | ) |
0 = Unknown 1 = Native American 2 = Asian 3 = African American 4 = Hispanic 5 = Native Hawaiian/Pacific Islander 6 = White 7 = Other |
2|3|5 |
L |
Special Services |
Student |
N |
Enter 0-5 to indicate the student's special services.
Note: Multiple values must be separated by a pipe ( | ). |
1 character between pipes ( | ) |
0 = Unknown 1 = IEP 2 = 504 3 = Gifted/Talented 4 = Migrant Education 5 = Title I |
3|5 |
M |
English Proficiency |
Student |
N |
Enter 0-6 to indicate the student's English proficiency. |
1 |
0 = Unknown 1 = Fully/Only 2 = English Proficient 3 = English Student Level 1 - Beginning/Pre-production 4 = English Student Level 2 - Beginning/Production 5 = English Student Level 3 - Intermediate 6 = English Student Level 4 - Advanced |
2 |
N |
Special Conditions |
Student |
N |
Enter 0–13 to indicate the student's special conditions.
Note: Only a single entry is accepted. |
2 |
0 = None 1 = Autism 2 = Visual Impairment 3 = Deaf – Blindness 4 = Developmental Delay 5 = Hearing Impairment 6 = Orthopedic Impairment 7 = Multiple Disabilities 8 = Intellectual Disability 9 = Emotional Disturbance 10 = Speech and Language Disorders 11 = Specific Learning Disabilities 12 = Other Health Care Needs 13 = Traumatic Brain Injury |
0 |
O |
Economic Status |
Student |
N |
Enter 0–4 to indicate the student's economic status. |
1 |
0 = Unknown 1 = No - NOT economically disadvantaged 2 = Eligible for free lunch program 3 = Eligible for reduced price lunch program 4 = Economically disadvantaged by other criteria |
2 |
P |
School |
Teacher Student |
Y |
Enter the school PID, also known as the Market Data Retrieval (MDR) number, which is available on the VIEW MDR INFO page.
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, alternative options are available. (Click link to learn more.) |
9 |
0–9 |
12345678 |
Q |
Activate |
Teacher Student |
Y |
Enter the status of the user account (active or inactive). |
1 |
A = Active I = Inactive |
A |
R |
Update |
Teacher Student |
Y |
Specify the purpose of this row in the import file by doing the following: ● Enter a "Y" when updating an existing account. ● Leave the field blank when adding a new account. If you are moving a user account, see Move User Accounts for complete details. |
|
Y = Update to existing account leave blank = Adding a new account |
Y |
*Supported Symbols: !#$%&'()*+,-./:;<=>?@[]_` {|}~\¡¢£¤¥¦§¨©ª«¬-®¯°±²³´¶¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞàáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþ
If you plan to use these extended special characters, you must save the file as a UTF-8 file. (See Encode Files as UTF-8 for details.)
Additionally, HMH recommends that all fields and headers be placed in quoted identifiers.
v7.0