Work with Data Validation

On this page:

AutoComm

When data is imported into the Students or Teachers table using the AutoComm function, it is validated against applicable data validation rules. When the AutoComm function runs, the system emails the recipient the status of the AutoComm process if an email address is specified in the E-Mail completion report to field. Successful AutoComm runs can contain up to 100 Error messages for records that failed to import due to validation issues. Unsuccessfully imported records are not updated during the AutoComm import. If a record was not imported due to a data validation error, the message "Error on line [#]: Validation error for field: [field name]" appears along with one or more of the following explanations:

- Empty value is not allowed
- Value may not contain more than [#] character(s)
- Value must be a number
- Value must be a valid date
- Value must be an integer
- Value must be at least [#]
- Value must be less than or equal to [#]
- Value must be on or after [date]
- Value must be on or before [date]
- Value must contain at least [#] character(s)

If a record was unsuccessfully imported due to a data validation, the system does not attempt routine validation until the data validation is corrected.

For the import status on unsuccessful records, refer to the system log. Review the details about each error, make any necessary corrections, and then run the AutoComm function again. Continue this process until all files are imported.

Page Submission

Fields that have data validation rules associated to them are validated against those rules upon submitting a page that contains those fields. Upon submitting a page, the following occurs:

If there are any data validation errors, a warning message appears at the top of the page indicating that the information could not be saved, each type of error encountered and the number of occurrences of each error, for example:

Information was not submitted. Please refer to error messages on the page and correct before submitting again.
Number cannot be less than [#] - (X)
Number must be at least [#] digits in length - (Y)
Date must be on or after [date] - (Z)

Where X, Y and Z are the count of the number of occurrences of that error on the page.

A message appears next to each field where a data validation error occurred indicating a correction needs to be made. For more information, refer to Data Validation Rule Status.
When updating fields that need to be corrected, the orange warning message that appears at the top of the page scrolls with the user as the user corrects each field.
When updating fields that need to be corrected, data validation error messages remain until a valid entry is made. For more information, refer to Data Validation Rule Status.
Once all data validation errors are corrected, the orange warning message then appears green indicating that the information is now valid and can be saved.

Quick Import Data

Data that is imported into the Students or Teachers table using the Quick Import function is validated against applicable data validation rules. The results page displays both successfully and unsuccessfully imported records. Unsuccessfully imported records are not updated during the import. If a record was not imported due to a data validation error, the message "Not imported: Validation error for field: [field name]" appears along with one or more of the following explanations:

Empty value is not allowed
Value may not contain more than [#] character(s)
Value must be a number
Value must be a valid date
Value must be an integer
Value must be at least [#]
Value must be less than or equal to [#]
Value must be on or after [date]
Value must be on or before [date]
Value must contain at least [#] character(s)

If a record was unsuccessfully imported due to a data validation, the system does not attempt routine validation until the data validation is corrected.

Review the details about the error, make any necessary corrections, and then import again. Continue this process until all records are imported.