Import Students

Thank you for your feedback! We are pleased to announce that the first version of Import/Update Students feature is now available!

You can import a batch of students if you want to add or update multiple Students at the same time, rather than individually.

You may want to import Students at the beginning of the academic year, when you have a large number of Students to add to the system at once.

When you import Students, they are all added to the Students List, which means that you can view them in the Student List or Change Student details as and when required.

If you want to add Students to the Student List individually, you can create a new student by following the steps mentioned in the 'Create Student' section for adding each new user.

To import new and/or bulk update students

1. Ensure that the Students you wish to update are in the Testwise Import Template.

Note: The most efficient way to update your Students List is by first exporting the list using the Export Student List as a CSV file function. This will download a .csv file version of your Students List on your system. You may now add new or update any existing students in this file. Once you are happy with your updated list, simply re-import it into Testwise.

2. Edit your Students List in the .csv file, as required. 

Note: The unique identifiers in your file must match the ones on Testwise in order to update a student. If a different unique identifier is used, then a new Student record will be created. 

3. Once you are happy with your updated list and it is ready to be imported, click on the Students button on the home screen. 

4. Click on the Import Students button  to display the Import Students page.

5. Click on Browse to display the 'Choose File Upload' box. Then navigate to the .csv file on your system that you would like to import and then click on the Open button.

6. Verify the student details displayed on this page and click the Import button to complete the updation process.

Note: Student data imported into Testwise from the .csv file will be coloured blue and considered updated, even if you have not made any changes to every student record.

Note: If the data has not passed the verification process, the Import button will change to 'Retry'. To correct the errors in the data:

a.  Identify exactly where the errors are by finding the fields highlighted in red within the data grid. Scroll through the full list of Students to find all the errors. The data that is missing or incorrect will have a red box around it. To find out more information about each error, hover your mouse over the red warning marker shown in the last column of the row.

b.  Open MS Excel (or the CSV editing software). Open the file containing the errors.

c.  Correct the errors in the file.

d.  Save your changes.

e.  Click the 'Retry' button.

f.  Repeat step 5 mentioned above.

7. Click Import if the changes highlighted in the summary are correct.

Note: If you are not happy with the changes in the summary page, you can simply edit the file again and re-upload.

8. Once your updated file has been processed, you will receive an email confirming that your file has been uploaded successfully. The following message will be displayed.

9. Now that you have received confirmation of your updates/import, you can go back to the Students List and check that the required changes have been made.

10. To return to the home screen, click on the Home button .