WebTess can import data from any plain text comma-separated (CSV) or tab-delimited (TXT) file. If you have a file in Excel or Google Sheets, you can export the file into either CSV or TXT form.
You can import student data, including addresses, phone numbers and emails, and register new students.
You can import courses, master schedules, student course requests and schedules.
And you can import mark data into classes.
Column headings
In order to import data, WebTess must match up the columns in the files with the data fields in WebTess. There are a set of standard column headings for student data, address, courses, schedules, master schedules and grades. Generally, the columns can be in any order, and you can exclude columns you don’t use. For each standard column heading there are a set of alternates which will also be recognized. Spaces are optional, column headings can be upper or lowercase.
For example:
| Standard heading | Alternates |
| Student ID | Student #, Student Number, Student Num, Student ID#, St ID, St #, St Number, St Num, St ID#, Local ID, Local #, Local Number, Local Num, Local ID#, ID, #, ID#, ID Number, ID Num, Number, Num |
| Gender | Sex |
| Birth date | Birth, Birthday, Date of birth, DOB |
| First name | First, Given name, Given, Usual first name |
| Middle name | Middle, Middle Initial, Initial, Usual middle name |
| Last name | Last, Surname, Family name, Usual last name |
| Foreign name | National name, Foreign, National, Foreign language name, National language name |
| Legal first name | |
| Legal middle name | |
| Grade | Grade level, Gr, Grd, Grd level, Grade lvl, Gr Lvl, Gr level |
| Homeform | Homeroom, Home, Hmrm, Hmfm, Homeroom #, Home #, Hmrm #, Hmfm #, Division, Div, Division #, Div # |
| External number | External ID, External #, Ext Num, Ext ID, Ext #, Ext ID#, PEN, Student PEN, PEN # |
| Registration date | Reg date |
| Phone number | Phone #, Phone Num, Phone |
| Email address | Email add, Email, E-mail address, E-mail addr, E-mail |
| Address | Contact, Parent, Parent/Guardian |
| Street address | Street |
| City | Town, Village, Municipality |
| Province | Prov, State, District, County, Prefecture, Region |
| Country | Cntry, Cntr |
| Post/Zip | Post, Postal code, Zip code, Zip |
Example:
Student ID Gender First name Last name Grade Birthdate Ext num
981234 M Heronymous Ponsonby 12 17-JAN-2011 9213101234
90210 F Miller Stephanie 11 7-FEB-2012 9245190210
98109 M Alberto Einstein 11 10-OCT-2012 9211298109
Importing courses into WebTess
To import courses, use a CSV or TXT file with these columns:
| Standard heading | Alternates |
| Course number | Course #, Course num, Crs number, Crs, Crs #, Crs num |
| Course name | Crs name |
| Course type | |
| Class limit | |
| Class limit | |
| Number of terms | |
| Number of days | |
| Number of periods | |
| Ministry code | |
| Ministry level | |
| Ministry type | |
| Course description |
The course number must be unique. If it matches an existing course number in WebTess, the data will replace the existing course.
Example:
Course number Course name Ministry Code Ministry Level
EN10 English 10 EN 10
MA10 Math 10 MA 10
PHYS10 Physics 10 PHYS 10
Importing student schedules (classes) into WebTess
To import student schedules, use a CSV or TXT file with these columns:
| Standard heading | Alternates |
| Student ID | Student #, Student Number, Student Num, Student ID#, St ID, St #, St Number, St Num, St ID#, Local ID, Local #, Local Number, Local Num, Local ID#, ID, #, ID#, ID Number, ID Num, Number, Num |
| Course number | Course #, Course num, Crs number, Crs, Crs #, Crs num |
| Section number | Section #, Section, Sec number, Sec, Sec #, Sec num |
Example:
Student ID Course number Section number
981234 EN10 1A
981234 MA10 2
981234 PHYS10 1
90210 EN10 1A
90210 MA10 1
90210 PHYS10 1
Important: the course and section must exist in WebTess. The course number and section number are used to match with existing data in the master schedule.
Importing the master schedule into WebTess
To import the master schedule, use a CSV or TXT file with these columns:
| Standard heading | Alternates |
| Course Number | Course #, Course num, Crs number, Crs, Crs #, Crs num |
| Course Name | Crs name |
| Section Number | Section #, Section, Sec number, Sec, Sec #, Sec num |
| Period | Pd |
| Day | Dy |
| Term | Tm |
| Room Number | Room #, Room num, Room, Rm |
| Teacher Name | |
| Teacher Initials | |
| Teacher Number | Teacher ID, Teacher #, Teacher Num, Teacher ID#, Teacher Immutable ID Tchr Number, Tchr ID, Tchr #, Tchr Num, Tchr ID#, Staff Number, Staff ID, Staff #, Staff ID# |
Example
Course number Course Name Section Number Period Day Term Teacher Number Teacher Name
EN10 English 10 1A A 1 12 24 Mr Smith
EN10 English 10 2 C 1 12 22 Dr E. Parishmen
MA10 Math 10 1 D 1 12 37 Dr Parjeet
MA10 Math 10 2 E 1 12 37 Dr Parjeet
MA10 Math 10 3 G 1 12 37 Dr Parjeet
Important: the course should already exist in WebTess. If the section does not exist, it will be created automatically.
Import marks into classes in WebTess
Marks can imported directly into a teachers class lists under
Grades, Enter data by teacher
– select the class, then go to Spreadsheets, Import Class Marks
To import marks, use a CSV or TXT file with these columns:
| Standard heading | Alternates |
| Student ID | Student #, Student Number, Student Num, Student ID#, St ID, St #, St Number, St Num, St ID#, Local ID, Local #, Local Number, Local Num, Local ID#, ID, #, ID#, ID Number, ID Num, Number, Num |
| Student name | |
| Gender | Sex |
| External number | External ID, External #, Ext Num, Ext ID, Ext #, Ext ID#, PEN, Student PEN, PEN # |
| Mrk | Mark, Mk, LG |
| Wrk | Work, Wk, Wh, Work habit, Work habits |
| Att | Abs, Ab, Absences, Attend, Attendance |
| Com1 | Comment 1, C1, 1st comment, 1st com, Com, Comment, Comments |
| Com2 | Comment 2, C2, 2nd comment, 2nd com |
Example:
Student ID Mrk Wrk Att Com1 Com2
981234 87 G 1 44 21
90210 96 G 0 “This is a comment” “2nd comment”
98109 C+ S 2 31 "This is another comment"