Column in CSV for "Year" import: "Home room"

[Diego Froner]

Hi guys.

I use the import of CSV files too often because all my planning is made in Excel. One step of this planning is to choose a home room for some classes. So, after all the imports, i have to set a home room for about 350~400 classes manually.

My suggestion is to add a "column" in CSV for import "years, groups and subgroups" named "home room" which would be optional. It would automatically add the respective "A set of students has a home room" constraint.

Example:

Year ; Number of Students ; Home Room
ClassA ; 10 ; Room 01

This example will set "Room 01" as the home room for "classA" which has 10 students.

If this is not a very expensive thing to develop, I will bring more suggestions of this kind in the future.

Thanks for listening. I would like to congratulate you for this great tool.

[Liviu Lalescu]

Hello,

Thank you for the appreciation!

I do not like the idea, because it mixes students with constraints. You could add the constraints from the Excel file to a .fet XML format (see how the constraints do look like).

But I will add your suggestion in the TODO.

[Volker Dirr]

Liviu, please don't forget 2 more ponits:
a) we need to stay at the old csv file format, since several other projects already use it. So changes might be very critical in that file format
b) we should add all constraints in that files (not only home rooms). Similar to teachers and rooms.
c) Because a) and b) conflict each other we should add a second csv file format.

[Liviu Lalescu]

OK, Volker, I added also your words in the TODO.

[Diego Froner]

Thank you guys