+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 24 of 24
Virtual Learning Platforms Thread, Moodle/SIMS integration in Technical; I don't think the Sims manager will mind, I'm sure he has a backup somewhere. Code: USE [sims] GO /****** ...
  1. #16


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339

    Re: Moodle/SIMS integration

    I don't think the Sims manager will mind, I'm sure he has a backup somewhere.


    Code:
    USE [sims]
    
    GO
    /****** Object:  View [dbo].[mdl_enrolments]    Script Date: 12/05/2007 17:16:34 ******/
    
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER VIEW [dbo].[mdl_enrolments]
    AS
    SELECT DISTINCT class_name AS course, staff_initials AS person, 'editingteacher' AS role
    FROM         sims.curr_via_classperiods AS p
    UNION
    SELECT DISTINCT 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
    Attached Images Attached Images

  2. #17
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    33

    Re: Moodle/SIMS integration

    OK, so no extra fields required.. that query will run against any SIMS db and return the teacher initials for every class code and the pupil's UPN for every pupil in every class.

    It's very similar to the data I used when I tried to set up MS Classserver a few years back. The difficulty I had was a lack of link between the SIMS id (which can be the UPN or the admission number) and the AD id (which would probably be the username (samid) or the SID).

    I found that although the UPN would be better to use in theory, in practice we often didn't get UPNs for our sixth formers until several months after they started. I was also wary of temporary UPNs being issued and then changed later which apparently can happen.

    It's not a simple problem to solve!

    EDIT: Thanks for sharing by the way

  3. #18


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339

    Re: Moodle/SIMS integration

    I spoke to our Sims manager this evening as I'm obviously getting quite confused as to how we have this set up. He confirmed that the user defined fields that we have are nothing to do with moodle integration and it is just the view that was set up. It's all starting to fall into place (i think), the user defined fields that our sims has were migrated over because we used to automatically create active directory accounts from CMIS - It was the autocreation script that needed the extra field. my mistake.
    Anyone fancy trying this out and writing a howto ?

  4. #19


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339

    Re: Moodle/SIMS integration

    I found that although the UPN would be better to use in theory, in practice we often didn't get UPNs for our sixth formers until several months after they started. I was also wary of temporary UPNs being issued and then changed later which apparently can happen.
    We have the UPN set in the employeeID field in active directory. In the LDAP authentication of moodle under data mapping, we pull out that information "ID number = employeedID". This is why AD/MIS integration is the way forward.

  5. #20

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    17

    Re: Moodle/SIMS integration

    Quote Originally Posted by webman
    I remember a while ago several of us (including dhicks) were discussing the very thing dhicks is currently working on; that is developing ways of getting data from the (albeit poor) method of data extraction at our disposal - the "SDK".
    What's wrong with the IMS. Updating VLEs is what it was created for.

  6. #21
    sahmeepee's Avatar
    Join Date
    Oct 2005
    Location
    Greater Manchester
    Posts
    795
    Thank Post
    20
    Thanked 70 Times in 42 Posts
    Rep Power
    33

    Re: Moodle/SIMS integration

    Quote Originally Posted by CyberNerd
    We have the UPN set in the employeeID field in active directory. In the LDAP authentication of moodle under data mapping, we pull out that information "ID number = employeedID". This is why AD/MIS integration is the way forward.
    I haven't really delved into moodle very seriously yet, but from what I can see these issues are fairly universal with VLEs as they stand today. I'm glad to hear that people are having success with it in Moodle, despite the slightly crushing news today that after consultation with the NMs in the borough, our LA have decided to ignore our requests and base their VLE selection process on BECTArds "List Of Ten". The winner to be announced on Friday to all Heads :/

  7. #22

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,403
    Thank Post
    637
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    319

    Re: Moodle/SIMS integration

    Moodle will never win in the eyes of those QUANGOs as it's free.

  8. #23


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339

    Re: Moodle/SIMS integration

    our LA have decided to ignore our requests and base their VLE selection process on BECTArds "List Of Ten". The winner to be announced on Friday to all Heads :/.
    Seems to be the same everywhere, The LA's get funding but only if they pay companies that are on bectas favorites list. Education will ultimately suffer because such a huge amount of money is being wasted on these companies, given the robustness of the free solutions. If Becta could have just offered a financial incentive to develop moodle/mis plugins - or even a howto (like they recently paid RM to develop an opensource whiteboard format then we'd all get a better solution and the government would save money. It's hard to believe there is no conspiracy.

  9. #24

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Re: Moodle/SIMS integration

    CLEO (Lancs and Cumbria) have standardised on Moodle. Cumbria even has some full time developers working on Moodle coding/addons.

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Which VLE Moodle, Digital Brain, Oracle, Fronter, SIMS LG
    By ITWombat in forum Virtual Learning Platforms
    Replies: 45
    Last Post: 1st February 2011, 01:16 AM
  2. Moodle and SIMS .Net
    By wesleyw in forum Virtual Learning Platforms
    Replies: 21
    Last Post: 21st March 2007, 06:16 PM
  3. Importing Users into Moodle from SIMS
    By Ric_ in forum Virtual Learning Platforms
    Replies: 16
    Last Post: 23rd January 2007, 08:34 AM
  4. SIMS AD Integration
    By mark in forum MIS Systems
    Replies: 3
    Last Post: 11th November 2006, 12:24 PM
  5. Moodle and Assessment Manager/Sims
    By Mintsoft in forum Web Development
    Replies: 33
    Last Post: 15th May 2006, 01:49 PM

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
  •