+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, Extracting Students Timetables in Technical; Hi I have been requested to fnd out if i can extract timetables from cmis for students and display thier ...
  1. #1

    Join Date
    Oct 2007
    Location
    Essex
    Posts
    9
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Extracting Students Timetables

    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

  2. #2

    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    50
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    I think you will find that eportal already does this....

  3. #3

    Join Date
    Oct 2007
    Location
    Essex
    Posts
    9
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by AndyCope View Post
    I think you will find that eportal already does this....
    we have eportal. the idea is to have the timetable on sharepoint

  4. #4

    Join Date
    Jan 2007
    Posts
    424
    Thank Post
    7
    Thanked 32 Times in 27 Posts
    Rep Power
    21
    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

  5. Thanks to kylewilliamson from:

    sutton2007 (10th March 2008)

  6. #5

    Join Date
    Oct 2007
    Location
    Essex
    Posts
    9
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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

  7. #6
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25
    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?

  8. Thanks to limbo from:

    sutton2007 (10th March 2008)

  9. #7

    Join Date
    Oct 2007
    Location
    Essex
    Posts
    9
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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!!
    Last edited by sutton2007; 10th March 2008 at 09:50 AM.

  10. #8
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    182
    Thank Post
    50
    Thanked 63 Times in 51 Posts
    Rep Power
    26
    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/a...s-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

  11. Thanks to rpwillis from:

    sutton2007 (10th March 2008)

  12. #9
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25
    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.

  13. 2 Thanks to limbo:

    mark80 (10th March 2008), sutton2007 (10th March 2008)

  14. #10

    Join Date
    Oct 2007
    Location
    Essex
    Posts
    9
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by limbo View Post
    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
    Last edited by sutton2007; 10th March 2008 at 01:02 PM.

  15. #11
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Extracting data automatically from CMIS
    By danIT in forum MIS Systems
    Replies: 39
    Last Post: 26th March 2010, 08:13 PM
  2. Extracting data from an MIS
    By MikeBostock in forum MIS Systems
    Replies: 76
    Last Post: 27th February 2008, 09:18 PM
  3. Exporting Timetables/Reports to the Web
    By Pumaedition in forum Windows
    Replies: 1
    Last Post: 30th November 2007, 10:33 AM
  4. SIMS.NET Timetables
    By BadComputerDay in forum MIS Systems
    Replies: 0
    Last Post: 2nd October 2006, 08:24 PM
  5. Replies: 32
    Last Post: 25th July 2005, 07:17 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •