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 ...
20th June 2012, 07:50 PM #1
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?
20th June 2012, 08:13 PM #2
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.
20th June 2012, 08:57 PM #3
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.
20th June 2012, 10:10 PM #4
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.
20th June 2012, 10:44 PM #5
Originally Posted by MicrodigitUK
How much does it cost?
21st June 2012, 11:42 AM #6
Originally Posted by ihaveaproblem
21st June 2012, 12:18 PM #7
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
Thanks to matt40k from:
rpwillis (16th July 2012)
21st June 2012, 12:58 PM #8
I'd be interested to know how much this is as well.
23rd June 2012, 08:52 AM #9
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.
Thanks to vikpaw from:
rpwillis (16th July 2012)
25th June 2012, 09:00 AM #10
I am not a number!!! Oh wait, I'm 32427
25th June 2012, 11:22 AM #11
You're way down the ranks! I am Number 6.
Originally Posted by matt40k
By Max_Power in forum MIS Systems
Last Post: 14th April 2011, 03:19 PM
By CaterinaAnna in forum MIS Systems
Last Post: 12th January 2010, 03:28 PM
By u8dmtm in forum MIS Systems
Last Post: 8th September 2009, 02:27 PM
By jrubinstein in forum How do you do....it?
Last Post: 22nd June 2007, 09:40 AM
By David_Paylor in forum MIS Systems
Last Post: 23rd March 2007, 03:16 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)