Uploading and Validating Booking Data
Once you have downloaded the appropriate template and filled in the booking data, you can begin the import process.
Go to the Import Records page and click the “+” button in the top-right corner. Select Import Bookings, then choose the booking type you wish to import. This will bring up the file upload modal.
Click Choose File to select the prepared file from your device and upload it. Once the file is uploaded, the validation process will start automatically.
You will be able to see the new import record listed on the Import Records page. Its initial status will be Validating. After the validation process is complete, the status will update to either Validated or Validation Failed, depending on the result. The table below outlines what each validation status means:
| Validation Status | Definition | Notes |
| Validating | The import file has been successfully submitted for validation. | Once validation begins, it cannot be stopped. The file will either pass or fail validation. |
| Validated | The import file has passed validation and is ready to be imported into Student Suite. | Details can only be imported after the file has successfully passed validation. |
| Validation Failed | The import file did not pass validation due to errors that must be corrected. | Download the validation report to view and resolve the errors before re-submitting. |
Viewing Import Details and Error Messages
You can locate the import record you want to review from the list on the left side of the Import Records page. Once you click on a specific record, its detailed information will be displayed on the right side of the screen.
If your imported booking file did not pass validation, a Download Detail button will appear at the bottom of the detail view. By clicking this button, you can download the booking file that includes error messages, which will help you identify and correct the issues.
Reviewing the Validation Result
When you open the downloaded file, you will see that the first two columns in the Excel sheet are labelled Errors and Warnings.
If there is content in the Errors column, it means that certain fields in your booking data contain critical issues that must be corrected. These errors will prevent the data from being successfully imported into the system.
If messages appear only in the Warnings column, they indicate non-critical issues. Warnings will not stop the import process, but you should review them and decide whether any adjustments are necessary.
Common Error Types
The Errors column typically reflects one of the following issues:
Missing Value: A mandatory field has not been filled in.
Invalid Format: The value provided does not match the required format or data type.
Duplicate Values: Some fields contain duplicate entries that are not allowed.
You will need to address these errors before attempting to re-upload the file.
Re-uploading After Fixing Errors
After correcting all the identified issues in your booking data, you can re-upload the file by following the same steps as before. Once the file is uploaded again, the system will automatically perform a new round of validation.
If the validation is successful, the record status will change to Validated, and you can proceed to the next step in the import process.
If the validation still fails, you will need to download the Detail file again, review the updated error messages, and make the necessary corrections before trying again.