aSc Timetables API

	A	B	C	D	E
1	Table	Column	Format	Explanation	Changes

2	globals
3	global	name	text	menu-Specification-Basic data-Name of the school
4	global	short	text (export)	registration name
5	global	customfield1 customfield2 ...	text	Custom fields. Used together with table option "customfieldX:MyFieldName"
6
7
8	teachers
9	teacher	id	id
10	teacher	name	text
11	teacher	short	text
12	teacher	customfield1 customfield2 ...	text	Custom fields. Used together with table option "customfieldX:MyFieldName"
13	teacher	gender	char	'M' - male, 'F' - female
14	teacher	color	htmlcolor
15	teacher	email	text		since 2010.?.?
16	teacher	mobile	text		since 2010.7.5
17	teacher	timeoff	timeoff
18	teacher	subjectids	ids	Approbation (used in aSc Substitutions)	2008 - removed from UI by default
19	teacher	htmlexportlink	text (export)
20	teacher	ascttorder	int (export)
21
22
23	classes
24	class	id	id
25	class	name	text
26	class	short	text
27	class	customfield1 customfield2 ...	text	Custom fields. Used together with table option "customfieldX:MyFieldName"
28	class	teacherid	id
29	class	classroomids	ids
30	class	timeoff	timeoff
31	class	classlevel	text		deprecated, use grade or gradeid instead
32	class	grade	int		upcoming feature, see table grade
33	class	gradeid	id		upcoming feature, see table grade
34	class	htmlexportlink	text (export)
35	class	ascttorder	int (export)
36
37
38	classrooms
39	classroom	id	id
40	classroom	name	text
41	classroom	short	text
42	classroom	customfield1 customfield2 ...	text	Custom fields. Used together with table option "customfieldX:MyFieldName"
43	classroom	capacity	int or special	* - udenfined	2009 - added
44	classroom	timeoff	timeoff
45	classroom	htmlexportlink	text (export)
46	classroom	ascttorder	int (export)
47	classroom	buildingid	id	* - no building specified	since 2015, readonly
48
49
50	subjects
51	subject	id	id
52	subject	name	text
53	subject	short	text
54	subject	customfield1 customfield2 ...	text	Custom fields. Used together with table option "customfieldX:MyFieldName"
55	subject	timeoff	timeoff
56	subject	ascttorder	int (export)
57
58
59	students
60	student	id	id
61	student	name	text		Deprecated, please use firstname/lastname if possible.
62	student	firstname	text
63	student	lastname	text
64	student	number	text
65	student	customfield1 customfield2 ...	text	Custom fields. Used together with table option "customfieldX:MyFieldName"
66	student	gender	char	'M' - male, 'F' - female
67	student	classid	id	This field is required. Each student must belong to some class.
68	student	groupids	ids	Groups to which thsi student is assigned, "Entire class" is excluded.	since 2012.9.1
69	student	groupnames	text	Same as groupids, but this is comma separated list of names.	since 2012.9.1
70	student	email	text		since 2010.?.?
71	student	mobile	text		since 2010.7.5
72
73	studentsubjects			Students' choices of seminars (see "Student" dialog)
74	studentsubject	studentid	id
75	studentsubject	subjectid	id
76	studentsubject	seminargroup	int or special	'-' - if unassigned
77	studentsubject	seminargrouptermoverride	special	Comma separated list of changed groups, e.g. "-,-,2,-" means change group to 2 in term 3. Export only.
78	studentsubject	importance	importance	'low', 'normal', 'high', 'strict', 'optimize', 'alternative', 'disabled'
79	studentsubject	alternatefor	id	If this is alternative to some other subject, this is id of that subject and importance field must contain 'alternative' value
80	studentsubject	locked	char	blank if group is unassigned. '0'/'1' for unlocked/locked group
81
82
83	groups			Note: 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	group	id	id	for groupstype1
85	group	classid	id	Required for type 1
86	group	classids	ids	Required for type 2
87	group	name	text
88	group	entireclass	char	'1' - entire class, '0' - part of division
89	group	divisiontag	text (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	group	ascttdivision	text (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	group	studentcount	int 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	lessons			Maps directly to lessons in aSc Timetables
97	lesson	id	id
98	lesson	subjectid	id	required for import
99	lesson	groupids	ids	for groupstype1
100	lesson	groupid	id	for groupstype2