Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Data, such as information about organizations, users, and students, can be entered into the system directly and read from the screen. However, for large amounts of data, it is often easier to enter or retrieve it by uploading or downloading a file.

View File Details

To view information about available data files, follow these steps:

  1. From Setup > Import / Export Data, mark the box next to the file(s) you want to know more about. You can use the Search box to narrow your search to only files that contain the text you enter.

    Expand
    titleClick here to view a screenshot...

    Image Removed

  2. Open the task list and select View File Details and click Start.

    Expand
    titleClick here to view a screenshot...

    Image Removed

  3. View listed details about the file(s) you selected. If you selected more than one file, then select the file you wish to view from the Files list at the left.

    Expand
    titleClick here to view a screenshot...

    Image Removed

  4. Click Download File if you want to download the file.

Import Data

  1. From Setup > Import / Export Data, open the task list and select Import / Export Data and click Start.

    Expand
    titleClick here to view a screenshot...

    Image Removed

  2. Select the type of file you wish to import. You should select a type with Import in the name.

    Expand
    titleClick here to view a screenshot...

    Image Removed

  3. Click Choose File and select the file from your local machine that you will upload and import.

    Expand
    titleClick here to view a screenshot...

    Image Removed
     

    If you import multiple versions of the same type of file, then the newer file will override existing data. For example, if you import a User Import file and then import a second one later, then the data in the system will contain any changed or new data in the second file in addition to data that was in the first file but not the second file.

  4. Click Process.

After you import a file, you will see it listed at Setup > Import / Export Data. The Status column displays the file import status. Most importantly:

  • Pending, which means that the file is still being processed and you must wait a while longer.
  • Complete, which means that the file was uploaded successfully, or 
  • Complete with issues, which means that the file was uploaded, but that there were problems with some of its contents. Select a file with issues. Then select View File Details to view a description of the issues and to download related error messages, so you can fix the issues before importing the file again.
Expand
titleClick here to view screenshots...

Image Removed

This is the information that is displayed for files with a status of Complete with issues:

Image Removed

Export Data

Before you can download data from the system, a file containing that data must be created. This creation process is called export. Once the file is created, you can download it.

  1. From Setup > Import / Export Data, open the task list and select Import / Export Data and click Start.

    Expand
    titleClick here to view a screenshot...

    Image Removed

  2. Select the type of file you wish to export. You should select a type with Export in the name.

    Expand
    titleClick here to view a screenshot...

    Image Removed
     

  3. Click Process to begin creating the file. After you export a file, you will see it listed at Setup > Import / Export Data. Select the file(s) you want from the list.

    Expand
    titleClick here to view a screenshot...

    Image Removed

  4. Select View File Details.

    Expand
    titleClick here to view a screenshot...

    Image Removed

  5. View listed details about the file(s). If you selected more than one file, then select the file you wish to download from the Files list at the left. Select Download File.

    Expand
    titleClick here to view a screenshot...

    Image Removed

Related Information

Your program works together with Pearson to clearly define and configure the data file contents and layouts. Users who import files containing information for your organization are supplied with instructions for how to create those files for your organization and populate them with correct data.

Expand
titleView a general description of the types of data files that can be imported and exported

These are the types of data files that can be imported and/or exported:

Data Type
Description of file contents
Online Test AttemptsThese contain data from the online test document that is produced after testing.
Organizations

These contain data about the organizations themselves.

Organization Participation

These contain data about both the organizations and their participation, along with current enrollment counts.

It is considered a best practice to use this file only for managing participation data and using the Organizations File for managing organization data, even though both can be done using this file.

Organization Participation Preloads

These list organizations and whether they are participating in specific test administrations. These are created based on previous administration data.

The contents are similar to the Organization Participation file.

PreID

These contain barcode information.

This information is used to match the student to a test (paper or online) and test results while allowing the test to be scored without a name attached.

Students

These contain student data.

Student Registrations

These contain data about students and include their test administration registration, which can be used to determine enrollment counts. If you upload multiple files and the tests identified in the new file have already been completed, new test assignments will be created instead of the existing data being updated.

Test Attempts

These contain the data from the paper test document that is produced after testing. The data from this file is matched to data in the system to match the student to a test (paper or online) and test results while allowing the test to be scored without a name attached. These files can only be imported.

Users

These contain data about users, the organization(s) each is assigned to, role assignments, and dates during which the account will be active.

Personal Needs ProfileThe personal needs profile (PNP) is a list of accommodations attached to a student record denoting any special requirements to enable the student to take a test.

For more information, see Data Files and Fields.

Importing files into the system is one of two ways to enter data into the system.

  1. You can import a file, which is commonly done for additions or changes that involve multiple records. 
  2. You can enter or edit records through the user interface, which is commonly done for additions or changes that involve one or few records. See these pages if you wish to enter data through the user interface: Manage OrganizationsManage UsersManage Students.

 

 

 

Anchor
TOP
TOP

Extra Table Properties
table-width10%
column-widths80%,20%
hide-bordertrue

Livesearch
spaceKeyPAsup
placeholderEnter your search criteria.

Anchor
RI
RI
Pearson recommends importing or exporting/re-importing files that contain large amounts of data. Users can, then, access this data to update existing records and/or add new records.

Data files and fields may vary by program. For details, see Data File Descriptions and Data Field Descriptions.

UI Text Box
typenote

Anchor
PRE
PRE
Prerequisites

Your program works with Pearson to clearly define data file content and layout. Authorized users import data files using organization-specific instructions on file formats and data.

Anchor
Instructions
Instructions
Step-by-Step 

You can choose to read or watch the instructions below.

Extra Table Properties
table-width90%
column-widths50%, 50%
hide-bordertrue
UI Text Box
sizemedium

Image Added


(Click Image Added to view image)

  1. From Setup, select Import / Export Data.Image Added

  2. Click Start and select Import / Export Data.Image Added 

  3. Select the type of file you want to import or export.Image Added

  4. Type or select the necessary details that apply. Depending on the file type, you may see options to extract specific data in the reports. You can see the selected export options in the Parameter section of the view file details.

  5. Click Choose File, and navigate to the file you want to import. You may select Ignore Error Threshold (when available).Image Added

  6. Click Process.Image Added

UI Text Box
sizemedium

Image Added


Widget Connector
width600
urlhttps://www.youtube.com/watch?v=BUa6MchhZmA&t=43s
height338

UI Text Box
typeinfo

Anchor
Effects
Effects
Effects

The system automatically sends an import-complete notification to designated email address, if previously provided.

After you import a file, you see it on the Import / Export Data page.

Expand
titleStatus definitions...

Status

What it means

Action

CompleteFile successfully imported.No further action needed.
PendingFile is processing.Wait until processing is complete.
Complete with issuesFile uploaded with some content issues.Use View File Details for information on files and error records. Make any necessary changes and upload the updated file.
Expand
titleAfter you import/export, you can view file details...

Such as, when the action occurred, if it was successful, who performed the action, etc.

  1. From Setup, select Import / Export Data.

  2. Select the checkbox next to the file(s) you want to know more about. 

  3. Select the task View File Details, and click Start.

  4. View listed details about the selected file(s).

  5. To download the file, click Download File.

UI Text Box
typetip

Anchor
What's Next?
What's Next?
What's Next? (Optional)

Expand
titleIf you experience issues...

Review the files in the Errors section. Make necessary changes, and repeat the steps to import data.


Back to the top