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

[CyberNerd]

The beginning of that row is the database name. our is SIMS. there are other rows such as the sample database "AdventureWorks".

 

if you then do

 

1> use dbname
2> select * from mdl_enrolment_v1_0
3> go

where dbname is the name of the database, it should pullout a load of info. if it doesn't then penfold may hava an idea

[kieran8055]

Still no joy........

[kieran8055]

well i have check the network configuration for SQL Server (sims), protocol for sims and TCP/IP is enabled and dynamic port is " 1414 ".

 

I have changed the freetds and connected again i can use sims database but it says mdl_enrolment_v1_0 is invalid object name.

[penfold_99]

tried:

select * from master.dbo.sysdatabases

 

It displays 5 rows:

 

with file name as

 

d:\sql2000\MSSQL\data\XXXX

 

I think your connecting to the wrong port.

You are searching a MS SQL 2000 Server not MS SQL 2005 Server.

Change the port to 1427 and see if that works.

[kieran8055]

Hi All,

 

At last i have managed to connect to Sims Server ( instance ADMINSERVER\SIMS) actually it tcp\ip was enabled on 1414 port.

 

Well i can connect to mssql server and i can access sims database but when i try select mdl_enrolment_v1_0 table, it says mdl_enrolment_v1_0 invalid object.

 

Any suggestions,

 

Thanks :0)

[penfold_99]

the enrolement view is created after the enrolement plugin is configured.

 

remove the enrolment plugin and reinstall and configure, then it should work.

[kieran8055]

Well Penfold sorry to trouble you again,

 

The following steps i have done to integrate SIMS2MOOLDE ( as i am intrested in only Timetable block):

 

 

1. Installed FreeTDS on ubuntu 8.04lts ( configured freetds.conf ).

2. Created Moodle SIMS.net Course template.

3. Downloaded SIMS2Moodle - Enrolment Plug-in and copied to enrol folder (/var/www/moodle/enrol).

4. configured sims server settings on admin/enrol page:

5. downloaded the Moodle_sims.net _timetable_block, copied to (/var/www/moodle/blocks) and configured the block.

 

Is that any thing am i missing.

 

I have uninstalled the enrolment plug-in an reinstalled, i can connect to sims database but to mdl_enrolment_v1_0 object, says invalid object.

 

 

Any suggestions,

 

Thanks

[penfold_99]

Well Penfold sorry to trouble you again,

 

The following steps i have done to integrate SIMS2MOOLDE ( as i am intrested in only Timetable block):

 

 

1. Installed FreeTDS on ubuntu 8.04lts ( configured freetds.conf ).

2. Created Moodle SIMS.net Course template.

3. Downloaded SIMS2Moodle - Enrolment Plug-in and copied to enrol folder (/var/www/moodle/enrol).

4. configured sims server settings on admin/enrol page:

5. downloaded the Moodle_sims.net _timetable_block, copied to (/var/www/moodle/blocks) and configured the block.

 

Is that any thing am i missing.

 

I have uninstalled the enrolment plug-in an reinstalled, i can connect to sims database but to mdl_enrolment_v1_0 object, says invalid object.

 

 

Any suggestions,

 

Thanks

 

The timetable block relise on the enrolment plugin for the settings to connect to the database this doesn't have to be enabled.

 

Have the views been created for mdl_student_timetable_v1_0 and mdl_staff_timetable_v1_0?

 

how are you getting this error "mdl_enrolment_v1_0 object, says invalid object"?

[kieran8055]

No i havent created any views ( like mdl_student_timetable_v1_0 and mdl_staff_timetable_v1_0).

 

When i am testing using

 

tsql -H XX.XX.XX.XX -p 1414 -U sa -P sapassword

 

> use sims

> select * from mdl_enrolment_v1_0

> go

error: Invalid object name.

 

I have missed out Section 1. in your documentation( SIMS2AD) because i am intrested in only SIMS2MOODLE integration.

 

Thanks

[penfold_99]

No i havent created any views ( like mdl_student_timetable_v1_0 and mdl_staff_timetable_v1_0).

 

these should be automatically created on install of the timetable block.

 

Have a look in SQl Server 2005 Management Studio and see if there are any views with the prefix mdl_

[penfold_99]

Try this

 

tsql -H XX.XX.XX.XX -p 1414 -U sa -P sapassword

 

> use sims

> select * from asm_via_aspect

> go

[kieran8055]

There are no views created on Sims database called

" mdl_student_timetable_v1_0 and mdl_staff_timetable_v1_0 ".

 

Thanks

[kieran8055]

Try this

 

tsql -H XX.XX.XX.XX -p 1414 -U sa -P sapassword

 

> use sims

> select * from asm_via_aspect

> go

 

I have tried this but same error asm_via_aspect - Invalid object name

 

But there is a view called asm_via_aspect on sims database, i have checked on our sims database using management studio.

[kieran8055]

Hi All,

 

Sims timetable block is missing on moodle site............!(modules and plugins)

 

Thanks

[penfold_99]

Hi All,

 

Sims timetable block is missing on moodle site............!(modules and plugins)

 

Thanks

 

I have changed the SIMS.net Timetable Block to SIMS.net Integration on the plugins Moodle website.

This now directs to the documentation which has the correct links.

[kieran8055]

I have changed the SIMS.net Timetable Block to SIMS.net Integration on the plugins Moodle website.

This now directs to the documentation which has the correct links.

 

Sorry, there is no plugin with Sims.net Integration on moodle.org, (modules & plugins)..

 

Thanks

Edited May 11, 2009 by kieran8055

[penfold_99]

Sorry, this is no plugin with Sims.net Integration on moodle.org, (modules & plugins)..

 

Thanks

 

There is, It's probably going through the checking process again as i changed the title. Last time it took a day or so to appear for other users.

[kieran8055]

There is, It's probably going through the checking process again as i changed the title. Last time it took a day or so to appear for other users.

 

Thanks, Fingers crossed!

[penfold_99]

Thanks, Fingers crossed!

 

Instead of having to wait, just click the link on the first post.

It goes to the same place.

[kieran8055]

Instead of having to wait, just click the link on the first post.

It goes to the same place.

 

Hia...,

 

Well i have done every thing from the scratch again still blank (timetable) page,

my MSSQL 2005 server is configured properly because i can select table from sims database using " tsql "

i have rechecked again and again, gone through all the threads and posts tried almost every thing.

 

Sims.net timetable block is doing nothing.

 

Any suggestions please.

[penfold_99]

Hia...,

 

Well i have done every thing from the scratch again still blank (timetable) page,

my MSSQL 2005 server is configured properly because i can select table from sims database using " tsql "

i have rechecked again and again, gone through all the threads and posts tried almost every thing.

 

Sims.net timetable block is doing nothing.

 

Any suggestions please.

 

Is the tabletime blank or the page blank?

Have you installed and configured the enrolment plugin?

Have the views been created in ms sql server?

[kieran8055]

Is the tabletime blank or the page blank?

Have you installed and configured the enrolment plugin?

Have the views been created in ms sql server?

 

Thanks for replying.

 

Well Timetable is blank.

I have installed and configured the enrolment plugin.

Unfortunately Timetable block is not creating any views on MSSQL server.

 

But i am sure i can connect to ADMIN\SIMS server, i can select tables from sims database.....

 

Thanks.

[penfold_99]

Thanks for replying.

 

Well Timetable is blank.

I have installed and configured the enrolment plugin.

Unfortunately Timetable block is not creating any views on MSSQL server.

 

But i am sure i can connect to ADMIN\SIMS server, i can select tables from sims database.....

 

Thanks.

 

If you run these queries it will create the required views.

 

CREATE VIEW mdl_student_timetable_v1_0

AS SELECT TOP (100) PERCENT sims.rpt_vix_timetable.period_name, sims.rpt_vix_timetable.class_name,sims.stud_via_student_browse.unique_pupil_no,sims.rpt_vix_timetable.staff_initials, sims.rpt_vix_timetable.room_name

FROM sims.stud_via_group_members INNER JOIN sims.curr_class_period ON sims.stud_via_group_members.base_group_id = sims.curr_class_period.base_group_id

INNER JOIN sims.stud_via_student_browse ON sims.stud_via_group_members.person_id =

sims.stud_via_student_browse.person_id INNER JOIN sims.rpt_vix_timetable ON sims.curr_class_period.class_period_id = sims.rpt_vix_timetable.class_period_id

WHERE (sims.curr_class_period.person_id IS NOT NULL) AND (sims.rpt_vix_timetable.end_date > GETDATE()) AND (sims.stud_via_group_members.start_date < GETDATE()) AND (sims.stud_via_group_members.end_date > GETDATE())

ORDER BY sims.rpt_vix_timetable.period_name

 

 

CREATE VIEW mdl_staff_timetable_v1_0

AS SELECT TOP (100) PERCENT sims.rpt_vix_timetable.period_name, sims.rpt_vix_timetable.class_name, sims.rpt_vix_timetable.staff_initials, sims.rpt_vix_timetable.room_name

FROM sims.curr_class_period INNER JOIN sims.rpt_vix_timetable ON sims.curr_class_period.class_period_id = sims.rpt_vix_timetable.class_period_id

WHERE (sims.rpt_vix_timetable.end_date > GETDATE())

ORDER BY sims.rpt_vix_timetable.period_name

[kieran8055]

If you run these queries it will create the required views.

 

CREATE VIEW mdl_student_timetable_v1_0

AS SELECT TOP (100) PERCENT sims.rpt_vix_timetable.period_name, sims.rpt_vix_timetable.class_name,sims.stud_via_student_browse.unique_pupil_no,sims.rpt_vix_timetable.staff_initials, sims.rpt_vix_timetable.room_name

FROM sims.stud_via_group_members INNER JOIN sims.curr_class_period ON sims.stud_via_group_members.base_group_id = sims.curr_class_period.base_group_id

INNER JOIN sims.stud_via_student_browse ON sims.stud_via_group_members.person_id =

sims.stud_via_student_browse.person_id INNER JOIN sims.rpt_vix_timetable ON sims.curr_class_period.class_period_id = sims.rpt_vix_timetable.class_period_id

WHERE (sims.curr_class_period.person_id IS NOT NULL) AND (sims.rpt_vix_timetable.end_date > GETDATE()) AND (sims.stud_via_group_members.start_date < GETDATE()) AND (sims.stud_via_group_members.end_date > GETDATE())

ORDER BY sims.rpt_vix_timetable.period_name

 

 

CREATE VIEW mdl_staff_timetable_v1_0

AS SELECT TOP (100) PERCENT sims.rpt_vix_timetable.period_name, sims.rpt_vix_timetable.class_name, sims.rpt_vix_timetable.staff_initials, sims.rpt_vix_timetable.room_name

FROM sims.curr_class_period INNER JOIN sims.rpt_vix_timetable ON sims.curr_class_period.class_period_id = sims.rpt_vix_timetable.class_period_id

WHERE (sims.rpt_vix_timetable.end_date > GETDATE())

ORDER BY sims.rpt_vix_timetable.period_name

 

Hi

 

Well before creating views on the mssql server i want to make sure whether admin server firewalled.

I have created test.html page on admin server when i am trying to access webpage (http://10.134.XX.XX/test), " The website declined to show this webpage "

 

"You are not authorized to view this page".

 

when i trying to access internet on admin server, it ask for user name and password.

 

I am wondering it is been firewalled.

 

Is that make sense?

 

Thanks

Edited May 12, 2009 by kieran8055

[penfold_99]

Hi

 

Well before creating views on the mssql server i want to make sure whether admin server firewalled.

I have created test.html page on admin server when i am trying to access webpage (http://10.134.XX.XX/test), " The website declined to show this webpage "

 

"You are not authorized to view this page".

 

when i trying to access internet on admin server, it ask for user name and password.

 

I am wondering it is been firewalled.

 

Is that make sense?

 

Thanks

 

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.