Pearson imports project data into Pearson Access, and maintains and manages that data. A user's ability to view or edit this data depends on his or her organization(s) and role(s) within them. 

Pearson periodically imports this data into Pearson Access for projects. Each project designates users with specific permissions to periodically send Pearson data through .csv roster files that adhere to specific naming conventions and contain valid values. These designated users can send Pearson these files in one of two ways, depending on their projects.

  • Data Import through Pearson Access user interface (UI) - Users with specific permissions can initiate these imports at any time necessary through the UI (in each related page) to insert data into the system (see Delta below). To do so, export existing data, update that document, and then, re-import it. You can use the template .csv roster file from each related page to compare fields to ensure that the file can import without error.
  • Nightly Data Import -  Users with specific permissions send Pearson a compressed (.zip) file that contains the .csv roster files and a manifest file. Pearson receives these files periodically (usually nightly), and imports them to overwrite existing data within the system (see Bulk below). The overwriting does not occur if the files contain any errors. You can access data import files for details on import success or errors. You must correct any errors and resubmit the import for the system to overwrite existing data.
  • The manifest file contains roster file names, with one of the following indicators:
    • bulk - Used in the Nightly Data Import. Indicates that roster .csv files exist within the .zip, containing data that will overwrite currently existing data in the system.
    • delta - Used in the Data Import through Pearson Access user interface (UI). Indicates that a file(s) exist within the .zip, containing data that the system will delete, insert, or update.
    • absent - Indicates that the file does not exist within the .zip. Currently existing system data will remain in tact.
  • Within a .csv roster file, the first column contains one of these Update Indicator values to indicate to the system how to update the data.
    • D = Deletes the data.
    • I = Inserts the data and leaves existing data intact.
    • U = Updates by overwriting existing data.
    • blank - Used in bulk files. Does not indicate action. The system updates data based on differences in the roster .csv files you send for import.

Prerequisites

  • Updated data should have previously been loaded into your student management system (SMS), as this data is exported from the SMS to complete the steps for roster import below. The SMS must contain the most current data.
  • Confirm your role and project under your name, and your district or school in the Organization dropdown. If you have access to multiple projects or organizations, click each dropdown to select the one(s) you want to manage.

Roster Import

To complete the import of updated data to Pearson Access, use Pearson's Standard Layout (PSL) 2.0 (or one previously agreed upon for your project) with the specific file naming conventions for each roster file and manifest, if applicable.

Step-by-Step

For instructional purposes, these steps refer to importing students; however, you can use the steps beginning with the Students, Users, Classes, Courses, Districts, Schools, or Parent/Guardians tabs.
Tabs vary by project.
  1. Export relevant data from your student management system.
  2. In the main menu, click Students.

  3. Prepare your file(s) for import. If your organization:
    • Has previously imported data within Pearson Access, click Export Students to download the most recently imported data from the system. Note that this export includes data that pertains only to the organization to which you are pinned.
    • Does not have related previously imported data within Pearson Access, download the PSL 2.0 template file from the related page and populate it with your project's valid values and naming conventions.
  4. Open either of the above files with a compatible application.

     Examples for opening .csv in two different applications...

    Opened in Brackets (Recommended)

    Opened in Excel (see note on retaining zeros below)

    • If using an exported file, delete extraneous data to use the same file for import. This helps retain necessary fields and provides guidance on valid values. Note that projects previously using PSL 1.0 must use PSL 2.0 to import without error.

  5. Populate the .csv fields in the appropriate columns with valid values, and save the .csv file with a descriptive naming convention (for example, teacherlastname.students.csv).

    - Check that every number containing zeros retains those zeros before import. For example, student ID 00123 must retain the first two zeros to properly import. Some spreadsheet applications (Excel, for example) automatically strip out these zeros, and you must add them back in before import or import the data as text for those columns.

    - Remove pipe characters or extraneous commas.

  6. Click Import Students and click Browse to find your file.

    When importing more than one local file, wait one minute before importing the same type of local file and change the file name. Uploading the same type of file with the same name (for example, local.students.csv) in short progression results in the system assigning each file the same timestamp and flagging them as duplicate errors. In this scenario, the system loads only the first file. You can add a teacher or class to file names to vary them.


  7. Click Submit.

    Pearson Access receives the file and creates the manifest to import the data into Pearson Access data storage.


Processing time for imports and exports varies depending on the number of records and types of updates within the file. Imports are processed in the order that they are received, and updates may not process immediately after the file status is COMPLETE. NOTE that a COMPLETE status indicates only that the file was received. Updates may take additional time to appear within the system.

You can click the Imports/Exports tab in the main menu to view and download any available files.



Effects

  • Successfully imported data is available to users in the Pearson Access project, based on their roles and permissions. 
  • Consult your headquarter or state technical/data support to address any errors in the .csv file.