+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, Exporting Admission numbers from sims to AD ? in Technical; Is it possible to export admin numbers from sims and directly in the users AD account? I know I can ...
  1. #1

    Join Date
    Jun 2010
    Location
    England
    Posts
    735
    Thank Post
    89
    Thanked 52 Times in 46 Posts
    Rep Power
    34

    Exporting Admission numbers from sims to AD ?

    Is it possible to export admin numbers from sims and directly in the users AD account?
    I know I can run a report within sims to get this data and then use a csv file to import the data into active directory. I was hoping of a scheduled/automated way which didnt rely on any user input.

    Anyone got any idea's?

  2. #2

    Join Date
    Mar 2011
    Location
    Bournemouth
    Posts
    280
    Thank Post
    16
    Thanked 74 Times in 64 Posts
    Rep Power
    21
    Yeah, its possible, I wrote a powershell script to auto generate ad users from SIMS and as part of that we record admission numbers and upns into fields in AD.

    We record the admission numbers against AD users at creation because there is no other reliable way of linking an AD user to a student in SIMS. This will be your problem with doing it automatically. How do you find the right student in AD to record the number against? Use their name to calculate a username? Surely you have name clashes which forced you to use a slightly non standard format, so that will cause problems.

    I suggest you do it manually once as you suggest and then ensure that you record the number when you create any additional users.

  3. #3
    camel's Avatar
    Join Date
    Nov 2009
    Location
    east midlands
    Posts
    109
    Thank Post
    30
    Thanked 38 Times in 19 Posts
    Rep Power
    15
    We are in the process in developing a powershell script, where my colleague is in the process of finishing development. We have both searched for various methods in order to match students from initial creation right though to managed name changes. Some pupils' names can change, more than once in certain familial situations.

    We decided on comparing the UPN and the admission number as unique fields where I created a report in sims to export all of the necessary student details. The report can be scheduled to run through the SIMS tool CommandReporter found in C:\Program Files\SIMS\SIMS .net\.

    The powershell script checks all of the fields that we want it to compare and either creates, updates, enables/disables the users through a combination of student status and date of birth to auto create the intake year OU in AD.

    The export only exports pupils who are on roll or pre-admissions. If the student is a leaver, they are not exported, and they have already been created in AD then the script knows that the user has left and only disables the user. The same powershell script can be run with a leavers flag to remove pupils that have been disabled. Any changes in sims are daily mirrored in AD.

  4. #4
    MicrodigitUK's Avatar
    Join Date
    May 2007
    Location
    Wiltshire
    Posts
    309
    Thank Post
    33
    Thanked 51 Times in 47 Posts
    Rep Power
    23

    Smile

    Just do what I did and pay someone to do it for you! Have a look at SalamanderSoft Limited - Salamander Active Directory

    What I like about it is, it dose what you need and also creates all of your class, tutor, year and house groups. I'v then built on this functanalaty and imported photos into AD using ther free tool. I'v also managed to sync all of the AD groups made by salamandersoft to my live@edu via Olysync.

    For an easy life just pay for a tool to do the job.
    Last edited by MicrodigitUK; 20th June 2012 at 10:13 PM.

  5. #5

    Join Date
    Jun 2010
    Location
    England
    Posts
    735
    Thank Post
    89
    Thanked 52 Times in 46 Posts
    Rep Power
    34
    Quote Originally Posted by MicrodigitUK View Post
    Just do what I did and pay someone to do it for you! Have a look at SalamanderSoft Limited - Salamander Active Directory

    What I like about it is, it dose what you need and also creates all of your class, tutor, year and house groups. I'v then built on this functanalaty and imported photos into AD using ther free tool. I'v also managed to sync all of the AD groups made by salamandersoft to my live@edu via Olysync.

    For an easy life just pay for a tool to do the job.

    How much does it cost?

  6. #6
    MicrodigitUK's Avatar
    Join Date
    May 2007
    Location
    Wiltshire
    Posts
    309
    Thank Post
    33
    Thanked 51 Times in 47 Posts
    Rep Power
    23
    Quote Originally Posted by ihaveaproblem View Post
    How much does it cost?
    PM sent...

  7. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,152
    Thank Post
    354
    Thanked 585 Times in 479 Posts
    Rep Power
    143
    SalamanderSoft is a pretty nice solution - if you've got the money to spend, well let me put it another way, assuming your smart enough to work out that it'll pay for itself and save you alot of hassle

  8. Thanks to matt40k from:

    rpwillis (16th July 2012)

  9. #8
    knightrider's Avatar
    Join Date
    Mar 2006
    Location
    Leeds
    Posts
    85
    Thank Post
    18
    Thanked 10 Times in 7 Posts
    Rep Power
    18
    I'd be interested to know how much this is as well.

  10. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,601
    Thank Post
    640
    Thanked 1,309 Times in 1,091 Posts
    Rep Power
    337
    I wouldn't want to mention cost on behalf of Richard, but he is on the forums @rpwillis so you could contact him as well as through the website link above.
    Depending on the size of your school, i think you'd be paying less than 1 per student per year. For that package, you get an awful lot of customisation / automation.

    Just as an aside. Our AD usernames are our admission numbers. Makes life so much easier It's also used for all sorts of other systems such as ID card, library barcode, etc.

  11. Thanks to vikpaw from:

    rpwillis (16th July 2012)

  12. #10

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,152
    Thank Post
    354
    Thanked 585 Times in 479 Posts
    Rep Power
    143
    I am not a number!!! Oh wait, I'm 32427

  13. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,601
    Thank Post
    640
    Thanked 1,309 Times in 1,091 Posts
    Rep Power
    337
    Quote Originally Posted by matt40k View Post
    I am not a number!!! Oh wait, I'm 32427
    You're way down the ranks! I am Number 6.

SHARE:
+ Post New Thread

Similar Threads

  1. Potential move from SIMS to Isams - have you done it?
    By Max_Power in forum MIS Systems
    Replies: 30
    Last Post: 14th April 2011, 03:19 PM
  2. Exporting timetables from SIMs to Excel
    By CaterinaAnna in forum MIS Systems
    Replies: 18
    Last Post: 12th January 2010, 03:28 PM
  3. Exporting Attendance Data from SIMS.Net
    By u8dmtm in forum MIS Systems
    Replies: 7
    Last Post: 8th September 2009, 02:27 PM
  4. Win32 SID path - linking sims to AD
    By jrubinstein in forum How do you do....it?
    Replies: 2
    Last Post: 22nd June 2007, 09:40 AM
  5. Exporting Pupil Data From SIMS
    By David_Paylor in forum MIS Systems
    Replies: 9
    Last Post: 23rd March 2007, 03:16 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
  •