This article is available in: This topic is for IT personnel of your school. It requires basic software programming skills. Please see this topic for simpler way of importing data into aSc Timetables: aSc Timetables can import data from "aSc Timetables XML" file. You need to write your data into this format. There is a sample XML import file included in installation of aSc Timetables: c:\TimeTables\template\Import Samples\XML\import_basicdata.xml This XML file is quite simple and contains import of just very basic data about classes, subjects, teaches and classrooms. It is a good start with implementing export from you school's system into this format. Note: To create new timetable file from XML data, first click on "Create new timetable" and then go to menu - File - Import - aSc Timetables XML. Note2: you need to replace "MyApp" in first row with name of your system (use only letters/spaces). It is possible to enhance this import in two ways: 1) You can add new columns to existing tables in XML file Adding new columns into XML file In documentation (see link at bottom) you can find that column for class teachers is in table "classes" and it is called "teacherid". We have to add "teacherid" to list of columns in attribute columns="id,name" of XML node "classes". Also for each class we need to add teacherid="xxx" attribute. So the resulting XML might look like this (only classes part is shown here): Note: It is also possible to import up to 3 custom fields for teachers, classes, subjects and classrooms. In this case you have to also add name of custom fields to attribute options="". Example: Adding new tables into XML file In documentation (see link at bottom) you can find that there are several tables for this purpose. We will choose "classsubjects" table and import classes' subjects, their count per week and teacher. For this purpose, we have to add this section into XML:
This way you can enhance with any number of additional tables from list of all possible tables. Full list of supported tables and their columns can be found in documentation. Documentation Note: If you have some question regarding XML import, please write to support@asc.sk See also: Export to XML
This article was viewed 176219 times.138442 / 176219
|