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

[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

[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_st udent_browse.unique_pupil_no,sims.rpt_vix_timetabl e.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_st udent_browse.unique_pupil_no,sims.rpt_vix_timetabl e.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

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