aSc Timetables API
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRST
1
TableColumnFormatExplanationChanges
2
globals
3
globalnametextmenu-Specification-Basic data-Name of the school
4
globalshorttext (export)registration name
5
globalcustomfield1
customfield2
...
textCustom fields. Used together with table option "customfieldX:MyFieldName"
6
7
8
teachers
9
teacheridid
10
teachernametext
11
teachershorttext
12
teachercustomfield1
customfield2
...
textCustom fields. Used together with table option "customfieldX:MyFieldName"
13
teachergenderchar'M' - male, 'F' - female
14
teachercolorhtmlcolor
15
teacheremailtextsince 2010.?.?
16
teachermobiletextsince 2010.7.5
17
teachertimeofftimeoff
18
teachersubjectidsidsApprobation (used in aSc Substitutions)2008 - removed from UI by default
19
teacherhtmlexportlinktext (export)
20
teacherascttorderint (export)
21
22
23
classes
24
classidid
25
classnametext
26
classshorttext
27
classcustomfield1
customfield2
...
textCustom fields. Used together with table option "customfieldX:MyFieldName"
28
classteacheridid
29
classclassroomidsids
30
classtimeofftimeoff
31
classclassleveltextdeprecated, use grade or gradeid instead
32
classgradeintupcoming feature, see table grade
33
classgradeididupcoming feature, see table grade
34
classhtmlexportlinktext (export)
35
classascttorderint (export)
36
37
38
classrooms
39
classroomidid
40
classroomnametext
41
classroomshorttext
42
classroomcustomfield1
customfield2
...
textCustom fields. Used together with table option "customfieldX:MyFieldName"
43
classroomcapacityint or special* - udenfined2009 - added
44
classroomtimeofftimeoff
45
classroomhtmlexportlinktext (export)
46
classroomascttorderint (export)
47
classroombuildingidid* - no building specifiedsince 2015, readonly
48
49
50
subjects
51
subjectidid
52
subjectnametext
53
subjectshorttext
54
subjectcustomfield1
customfield2
...
textCustom fields. Used together with table option "customfieldX:MyFieldName"
55
subjecttimeofftimeoff
56
subjectascttorderint (export)
57
58
59
students
60
studentidid
61
studentnametextDeprecated, please use firstname/lastname if possible.
62
studentfirstnametext
63
studentlastnametext
64
studentnumbertext
65
studentcustomfield1
customfield2
...
textCustom fields. Used together with table option "customfieldX:MyFieldName"
66
studentgenderchar'M' - male, 'F' - female
67
studentclassididThis field is required. Each student must belong to some class.
68
studentgroupidsidsGroups to which thsi student is assigned, "Entire class" is excluded.since 2012.9.1
69
studentgroupnamestextSame as groupids, but this is comma separated list of names.since 2012.9.1
70
studentemailtextsince 2010.?.?
71
studentmobiletextsince 2010.7.5
72
73
studentsubjectsStudents' choices of seminars (see "Student" dialog)
74
studentsubjectstudentidid
75
studentsubjectsubjectidid
76
studentsubjectseminargroupint or special'-' - if unassigned
77
studentsubjectseminargrouptermoverridespecialComma separated list of changed groups, e.g. "-,-,2,-" means change group to 2 in term 3. Export only.
78
studentsubjectimportanceimportance
79
studentsubjectalternateforidIf this is alternative to some other subject, this is id of that subject and importance field must contain 'alternative' value
80
studentsubjectlockedcharblank if group is unassigned. '0'/'1' for unlocked/locked group
81
82
83
groupsNote: Import/export of groups is generally DISCOURAGED, because there is usually different meaning of “group” in aSc Timetables and various SMS systems. Usually it is not possible to simply map aSc Timetables groups to SMS groups.
However we have implemented some system to handle required conversions here. This system partially works for simple import of SMS data and for export of lessons after that, but if user makes some changes in aSc Timetables to groups, so that manual mapping of aSc Timetables groups to SMS groups is required, it may be too complicated for user to handle it in synchronization dialog.
84
groupididfor groupstype1
85
groupclassididRequired for type 1
86
groupclassidsidsRequired for type 2
87
groupnametext
88
groupentireclasschar'1' - entire class, '0' - part of division
89
groupdivisiontagtext (import)During import, groups with the same tag form new division. Note that imported value is not stored in timetable file, it is used only to form divisions.
90
groupascttdivisiontext (export)Similar to divisiontag, only this is value sent from aSc Timetables to database. Groups from the same division in aSc Timetables will have equal value for this column.
See note 3 below.
91
groupstudentcountint or special (export)blank value if unknown
92
93
There are two general grouping types supported. You have to specify which type you use in database options.
• GROUPSTYPE1 - Use same grouping system as in aSc Timetables. Each group belongs to just one class, there is also group for entire class. One lesson can be linked to multiple groups.
• GROUPSTYPE2 - Database group can belong to multiple classes. One lesson is linked to exactly one group.
94
Note 1: Instead of using ASCDBCOLUMN_CLASS_IDS to specify classes, you may use ASCDBTABLE_GROUP_CLASS table.
Note 2: It is highly recommended to send ENTIRE_CLASS=1 information if possible. Otherwise user will have to link manually entire class groups in aSc Timetables to entire class groups in your database during import. For other groups please send us ENTIRE_CLASS=0 if you are sure that your group does not contains all students from class, or otherwise leave it blank (empty string).
Note 3: We plan to change grouping system in aSc Timetables in some of future versions, so this column may not contain correct value in future versions.
95
96
lessonsMaps directly to lessons in aSc Timetables
97
lessonidid
98
lessonsubjectididrequired for import
99
lessongroupidsidsfor groupstype1
100
lessongroupididfor groupstype2
Loading...