Sonia Student importer
Sonia provides the ability to import student personal and enrolment information from an existing Student Record System. This process eliminates the need for manual data entry of student details, removes the risk of duplicate entries and ensures that Sonia always stores the most current personal and enrolment details for a student, as recorded in the Student Record System.
The Sonia Student Importer can be scheduled to run nightly (configurable) to ensure that the student details within Sonia are always the most current.
The Sonia Student Importer provides the ability to import data from a variety of sources including Microsoft SQL Server databases, Oracle databases and flat files. The data sources and the format of the data being imported are specified in a configuration file, allowing the Sonia Student Importer to adapt to any data source and format changes that may occur over the lifecycle of the application without the need for redeploying an updated version of the application.
Mandatory Fields
Below are the mandatory Fields that are required to be imported from the Student Record System. For further information please download the Student Importer Manual
|
Field Name |
Data Type |
Max. Size |
Description |
Example(s) |
|
Student Code |
Text |
50 |
Student’s unique code within the organisation |
S12345678 |
|
First Name |
Text |
250 |
Student’s first name |
Donald |
|
Last Name |
Text |
250 |
Student’s last name |
Duck |
|
Display Name |
Text |
850 |
A preformatted representation of the student’s name that the Sonia Student Importer can break down into Salutation / First Name / Middle Name / Last Name |
Duck, Donald Fauntleroy |
|
School Name |
Text |
500 |
The name of the school that the student belongs to |
School of Computer Science |
|
Subject Code |
Text |
50 |
The unique code for the subject that the student is enrolled in |
COMP1001 |
|
Subject Name |
Text |
400 |
The name of the subject that the student is enrolled in |
Introduction to Computers |
|
Semester Name |
Text |
400 |
The semester of enrolment for the current student subject |
Semester 1 |
|
Year |
Text |
10 |
The year of enrolment for the current student subject |
2011 |
|
User Name |
Text |
100 |
The student’s network username, which is used to provide access to Sonia Online |
unidomain\d.duck |
Comments
0 comments
Please sign in to leave a comment.