To import data, go to Settings > Import.
1. Download the template
2. Input or copy and paste your data into the excel. Here are some general guidelines :
- 1. The import file should be in .xlsx format
- 2. All the cells in the excel data file should be in TEXT format (NOT date, boolean etc).
- 3. The header of excel MUST be the same as the template
3. Upload your template.
Note on student data:
Field | Note | Format |
***Display Name (Required) | The display name is displayed in timetable and receipt | TEXT |
***Student Number (Required) | TEXT | |
Gender | M or F | |
Date of birth | YYYY-MM-DD (TEXT) | |
Major communication email | xxxx@yyyy.zzz | |
Receive Promotional Email | If this is set to false, the parent will be opt out from email / app communication | true or false (Text) |
Contact 1 Email | xxxx@yyyy.zzz | |
Contact 2 Email | xxxx@yyyy.zzz | |
Enrollment Date | For record only | YYYY-MM-DD (TEXT) |
Quit Date | For record only | YYYY-MM-DD (TEXT) |