SIMS Timetable Module for Moodle

[Hightower]

Just noticed a big school boy error - the VBS scripts need editing duh!

 

Can anybody help me with the correct settings?

 

This is what I am struggling with (I don't know whether to leave as default or what to put in the empty ones):

 

strServerComputer = "student"
strServerLocalFolder = "e:\users"
strBaseOU = "OU=UCTC"
strIntakeOUPrefix = "OU=Year"
strLogonScript = "logon.bat"
strProfilePath
strSchool = "UCTC"
strHomeDrive = "S:"
arrUserDomainGroups = Array("Student-Filtered")

etc etc

 

Has anybody got their VBS's for this so I can take a look - especially any CC3 users.

 

Thanks,

[penfold_99]

Just tested it, same problem.

 

Sorry for being and idiot but my logic is off today but with this line of code:

 

$parts = explode($periodseperator, $row['period_name']);
$lessons[$periods[$parts['1']]][$days[$parts['0']]] = $row['class_name'];
$rooms[$periods[$parts['1']]][$days[$parts['0']]] = $row['room_name'];
$teachers[$periods[$parts['1']]][$days[$parts['0']]] = $row['staff_initials'];

 

for '1Mon 1', which has a class of say En, it would work out like this:

 

$parts[0]='1Mon'
$parts[1]='1'
$lessons[$periods['1']][$days['1Mon']] = $lessons[1][1]
$lessons[1][1] = 'En' 

 

for '2Mon 1', which has a class of say Ma, it would look like this:

 

$parts[0]='2Mon'
$parts[1]='1'
$lessons[$periods['1']][$days['2Mon']] = $lessons[1][1]
$lessons[1][1] = 'Ma' 

 

So in the array $lessons the value En has been overriden with Ma. Am i right?

 

You are i need to changes these lines

 

$parts = explode($periodseperator, $row['period_name']);
$lessons[$periods[$parts['1']]][$days[$parts['0']]] = $row['class_name'];
$rooms[$periods[$parts['1']]][$days[$parts['0']]] = $row['room_name'];
$teachers[$periods[$parts['1']]][$days[$parts['0']]] = $row['staff_initials'];

 

to this

 

$parts = explode($periodseperator, $row['period_name']);
	if (($no_weeks > 1) && (strpos($parts['0'],$no_weeks)=== true))
	{
		$period = $parts['1'] +(count($periods) +1);
	}
	else
	{
		$period = $parts['1'];
	}
	$lessons[$periods[$period]][$days[$parts['0']]] = $row['class_name'];
	$rooms[$periods[$period]][$days[$parts['0']]] = $row['room_name'];
	$teachers[$periods[$period]][$days[$parts['0']]] = $row['staff_initials'];

 

this will take into account

 

$parts[0]='2Mon'
$parts[1]='1'
$lessons[$periods['1']+][$days['2Mon']] = $lessons[1][1]
$lessons[1][1] = 'Ma' 

 

should now become

 

$parts[0]='2Mon'
$parts[1]='1'
offset = (count($periods) +1);
$lessons[$periods['1'+[offset]]][$days['2Mon']] = $lessons[1][1]
$lessons[10][1] = 'Ma' 

Edited January 21, 2009 by penfold_99

[penfold_99]

Just noticed a big school boy error - the VBS scripts need editing duh!

 

Can anybody help me with the correct settings?

 

This is what I am struggling with (I don't know whether to leave as default or what to put in the empty ones):

 

strServerComputer = "student"
strServerLocalFolder = "e:\users"
strBaseOU = "OU=UCTC"
strIntakeOUPrefix = "OU=Year"
strLogonScript = "logon.bat"
strProfilePath
strSchool = "UCTC"
strHomeDrive = "S:"
arrUserDomainGroups = Array("Student-Filtered")

etc etc

 

Has anybody got their VBS's for this so I can take a look - especially any CC3 users.

 

Thanks,

 

High tower,

 

set

 

USER_CREATION = FALSE

AD_REG_UPDATE = FALSE

AD_UPN_UPDATE = FALSE

 

strBaseOU = to you base ou holding all your students

 

Set you sims information, SMTP settings and email address and then run it, this will email you a report if everything is correctly setup.

[Hightower]

High tower,

 

set

 

USER_CREATION = FALSE

AD_REG_UPDATE = FALSE

AD_UPN_UPDATE = FALSE

 

strBaseOU = to you base ou holding all your students

 

Set you sims information, SMTP settings and email address and then run it, this will email you a report if everything is correctly setup.

 

Thanks, changed those but still get the same error.

[penfold_99]

Thanks, changed those but still get the same error.

 

whats the exact error?

[Hightower]

http://www.edugeek.net/forums/virtual-learning-platforms/29084-sims-timetable-module-moodle-3.html#post277136

[Gatt]

I think the VB creates users in AD for you but dont know if you need to create the OUs first or if it does it for you...

 

Things I know I would change are in Red

 

strServerComputer = "Name Of Your SIMS Server"

strServerLocalFolder = "e:\users"

strBaseOU = "OU=SchoolName or Pupils or Users"

strIntakeOUPrefix = "OU=Year"

strLogonScript = "logon.bat"

strProfilePath

strSchool = "SchoolName"

strHomeDrive = "Pupil Home Drive letter"

arrUserDomainGroups = Array("Student-Filtered")

[Gatt]

http://www.edugeek.net/forums/virtual-learning-platforms/29084-sims-timetable-module-moodle-3.html#post277136

 

What names did you give the views in MS SQL when you created them - they need to be the same as the ones in the Doc..

[Hightower]

What names did you give the views in MS SQL when you created them - they need to be the same as the ones in the Doc..

 

Yeah - they were the same :S

[barney]

Newbie here and first post ..

 

As an institution we are possibly being railroaded into buying Fronter, so I thought we'd take peek moodle to see what it can/can't do and to try and setup something as close to an MLE as we would end up buying.

 

In 2 days we've got moddle up and running on Win2k03 box using Apache and MYSQL thanks in no small part to the wonder XAMPP. We've setup LDAP for authentication which works a treat and brought in some of our existing learning materials.

 

I've read this thread and Penfold's documentation several times now and I'm still confused As an ex techie and moodle virgin so to speak would someone be kind enough to try and talk me through the latter 2 parts of Penfold's documentation. ie

# Integrate Moodle and SIMS.net

# Install SIMS.net Moodle Modules

 

Many thanks

[Hightower]

As an institution we are possibly being railroaded into buying Fronter, so I thought we'd take peek moodle to see what it can/can't do and to try and setup something as close to an MLE as we would end up buying.

 

We're currently taking a look at Moodle also, and I've found it to do so much compared to our current setup (SharePoint). Everything we've wanted we've found in the downloads area.

 

I'm playing with this SIMS.net thing also, will report back on any breakthroughs.

[Gatt]

@barney

 

Are there any parts in particular you are stuck at?

The Moodle Docs should be fairly up to date now after my input

[barney]

@barney

 

Are there any parts in particular you are stuck at?

The Moodle Docs should be fairly up to date now after my input

 

Yes!

 

In the documentation Configuring SQL Server 2005

[edit] Add a new view to MS SQL Server is mentioned twice, is this an oversight? I have it in my head moodle doesn't talk directly to the SIMS.Net database and that you create an intermediary or have I dreamt this??? Told you, I've been out the loop on the tech side of things for years now.

Secondly, is FreeTDS 0.64 only required when using Linux??

And thirdly, is the link between moodle and the sims.net databde (or the intermediary database dynamic or does it need to be scheduled?

 

Many thanks

[CyberNerd]

You do need to add a view to the SQL - the connection from moodle is direct to the SQL database, it is read only so the SQL is safe.

FreeTDS is Linux only - I'm not sure what you need to do a windows connection

The link is live so nothing needs to be schedules unless you want to do autocreation of user accounts.

[Hightower]

How do you test FreeTDS is doing its job? I have followed the steps in the docs and have a table for the timetable with the periods I set, but it is blank.

 

Also, does the account for Enrolements have to be the 'sa' account or can it be a system managers account?

[CyberNerd]

How do you test FreeTDS is doing its job? I have followed the steps in the docs and have a table for the timetable with the periods I set, but it is blank.

 

 

use the tsql command. I know that works on centos/rhel. but I think I read a thread that there was a problem with ubuntu

FreeTDS User Guide

[Hightower]

Have tried that - doesn't work with Ubuntu

[barney]

You do need to add a view to the SQL - the connection from moodle is direct to the SQL database, it is read only so the SQL is safe.

FreeTDS is Linux only - I'm not sure what you need to do a windows connection

The link is live so nothing needs to be schedules unless you want to do autocreation of user accounts.

 

Thanks, that's quite interesting.

I've followed the instructions and created the templates and setup the external database for the enrolments but alas I can't see any courses. What I can't figure out is where the view created by pasting in the query is referenced. I've actually "run" the view in SQL studio manager and it works but it looks to me like it uses UPN number to indentify students. Therefore would I be right in thinking that we need UPN's in AD too?

[CyberNerd]

Thanks, that's quite interesting.

I've followed the instructions and created the templates and setup the external database for the enrolments but alas I can't see any courses. What I can't figure out is where the view created by pasting in the query is referenced. I've actually "run" the view in SQL studio manager and it works but it looks to me like it uses UPN number to indentify students. Therefore would I be right in thinking that we need UPN's in AD too?

 

yes, you need to have the UPN data in active directory.

It is the UPN data that is used as a reference point to tie SIMS/AD and moodle together.

 

Have tried that - doesn't work with Ubuntu

 

you may need to compile it manually.

[Hightower]

Just to ask again... Does anyone know if it has to be the 'sa' account or can it be an account of a system manager in SIMS?

[barney]

Just to ask again... Does anyone know if it has to be the 'sa' account or can it be an account of a system manager in SIMS?

 

I would imagine it has to be SA account. SA is root account for the database and it's context within the SQL server. SIMS System admin account if for use with the sims.net application which accesses the SIMS database.

[rpwillis]

You shouldn't really be using UPNs to identify pupils to other systems. You should really be using the admission number. The UPN's purpose is purely tracking of pupils’ movement and progress within the maintained school system in England, not as a general purpose identifier.

 

From the guidance notes on UPNs at http://www.teachernet.gov.uk/_doc/11933/UPN%20Guidance%20Update%202007.rtf

 

• the UPN to be as far as possible a ‘blind number’, held by schools on the pupil's electronic record, and only output when required to provide information to the LA, to the Department or other central agencies (e.g. QCA/NAA), or to another school to which the pupil is transferring. The UPN should not be regarded as an automatic adjunct to the pupil's name, routinely appearing on any record or document relating to them;

 

• schools should not enter UPNs on pupils' paper files or on any other physical documents, including admission and attendance registers, and should continue to use the admission number, not the UPN, as a general pupil reference number within the school.

 

Richard

[Hightower]

Ok, now I gotsa find out the 'sa' password - hmmmm

[barney]

Ok, now I gotsa find out the 'sa' password - hmmmm

 

was SIMS installed by your Local Authority? If so, ring them and say you need it. Alternatively, it may actually be blank

[Hightower]

Found the password, set it - and still get a blank timetable.

 

Any ideas?