+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, Need SIMS - AD Create Module in Technical; I am looking for a prohram that lets us export new users from SIMS and Creates Accounts in AD and ...
  1. #1
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    25

    Need SIMS - AD Create Module

    I am looking for a prohram that lets us export new users from SIMS and Creates Accounts in AD and visa versa when they leave their account is disablled..

    ANy Ideas ?

  2. #2
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    936
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Quote Originally Posted by Grommit View Post
    I am looking for a prohram that lets us export new users from SIMS and Creates Accounts in AD and visa versa when they leave their account is disablled..

    ANy Ideas ?
    Hi,

    Do you use moodle?

    I will be finished my moodle block that handles this in the coming weeks.

  3. #3
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    948
    Thank Post
    544
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    Quote Originally Posted by Grommit View Post
    I am looking for a prohram that lets us export new users from SIMS and Creates Accounts in AD and visa versa when they leave their account is disablled..

    ANy Ideas ?
    You can almost certainly do this from a batch file using DsMod, DsAdd, a "for" loop and some carefully crafted Sims .Net reports that output as CSVs...

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,425
    Thank Post
    368
    Thanked 642 Times in 524 Posts
    Rep Power
    159
    Salamander Active Directory
    SalamanderSoft Limited - Salamander Active Directory

    Capita SQL partner (both read\write)

  5. Thanks to matt40k from:

    Grommit (23rd June 2009)

  6. #5

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,646
    Thank Post
    1,255
    Thanked 781 Times in 678 Posts
    Rep Power
    236
    Quote Originally Posted by TonyRidal View Post
    You can almost certainly do this from a batch file using DsMod, DsAdd, a "for" loop and some carefully crafted Sims .Net reports that output as CSVs...
    I've got a script that does this - extracts data via a SIMS report (XML passed over HTTP rather than fiddling around with CSV files) and uses DsAdd to add users to Active Directory. It's currently broken while I convert it from Perl to Python, give us a couple of weeks and it should be sorted.

    --
    David Hicks

  7. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,425
    Thank Post
    368
    Thanked 642 Times in 524 Posts
    Rep Power
    159
    Quote Originally Posted by dhicks View Post
    I've got a script that does this - extracts data via a SIMS report (XML passed over HTTP rather than fiddling around with CSV files)
    Tasty

    Quote Originally Posted by dhicks View Post
    while I convert it from Perl to Python, give us a couple of weeks and it should be sorted.
    Agggh.... What's wrong with C# or such?

  8. #7

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,646
    Thank Post
    1,255
    Thanked 781 Times in 678 Posts
    Rep Power
    236
    Quote Originally Posted by matt40k View Post
    What's wrong with C# or such?
    Nothing, the utility is written as a pair of programs, one providing a Windows Service that acts as an HTTP server that simply passes report names and parameters on to CommandReporter.exe, the other as a library API that facilitates getting XML data via HTTP and processing it. Other people are more than welcome to write their own libraries in other languages to replace my API, and I only wrote the HTTP server in Python because that was the simplest, easiest thing I had to hand.

    --
    David Hicks

  9. #8
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    936
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Quote Originally Posted by dhicks View Post
    Nothing, the utility is written as a pair of programs, one providing a Windows Service that acts as an HTTP server that simply passes report names and parameters on to CommandReporter.exe, the other as a library API that facilitates getting XML data via HTTP and processing it. Other people are more than welcome to write their own libraries in other languages to replace my API, and I only wrote the HTTP server in Python because that was the simplest, easiest thing I had to hand.

    --
    David Hicks
    Hi David,

    What is you speed like with using a web service around commandreport.exe. Is there any caching invloved? as some reports can take a while.

    I went with csv as it's less fiddly than a direct DB connection (but does remove some of the possible features) and there wasn't any speed issues.

  10. #9

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,646
    Thank Post
    1,255
    Thanked 781 Times in 678 Posts
    Rep Power
    236
    Quote Originally Posted by penfold_99 View Post
    What is you speed like with using a web service around commandreport.exe. Is there any caching invloved?
    The speed is simply however long it takes commandreporter to run. HTTP itself doesn't have any timeout - your browser or web server normally handle timeouts, but my small Python web server will cheerfully sit there and wait for SIMS to take however long it wants. This, coupled with the fact that the web server is only single-threaded (i.e. it starts one request, waits until it's done, then does the next) does potentially mean that if commandreporter conks out then the web service will get stuck, but there's no reason I've seen to expect that to happen.

    Any caching I intended to happen client-side, i.e. it's up to the library / API to cache anything it wants. Theoretically, performance is also affected by encrypting / decrypting xhunks of XML at each end and using HTTP as a transport layer, but this isn't really intended to run anything a user will be directly using, it's for automated scripts that run once an hour or whatever, performance isn't really much of an issue.

    I went with csv
    The XML that comes out of commandreporter seems to be impressivly comprehensive, complete with schema embedded at the head of every document and everything, so I thought it a shame to waste it :-)

    We should probably, at some point soon, get together and discuss what we're doing and maybe try and coordinate our efforts a bit. It seems that you're rather further along than I am, so I should probably try and conform any API that I write (in Python) to whatever you're already got written. I'm attending the Open Source Schools un-conference in Nottingham next month where we'll be discussing this stuff, it'd be handy to know what you've done before then. Is there a code repository somewhere that you're using (CVS or whatever) - if not, do you reckon it's worth starting a SourceForge project or similar so we have somewhere to put stuff as we work on it?

    --
    David Hicks

  11. #10
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    936
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    @dhicks

    I will be at unconference also. (that reminds me i need to register a place)

    I'm in the proccess of turning my integration bits in to a commercial offering while still being open source.
    The idea is a co-op membership subscription, everyone pays the same low price (compared to other offerings, ie hundreds not thousands).

    The goal here is to sustain the development time with the lead of to 2010 and meeting the becta requirements.

  12. #11

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,646
    Thank Post
    1,255
    Thanked 781 Times in 678 Posts
    Rep Power
    236
    Quote Originally Posted by penfold_99 View Post
    I will be at unconference also.
    Ah ha, I'll see you there, then! Do you think we need to propose another session? I don't want to hijack the ScholarPack one, although I think the work we're doing is relevant to ScholarPack - no reason why anything we write can't work with ScholarPack or other tools as well as SIMS, we just need to agree on some kind of common API or data exchange format. We would basically be writing a bunch of plugins around a core MIS system, with the idea that we could (maybe) eventually swap out the core MIS for a different one.

    --
    David Hicks

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS.net EMA Module
    By Sylv3r in forum MIS Systems
    Replies: 8
    Last Post: 10th August 2009, 05:09 PM
  2. Sims Examinations Module
    By arthur231283 in forum MIS Systems
    Replies: 10
    Last Post: 29th April 2009, 11:47 AM
  3. SIMS Timetable Module for Moodle
    By Hightower in forum Virtual Learning Platforms
    Replies: 102
    Last Post: 4th February 2009, 01:50 PM
  4. SIMS Launcher Module NO ID
    By ndavies in forum MIS Systems
    Replies: 4
    Last Post: 29th February 2008, 12:54 PM
  5. Replies: 5
    Last Post: 1st October 2007, 09:27 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
  •