Imagine Math

Imagine Learning file specifications

Populating Imagine Math templates

There are four Imagine Math templates: organization, class, user, and student. Each of the templates must include the record type in the filename. You must use the CSV file type.

To populate Imagine Math templates

  1. Click the link to download a .zip file containing the Imagine Math templates.
  2. Populate each template with organization, class, user, and student data.
 

 

Leading zeros from record numbers, usernames, and passwords may be dropped during the import when you use Excel files. You can avoid this problem by formatting the columns for text in Excel before you enter or import data.

 

Field information for Imagine Math templates

The following tables list descriptions of required and optional fields in each template, as well as directives you can use to customize the import. Columns are defined by name, not by position. Column names are case insensitive, and optional columns can be omitted.

Full or incremental imports are determined by the presence of the <DeleteUnlistedRecords> directive. The import is incremental if the directive is not used.

Organization

Required organization fields

Field

Description

OrganizationNumber

Enter the number that has been assigned to this organization by the district or by the district SIS. In this and other templates, you use this number to associate schools, users, and students with this organization. This number is a primary identifier; it uniquely identifies the organization and will not change.

OrganizationName

Enter the name of the organization as it appears in Imagine Math. The first import creates a new organization and associates the organization number with this organization name. In subsequent imports, by using the correct organization number, you can change this organization name.

OrganizationType

Enter school (default value) or district.

ParentOrganizationNumber

If you want to create a parent organization for a site, enter one of the organization numbers to associate this organization with its parent organization (always a district). Any organization that has a blank parent organization number will be created or updated at the root level of the site. Districts are not typically assigned to another organization; they are usually assigned to the root site.

StreetAddress

Enter the street address of the organization. Used to set the time zone of the school.

City

Enter the city where the organization is located. Used to set the time zone of the school.

State

Enter the state where the organization is located. Used to set the time zone of the school.

Zip

Enter the Zip Code of the organization. Used to set the time zone of the school.

Country

Enter the country where the organization is located.

 

The organization import filename must include the record type (name_organization.csv). You must use the CSV file type.

Optional organization directive

Directive or field

Description

<DeleteUnlistedRecords>

The import automatically deactivates any previously imported records that are no longer listed in the import file as it adds and updates listed records. Manually created records that were never matched with an import record are not deactivated.

To use this directive, add <DeleteUnlistedRecords> to the import file between the column headings and the data rows, under the OrganizationNumber column.

Class

Required class fields

Field

Description

ClassNumber

Enter the number that has been assigned to this class by the district or by the district SIS. In this and other templates, you use this number to assign users and students to this class. This number is a primary identifier; it uniquely identifies the class and will not change.

ClassName

Enter the name of the class as it appears in Imagine Math. The first import creates a class and associates the class number with this class name. In subsequent imports, by using the correct class number, you can change this class name.

OrganizationNumber

Enter an organization number to assign this class to the correct school.

 

The class import filename must include the record type (name_class.csv). You must use the CSV file type.

Optional class directive

Directive

Description

<DeleteUnlistedRecords>

The import automatically deactivates any previously imported records that are no longer listed in the import file as it adds and updates listed records. Manually created records that were never matched with an import record are not deactivated.

To use this directive, add <DeleteUnlistedRecords> to the import file between the column headings and the data rows, under the ClassNumber column.

User

Required user fields

Field

Description

UserNumber

Enter the administrator or instructor's number as defined by the district or by the district SIS. This number is a primary identifier; it uniquely identifies the user and will not change.

Username

Enter the username. The username must be an email address. The username is globally unique. The first import creates the user and associates the user number with this username. In subsequent imports, by using the correct user number, you can change the username; however, no two users may share the same username.

FirstName

First name of the user. Cannot begin with numbers (i.e. 1, 2, 3). Cannot begin with—or contain—commas or special characters (i.e., &, @, #, $, ?).

LastName

Last name of the user. Cannot begin with numbers (i.e. 1, 2, 3). Cannot begin with—or contain—commas or special characters (i.e., &, @, #, $, ?).

UserType

Enter administrator or instructor (default value).

OrganizationNumbers

Enter an organization number (from the Organizations.xxx import file) to assign the user to a school or district. Users may only be associated with a single organization at one time.

ClassNumbers

Enter a class number to assign the user to a class. To associate a user with more than one class, separate class numbers with semi-colons. Users can only be assigned to classes within organizations to which they belong.

 

The user import filename must include the record type (name_user.csv). You must use the CSV file type.

Optional user directives and fields

Directive or field

Description

<DeleteUnlistedRecords>

The import automatically deactivates any previously imported records that are no longer listed in the import file as it adds and updates listed records. Manually created records that were never matched with an import record are not deactivated.

To use this directive, add <DeleteUnlistedRecords> to the import file between the column headings and the data rows, under the UserNumber column.

<DeleteUnlistedAssignments>

The import deletes old user assignments for organizations, classes, or both. Assignments associated with manually created users are not deleted.

To use this directive, add <DeleteUnlistedAssignments> to the Users.xxx file between the column headings and the data rows. Place the directive under the OrganizationNumbers column to remove each record's assignments to unlisted organizations. Place the directive under the ClassNumbers column to remove each record's assignments to unlisted classes. You can use the directive under either or both columns.

UserSsoId

Enter the SSO realm and unique identifier assigned to this user by your Single Sign-On identity provider separated by a divider '|' (examplerealm|ssoid).

Student

Required student fields

Field

Description

StudentNumber

Enter the student's number as defined by the district or by the district SIS. This number is a primary identifier; it uniquely identifies the student and will not change.

StudentUsername

Enter the student username. The student username must contain at least three characters. The student username is a secondary identifier; it is unique within the site. The first import associates the student number with this student username. In subsequent imports, by using the correct student number, you can change the student username. If left blank, username will be generated.

Password

Enter the student password. The password must contain at least four characters. If left blank, password will be generated.

FirstName

First name of the student. Cannot begin with numbers (i.e. 1, 2, 3). Cannot begin with—or contain—commas or special characters (i.e., &, @, #, $, ?).

LastName

Last name of the student. Cannot begin with numbers (i.e. 1, 2, 3). Cannot begin with—or contain—commas or special characters (i.e., &, @, #, $, ?).

GradeLevel

Nominal grade level of the student. Acceptable values are integers (2, 3, 4, 5, 6, 7, 8) or strings (Algebra Readiness, Algebra I, Geometry, HS Math I, HS Math II). For the Imagine Math K-2 Benchmark Series, acceptable values are K, 1, 2.

Language

Enter the student's preferred support language: en (English - default value) or es (Spanish).

OrganizationNumbers

Enter a number to assign the student to a school. Students may only be associated with a single school at one time.

ClassNumbers

Enter a class number to assign the student to a class. To associate a student with more than one class, separate class numbers with semi-colons. Students can only be assigned to classes within organizations to which they belong.

 

The student import filename must include the record type (name_student.csv). You must use the CSV file type.

Optional student directives and fields

Directive or field

Description

<DeleteUnlistedRecords>

The import automatically deactivates any previously imported records that are no longer listed in the import file as it adds and updates listed records. Manually created records that were never matched with an import record are not deactivated.

To use this directive, add <DeleteUnlistedRecords> to the import file between the column headings and the data rows, under the StudentNumber column.

<DeleteUnlistedAssignments>

The import deletes old student assignments for organizations, classes, or both. Assignments associated with manually created students are not deleted.

To use this directive, add <DeleteUnlistedAssignments> to the Students.xxx file between the column headings and the data rows. Place the directive under the OrganizationNumbers column to remove each record's assignments to unlisted organizations. Place the directive under the ClassNumbers column to remove each record's assignments to unlisted classes. You can use the directive under either or both columns.

StudentSsoId

Enter the SSO realm and unique identifier assigned to this user by your Single Sign-On identity provider separated by a divider '|' (examplerealm|ssoid)

AlternateStudentNumber

This optional field stores the state-assigned number for each student, or the Clever state_id.