+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 22
MIS Systems Thread, Logins at same time as enrolment in Technical; Has anyone here fully integrated their MIS with their network system so that when a new student is enrolled / ...
  1. #1

    Join Date
    Jan 2007
    Posts
    971
    Thank Post
    10
    Thanked 35 Times in 27 Posts
    Rep Power
    22

    Logins at same time as enrolment

    Has anyone here fully integrated their MIS with their network system so that when a new student is enrolled / put on the MIS system they are automatically created a network login at the same time? Not exporting data into a CSV file!

    Obviously this would involve enrolment staff having extra access to AD etc but it would be a lot more streamlined than a huge text file every morning!

  2. #2

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,457
    Thank Post
    645
    Thanked 1,611 Times in 1,443 Posts
    Rep Power
    419
    Doesn't have to be that way I'd favour an automatic integrated system rather than giving someone eleveated access.

    Ben

  3. #3

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    71
    These guys (SystemHOST | Extra-ordinary IT outsourcing) wrote us a utility called SimSync. This creates AD accounts automatically when students and staff join. It also disables them when they leave on SIMS. It runs over night for us but I can't see any reason why it couldn't run more often. Perhaps worth giving them a call.

  4. #4

    Join Date
    May 2011
    Location
    Jus North of London, close but not too close
    Posts
    760
    Thank Post
    174
    Thanked 56 Times in 54 Posts
    Rep Power
    35
    Set this up at last place. This may not be suitable for your enviroment but it worked in ours.

    A MS Database to pull from the MIS system database, manipulate and export the needed data as csv's. Use something like dovestones that will also create user and home areas from the csv's that were exported.

    Task scheduler can be used to open the database (set the database to autorun) and create additional tasks to run Dovestones command line interfaces to use the exported csv's to update AD.

    Just test, test and test on a test OU.

    What puts you off having csv files?
    Last edited by Davit2005; 27th January 2012 at 11:19 AM.

  5. #5

    Join Date
    Jan 2007
    Location
    Nottinghamshire
    Posts
    530
    Thank Post
    1
    Thanked 84 Times in 58 Posts
    Rep Power
    38
    sims2ad - VBScript that reads a Capita SIMS database, or Excel file, compares to Active Directory, and add/removes/changes users as needed. Multiple site aware - Google Project Hosting is a script I part wrote, enables, disables, moves between sites from sims for pupils, or excel file for staff, easy enough to alter to do staff from sims if you wanted.

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,850
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Most MISes i spoke to say that they are able to integrate. Certainly since they can do single sign on. So it should be possible to write a routine to push the new users into AD.
    Which one do you use @googlemad ?
    It would really only be semi-automatic, so a script / routine that runs overnight. But could in theory be triggered on-demand. I would want it to run as a different user, on the server, so you don't need to give elevated rights to the end user.
    For example with SIMS in order to use their SLG (sharepoint/VLE type product) they have a service called ADP, which is active directory provisioning that is scheduled to run overnight.
    Most routines will most likely need some intermediate step, be it csv or a direct read into another db. ADP stores it's own list in a table in the db.
    I would recommend @rpwillis from SalamanderSoft who can do all kinds of integration with various MIS, moodle, sharepoint, especially if you don't fancy hacking around the dbs or with code yourself.

  7. #7

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,457
    Thank Post
    645
    Thanked 1,611 Times in 1,443 Posts
    Rep Power
    419
    Seems salamandersoft have it covered: SalamanderSoft Limited - Salamander Active Directory

    Don't know about pricing though

    Ben

  8. #8
    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 mavhc View Post
    sims2ad - VBScript that reads a Capita SIMS database, or Excel file, compares to Active Directory, and add/removes/changes users as needed. Multiple site aware - Google Project Hosting is a script I part wrote, enables, disables, moves between sites from sims for pupils, or excel file for staff, easy enough to alter to do staff from sims if you wanted.
    I see the script i wrote has found a new home.

  9. #9
    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 googlemad View Post
    Has anyone here fully integrated their MIS with their network system so that when a new student is enrolled / put on the MIS system they are automatically created a network login at the same time? Not exporting data into a CSV file!

    Obviously this would involve enrolment staff having extra access to AD etc but it would be a lot more streamlined than a huge text file every morning!
    There are SIF based applications that can do this and integrating with office365 and Google Apps.

  10. #10
    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 jcollings View Post
    These guys (SystemHOST | Extra-ordinary IT outsourcing) wrote us a utility called SimSync. This creates AD accounts automatically when students and staff join. It also disables them when they leave on SIMS. It runs over night for us but I can't see any reason why it couldn't run more often. Perhaps worth giving them a call.
    I have have looked at their site but didn't come across it. Know any rough costs?

  11. #11
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    25
    We achieved this a few years ago. A script runs on a schedule (we have found overnight is frequently enough) and goes through the MIS data on the SQL server cross referencing each student against an MSAccess table. Any students / staff who do not have an entry in the MSAccess table have a new AD account, home drive, email address, canteen card number, library card reference etc. generated.

    It works just as well with a single new student mid term as it does with our 300 strong new intake in September.

    The interim MSAccess DB saves having to record information in the MIS and seems more efficient that having to check AD - it also gave us the opportunity to do a snap shot when we first started so that it didn't generate everyone a new account.

  12. #12
    sdc
    sdc is offline
    sdc's Avatar
    Join Date
    Apr 2008
    Location
    Dorset, UK
    Posts
    312
    Thank Post
    53
    Thanked 42 Times in 37 Posts
    Rep Power
    41
    Quote Originally Posted by plexer View Post
    Seems salamandersoft have it covered: SalamanderSoft Limited - Salamander Active Directory

    Don't know about pricing though

    Ben
    We use this very effectively; pricing is good in my opinion for what the software does.

  13. Thanks to sdc from:

    plexer (27th January 2012)

  14. #13

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,024
    Thank Post
    373
    Thanked 365 Times in 297 Posts
    Blog Entries
    8
    Rep Power
    176
    With SIMS, and granted is 2 years since my last use of it, used ADPT to do just this. It was the provisioning tool that bolted into SLG?

    Anyone back me on that?
    Last edited by vikpaw; 28th January 2012 at 05:39 AM. Reason: sneaky advertising

  15. #14

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,850
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by plexer View Post
    Seems salamandersoft have it covered: SalamanderSoft Limited - Salamander Active Directory

    Don't know about pricing though

    Ben
    It's reasonable and depending on what you want doing can be flexible, and everything is customised to suit the environment, it's not like you're buying a boxed product.

    Quote Originally Posted by GREED View Post
    With SIMS, and granted is 2 years since my last use of it, used ADPT to do just this. It was the provisioning tool that bolted into SLG?

    Anyone back me on that?
    @GREED
    I can back you on one thing - see post 6.
    Last edited by vikpaw; 28th January 2012 at 06:02 AM.

  16. #15

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,024
    Thank Post
    373
    Thanked 365 Times in 297 Posts
    Blog Entries
    8
    Rep Power
    176
    Quote Originally Posted by vikpaw View Post
    It's reasonable and depending on what you want doing can be flexible, and everything is customised to suit the environment, it's not like you're buying a boxed product.


    @GREED
    I can back you on one thing - see post 6.

    D'oh missed that bit totally! To be fair I would have expected you to have mentioned that mate

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

Similar Threads

  1. Replies: 1
    Last Post: 7th February 2010, 10:41 PM
  2. DHCP DNS AD all died at the same time!
    By CHR1S in forum Windows Server 2000/2003
    Replies: 14
    Last Post: 30th November 2009, 11:12 AM
  3. b/g and n wireless at the same time
    By rocknrollstar in forum Network and Classroom Management
    Replies: 6
    Last Post: 8th November 2009, 08:11 PM
  4. Restricted login at specific times
    By mortstar in forum Windows
    Replies: 12
    Last Post: 28th March 2007, 10:51 AM
  5. Restrict users to a single login at any one time
    By frontal in forum How do you do....it?
    Replies: 6
    Last Post: 15th September 2006, 12:45 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
  •