How to import rosters

Document created by Community User on Jul 29, 2016Last modified by Community User on Jun 19, 2017
Version 140Show Document
  • View in full screen mode
Overview of the import process.

Users with the Data Administrator user role are able to import rosters into the MAP Suite. See Students and Staff Roster for additional information.

The combined roster import is the primary way to enroll students as well as register instructors and create classes. The Additional Users template is used to create other user accounts in bulk, and to assign additional roles to user accounts in bulk. For example, you can use the Additional Users template to import your administrative users, as well as assign the proctor role to instructors.

Optionally, you can import a programs file to assign students to special programs such as Title 1, or Gifted and Talented.

Get the template:

You can download the roster file template and the programs file template from the home page of the MAP Administration and Reporting Center (MARC). The links are in the Information Center section at the bottom.

Start the import:

  1. Complete the template and save the file as a CSV (comma separated values) file.
  2. Go to Import Profiles.
  3. Click Start New Import.
  4. Select the import type:
    • Combined: Choose this for a standard import containing students and teachers. This is the import type you will usually choose, and is required for full reporting.
    • Add/Update Students Only: Imports only student data. Teacher, class, and school data is ignored. Use this if you need to change an attribute for many students. For example, you are changing your student ID system.
    • Add/Update Instructors Only: Imports only instructor data. Student data and class is ignored. Use this if you need to change an attribute for many instructors. For example, you are assigning new teacher IDs.
    • Add/Update Additional Users: Use this to import additional non-instructor users, or to assign new roles to users. For example, you can import school administrators, and assign the proctor role to instructors.
  5. Combined roster only: You can choose to add new data and update any existing data (default) or remove all existing data and replace it with the data in your file. See Selecting Add or Replace when importing roster files.
  6. Select the term. If the term is missing, make sure the current academic year has been added and the current term is active in Modify Preferences > Manage Terms.
  7. Under the Roster File heading, click the Add... button.
  8. Select the roster file on your computer. Make sure you select the CSV file.
  9. Combined roster only: (Optional) If you are importing a programs file, you must import it at the same time as your combined roster. Click Add... under the Programs File heading to select the programs file on your computer.
  10. The uploaded file names will appear under the Uploaded Files Info heading.
  11. Click Next to upload and validate the file.
Import validation and file errors:
  1. The template format will be validated first.
  2. If you get the error "Source file(s) do not match the required format", see Source file(s) do not match the required format.
  3. If you get the message "Queued for Validation", you can leave this page and come back later to finish the import. Roster processing may be slowed during periods of heavy testing.
  4. Once the template format has been validated, you will see a preview of the first 20 rows of your file. You can use this page to verify that you are uploading the correct file.
  5. Click Submit.
  6. The data in the file will be validated.
  7. If you receive a list of file format errors, you must fix the roster file and re-import. See How to use Excel filtering to resolve File Format errors.
  8. Otherwise, click Go to Import Summary.
Reconciling errors and posting valid data:
  1. Review the import summary to make sure the number of incoming records is roughly as you expected.
  2. You may have errors to reconcile. If so, click the Reconcile Errors button and proceed through the errors. See Import Errors - Causes and Solutions in Web-Based MAP help for assistance with fixing errors if necessary.
  3. When you have finished reconciling errors, click Return to Import Summary.
  4. If the data looks correct and all errors have been reconciled, click Post Valid Records, then click OK after reading the warning message.
  5. Depending on the size of your roster and the current volume of rostering and testing, it may take some time for the records to be posted.

When the import is complete, the Import Profile page will reset, displaying the Start New Import button. You can now begin testing immediately. Any changes to reports will take effect within 24 hours.

Article Number