Export to csv

[Frans]

Dear Volker

In the data and timetable fet file the sizes for subjects are indicated. Is it not possible when export to csv file to also export the group and/or subject sizes.

In some institutions the group and subject size are important in calculating workloads and ftes for lecturers.

The groups with the respective sizes are already exported but this is not always the same for all subjects as the number of students can be changed on the add activities page and this is not exported.

Frans

[Volker Dirr]

I am not 100% sure if i understood correct.
So please sent me a minimal fet sample file (just a few/firstfull activities) and the expected csv export.

[Frans]

At the moment the exported Activities csv file looks like this (Example):

Students Sets   Subject                               Teachers   Activity Tags   Total Duration   Split Duration   Min Days   Weight   Consecutive
RTM3A(CR)   RBusMan3.RBM300SR   AA   Retail                  4                  4         
RTM3A(CR)   BusMan3.ONB303SR   BB   Retail                  4                  4         

I want to know if the following is possible:

Students Sets   Nr. Students   Subject                                Teachers   Activity Tags   Total Duration   Split Duration   Min Days   Weight   Consecutive
RTM3A(CR)   100                  RBusMan3.RBM300SR   AA   Retail                  4                  4         
RTM3A(CR)   120                  BusMan3.ONB303SR   BB   Retail                  4                  4         

Although it is the same group the numbers for different subjects differ. I noticed that these figures are available in the data and timetable fet file.

Thank you very much

Regards

Frans

[Frans]

Volker

Sorry about the spacing.

Regards

Frans

[Volker Dirr]

Are you talking about official FET or the custom mapr version?

[Frans]

Volker

I am talking about the Official Fet.

Regards

Frans

[Volker Dirr]

hmmm... for the official version... but that data is not included in the official version.
but maybe i misunderstood. How does your fet file with that example look like?

[Frans]

This is a part from the fet file saved in the same folder as the html timetables, on Windows 7 in the Users folder:

<Activities_List>

<Activity>
   <Teacher>AA</Teacher>
   <Subject>BusMan3.ONB303SR</Subject>
   <Activity_Tag>Retail</Activity_Tag>
   <Students>RTM3B(CR)</Students>
   <Duration>4</Duration>
   <Total_Duration>4</Total_Duration>
   <Id>340</Id>
   <Activity_Group_Id>0</Activity_Group_Id>
   <Number_Of_Students>75</Number_Of_Students>
   <Active>true</Active>
   <Comments></Comments>
</Activity>
.
.
.
.
.
.</Activities_List>


Regards
Frans

[Volker Dirr]

ahh.. Sorry... i was a bit blind.
Export will be easy to code.
Import of that will be a bit tricky.
I must code both.
I will write it into my TODO. I can't tell you how long i need, because there are other things i must do first.

[Frans]

Volker
Thank you very much, much appreciated. (I am not worried or interested about the import, probably to you it will be very important. These figures change quarterly and must anyway be entered manually.)

The student numbers are very important as the institution use this for calculating workloads for teachers and lecturers.

Kind regards.

Frans

[Volker Dirr]

Ok. Like i said: Export is easy. I coded that.
You just need to unzip the attached file, replace the export.cpp file in fet -> src -> engine
and compile fet.

But we can't release that in the official version, because it also need the same file format for import. But modifying the import will take at least 1 day coding (i fear even a bit more). I can't do that now. Too much other stuff to do.

[Frans]

Volker

Thank you.

I do not know C or C++ but it is probably now a good time to start looking at it.

I will download and see what I can do.

Kind regards.

Frans