How to upload a file

Editing the uploaded template

Download and save the template by clicking on the ‘Template’ link on the right of the screen.

If opening the saved file via Excel:

1. Replace the sample rows in the file with the details of students being enquired about. Note that ‘Family Name’, ‘Passport Number’, and ‘Passport Nationality’ are mandatory fields and are required and that fields should be completed using capital letters.
2. Save the file as a csv file.

If opening the saved file via Notepad:

1. Note that the separation between fields is represented with a comma.
2. Replace the sample rows in the file with the details of the students being enquired about.
3. Ensure that where there are blank fields, it is represented with a comma.
4. Save the file as a csv file.

Uploading the file

1. Click on the ‘Browse…’ button.
2. A window will pop-up. Locate the file required for the upload. When you locate the file, double-click on it. The file location will now appear in the text box next to the ‘Browse…’ button.
3. Click on the ‘Upload’ button.

If the file is uploaded successfully and passes validation, the screen will display a message letting the user know. The user can then proceed with the bulk enquiry by clicking the ‘Submit Bulk Query’ button.

If the file is not uploaded successfully, the screen will display a message letting the user know with a summary of where and what the errors are. If needed, a summary of the errors can be downloaded by clicking on the ‘Download Error Report’ button.

A file being uploaded must not contain any errors to execute a bulk enquiry successfully.