Windows Thread, Logins for every child. in Technical; Looking for advise on how to create logins for every child with their initials as their user name and password ...
13th October 2008, 08:53 PM #1
Logins for every child.
Looking for advise on how to create logins for every child with their initials as their user name and password on Windows Server 2003 (standard). Without doing it the manual way!!
Was thinking their must be a way to import names via sims to AD some how?
p.s. Its a juniors
13th October 2008, 09:00 PM #2
We had a way of using Excel to generate a CSV file, then imported that somehow, I'll try find the instructions for you, did it about 5 years ago when our DC died...
13th October 2008, 09:05 PM #3
dsadd lets you add users from the command line, dsmod lets you alter existing users. Google for these to get how they are used then export the users from SIMS to a text file and a bit of creative use of Excel and wordpad will give you a batch file you can run.
Tip, it is VERY useful to stick their admissions number from SIMS into a field in active directory so that when you have two users with the same name or initials you have a definitive field to figure out which is which!
13th October 2008, 09:31 PM #4
You want a spreadsheet with a formula to create names from their name columns and this:
Mikey Magic's Web Site - Active User Manager for Windows 2000 & 2003 Active Directory (AD)
You start with an export from Sims/CMIS/Whatever with columns like FirstName,LastName,YearGroup
Then add your own username column and make a formula to create the username from the other columns. Add extra columns fro passwords etc. You can create home folder paths by selecting all the users in a year > properties > and set home folder as \\server\share\yeargroup\%username%
Last edited by ChrisH; 13th October 2008 at 09:33 PM.
2 Thanks to ChrisH:
KarlGoddard (15th October 2008), maniac (13th October 2008)
13th October 2008, 09:37 PM #5
Without using 3rd party software, your best bet is CSVDE, which is a utility that comes with Server 2003. You will need to preapre a CSV file from SIMS with the correct data in, but that shouldn't take too long.
Good article explaining how it works here;
CSVDE - Examples Import Export of user accounts Active Directory
EDIT: or you could use the utillity that ChrisH has posted, it looks easier than CSVDE!
13th October 2008, 09:44 PM #6
I also posted a vbs file a couple of years ago. I never did get round to finishing the GUI. The app I linked to is great though I have used it the last 2 years for the new intake.
Originally Posted by maniac
13th October 2008, 09:52 PM #7
I've just downloaded it myself to try, been looking for a decent (free) program for importing users. I've always used CSVDE (until I changed jobs to a CC3 network that is) which is OK once you've worked out how to format the CSV file, but this looks a whole lot easier and may come in handy if we decide to ditch CC3 next year.
Originally Posted by ChrisH
I did have a go at writing my own VB.NET program based on a (probably the same) VBS script, but never got the time to finish it.
Last edited by maniac; 13th October 2008 at 09:55 PM.
13th October 2008, 09:53 PM #8
Cheers chaps ill try it next time I am in! Looks good stuff.
In the mean time its interview preparation.
13th October 2008, 10:01 PM #9
I really will sort out my SIMS-to-AD Python script Real Soon Now...
Originally Posted by Jiser
13th October 2008, 10:12 PM #10
I use this tool and it's fantastic. A big thanks to the author for it - it has saved me hours this term.
WiseSoft - Account Management. Bulk Create User Accounts with Excel Spreadsheet.
13th October 2008, 10:32 PM #11
can 2nd wisesoft... i have used that bit of kit does the job nicely
14th October 2008, 09:09 AM #12
3rd for wisesoft is really easy to use.
14th October 2008, 09:38 AM #13
speak to penfold_99 he has a good vb script that works, I think he just needs some encouragement to document and release it
Originally Posted by dhicks
Thanks to CyberNerd from:
penfold_99 (14th October 2008)
14th October 2008, 09:55 AM #14
Use Dovestones ADBI too!
Though getting the CSV template to work was tricky but think that was down to column header orders..
14th October 2008, 11:05 AM #15
Personally, MIS + Excel + Dsadd + mkdir + subinacl = all users created in 30 seconds! Love it
..OK admittedly it took me about a day initially to create the excel spreadsheet I use to take my SIMS export and create the dsadd commands but after that away you go.
You also will probably need to make use of another windows command line tool called "subinacl" which allows you to modify the security on folders. For some reason I found that if you use dsadd to create the user it doesn't create the home drive and seure it the same way it does if you use the manual way of user creation.
Last Post: 2nd August 2013, 11:44 AM
By FAA in forum Windows Vista
Last Post: 8th September 2008, 11:48 AM
By Geoff in forum General Chat
Last Post: 28th September 2007, 07:02 PM
Last Post: 26th June 2007, 12:33 PM
By Nij.UK in forum Windows
Last Post: 28th September 2006, 08:39 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)