SIMS Timetable Module for Moodle

[Hightower]

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?

[penfold_99]

@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?

[Gatt]

Here you go...

[Gatt]

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)

[penfold_99]

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.

[apeo]

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

 $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

     $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

 $periods_labels = array("","1","2","Reg","3","E4","L4","5","TWL"); 
  

To

 $periods_labels = array("","1","2","3","Lunch","5","6","",""); 
  

From

     $parts = explode(":", $row['period_name']); 
  

To

     $parts = explode(" ", $row['period_name']); 
  

The following changes are made in the duplicated table.
From

     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

 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>'; 
  

[penfold_99]

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?

[Gatt]

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...

[penfold_99]

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,

[Gatt]

Thanks penfold...

[alan-d]

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.

[CyberNerd]

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.

[Gatt]

Yea I know - but we dont use the sims generated courses - we have our own courses, which by default everyone is enrolled into...

[CyberNerd]

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....

[penfold_99]

BTW for me to get it to work i duplicated the table and made the following changes:

From

 $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

     $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

 $periods_labels = array("","1","2","Reg","3","E4","L4","5","TWL"); 
  

To

 $periods_labels = array("","1","2","3","Lunch","5","6","",""); 
  

From

     $parts = explode(":", $row['period_name']); 
  

To

     $parts = explode(" ", $row['period_name']); 
  

The following changes are made in the duplicated table.
From

     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

 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