The Definitive Guide to SIMS.net, Moodle and LDAP Integration

[kieran8055]

Hi,

 

you might not be able to view to the page as iis might not be setup.

you can connect via tsql so there no firewall issues.

 

Add the views and it should work.

 

Hi

 

Sorry i have put sims integration on hold for course works in school, I am back to integrate on full.

 

Well good news is i can manage to Add employee ID on to AD and can import upn for students on to moodle, it works fine.

 

 

 

i have manually created sims time table view for student and staff and i can view using tsql http://www.chtsmoodle.co.uk/file.php/1/student_timetable.jpg

 

I have resetup whole from scratch and i am still stuck with empty timetable

http://www.chtsmoodle.co.uk/file.php/1/timetable.jpg

 

and i am doubting it's and php-mssql issue,

 

on ubuntu 8.04lts i have installed php5-sybase.

 

and for sims_timetable block on moodle Lessons labels i have entered is 1,2,3,4,5,6

 

Any suggestions Please.

Edited May 22, 2009 by kieran8055

[kieran8055]

Morning,

 

Is there any chance of importing student attendance from sims.net (weekly basis) as moodle block, as we can import timetable.

 

Cheers :0)

[penfold_99]

Hi

 

Sorry i have put sims integration on hold for course works in school, I am back to integrate on full.

 

Well good news is i can manage to Add employee ID on to AD and can import upn for students on to moodle, it works fine.

 

 

 

i have manually created sims time table view for student and staff and i can view using tsql

 

I have resetup whole from scratch and i am still stuck with empty timetable

 

and i am doubting it's and php-mssql issue,

 

on ubuntu 8.04lts i have installed php5-sybase.

 

and for sims_timetable block on moodle Lessons labels i have entered is 1,2,3,4,5,6

 

Any suggestions Please.

 

can you add the line

 

var_dump(mssql_fetch_array($result));

 

on line 87 just before the while loop.

 

if it doesn't return any results then there is a issue with freetds setup.

[kieran8055]

can you add the line

 

var_dump(mssql_fetch_array($result));

 

on line 87 just before the while loop.

 

if it doesn't return any results then there is a issue with freetds setup.

 

THANKS Penfold

 

Well I have managed, issue was of php-mssql, it works like a treat thankyou once again. Only my concern is we are using courses of our own not from sims.net courses. when user click on timetable courses it takes to timetable course, well i want to import course onto moodle from sims.net but for mean time i want to disable link of the courses on timetable

 

Can you help How to disable link to course on timetable.

 

And also any help for attendance block from sims.net.

 

Thankyou Once again :0)

[penfold_99]

Hi All,

 

I have update SIMS.net Timetable Block for Moodle to version 1.2.2.

 

CHANGELOG

 

FIXED: Connection issues when using non standard port.

FIXED: Now uses moodle DB layer instead of native php command for mssql.

ADD: Ability to enable/disable link to moodle course.

ADD: Error checking on SIMS.net connection.

 

Links to the update version are Here

[penfold_99]

Morning,

 

Is there any chance of importing student attendance from sims.net (weekly basis) as moodle block, as we can import timetable.

 

Cheers :0)

 

Can you expand on the context of how the data would be displayed?

[kieran8055]

Can you expand on the context of how the data would be displayed?

 

It some thing like

 

present attendance sessions with percentage

 

eg

 

Your Attendance

 

Present : 95.6%

sessions: 305

 

or just

 

Your attendance

 

95.6%

 

on moodle blocks

 

Thanks

[penfold_99]

It some thing like

 

present attendance sessions with percentage

 

eg

 

Your Attendance

 

Present : 95.6%

sessions: 305

 

or just

 

Your attendance

 

95.6%

 

on moodle blocks

 

Thanks

 

Would it display the attendance for the course they are looking at or just a overall for all courses?

[kieran8055]

Would it display the attendance for the course they are looking at or just a overall for all courses?

 

OVER ALL SCHOOL ATTENDANCE FROM SIMS.NEThttp://cloughhallmoodle/file.php/1/ATT.png

 

THANKS

[penfold_99]

OVER ALL SCHOOL ATTENDANCE FROM SIMS.NEThttp://cloughhallmoodle/file.php/1/ATT.png

 

THANKS

 

Where you trying to attach a png image to this post as i cant view it as its giving your internal hostname for moodle.

[kieran8055]

Where you trying to attach a png image to this post as i cant view it as its giving your internal hostname for moodle.

 

sorry about that

 

http://www.chtsmoodle.co.uk/file.php/1/ATT.jpg

 

Thanks

[penfold_99]

sorry about that

 

http://www.chtsmoodle.co.uk/file.php/1/ATT.jpg

 

Thanks

 

I will have a think about this. I'm look at a couple of different options as we will be having parental access via moodle.

[kieran8055]

I will have a think about this. I'm look at a couple of different options as we will be having parental access via moodle.

 

ya well I am also concern about parental access via moodle.

 

Cheers :0)

[ICTNUT]

OK Here goes,

 

Have been playing with this since 07:15 this morning and I am well, stuck.

 

I have the following setup:

 

Sims2Ad - not setup as I do not need to have sims exported to AD

FreeTDS - Setup on Ubuntu

Sims.Net - enrollment setup

Sims_Timetable - installed no errors

 

If i login as a student (LDAP Auth is working as this how our current moodle setup works), I goto My Courses and select the timetable block i get cannot connect to SIMS.NET error.

 

What do i need to do in order to check the connectivity?

 

I have checked the SQL server used by SIMS and the custom MDL_ views are not to be found so i assume an install issue with the block maybe?

 

any help would be grand as I would really like to get this setup as the school want to use this method of course creation to ensure school wide adoption of the vle.

 

[edit]

I know the username and password for the sql server are correct as i have used them same to access the sql manager[/edit]

Edited July 7, 2009 by ICTNUT
more info

[ICTNUT]

BUMP !!

 

Any one got any ideas on getting this working?

[penfold_99]

Hi ICTNUT,

 

I'm currently in the process for testing a new version of SIMS2MOODLE integration that doesn't use direct db access. direct db and support from capita is a gray area.

 

With the new version there will be the opportunity to have official support contacts.

 

The new version also doesn't have the technical barrier to implementation that direct db access has.

 

What's your time frame for implementing this?

[ICTNUT]

I want to get his in place for september 09.

 

The school has being using Moodle now for 2 years but has limited take up and it is now part of the school SIP to make this cross curricular.

 

One of the main reasons staff give for not using this is that is just takes to long to create classes and having moodle create these for them based on the SIMS timetable would remove this barrier.

 

This means that we would need to have the intergration in place within the next 3 weeks so migration from the current production moodle to the newly reveloped one and testing can take place.

 

Is this achieveable do you think?

 

What would be the costs for this (support)?

[TechMonkey]

Can any one tell me what the difference is between teh moodle sims integration described in the wiki and the method this thread uses?

 

Ta

[penfold_99]

Can any one tell me what the difference is between teh moodle sims integration described in the wiki and the method this thread uses?

 

Ta

 

There isn't much difference the main one is direct database access is not supported by capita so it shouldn't be used. I have developed an alternative for which a support contract is available.

[kieran8055]

Hi Penfold!

 

Wondering whether there are any additional facilites (apart from time table ) in SIMS2MOODLE like Attendance data, Assessment dat etc.

 

Thanks

[penfold_99]

Hi Penfold!

 

Wondering whether there are any additional facilites (apart from time table ) in SIMS2MOODLE like Attendance data, Assessment dat etc.

 

Thanks

 

This is currently in development the goal is to allow schools to meet the September 2010 parental Reporting deadline.

[kieran8055]

This is currently in development the goal is to allow schools to meet the September 2010 parental Reporting deadline.

 

Wondering howlong it gonna be?

 

Thanks Penfold

[penfold_99]

Wondering howlong it gonna be?

 

Thanks Penfold

 

Course Creation, Enrolment and Timetabling is completed.

Parental Email System is currently beta testing due for release before December

The 2010 requirement im looking at trying to coincide the release with Moodle 2.0

[kieran8055]

Course Creation, Enrolment and Timetabling is completed.

Parental Email System is currently beta testing due for release before December

The 2010 requirement im looking at trying to coincide the release with Moodle 2.0

 

Well we are currently using SIMS2Moodle (sims integration) for timetable and we look forward for some more facilities.

 

Thanks :0)

[penfold_99]

Well we are currently using SIMS2Moodle (sims integration) for timetable and we look forward for some more facilities.

 

Thanks :0)

 

If your using the version that connects directly to the SIMS.net database the development of those plug-ins has stopped.

 

If you required any greater functionality you would need to move to the supported version.