SIMS Timetable Module for Moodle

**CyberNerd** · 21st January 2009, 12:50 PM

Originally Posted by Hightower

Can anybody help me configure FreeTDS for Ubuntu 8.04LTS?

I've done a "sudo apt-get install freetds-dev" successfully but when editing /etc/freetds.conf I get a blank file - is this normal and do I have to populate it myself?

I'm not using freetds on ubuntu, but it appears that the config file is just /etc/freetds/freetds.conf

Code:

dpkg --listfiles freetds-common 
/.
/usr
/usr/share
/usr/share/freetds
/usr/share/freetds/freetds.conf
/usr/share/doc
/usr/share/doc/freetds-common
/usr/share/doc/freetds-common/README
/usr/share/doc/freetds-common/README.Debian
/usr/share/doc/freetds-common/TODO.Debian
/usr/share/doc/freetds-common/copyright
/usr/share/doc/freetds-common/examples
/usr/share/doc/freetds-common/examples/freetds.conf.pl
/usr/share/doc/freetds-common/examples/locales.conf
/usr/share/doc/freetds-common/NEWS.gz
/usr/share/doc/freetds-common/TODO.gz
/usr/share/doc/freetds-common/changelog.Debian.gz
/etc
/etc/freetds
/usr/share/doc/freetds-common/examples/odbcinst.ini
/usr/share/doc/freetds-common/examples/freetds.conf

thing is, I can't find the tsql command that is present on RHEL?
can someone confirm that the freetds package works on ubuntu - you may be better of using the source, luke

**Gatt** · 21st January 2009, 12:51 PM

Dont think I can help there - our AD is already setup so dont need to export from SIMS into AD..

**Hightower** · 21st January 2009, 12:56 PM

Originally Posted by Gatt

Dont think I can help there - our AD is already setup so dont need to export from SIMS into AD..

Can you quickly bullet the install points it took you to get it to work?

**penfold_99** · 21st January 2009, 12:59 PM

Originally Posted by Gatt

Nice one - though in the block_simstimetable.php you need to change /mod/simstimetable/ to mod/simstimetable/

Sorry - meant to remove it myself in my previous quote..

For some reason if its there it ignores the $CFG->wwwroot entirely!!

I have fixed this and update the zip file

**apeo** · 21st January 2009, 01:07 PM

Originally Posted by penfold_99

Hi Gatt, Apeo

I have updated to the latest version, if you could download and test i would be grateful.

The latest version includes the link to from the timetable to the course.

Just tested it, same problem.

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

PHP 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:

Code:

$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:

Code:

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

**Hightower** · 21st January 2009, 01:29 PM

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):

Code:

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** · 21st January 2009, 01:30 PM

Originally Posted by apeo

Just tested it, same problem.

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

PHP 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:

Code:

$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:

Code:

$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

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

to this

PHP Code:

 $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

Code:

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

should now become

Code:

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

**penfold_99** · 21st January 2009, 01:35 PM

Originally Posted by 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):

Code:

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** · 21st January 2009, 01:42 PM

Originally Posted by penfold_99

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** · 21st January 2009, 01:44 PM

Originally Posted by Hightower

Thanks, changed those but still get the same error.

whats the exact error?

**Hightower** · 21st January 2009, 01:55 PM

SIMS Timetable Module for Moodle

**Gatt** · 21st January 2009, 02:03 PM

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** · 21st January 2009, 02:05 PM

Originally Posted by Hightower

SIMS Timetable Module for Moodle

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** · 21st January 2009, 02:21 PM

Originally Posted by Gatt

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** · 29th January 2009, 10:29 AM

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

LinkBack

Thread Tools

Search Thread

Similar Threads

SIMS.Net & Timetable planning

SIMS Lesson Monitor Timetable Structure

Timetable T6 or Sims.net confused

Sims Timetable Front end

Moodle Blog Module SQL Injection Vulnerability - Heads Up

Thread Information

Users Browsing this Thread

Posting Permissions