D. Base Timetable Import

Description:

 

This file holds the school timetable, staff and room allocations.

Note that this import must be a .csv (Comma delimited) file with no headers for import.

Field Name

Data Type

Length

Required / Optional

Field Explanation (If Required)

DayNumber

Integer

-

Required

 

PeriodNumber

Integer

-

Required

 

ClassCode

Text

20

Required

 

Room

Text

10

Optional

 

SchoolStaffCode

Text

10

Optional

Should be a valid SchoolStaffCode as entered from Staff Import and matching the timetable teacher code.

SchoolCampus

Text

10

Optional for single Campus configured Schools

Required for Schools that have a timetable group shared across multiple campuses.

The campus code as defined by the campus maintenance module.

 

Example

1,1,"07PAS1GO","7D3","BAM"
1,1,"12MEN104","I1.34","SJD"
1,1,"08PAS1BL","8D2","CIB"
1,1,"11MEN111","I2.10","SNB"
1,1,"11MEN110","I2.62","CJD"
1,1,"10MEN112","I2.53","MYY"
1,1,"08PAS1PU","","KZF"
1,1,"10MEN107","I2.18","PJU"
1,1,"11MEN102","I2.16","GMK"
1,1,"09PAS1MA","L1.09","NJM"
1,1,"11MEN106","I2.60","SXX"
1,1,"11MEN105","I1.42","SDM"
1,1,"12MEN110","I1.66","STM"
1,1,"09PAS1YE","L2.08","MMA"
1,1,"12MEN111","I1.17","NPW"
1,1,"09PAS1GO","L1.05","CXC"
1,1,"07PAS1GR","","RPS"
1,1,"10MEN106","I1.64","RJC"
1,1,"12MEN102","I1.14a","RWM"
1,1,"09PAS1BL","L1.03","PFN"
1,1,"07PAS1NA","7M2","BMJ"
1,1,"10MEN115","I2.29","JPF"
1,1,"11MEN112","I2.11","LEC"
1,1,"08PAS1RE","8R1","ETP"
1,1,"12MEN108","I1.23","HKW"
1,1,"11MEN113","P1.02","TML"
1,1,"08PAS1MA","8M1","JKD"
1,1,"10MEN110","I1.48","DLH"
1,1,"08PAS1AQ","8D1","JYD"
1,1,"12MEN114","I1.16","EAR"
1,1,"11MEN109","I2.13","SAH"
1,1,"09PAS1NA","L1.01","ERC"
1,1,"09PAS1RE","L2.04","KXB"
1,1,"08PAS1NA","8M2","LAT"
1,1,"07PAS1AQ","7D1","KLG"