Please enable JavaScript to view this site.

thankQ Help

Navigation: IMPORT DATA EDI > Schools

Create the Schools Import Spreadsheet

Scroll Prev Top Next More

The various worksheets can be imported. The information in the following spreadsheets has been setup to cause validation errors for training purposes.

When entering IDs and codes do not use the thankQ id’s, use a made up number and the import will convert that to the next number for that particular code/id in thankQ.

School Subjects:

DATAIM~1_img59

School Terms:

DATAIM~1_img60

School Holidays:

DATAIM~1_img61

Term Holiday:

DATAIM~1_img62

School Classes:

(Class Year should be the Grade Year e.g. 12)

DATAIM~1_img63

Class Terms:

DATAIM~1_img64

Class Objectives:

(Class Objective Subject Code = School Subject e.g. ES00001)

DATAIM~1_img65

Class Schedule:

(Class Schedule Class ID is a mandatory field e.g. EC000001)

DATAIM~1_img66

Class Teacher:

(Designation must match lookup values e.g. Primary, Secondary, Substitute)

(Student Teacher Supporter ID is not required)

DATAIM~1_img67

Class Student:

DATAIM~1_img68

Class Results:

DATAIM~1_img69