fet xml documentation

Started by lebwoski, May 16, 2012, 01:26:18 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

lebwoski

I,

i want to try to import datas from our school-database to fet. Is there somewhere an documentation for the .fet file? Especially for the constraints?

Thanks, Martin

Liviu Lalescu

No, unfortunately. Possibilities:

1) Make a file and add each constraint from the interface, or open the file translations/test-all-constraints.fet.

2) See the C++ code in timeconstraint.cpp and spaceconstraint.cpp, functions Constraint...::getXmlDescription(...).

yush

I have made a tool to convert my school's database to FET. It may be helpful to you. You can try it at:
http://fet2web.appspot.com/fet_upload/form

You need to update a csv file with specific format. I have attached a sample for you. Just ignore all the other inputs on the page. Choose your CSV then click submit.

A bit more explanation of the CSV:
sfkey = teacher
sukey = subject
class_ = Non-fet: class number to uniquely identify different class of the same subject (notice the _, I added it to avoid class as a reserved word)
dykey = day
prkey = period
yrkey = year
rmkey = room
block = Non-fet: multiple activities in the same block. Will automatically generate same day-time constraint for activities with the same block name. Also add a Tag - block:name
rgkeys = year group (we called it rollgroup in our school). Notice the "s", for you can put multiple groups separated by commas
fckey = Non-fet: faculty/department. Will create a Fet Tag in this format- fckey:MATH forexample
rotation = Non-fet: multiple teachers may rotate throughout the year for a set of classes. will add dummy teachers to activities to achieve that

You don't need all the fields, but the header is a must. The tool will also add all the necessary min-day between activities. min 1 day set at 100% for activities that are a set of >2, 2 days set at 99% for activities that are set of 2.

Double period is tricky. You have to specify 2 activities with say day and consecutive period (use numeric). the program will convert them to a double period with duration=2.

the program will gather all information and generate the rooms list, teachers list, etc.

You Probably need to manually edit the periods before using it, as the most timetable data don't have information about recess and lunch.