+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 20
Virtual Learning Platforms Thread, VLE and SIMS (MIS) Intergration in Technical; I currently work with and support Moodle in our school, we love it and didnt really look around all that ...
  1. #1

    Join Date
    Apr 2006
    Location
    UK
    Posts
    939
    Thank Post
    39
    Thanked 70 Times in 54 Posts
    Rep Power
    30

    VLE and SIMS (MIS) Intergration

    I currently work with and support Moodle in our school, we love it and didnt really look around all that much at alternatives because we host it our selves and do a lot of the development in-house.

    Speaking to local schools and techies on EduGeek im hearing over and over again the new buzz word "SIMS intergration".

    What i would like to know is what other VLE/MLE system out there have SIMS intergration and on what level?

    E.g: We do a SIMS extraction of pupils timetables and teacher timetables and tie them together in Moodle. So we boast SIMS intergration (of sorts).

    But do the other VLE system offer a live link, or a nightly update process for example?

    In short...how do they do it?

  2. #2


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    In short, it works like this:

    get SIMS working with Active Directory first. Ideally SIMS will autocreate the users in AD. At the very least you need a field that in LDAP (AD) that has the students UPN number and the employeetype as student or teacher that matches your SIMS.

    In the SIMS SQL server, create a view that shows the Course, Person and the Roll.
    Moodle will automatically talk to an MSSQL server - this way when a user logs on it gets their courses out of SIMS automatically - and assigns the teacher and student to their appropriate roles. Login will still be done with LDAP - so moodle will map the LDAP fields to the appropriate fields in AD.

    What it doesn't do (yet) is write data back to SIMS (IMS?/SIF?). Moodle (1.9) has a pretty funky question/answer/targets that ideally should feed back to SIMS. Best we can do is export grades to a spreadsheet and copy and paste into sims. The commercial VLEs will offer this level of integration.

    Moodle/SIMS integration

  3. #3

    Join Date
    Apr 2006
    Location
    UK
    Posts
    939
    Thank Post
    39
    Thanked 70 Times in 54 Posts
    Rep Power
    30
    Thanks for that CyberN, were not really bothered about live updates were happy with the manual update.

    But how do the other commerical VLE's do it?

    Listening device on a server and some kind of software on the SIMS box that communicates with the remote serveR?

  4. #4

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,235
    Thank Post
    375
    Thanked 381 Times in 339 Posts
    Rep Power
    148
    Quote Originally Posted by danIT View Post
    Thanks for that CyberN, were not really bothered about live updates were happy with the manual update.

    But how do the other commerical VLE's do it?

    Listening device on a server and some kind of software on the SIMS box that communicates with the remote serveR?
    I think most just have a custom script to interrogate the SIMS database. TALMOS for one does this but it has to be done manually - its not live so to speak.

  5. #5

    maniac's Avatar
    Join Date
    Feb 2007
    Location
    Kent
    Posts
    3,070
    Thank Post
    210
    Thanked 430 Times in 310 Posts
    Rep Power
    144
    Not sure how other VLES do it or how it's done with SIMS, but as an example I've written an selection of PHP scripts that automatically sync moodle with CMIS, it has a simple user interface built in that allows you to add CMIS teaching groups to Courses created within moodle, and then using this information it allocates the correct kids to the various courses etc. It also notifys me when students that are in moodle don't exist anymore in CMIS (i.e have left the school) so we can disable their accounts on the network, and does the same for new starters, so we can create their account ahead of them starting (how efficient!)

    It runs the main part of the program as a batch (or CRON) job every night, as part of this is checks all the group memberships against cmis and moves students around as necessary, it also e-mails me a detailed report. Its deadly accurate, I can see staright away what students have moved groups from the report, and I can trigger it manually if necessary e.g if there's a new starter that deperately needs to use moodle, and their account has only just been created.

    I would imagine a VLE that links to SIMS would read the data in a simelar fashion, and use it in a simelar way and probably as a batch job as well as this is by far the easiest way of syncronising two systems. I know some systems will also feed assesment data back into the MIS, as well as use the MIS data for creation of accounts etc. Moodle uses LDAP here, their CMIS student number is added in AD when the accounts are created to tie it all together.

    Mike.
    Last edited by maniac; 27th March 2008 at 12:50 AM.

  6. #6
    scottyses's Avatar
    Join Date
    Dec 2007
    Location
    Stamford, Lincolnshire
    Posts
    39
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    DanIT... I would be interested to know how you extract the staff and pupil timetables from SIMS. Any info would be much apprechiated!!!

  7. #7
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30
    Quote Originally Posted by scottyses View Post
    DanIT... I would be interested to know how you extract the staff and pupil timetables from SIMS. Any info would be much apprechiated!!!
    Same here.. I thought this couldn't be done

  8. #8


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    me too.
    I'm going to start a wiki of some of the stuff thats working at my place before it all gets replaced with our (pants) LA offering.

    SIMS and Moodle Integration - EduGeek.net Wiki

  9. #9
    stratisphere's Avatar
    Join Date
    Apr 2007
    Posts
    295
    Thank Post
    33
    Thanked 87 Times in 31 Posts
    Rep Power
    31
    The buzz words at the moment as far as intergration goes with MIS's and VLE's (and anything else really) is SIF.

    Well, around here it is anyway!

    Basically the way it's supposed to work is, each app/system is SIF compliant. Then, there is a SIF agent which is responsible for translating the SIF framework back to (or from) what the application knows.

    E.g.
    Our vle is a system called Dokeos (really cool open-source VLE. Made by people from france. But fully translated... code is a little hard to follow at times tho).
    So, it would work like this...
    Dokeos -> SIF Agent -> SIMS.Net (Or other MIS)
    and vice versa
    SIMS.Net -< SIF Agent -< Dokeos

    Communication is live and as the application itself does the processing then data doesnt get corrupted from editing the database direct (not too much of an issue with things like VLE's... but with SIMS you can really mess up the DB if you edit it directly).

    As i'm aware, there are no open-source/free agents out there. And i suspect the SIF agent you would use for SIMS or any other MIS's would come with an extra cost.

    But the SIF website is Welcome to the Schools Interoperability Framework Association and i'm slowly making my way through the framework specification and writting an agent to do some things with it. No idea on timescale tho.

  10. #10
    mylearningltd's Avatar
    Join Date
    Feb 2011
    Location
    Shropshire
    Posts
    13
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    As a commercial VLE provider we have noticed that "integration" can mean different things.
    There's the easy way and the way it should work.

    Easy way - "Yes, we integrate with your MIS because we connect and read some data from it onto a screen"

    Hard way - "Yes, we integrate and by that we mean that if your MIS admin changes/adds or edits a user or group on the MIS then our VLE will synchronise on request to update
    the VLE to try and reflect the exact tree structure of your MIS. Yes, we will take into account that a user you just deleted from the MIS will need removed from the VLE and also
    try to work out what to do if that person happened to own 3 courses, 6 learning spaces, sent 15 moderation requests and has uploaded 1200 files that 80% of the school are still using.

    We will also do our best to work out what to do with a group on our VLE when you rename it on your MIS even though your MIS doesn't store any type of unique reference for groups similar to the UPN number for users. This means that if you rename a group on your MIS our VLE has no way of knowing what it use to be so as it only has the name of the group to rely on as a reference. It will assume it's deleted and a new group just got added."

    Fortunately, we've tackled the hard way (using a wizard) and now, if anyone asks "Do you integrate with MIS" we can explain the difference between "Yes" the easy way and "Yes" the proper way.
    At the moment, we've been saying "No" because to us, reading some data from a table onto a screen isn't integration in the sense we want it to mean.

    All the best!

    Adam
    Last edited by mylearningltd; 30th March 2012 at 02:45 PM.

  11. Thanks to mylearningltd from:

    mikecampbell (18th October 2013)

  12. #11

    Join Date
    Jun 2010
    Posts
    66
    Thank Post
    1
    Thanked 6 Times in 5 Posts
    Rep Power
    16
    Hi,

    I use a Java application I've written running via a cron job. Runs various SIMS reports remotely and gathers student, staff and class details. Staff, student and SIMS classes in Moodle are created/deleted as required via Moodle web services using REST protocols. Currently a separate database holds details of who is attached to which SIMS class/course and this is used for database enrollment. The SIMS classes/courses are then used as sources for meta enrollment for Moodle courses.

    Here are links to the Java libraries I've created to do this, however I haven't as yet released the code for the sync routine. Works and it's free!

    MoodleRest Java Library | Free software downloads at SourceForge.net
    SIMS CommandReporter Java API | Free software downloads at SourceForge.net

    Ignore the single not recommended on the second download, they obviously knew not what they were doing or were trying to divert attention, I've been running SIMS reports remotely for some time without problems.

  13. #12
    paulgarratt83's Avatar
    Join Date
    Feb 2009
    Posts
    37
    Thank Post
    0
    Thanked 6 Times in 6 Posts
    Rep Power
    13
    Quote Originally Posted by stratisphere View Post
    The buzz words at the moment as far as intergration goes with MIS's and VLE's (and anything else really) is SIF.

    Well, around here it is anyway!

    Basically the way it's supposed to work is, each app/system is SIF compliant. Then, there is a SIF agent which is responsible for translating the SIF framework back to (or from) what the application knows.

    E.g.
    Our vle is a system called Dokeos (really cool open-source VLE. Made by people from france. But fully translated... code is a little hard to follow at times tho).
    So, it would work like this...
    Dokeos -> SIF Agent -> SIMS.Net (Or other MIS)
    and vice versa
    SIMS.Net -< SIF Agent -< Dokeos

    Communication is live and as the application itself does the processing then data doesnt get corrupted from editing the database direct (not too much of an issue with things like VLE's... but with SIMS you can really mess up the DB if you edit it directly).

    As i'm aware, there are no open-source/free agents out there. And i suspect the SIF agent you would use for SIMS or any other MIS's would come with an extra cost.

    But the SIF website is Welcome to the Schools Interoperability Framework Association and i'm slowly making my way through the framework specification and writting an agent to do some things with it. No idea on timescale tho.
    To stratisphere

    I'm just wonering how far long you got with creating your own SIF agent. We are looking for SIMS.net - SIF - Moodle and am wanting to create my own SIF to access the SIMS.

    Cheers

  14. #13
    stratisphere's Avatar
    Join Date
    Apr 2007
    Posts
    295
    Thank Post
    33
    Thanked 87 Times in 31 Posts
    Rep Power
    31
    Quote Originally Posted by paulgarratt83 View Post
    To stratisphere

    I'm just wonering how far long you got with creating your own SIF agent. We are looking for SIMS.net - SIF - Moodle and am wanting to create my own SIF to access the SIMS.

    Cheers
    Oh man, as with all things "buzzy"... it's totally died off. I put loads of work/research in to doing a C# implementation of the SIF framework only to find that I could not find anything to link in to SIMS. I know Capita do some kind of developer kit but you have to pay a ridiculous fee for it... just to link in to a number of DLLs (There are of course other technical solutions/possibilities, but I could never endorse anything that does not follow various terms of use etc).

    I havnt heard the SIF buzzword in aggesssss. Currently everything is one way from SIMS. I have various apps which sit on servers that run imported reports in sims (via the commandreporter.exe) and then transfered to the site for processing via HTTPS XMLRPC. Basically, read only. But without paying for developer access, I can only dream of writing to SIMS.

    Interestingly enough, i'm currently working on an agent to link in to Moodle FROM sims (auto creating groups/enrolments etc). What are you looking to do?

  15. #14
    stratisphere's Avatar
    Join Date
    Apr 2007
    Posts
    295
    Thank Post
    33
    Thanked 87 Times in 31 Posts
    Rep Power
    31
    Interestingly enough, I've just been looking back over the SIF specifications for the UK and the last it was updated was Nov 2011 so it still seems to be around. I wonder if we can extract any kind of response from Capita to if they are going to support it in SIMS.

  16. #15
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    983
    Thank Post
    58
    Thanked 165 Times in 117 Posts
    Rep Power
    68
    Quote Originally Posted by stratisphere View Post
    Interestingly enough, I've just been looking back over the SIF specifications for the UK and the last it was updated was Nov 2011 so it still seems to be around. I wonder if we can extract any kind of response from Capita to if they are going to support it in SIMS.
    Capita are involved with the SIF UK Technical Board and Partnership Exchange uses SIF to move data between consortia schools/academies and there are third party application that can SIF enable SIMS.net.

    Is your agent to link Moodle and SIMS going to use SIF or interface with command reporter directly?

  17. Thanks to penfold_99 from:

    stratisphere (19th April 2012)

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. sharepoint 2007/sims intergration
    By scottyses in forum Virtual Learning Platforms
    Replies: 11
    Last Post: 17th February 2008, 11:42 AM
  2. mac os x aduc intergration ?
    By mac_shinobi in forum Mac
    Replies: 4
    Last Post: 15th November 2007, 09:23 PM
  3. CMIS Intergration
    By danIT in forum MIS Systems
    Replies: 4
    Last Post: 4th October 2006, 02:37 PM
  4. Flickr Intergration?
    By dagza in forum Mac
    Replies: 1
    Last Post: 17th May 2006, 01:20 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
  •