Poll: Is this documentation helpful?

+ Post New Thread
Page 5 of 9 FirstFirst 123456789 LastLast
Results 61 to 75 of 131
Virtual Learning Platforms Thread, The Definitive Guide to SIMS.net, Moodle and LDAP Integration in Technical; Try this tsql -H XX.XX.XX.XX -p 1414 -U sa -P sapassword > use sims > select * from asm_via_aspect > ...
  1. #61
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    960
    Thank Post
    58
    Thanked 163 Times in 115 Posts
    Rep Power
    67
    Try this

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

    > use sims
    > select * from asm_via_aspect
    > go

  2. #62

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    There are no views created on Sims database called
    " mdl_student_timetable_v1_0 and mdl_staff_timetable_v1_0 ".

    Thanks

  3. #63

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by penfold_99 View Post
    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.

  4. #64

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Hi All,

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

    Thanks

  5. #65
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    960
    Thank Post
    58
    Thanked 163 Times in 115 Posts
    Rep Power
    67
    Quote Originally Posted by kieran8055 View Post
    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.

  6. #66

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by penfold_99 View Post
    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
    Last edited by kieran8055; 11th May 2009 at 12:37 PM.

  7. #67
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    960
    Thank Post
    58
    Thanked 163 Times in 115 Posts
    Rep Power
    67
    Quote Originally Posted by kieran8055 View Post
    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.

  8. #68

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by penfold_99 View Post
    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!

  9. #69
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    960
    Thank Post
    58
    Thanked 163 Times in 115 Posts
    Rep Power
    67
    Quote Originally Posted by kieran8055 View Post
    Thanks, Fingers crossed!
    Instead of having to wait, just click the link on the first post.
    It goes to the same place.

  10. Thanks to penfold_99 from:

    kieran8055 (11th May 2009)

  11. #70

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by penfold_99 View Post
    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.

  12. #71
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    960
    Thank Post
    58
    Thanked 163 Times in 115 Posts
    Rep Power
    67
    Quote Originally Posted by kieran8055 View Post
    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?

  13. #72

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by penfold_99 View Post
    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.

  14. #73
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    960
    Thank Post
    58
    Thanked 163 Times in 115 Posts
    Rep Power
    67
    Quote Originally Posted by kieran8055 View Post
    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

  15. Thanks to penfold_99 from:

    kieran8055 (12th May 2009)

  16. #74

    Join Date
    Apr 2009
    Location
    Stoke
    Posts
    81
    Thank Post
    24
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by penfold_99 View Post
    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
    Last edited by kieran8055; 12th May 2009 at 10:48 AM.

  17. #75
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    960
    Thank Post
    58
    Thanked 163 Times in 115 Posts
    Rep Power
    67
    Quote Originally Posted by kieran8055 View Post
    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.

  18. Thanks to penfold_99 from:

    kieran8055 (12th May 2009)

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS.Net Active Directory Integration
    By robknowles in forum MIS Systems
    Replies: 29
    Last Post: 4th October 2011, 02:54 PM
  2. Moodle Error log for LDAP integration
    By apearce in forum Virtual Learning Platforms
    Replies: 4
    Last Post: 19th November 2008, 12:36 PM
  3. Cancelled Intro Guide To Sims.net Thursday 20th Dec 10:30
    By russdev in forum General EduGeek News/Announcements
    Replies: 8
    Last Post: 13th March 2008, 09:31 PM
  4. Moodle LDAP integration
    By zag in forum Virtual Learning Platforms
    Replies: 4
    Last Post: 13th March 2008, 03:03 PM
  5. Moodle/SIMS integration
    By localzuk in forum Virtual Learning Platforms
    Replies: 23
    Last Post: 7th December 2007, 09:18 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •