Downloading and filling out your bulk-import files

At the beginning of a new school year or when you first start using the Imagine Learning Literacy and MyPath suite, you'll use in-product templates to create new educator and student accounts, assign student accounts to classes/groups, assign products to students, and change any default product settings. The program will guide you through the process of selecting the fields you need for your rostering templates. Once you generate your templates, you'll fill them out and upload them as CSV files.  

You can also use the files to update existing accounts during the school year. As long as the student ID stays the same, any other data fields you change in the spreadsheet will be reflected in the students' accounts. You can therefore update students' basic account information as well as change their product access or edit their product settings.

Administrators can create and edit classes/groups and student and educator accounts; Teachers can create and edit classes/groups and student accounts.

10,000 records can be uploaded simultaneously per entity (educators, students, classes/groups) per import.

This article walks you through these steps:

Downloading templates | Filling out the classes/groups template | Filling out the educators template | Filling out the students template

Downloading templates

To download blank templates and fill them out:

1. Log in to the Literacy and MyPath suite.
2. Click Users & Classes/Groups in the Product Portal. 
   
   

    Note

   You may have access to different products than what displays in the screen shot above. 

3. Click Add, then select Generate import templates.
   
4. Continue with the set of instructions applicable to the type of record you are creating or editing:
   Classes/Groups | Educators | Students

Classes and Groups

1. In the Record Type field, select Classes/Groups.
2. If you would like to assign an external ID to the group, click the checkbox by External Assigned ID. The External Assigned ID is optional; it is an identifier your organization can use for the class or group. 
3. Click Generate Template.
   
4. Open the template from your downloads. The first 2 rows underneath the headers are populated with sample data. Pay attention to the second row in particular; it shows how to separate the values with semicolons if you have multiple data points in one cell.
5. After reviewing, delete the 2 sample rows from your spreadsheet.
6. Fill our your template as indicated in the table below. Required fields are marked with a red asterisk (*); the optional data point (External Assigned ID) will only appear in your template if you selected it in the user interface. 
   

   Field	Description
   External Assigned ID	(Optional) The identifier for this class or group that is used in your Student Information System (SIS).  Note The External Assigned ID will display when viewing the class/group but will not display in reports within Imagine Learning products.
   Class/Group Name*	The name of the class or group.
   Organization*	The name of the school district or school to which the group should be tied. You may only associate 1 organization to each entity.  Note This column only appears on the templates downloaded by administrators with more than 1 organization. If you are only assigned to 1 school, this column will not appear in your template because your organization will automatically be assigned.
   Products*	The products available to students in this group. Separate multiple values with a semicolon but no spaces. For database purposes, enter the product names as follows: ImagineLanguageandLiteracy ImagineEspanol ImagineReading ImagineLectura ImagineGalileo MyPathReading MyPathMath ImaginePurpose ImagineScienceCorner  Note This information will help with filtering within the portal only. It does not grant product access to students within the class or group. Product access is assigned in the Students template.

7. Upload the template you just filled out. 

Educators

1. In the Record Type field, select Educators.
2. If you would like to add either of the optional columns to your template, click the applicable checkbox next to External Assigned ID and/or Classes/Groups. 
3. Click Generate Template.
   
4. Open the template from your downloads. The first 2 rows underneath the headers are populated with sample data. Pay attention to the second row in particular; it shows how to separate the values with semicolons if you have multiple data points in one cell.
5. After reviewing, delete the 2 sample rows from your spreadsheet.
6. Fill our your template as indicated in the table below. Required fields are marked with a red asterisk (*); the optional data points will only appear as columns in your template if you selected them in the user interface. 
   

   Fields	Description
   External Assigned ID	(Optional) The identifier for this class or group that is used in your Student Information System (SIS).  Note The External Assigned ID will display in the educator's account but will not display in reports within Imagine Learning products.
   First Name*	The educator's first name.
   Last Name*	The educator's last name.
   Username*	The username the educator will use to log in to the product(s). It must be a unique email address between 4 and 128 characters long.  Note: Educators will get a welcome email and will create their own password, which is case-sensitive and must be at least 8 characters long.
   Educator Type*	The educator's role. Enter one of the following: Teacher Admin Whether the user is a School Administrator or a District Administrator is determined based on the user's assigned organization(s); therefore, enter Admin for both types of administrators.
   Organizations*	The school(s) to which this educator should be assigned. If there are multiple organizations, separate them with a semicolon.  Note This column only appears on the templates downloaded by administrators with more than 1 organization. If you are only assigned to 1 school, this column will not appear in your template because your organization will automatically be assigned.
   Classes/Groups	(Optional) The name of the class(es) or group(s) to which the educator should be assigned. Make sure the name of the class or group matches the name in the Classes/Groups import file. If you don't assign educators their classes or groups on this file, you must manually assign classes or groups later.  Caution If the educator is assigned to multiple organizations and the class/group name provided is duplicated across those organizations, the educator will not be created or updated.

7. Upload the template you just filled out. 

Students

1. In the Record Type field, select Students.
2. Check any boxes in the Optional Columns section that you would like to include in your template. Required fields are marked with a red asterisk (*); the optional data points will only appear in your template if you selected them in the user interface.  

   Field	Description
   External Assigned ID*	The unique identifier for this student that is used in your Student Information System (SIS).
   First Name*	The student's first name.
   Last Name*	The student's last name(s).
   Username*	The username the student will use to log in to the Product Portal. Usernames are not case-sensitive. They must be at least 3 characters long, and must be unique within your organization's site code.
   Password*	The password the student will use to log in to the Product Portal. Passwords are case-sensitive and must be be at least 4 characters long.
   Grade level*	The student's rostered grade level. Choose from these grade levels: PK, K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, or 12.
   Organizations*	The school the student attends.  Note This column only appears on the templates downloaded by administrators with more than 1 organization. If you are only assigned to 1 school, this column will not appear in your template because your organization will automatically be assigned.
   Product Access*	The product(s) to which the student should be assigned. Enter the product names as follows: ImagineLanguageAndLiteracy ImagineEspanol ImagineReading ImagineLectura ImagineGalileo MyPathReading MyPathMath ImaginePurpose ImagineScienceCorner
   Classes/Groups	(Optional) This column allows you to associate students with their classes or groups so that you will be able to see their data in reports. Separate multiple values with a semicolon and no space.   Caution Students who are not tied to a class or group will be able to use the program but will not appear on educator reports. If you don't assign students their classes/groups in this step, be sure to do so at a later time.
   Alternate External Assigned ID	(Optional) A secondary identifier for the student's record, as determined by your school or district. Often this is a State ID.  Note Imagine Learning does not require this field, but your state might. If your state requires this ID, it must be unique. This data element will not display inside Imagine Learning product reports, but it will display in the student's account in the management tools.
   NWEA ID	(Optional) Add this column only if you will be using the NWEA assessments in Imagine MyPath. It will facilitate the upload of each student's NWEA assessment score so that students do not have to take an additional assessment inside MyPath in order for their learning path to be determined. Note Entering the NWEA ID for students using other products has no effect within those other products. Imagine Language & Literacy students' NWEA scores are incorporated through an automated sync, so there is no need to enter the ID here as well. No other products in the Product Portal besides MyPath Math, MyPath Reading, and Imagine Language & Literacy integrate with NWEA.
   Renaissance ID	(Optional) Add this column only if you will be using the Renaissance Star assessments in Imagine MyPath. It will facilitate the upload of each student's Star assessment score so that students do not have to take an additional assessment inside MyPath in order for their learning path to be determined. Note Entering the Renaissance ID for students using other products has no effect within those other products. No other products in the Product Portal integrate with Renaissance Star.
   Individual Education Plan (IEP)	(Optional) Insert this column into your template if you wish to track which students have an IEP.  The default is No; blank cells indicate No. You many also enter Yes.
   English Language Learner (ELL)	(Optional) Insert this column into your template if you wish to track which students are ELLs.  The default is No; blank cells indicate No. You may also enter Yes.

3. Click on the purple selector if you want to add columns to your template for that product's settings. 
   

    Note

   Only the products that your district has purchased will be available to turn on, so your view may be different from the image below.

   
   The product settings appear in columns in your template as described in the table below. All of these settings are optional, so only add a value in the template if you want to override the defaults.
   

   Column(s)	Details
   Text to Speech	Indicates whether the student's account should have Text-to-Speech (TTS) enabled. The default is no. For each product you wish to enable it for, type the name of the product with no spaces between the word. Separate multiple product names with semicolons and no spaces. This feature is available for the following products: MyPathReading MyPathMath ImaginePurpose ImagineScienceCorner
   Language Translation Tools	Indicates whether the student's account should have Language Translation Tool enabled. The default is no. For each product you wish to enable it for, type the name of the product with no spaces between the word. Separate multiple product names with semicolons and no spaces. This feature is available for the following products: MyPathReading MyPathMath ImaginePurpose ImagineScienceCorner
   Imagine Language & Literacy  Language Support	This column applies only to Imagine Language & Literacy. Enter the audio language for the instructions of the activities that each student hears when they use the program. English is the default and will be assigned if no other language is entered. Otherwise, designate another of the 15 supported languages: Japanese Spanish Mandarin Korean PortugueseBrazil French HaitianCreole Arabic Marshallese Vietnamese Russian Tagalog Cantonese Hmong Somali
   Imagine Español Language Support	This column applies only to Imagine Español. Enter the audio language for the instructions of the activities that each student hears when they use the program. The default is Spanish. If you prefer English for a particular student, type English in this column. Otherwise, leave this field empty and Spanish will be assigned.
   Imagine Language & Literacy and Imagine Español Session Time	The amount of time the student should use the program in one sitting. The default is 20 minutes; enter a new value between 10–120 if desired. If the student has both products, the session time you enter will apply to both Imagine Language & Literacy and Imagine Español.
   Audio Support	This column applies to the following products: Imagine Reading Imagine Lectura Indicate whether the student should be allowed to have the text read aloud by the computer. The default is Yes. If you want to disable audio support, type the name of the product(s) you want to turn off. Separate multiple products with a semicolon and no spaces.

4. At the bottom of the window, click Generate Template.
   
5. Open the template from your downloads. The header contains a description of each data point along with the acceptable values. The first two rows underneath the header are populated with sample data. Pay attention to the second row in particular; it shows how to separate the values with semicolons if you have multiple data points in one cell.
6. Fill out your template based on the fields you selected. 
7. Upload the template you just filled out.