SELMA SISResource CentreResource Centre
support@selmasis.comAU +61(0)7 3103 9873 / NZ +64(0)9 366 0789

Updated on

The CSV Importer

Upload CSV files of different types, using our file importers, which will then be saved as a SELMA record.

Upload CSV files of different types, using our file importers, which will then be saved as a SELMA record.

Read on to find the information you need to upload valid CSV files.



The Importer: Explained

You can import CSV files for the following data types:

  • Student
  • Grades
  • Class
  • Enrolment Class Link
  • Timetable

The figures in subsequent sections will show the Student Importer, as it is widely used, but the principles can be generalised and applied to all importing types.


Download Templates

Download the following templates for each import you require:

Student

Student Import Template

Grades

Grades Import Template

Class

Class Import Template

Enrolment-Class Link

Class Enrolment Import Template

Timetable

Attendance Timetables Import Template


Pre-Requisites and Upload

Please take note of the following steps, before filling out your CSV template.

  • Note: Required CSV columns are provided to you within the provided template.
Navigate to Reports > Import
Navigate to Reports > Import
Select an Import
Select an Import

Please download the appropriate template (above) and read the following notes before filling it out. Then, upload the CSV file to the Importer.
Important Notes:
All dates must be in YYYY-MM-DD format. Please make sure your user preferences are updated if you are using Microsoft Excel.
Status Codes: E - Enquiry | V - Validated | N - Enrolled | P - Provisional | I - Inactive

Screenshot: Figure 3. Create New Records or Update Existing Records
Figure 3. Create New Records or Update Existing Records

If your validation hasn't picked up on any errors in your CSV file, you can proceed to import it into SELMA by clicking the green "Start Import" button.

Screenshot: Figure 4. Start Import
Figure 4. Start Import
Success Message
Success Message

Validation Errors

When you validate your CSV file, you may get validation errors which you can correct, directly.
You must resolve these errors before you can complete the importing process.

If you have any validation errors, you can correct them directly, and revalidate the file.

Screenshot: Figure 6. Validation Errors
Figure 6. Validation Errors

Last updated

Was this page helpful?

On this page