+ Post New Thread
Results 1 to 4 of 4
Virtual Learning Platforms Thread, Moodle with SIMS integration - SIMS view help please in Technical; Hi everyone, not sure if to post this here or in the MIS forum, but here goes. I've got moodle ...
  1. #1
    dhassen's Avatar
    Join Date
    Oct 2005
    Location
    Work in Clitheroe but live in Manchester
    Posts
    36
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Moodle with SIMS integration - SIMS view help please

    Hi everyone, not sure if to post this here or in the MIS forum, but here goes.

    I've got moodle working with courses brought in from SIMS with help from SIMS and Moodle Integration

    I used the view they suggest, but it brings all classes ever - not just the active, currently running ones. Can anyone help me out with a view that gives the same result but only brings back active classes?

    I've been trawling through the SIMS views and tables but I've had no joy so far. Many thanks

    Dave

  2. #2
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Quote Originally Posted by dhassen View Post
    Hi everyone, not sure if to post this here or in the MIS forum, but here goes.

    I've got moodle working with courses brought in from SIMS with help from SIMS and Moodle Integration

    I used the view they suggest, but it brings all classes ever - not just the active, currently running ones. Can anyone help me out with a view that gives the same result but only brings back active classes?

    I've been trawling through the SIMS views and tables but I've had no joy so far. Many thanks

    Dave
    Hi Dave,

    Can you expand on the term active classes?

    That version was design to create a course for every class thats stored in SIMS.net. Also that version is no longer supported by myself.

    There are other version of SIMS.net and moodle integrations avaliable.

  3. #3
    dhassen's Avatar
    Join Date
    Oct 2005
    Location
    Work in Clitheroe but live in Manchester
    Posts
    36
    Thank Post
    1
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Hi, yea by active classes I mean classes that are currently running - not legacy ones. That view did bring in all classes from SIMS, including ancient ones that are obviosuly no longer used.

    I did the usual thing of managing to find my own solution before an answer was posted here though, with the following ammended view:

    Code:
    SELECT DISTINCT p.class_name AS course, p.staff_initials AS person, 'teacher' AS role
    FROM         sims.curr_via_classperiods AS p INNER JOIN
                          sims.sims_base_group ON p.base_group_id = sims.sims_base_group.base_group_id
    WHERE     (sims.sims_base_group.active_state LIKE 'A')
    UNION
    SELECT DISTINCT TOP (100) PERCENT p.class_name AS course, m.unique_pupil_no AS person, 'student' AS role
    FROM         sims.curr_via_classperiods AS p INNER JOIN
                          sims.stud_via_group_members AS m ON m.base_group_id = p.base_group_id INNER JOIN
                          sims.sims_base_group AS sims_base_group_1 ON p.base_group_id = sims_base_group_1.base_group_id
    WHERE     (sims_base_group_1.active_state LIKE 'A')
    Thanks for the reply anyhow.

  4. #4
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Quote Originally Posted by dhassen View Post
    Hi, yea by active classes I mean classes that are currently running - not legacy ones. That view did bring in all classes from SIMS, including ancient ones that are obviosuly no longer used.

    I did the usual thing of managing to find my own solution before an answer was posted here though, with the following ammended view:

    Code:
    SELECT DISTINCT p.class_name AS course, p.staff_initials AS person, 'teacher' AS role
    FROM         sims.curr_via_classperiods AS p INNER JOIN
                          sims.sims_base_group ON p.base_group_id = sims.sims_base_group.base_group_id
    WHERE     (sims.sims_base_group.active_state LIKE 'A')
    UNION
    SELECT DISTINCT TOP (100) PERCENT p.class_name AS course, m.unique_pupil_no AS person, 'student' AS role
    FROM         sims.curr_via_classperiods AS p INNER JOIN
                          sims.stud_via_group_members AS m ON m.base_group_id = p.base_group_id INNER JOIN
                          sims.sims_base_group AS sims_base_group_1 ON p.base_group_id = sims_base_group_1.base_group_id
    WHERE     (sims_base_group_1.active_state LIKE 'A')
    Thanks for the reply anyhow.
    Hi Dave,

    there is a new version of the component over on the moodle docs website, but still out of date. As the other view check for the course end date.

SHARE:
+ Post New Thread

Similar Threads

  1. Moodle Sims integration help
    By ssiruuk2 in forum Virtual Learning Platforms
    Replies: 7
    Last Post: 8th November 2010, 01:53 PM
  2. The Definitive Guide to SIMS.net, Moodle and LDAP Integration
    By penfold_99 in forum Virtual Learning Platforms
    Replies: 130
    Last Post: 8th September 2010, 04:50 PM
  3. Moodle/Sims - Timetable and course integration HELP
    By Danlewis3 in forum Virtual Learning Platforms
    Replies: 6
    Last Post: 11th January 2010, 01:26 PM
  4. Replies: 0
    Last Post: 5th January 2009, 12:53 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)

Posting Permissions

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