OEN Validation Import Results

Introduction

Import results are available from the Ontario Data Import page. Log in to the admin portal:

1. On the Start page, choose Special Functions. The Special Functions page appears.

2. Select Import Ontario Data Files. The Ontario Data Import System page appears.

3. Select any linked item in the Import Results section. A summary of all import results for this type of import is displayed. In the Import Results section.

Links are enabled only for import types for which at least one import has been run.

• On the Ontario Data Import System page, under Import Results, click OEN Validation Import Results.

  • if no import has been run, the OEN Validation Import Results link is not visible.

  • If viewing this page at the school level, only the results for the current school are displayed. If viewing this page at the district level, results for all available schools are displayed.

• Import results are organized by School, and then Import Date. For each import date, the import results are displayed by file, sorted alphabetically.

  • To see only the results for a specific section, click show/hide.

  • To delete a School or Import Date section, click the trash can icon. Results should only be deleted if you no longer need to review the import results. Deleting the results does not undo the results of the import; only the result record is deleted.

  • If a School ID is not found within the file, one or more errors occur during the import. A description of each error appears at the bottom of the page.
    

• To see more detailed results, click Import Date.

  • The results display all records for the selected school and import date.

  • The page displays the batch (import) file date, the date of the import, and the file ID.

  • The results display the invalid OEN records found by the Ministry. This list defaults to expanded, but can be collapsed by clicking on the corresponding hide link.

    • The invalid OEN value displays. If a student can be found within PowerSchool, the student's name displays and is linked to the student's record. If the student cannot be found, a message indicates that there was a problem finding the student and how many students were found with this OEN value. This message appears if more than one student or no students are found.

• The results display the mismatched OEN records found by the Ministry. This list defaults to expanded, but can be collapsed by clicking on the corresponding hide link.

  • The name of the student for which errors were found displays, along with all mismatched values that the Ministry returned. Ministry values display in red, and the corresponding values found within PowerSchool display in bold. Clicking the student's name takes you to the student's record.