+ Post New Thread
Page 2 of 7 FirstFirst 123456 ... LastLast
Results 16 to 30 of 103
Virtual Learning Platforms Thread, SIMS Timetable Module for Moodle in Technical; Thanks Gatt - appreciate all the help guys and to the shopkeeper for making something like this available in the ...
  1. #16

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    Thanks Gatt - appreciate all the help guys and to the shopkeeper for making something like this available in the first place.

    Anybody got a screenshot of it in use?

  2. #17
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Quote Originally Posted by Gatt View Post
    @hightower - Although we run a weekly timetable it works a treat once installed - but the install is a nightmare

    Big issue was just connecting to the SQL Server - found out later it was due to it being on a non-standard port (2155 IIRC.)

    If you get stuck give me a yell and i'll try and help..
    Given your problems Gatt, any suggestion for the documentation so i can reduce the pain?

  3. #18

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    Here you go...
    Attached Images Attached Images
    Last edited by Gatt; 16th January 2009 at 11:50 AM. Reason: Remoed Pupil Name from Screenshot

  4. 2 Thanks to Gatt:

    Hightower (16th January 2009), Oops_my_bad (1st February 2009)

  5. #19

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    Quote Originally Posted by penfold_99 View Post
    Given your problems Gatt, any suggestion for the documentation so i can reduce the pain?
    Off top of my head ..

    Dont need port in the Moodle enrol_dbhost
    Check what Port SQL Server is running on (1433 = SQL 2000 default, 1427 is SQL 2005 Default)
    FreeTDS - Version number of SQL 2005 is 9.0
    How to amend labels for the timetable periods

    Would also add in how to use the employeeID field in AD if you dont want to import them from SIMS.. - I had to

    Enable employeeID field/menu in AD Schema - info found via google
    Run SIMS report to export all kids names and the UPN
    Export pupils from AD
    Match Kids from AD to UPN - did this manually in excel - will get further info on that though -
    Import UPNs to AD - various ways - I used Dovestone's Bulk User Import

    Emphasise that you need all the views, but dont need to export/import from SIMS to AD (see UPN info above)

  6. #20
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Quote Originally Posted by Gatt View Post
    Dont need port in the Moodle enrol_dbhost
    Check what Port SQL Server is running on (1433 = SQL 2000 default, 1427 is SQL 2005 Default)
    FreeTDS - Version number of SQL 2005 is 9.0
    How to amend labels for the timetable periods
    I have added instructions for above.

  7. Thanks to penfold_99 from:

    Gatt (16th January 2009)

  8. #21
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41
    Quote Originally Posted by penfold_99 View Post
    i will have a look at the code and re-write to allow for a 2 week timetable over then next couple of days.
    BTW for me to get it to work i duplicated the table and made the following changes:

    From
    PHP Code:
    $days = array('Mon' => 1'Tue' => 2'Wed' => 3'Thu' => 4'Fri' => 5);
    $periods = array("" => 1,"1" => 2,"2"=> 3,"Reg"=> 4,"3"=> 5,"E4"=> 6,"L4"=> 7,"5"=> 8,"TWL"=> 9); 
    To
    PHP Code:
        $days = array('1Mon' => 1'1Tue' => 2'1Wed' => 3'1Thu' => 4'1Fri' => 5,'2Mon' => 6'2Tue' => 7'2Wed' => 8'2Thu' => 9'2Fri' => 10);     
        
    $periods = array("" => 1,"1" => 2,"2"=> 3,"3"=> 4,"4"=> 5,"5"=> 6,"6"=> 7,""=> 8,""=> 9); 
    From
    PHP Code:
    $periods_labels = array("","1","2","Reg","3","E4","L4","5","TWL"); 
    To
    PHP Code:
    $periods_labels = array("","1","2","3","Lunch","5","6","",""); 
    From
    PHP Code:
        $parts explode(":"$row['period_name']); 
    To
    PHP Code:
        $parts explode(" "$row['period_name']); 
    The following changes are made in the duplicated table.
    From
    PHP Code:
        echo '<td class="nottoday" style="text-align: center; vertical-align: middle;">';
    echo 
    '<b>'.$lessons[$i][$ii].'</b><br>';
    echo 
    $teachers[$i][$ii].'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.$rooms[$i][$ii];
    echo 
    '</td>'
    To
    PHP Code:
    echo '<td class="nottoday" style="text-align: center; vertical-align: middle;">';
    echo 
    '<b>'.$lessons[$i][$ii+5].'</b><br>';
    echo 
    $teachers[$i][$ii+5].'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.$rooms[$i][$ii+5];
    echo 
    '</td>'
    Last edited by apeo; 16th January 2009 at 04:56 PM.

  9. #22
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Thanks apeo,

    I have had a look at your changes and i think I will be able to incorporate into code quite easily so the module supports both 1 week and 2 week timetables.

    does anyone else have a use case of a timetable setup?

  10. #23

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    This was something out Deputy Head asked - on the STAFF timetables so they can click on the class code and get a list of the pupils in that class?

    Not sure how feasable that would be...

  11. #24
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Hi gatt,

    it could possible as the class code will be the same as the course code/name in moodle, it could be linked to the page with the class members in it.

    i will mull it over next week and let you know,

  12. #25

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    Thanks penfold...

  13. #26
    alan-d's Avatar
    Join Date
    Aug 2005
    Location
    Sutton Coldfield
    Posts
    2,414
    Thank Post
    359
    Thanked 256 Times in 187 Posts
    Rep Power
    75
    Quote Originally Posted by penfold_99 View Post
    Hi gatt,

    it could possible as the class code will be the same as the course code/name in moodle, it could be linked to the page with the class members in it.

    i will mull it over next week and let you know,
    Taking it a little (famous last words!) further, it may be useful if the class lists popped up in a new window.


  14. #27


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by Gatt View Post
    This was something out Deputy Head asked - on the STAFF timetables so they can click on the class code and get a list of the pupils in that class?

    Not sure how feasable that would be...
    As soon as the class is populated, the teacher can see the classlist of a particular course-code by selecting 'participants'. It's only one click away from the timetable-mod. Some of our teachers already use the 'participants' block of moodle to send instant message/email to their classes.

  15. #28

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    Yea I know - but we dont use the sims generated courses - we have our own courses, which by default everyone is enrolled into...

  16. #29


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    I see, we use a mix of the SIMS generated courses and metacourses.
    The metacourses are really useful as they are made dynamically of a range of SIMS courses. For example, we ks3 science that is populated from all yr7,8,9 sc courses - so when there is a new yr7 cohort the KS3 metacourse is automatically populated.
    This approach helps de-clutter the users page, as they are not members of all courses. In teacher speak it can be interpreted as creating an 'individual learning plan' as the students only have the courses that are 'tailored' for them....

  17. Thanks to CyberNerd from:

    Gatt (16th January 2009)

  18. #30
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Quote Originally Posted by apeo View Post
    BTW for me to get it to work i duplicated the table and made the following changes:

    From
    PHP Code:
    $days = array('Mon' => 1'Tue' => 2'Wed' => 3'Thu' => 4'Fri' => 5);
    $periods = array("" => 1,"1" => 2,"2"=> 3,"Reg"=> 4,"3"=> 5,"E4"=> 6,"L4"=> 7,"5"=> 8,"TWL"=> 9); 
    To
    PHP Code:
        $days = array('1Mon' => 1'1Tue' => 2'1Wed' => 3'1Thu' => 4'1Fri' => 5,'2Mon' => 6'2Tue' => 7'2Wed' => 8'2Thu' => 9'2Fri' => 10);     
        
    $periods = array("" => 1,"1" => 2,"2"=> 3,"3"=> 4,"4"=> 5,"5"=> 6,"6"=> 7,""=> 8,""=> 9); 
    From
    PHP Code:
    $periods_labels = array("","1","2","Reg","3","E4","L4","5","TWL"); 
    To
    PHP Code:
    $periods_labels = array("","1","2","3","Lunch","5","6","",""); 
    From
    PHP Code:
        $parts explode(":"$row['period_name']); 
    To
    PHP Code:
        $parts explode(" "$row['period_name']); 
    The following changes are made in the duplicated table.
    From
    PHP Code:
        echo '<td class="nottoday" style="text-align: center; vertical-align: middle;">';
    echo 
    '<b>'.$lessons[$i][$ii].'</b><br>';
    echo 
    $teachers[$i][$ii].'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.$rooms[$i][$ii];
    echo 
    '</td>'
    To
    PHP Code:
    echo '<td class="nottoday" style="text-align: center; vertical-align: middle;">';
    echo 
    '<b>'.$lessons[$i][$ii+5].'</b><br>';
    echo 
    $teachers[$i][$ii+5].'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.$rooms[$i][$ii+5];
    echo 
    '</td>'
    Hi Apeo,

    I have re-written the module to support a 2 week timetable, I have also simplified the setup.

    Could you please test the new version to see if it supports your config out the box?

    All that has changed is the view.php file in the mod folder.

    the link for the name file is that same as the old one on this moodle page
    Integrate Moodle, LDAP and SIMS.net - MoodleDocs

SHARE:
+ Post New Thread
Page 2 of 7 FirstFirst 123456 ... LastLast

Similar Threads

  1. SIMS.Net & Timetable planning
    By Ravening_Wolf in forum MIS Systems
    Replies: 22
    Last Post: 4th November 2009, 03:27 PM
  2. SIMS Lesson Monitor Timetable Structure
    By Sylv3r in forum MIS Systems
    Replies: 8
    Last Post: 15th March 2009, 09:45 PM
  3. Timetable T6 or Sims.net confused
    By training_needed in forum MIS Systems
    Replies: 4
    Last Post: 26th June 2008, 10:07 AM
  4. Sims Timetable Front end
    By Jamie_a in forum MIS Systems
    Replies: 5
    Last Post: 28th March 2007, 04:49 PM
  5. Moodle Blog Module SQL Injection Vulnerability - Heads Up
    By OutToLunch in forum Virtual Learning Platforms
    Replies: 7
    Last Post: 9th October 2006, 02:25 PM

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
  •