ThinkCentral Template File Details

Column

Field Name

Roles

Required

Instruction

Max. Field Length

Valid Values

Sample Entries

A

Action

Teacher

Student

Class

Y

Specify whether the account is being added (A), updated (U), moved (M), or transferred (T) by entering A, U, M, or T.

Note:

●      The move (M) and transfer (T) options are only available to districts using the District Level Username Uniqueness feature. Special conditions apply for each value. See Move User Accounts for complete details.

●      Import Management tolerates and corrects some input errors as follows:

–      If you enter an A to add a user but that user record is already in the database, the import process will perform an update.

–      Likewise, if you enter a U to update but the user record does not exist, then HMH will perform an add for that user.  

1

A = Add

U = Update

M = Move

T = Transfer

A

B

Role

Teacher

Student

Class

Y

Enter the account's role type.

1

1 = Teacher

2 = Student

3 = Class

2

C

School PID

Teacher

Student

Class

Y

Enter the school PID, also known as the Market Data Retrieval (MDR) number, which is available in the MDR List.

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

D

User Name

Teacher

Student

Class

Y

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

For classes, enter the teacher's username.

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

Note:

●      Usernames for ThinkCentral must be district-level unique.

●      If your 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.

KOMalley_12

E

Password

Teacher

Student

Y

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 TC import files, passwords reset with each 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:
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.

●      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

F

First Name

Teacher

Student

Y

Enter the first name of the user.

32

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

*See Supported Symbols for complete list.

Kimberly

G

Middle Initial

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

H

Last Name

Teacher

Student

Y

Enter the last name of the user.

32

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

*See Supported Symbols for complete list.

O'Malley

I

Grade

Teacher

Student

Y

Enter the user's grade.

●      Students can be assigned to only one grade.

●      Teachers can be assigned to more than one grade.

Note:

●      Multiple values must be separated by a pipe ( | ).

●      To determine the range of grade levels of the students associated with a teacher, you may use the SQL sample code file provided here. (Click link to open SQL code file.)

●      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 (K–8) for the school.

●      If you change the grade level of an existing class, the products available to the class will include the products of the new grade level and the products of the previously assigned grade level(s). To limit the available products, return to ThinkCentral and manually deselect any unneeded products for the class.

2 characters between pipes ( | )

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

5|6

J

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

K

Gender

Student

N

Enter 1 for female, 2 for male, or 0 for unknown.

1

0 = Unknown

1 = Female

2 = Male

1

L

Ethnicity

Student

N

Enter 1–8 to indicate the student's ethnicity.

1

1 = Unknown

2 = Native American

3 = Asian

4 = African American

5 = Hispanic

6 = Native Hawaiian/Pacific Islander

7 = White

8 = Other

1

M

Special Services

Student

N

Enter 1–6 to indicate the student's special services.

Note: Multiple values must be separated by a pipe ( | ).

1 character between pipes ( | )

1 = IEP

2 = 504

3 = Gifted/Talented

4 = Migrant Education

5 = Title I

6 = Other

3

N

English Proficiency

Student

N

Enter 1–7 to indicate the student's English proficiency.

1

1 = Unknown

2 = English Fully/Only

3 = English Proficient

4 = English Student Level 1 - Beginning/Pre-production

5 = English Student Level 2 - Beginning/Production

6 = English Student Level 3 - Intermediate

7 = English Student Level 4 - Advanced

5

O

Special Conditions

Student

N

Enter 1–14 to indicate the student's special conditions.

Note: Only a single entry is accepted.

2

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

14 = None

10

P

Economic Status

Student

N

Enter 1–5 to indicate the student's economic status.

1

1 = Unknown

2 = No - NOT economically disadvantaged

3 = Eligible for free lunch program

4 = Eligible for reduced price lunch program

5 = Economically disadvantaged by other criteria

2

Q

Email

Teacher

Y

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 ThinkCentral platform is turned off, newly added teachers receive an automated email containing their log in usernames. See TC-Edit District Configuration Settings and Add Products for details.

75

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

jgrant@ccpsmail.com

R

Teacher

Student

Class

Y

Enter the status of the account.

1

A = Active

D = Inactive

A

S

Classroom name

Class

Y

Enter a name to identify the class.

TIP: For best results, we strongly recommend reviewing the Class Name Tips provided below this table.

Note:

●      Classroom name must be unique within teacher's list of classes.

●      If a teacher is moving from class to class, then enter the class name, followed by a PIPE ( | ), followed by the teacher's user name. (For example: Algebra 1_a|KOMalley_12) See Move User Accounts for complete details.

75

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

*See Supported Symbols for complete list.

Algebra 1_a

T

Class grade

Class

Y

Enter the grade associated with the class.

Note: Only one grade can be entered for each class; if class consists of multiple grades, enter the grade that best represents the class such as the median grade of the students in the class.

To help determine the most representative grade for a class, do the following:

1.    Obtain the course/class grade if available and accurate.

2.    Map the course code to a grade level, if applicable.

3.    Use the SQL sample code file provided here to find the median grade level of students in the class. (Click link to open SQL code file.)

2

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

5

U

Products

Class

N

Enter the 10 or 13 character ISBN product codes to identify the free play products associated with the class.

See Locate ISBN Codes for details.

Note:

●      Multiple ISBN product codes can be entered for each class local ID, but multiple codes must be separated by a pipe ( | ).

●      Must use the student-edition ISBN , not the teacher-edition ISBN.

●      Leading zeros must be preserved by preceding the number with an apostrophe ('). See Retain Leading Zeros for more details.

●      Leaving this field empty allows you to activate products using the ThinkCentral platform. See Activate Products for details.

●      Personal Math Trainer (PMT) products cannot be added via import; PMT products can only be activated on the TC Add Class or Edit Class pages. (See TC-Add Classes or TC-Edit Classes for details.)

13

characters between pipes ( | )

A–Z and 0–9 acceptable

9284618003976

V

Period

Class

N

Enter the period associated with the class.

25

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

*See Supported Symbols for complete list.

Mon-1.2

W

Description

Class

N

Enter a description of the class.

200

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

*See Supported Symbols for complete list.

An example ThinkCentral virtual classroom.

X

Add Students

Class

N

Enter a student roster for the class.

Note:

●      Multiple usernames can be entered but must be separated by a pipe ( | ).

●      A student roster is not required, but students must be added before they can access their materials.

●      When importing a class, use this field to enter the student usernames to add with the class.

●      To update an existing class, be sure to enter "U" in column A.

Max User Name Length = 75 (between pipes | ),

Max. Field Length = 4000

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

Note: Spaces are not allowed.

*See Supported Symbols for complete list.

Username1|Username2|Username3

Y

Remove Students

Class

N

Enter one or more students to remove from the class roster.

Note: Multiple usernames can be entered but must be separated by a pipe ( | ).

Max User Name Length = 75 (between pipes | ),

Max. Field Length = 4000

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

Note: Spaces are not allowed.

*See Supported Symbols for complete list.

Username1|Username2|Username3