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

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.

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

THANKS

[penfold_99]

OVER ALL SCHOOL ATTENDANCE FROM SIMS.NET

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



Thanks

[penfold_99]

sorry about that



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]

[ICTNUT]

BUMP !!

Any one got any ideas on getting this working?