Imagine Language & Literacy

Imagine Learning file specifications

Populating Imagine Language & Literacy templates

There are four Imagine Language & Literacy templates: organization, class, user, and student. Each of the templates must include the record type in the filename. You can use CSV or Excel (.xls, or .xlsx) files; Strict Open XML Spreadsheet is not supported.

The import only requires files that changed. Missing files are ignored.

To populate Imagine Language & Literacy templates

  1. Click the link to download a .zip file containing the Imagine Language & Literacy 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 Language & Literacy 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.

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 Learning Portal. The organization name is a secondary identifier; it is unique within the site. The first import 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.

 

The organization import filename must include the record type (name_organization.xls). You can use CSV, XLSX, or XLS Excel 97-2003 files; Strict Open XML Spreadsheet is not supported.

Optional organization directives and fields

Directive or field

Description

<DeleteUnlistedRecords>

The import automatically deletes 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 deleted. Caution: This action can't be reversed.

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

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 (usually 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. Using a parent organization number adds another layer to the site structure in Imagine Learning Portal.

StreetAddress

Enter the street address of the organization.

City

Enter the city where the organization is located.

State

Enter the state where the organization is located.

Zip

Enter the Zip Code of the organization.

Country

Enter the country where the organization is located.

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 Language & Literacy Cloud. The class name is a secondary identifier; it is unique within the site. The first import 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.xls). You can use CSV, XLSX, or XLS Excel 97-2003 files; Strict Open XML Spreadsheet is not supported.

Optional class directive

Directive

Description

<DeleteUnlistedRecords>

The import automatically deletes 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 deleted. Caution: This action can't be reversed.

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

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 a secondary identifier; it is globally unique. The first import 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

Enter the user's first name.

LastName

Enter the user's last name.

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. To associate a user with more than one organization, separate organization numbers with semi-colons.

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.xls). You can use CSV, XLSX, or XLS Excel 97-2003 files; Strict Open XML Spreadsheet is not supported.

Optional user directives and fields

Directive or field

Description

<DeleteUnlistedRecords>

The import automatically deletes 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 deleted. Caution: This action can't be reversed.

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 unique identifier assigned to this user by your Single Sign-On identity provider.

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 one character. 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.

Password

Enter the student password. The password must contain at least four characters.

FirstName

Enter the student's first name.

LastName

Enter the student's last name.

GradeLevel

Enter the student's grade level. Valid values: -1, pk, prek, prekindergarten; 0, 00, 0th, k, kinder, kindergarten; 1, 01, 1st, first; 2, 02, 2nd, second; 3, 03, 3rd, third; 4, 04, 4th, fourth; 5, 05, 5th, fifth; 6, 06, 6th, sixth; 7, 07, 7th, seventh; 8, 08, 8th, eighth; 9, 09, 9th, ninth; 10, 10th, tenth; 11, 11th, eleventh; 12, 12th, twelfth; other (default value).

Language

Enter the student's first language: English (default value), Arabic, Cantonese, French, Haitian Creole, Hmong, Japanese, Korean, Mandarin, Marshallese, Portuguese (Brazil), Russian, Somali, Spanish, Tagalog, Vietnamese.

OrganizationNumbers

Enter a number to assign the student to a school. To associate a student with more than one organization, separate organization numbers with semi-colons.

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.xls). You can use CSV, XLSX, or XLS Excel 97-2003 files; Strict Open XML Spreadsheet is not supported.

Optional student directives and fields

Directive or field

Description

<DeleteUnlistedRecords>

The import automatically deletes 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 deleted. Caution: This action can't be reversed, and student progress data is deleted.

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 unique identifier assigned to the student by your Single Sign-On identity provider.

AlternateStudentNumber

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

Tags