Correct Validation Errors

Validation errors are generated when the format of the source data value does not match the format of the destination data value, or if there are orphaned records in the field set. If your source data value is not in the proper format, your data may not convert properly. For more information about appropriate field values, see the setup section of your state reporting documentation.

You can correct validation errors using the following methods:

Edit records or remove orphans on the Pre-Migration Validation page.
Export validation error records from the Pre-Migration Validation page and import the changes back into PowerSchool.
Update the errors using the appropriate PowerSchool pages.

How to Correct Validation Error Records

On the Pre-Migration Validation page, click the Pencil icon next to the record that you want to correct. A pop-up appears.
Enter the new Destination Value into the pop-up. This will change the value in the source field.

The data you enter will be validated against the Destination Data Type. Data validation only validates for data type and length.

Destination Data Type	Validation Description
String	The length of characters entered field must be less than or equal to the Destination Length. If you attempt to enter more characters than allowed, you are prohibited from entering additional characters.
Integer	The numeric value entered must be valid.
Double	The numeric value entered must be valid. Allows decimal points.
Boolean	The value entered must be one of the following: 0 1 T F True False Y N Yes No
Date	The date value entered must be a valid date format.

3. Click Save.

After you have edited a record, the status of the record changes to Updated. This status indicates that you have edited the record; it is not an indicator that the field value is valid.

Re-validate the data to verify that the records are now valid and ready for migration. See Re-validating Data below for more information.

How to Export and Remove Orphan Records

To export the orphan records, click Export Orphan Records on the Pre-Migration Validation page.
To Remove orphan records, click Remove Orphans on the Pre-Migration Validation page.

Do not remove orphans until you have downloaded an export of the records and verified that they can be removed. This is a one-time process and cannot be reversed.

Re-validate the data to verify that the records are now valid and ready for migration.

How to Export Validation Errors

To export orphan records: On the Pre-Migration Validation page, click Export Orphan Records.
To export all other validation errors: On the Pre-Migration Validation page, click Export all # records.

Exporting from the Pre-Migration Validation page exports all validation error records, or filtered validation errors. If you wish to export a select group of records outside of the available filters, select the records in PowerSchool and follow the Import and Export process.
Currently, data may only be imported into Students, Teachers, Sections, and Courses.

Re-validating Data

Once you have corrected your data, it is important to re-validate to verify that all the errors have been cleared and your data is ready for migration. You can re-validate using the following methods:

Re-validate using the Re-validate button on the Pre-Migration Validation page.
Re-run the validation process from the Custom Field Migration page.

How to Re-validate on the Pre-Migration Validation Page

Click the Re-Validate button to verify that the records are now valid and ready for migration. Use this option when you are correcting data using the Pencil icon on the Pre-Migration Validation page. See How to Correct Validation Error Records above for more information about how to use the Pencil icon.

How to Re-validate on the Custom Field Migration Page

See Run Pre-Migration Validation. Use this option when you navigate away from the Pre-Migration Validation page to correct validation errors.