Export of Activities to CSv

[Volker Dirr]

oh.. you missunderstood. it doesn't constain a save option yet, i just want to know if that data is all you need.

so if i save the table heading (rows and columns) is that enough?
if it enough if i save the second and/or third row of the teachers column in a csv file?

i currentyl think about file formats with that information by this variants:

teacher name, students set, duration

example:
Mr. X,5a,4
Mr. X,7b,4
...

and a file like this:
students set|subject|duration

example
5a,math,4
5a,english,4
...

i think this are the most needed information, correct?
i know there are also other variants. i guess i will implement them, just to have all. filesize will be small.

i also think about variants with activity tags. but i think that it is maybe unneeded. it is needed in the activity planning form, i used it very wise there already.
but in a statistics csv file like the abouve one it is unneeded, i think. do you need information about activity tags in the statistics?

[Frans]

teacher name, students set, duration

example:
Mr. X,5a,4
Mr. X,7b,4

Yes this is what I need. This information is already available in the current CSV file, but the problem is that one does not know if all 4 hours are active or only 2 or whatever. That is my major problem and the reason for the original posting, but I understand that it will be difficult as explained by you.

students set|subject|duration

This I actually do not need. In our institution the same subject are offered in different department and diplomas. So to me this is of no interest, but if it is easy to add one can probably do that as some other users might be interested.

i also think about variants with activity tags.

This I also do not need.

What I need is quick info on:
Students Sets
Teachers and
Rooms.

Before setting the actual timetable I need the information on Teachers as explained in a previous posting for planning purposes and this is your first proposal namely:

teacher name, students set, duration

So if necessary Management make changes and the the timetable is set.

Upon obtaining a final timetabe I can use the corresponding (existing) CSV file.

Once again thank you for everything.

Frans

[Volker Dirr]

n about rooms is very difficult, because rooms are not calculated at that time and activities might have one out of a lot of possible rooms. so a rooms statistic is difficult to write.

please check one more time if it realy is enough information if you have:
teacher name, students set, duration
because the is no subject included.

if fear a bit also subject is needed to you, but there is a small problem, because there are different variants to export them.

example: you have a teamteaching activitiy with 2 student sets.
so the activity is teached by teacher T1+T2.
they teach students set S1+S2. subject is MATH.

no watch the advanced statistics.
you will see that logicaly this single activity is displayed TWO times in the matrixes.
so also exporting will give 2 lines.

so maybe a better variant is to export that only once.
the small problem if you have entered with intend two times the same activity. i must sum it. no problem so far. but if someone swap the teachers (or students), so maybe T2+T1 in on and in the other T2+T1, then i also need to care about that this is the same.

i just want to check every problem before i start coding.
so do you need also the subject?
if you need also the subject, what do you think is better: exporting 3 files like in the advanced statistics. (so a single team teaching activity is maybe "doubled" in several lines)
or only a single line. that mean of course i need to check for example that T1+T2 and T2+T1 is the same.

[Frans]

Dear Volker

Thank you so much for spending your time on this request. I really do not want you to do programming for only one person.

If the following will help to make thing clear:

I define the activities.
If necessary delelete and or make activities.

Before setting the timetable I must make a summary for Management so that they can establish if each lecturer has a fair load in comparison with orhers. So I must tell them:

T1 has say x number of students and y FET hours per week.

At our institution there are no minimum and maximum loads for a teacher or rather a lecturer. They just want to make sure that the workload is equally distributed.

n about rooms is very difficult

I agree, rooms only become important after the final timetable is set. Then we calculate percentage occupation and percentage utilization.

teamteaching activitiy

At our institution we seldom, if ever get where T1 + T2 teach the same group the same time (it is actually an impossible activity.) What happens here is that T1 for example teaches S1 and T2 teaches S2. It can or cannot be the same subject. Where both T1+T2 teach say S1 or S1+S2 as one group, then T1 teaches the students say for 8 weeks and then T2 takes over for the next say 6 weeks. (During the first 8 weeks it is possible that T2 can teach somewhere else). The time periods have not to be of the same length.

so do you need also the subject?

I'll have to think about this. At this moment it seems to me that it is not necessary but I am not 100% sure. I also do not want you to do unnecessay coding.

A quick answer it that you can only export once because as said your example above occurs seldom at our institution.

Kind regards.

Frans

[Volker Dirr]

i don't want to code only for you.
i want to get a solution that is useable for as many guys is possible. that is why i also want to think about what is needed if 2 or more teachers teach the same activity.

currently i think the last varinat (with subject and summed) is the best one, but let me (or others) think some more. the other variants are also logical, but without subject some guys maybe can't use it and also getting two lines for a single activity will confuse many guys. so i think last variant is best, even if i need to do some more checks, but let me think a bit more.

ps:
i didn't said rooms statistics is unneeded, i said only it is difficult. i can highly use a room statistics, because we have teacher home rooms and he have more teachers then rooms. so if we get a new teacher, he must share a room with an other teacher. if i have a room statistic (before generating), it will help to find a good room for the new teacher. but saidly it is difficult to code, so i haven't done that yet.