Manually Importing Students into Sonia

Manually import students into Sonia in bulk any time using the Student Import Template and the in-client Student Importer. 

The template can be downloaded from the Students module > Import tab.

NOTE: Not all fields on the template are mandatory. To see which fields are mandatory as well as an explanation of each field, download the "Student Template Tips" document at the bottom of this article. 

You can also use this feature to update current students' records (e.g., Subject, Course). If students on the template are already in Sonia, Sonia will match the student's Code (usually their Student ID) in the import template to the student's Code on their profile to avoid duplicate profiles.

IMPORTANT

• The placement officer performing this task must have "can import students" permission assigned via School Options.
• Do not add or remove any columns.
• ENSURE THE FILE DOES NOT CONTAIN COMMAS, as the file is csv format, and commas will shift the data to the wrong fields.

Preparing the Import

• Ensure the Student Import template contains data in at least all required fields:
  • Student Code, First Name, Last Name, Subject Code/Name, Semester, Year, Study Mode, Subject Status
• Save the file as a CSV (comma-delimited) file type.
• Ensure the file is closed on your machine.

Importing Students

1. On the Home tab, click the Students module at the far left of the ribbon.
2. In the Students module, click the Import tab at the top left.
3. Click the Open button to browse for and select your csv file. The data from the file selected will display on the Import page.
4. If Sonia finds no errors in the data, four green checkmarks will appear on the ribbon.
5. If Sonia does find errors, an orange triangle will display.
   1. Click the Find Next Error button to find the errors in the data.
   2. The errors are identified by a large red oval.
   3. Most errors can be resolved on the Import page; however, in some cases, the errors need to be resolved on the original data file and then re-imported.
6. Once the data is deemed valid, click the Import Into Sonia button.
7. Select ‘Yes’ in the pop-up to begin the import.

After the Import

• If the import was successful, close the Students module and re-open to find the new/updated students.

Additional Info

SoniaGuide-ManuallyImportingStudents.pdf
Student Template Tips.docx
Student Import Template.xlsx