Extracting Students Timetables

[sutton2007]

Hi

 

I have been requested to fnd out if i can extract timetables from cmis for students and display thier timetable within sharepoint for our vle. I know that serco do webparts for this but id rather try and extract the information via sql and display the timetable maybe using a php page. Ive looking at the tables and can see where information is stored yet its a mess tbh .

has anyone done this ? or can help me achieve this i would be extremely greatful

 

Steve

[AndyCope]

I think you will find that eportal already does this....

[sutton2007]

I think you will find that eportal already does this....

 

we have eportal. the idea is to have the timetable on sharepoint

[kylewilliamson]

roughly, cmis's timetable structure works like this:

 

event specs are created - these can overlay depending on year group, etc; generally they wouldnt - most schools would have one! -> this would be used however, if you have different finish/start/break times for different year groups

 

students are members of a teaching group (STUGROUPS i think);

teaching group events are set on the timetable (TIMETABLE) - each event is allocated a LecturerId (see LECTDETS) - generally this refers to length, number of periods, roomings and week/time

 

Facility works on a week by week basis. There is a table (i cant recall it) that defines what week a certain day is in - and therefore you need to look that up first.

 

Hope that makes sense.

Kyle

[sutton2007]

thanks that does help a bit, but what i am finding difficult is getting a list of lessons for the student for the day, this is what im aiming first to output.

 

id like it to output like this

 

Timetable for 10/03/2008

Time Subject Room Group Code

10:00 Design and Technology T805 08C-DT1

11:30 Design and Technology RS82 08C-DT1

12:30 Design and Technology T083 09J-TE4

13:30 Design and Technology T083 09J-TE4

[limbo]

This is absolutely possible - I know becase we do it in our using SQL and asp.

 

But it is reliant on your Data in CMIS being totally up to date and accurate.

 

By this I mean it will only pull out things like the subject name if the module in CMIS has been named properly and linked properly, and the student is only in one group at a time etc. And is more complicated if you have things like two week timetable or rotations over several weeks.

 

How far have you got?

[sutton2007]

i havent got very far at all tbh, im finding it difficult just finding the data in sql i want and outputting it. our data in cmis is uptodate and we only have 1 week timetabling so i dont think i have any problems there. I could also do it in asp, have you any code you could share at all or could point me in the right direction on where to start ?

 

I have found the timetable table which i have filtered for the student and dataset i require but i am getting all the lessons for the student in the whole year, i cannot find the table to link to , to filter for the day and only this week!!

Edited March 10, 2008 by sutton2007

[rpwillis]

I know Twynham school in Dorset has done this. There's a link to a document which describes their SharePoint set up at

http://www.sharepointblogs.com/ajp/archive/2008/02/19/examplar-sharepoint-site-in-education-using-sql-2005-reports-in-moss.aspx

 

I think Dave Coleman would be happy to speak to you about how they did it - his email is on the front page of the document.

 

Richard

[limbo]

Basically there are three tables you need to do this:-

 

MODULE, TIMETABLE and STUGROUPS

 

The module table is just used to display the module name from the moduleID field in TIMETABLE - so you can forget about that for now.

 

So the TIMETABLE and STUGROUPS are linked by the GROUPID field.

 

In the TIMETABLE table there is a weekday field which you can use to filter out the current day of the week (1 is Monday, 2 Tuesday etc.)

 

That should just display the five or so lessons of the day for that students based on the groups they are a member of at any given time.

[sutton2007]

Basically there are three tables you need to do this:-

 

MODULE, TIMETABLE and STUGROUPS

 

The module table is just used to display the module name from the moduleID field in TIMETABLE - so you can forget about that for now.

 

So the TIMETABLE and STUGROUPS are linked by the GROUPID field.

 

In the TIMETABLE table there is a weekday field which you can use to filter out the current day of the week (1 is Monday, 2 Tuesday etc.)

 

That should just display the five or so lessons of the day for that students based on the groups they are a member of at any given time.

 

excellent

 

thanks limbo that has really helped me, i now have returned the 5 lessons a day for a particluar student. now comes the fun part of the front end!!

 

thankyou

Edited March 10, 2008 by sutton2007

[limbo]

Make sure link all the fields by SETID as well as their relating fields - otherwise you get an entry for each dataset because things like the groupID and ModuleID are present identically in each dataset.