+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 19
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 ...
  1. #1

    Join Date
    Apr 2008
    Location
    Bournemouth
    Posts
    472
    Thank Post
    34
    Thanked 28 Times in 26 Posts
    Rep Power
    27

    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

  2. #2
    Nick_Parker's Avatar
    Join Date
    Jan 2008
    Location
    Dainfern, South Africa
    Posts
    440
    Thank Post
    95
    Thanked 18 Times in 13 Posts
    Rep Power
    17
    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...

  3. #3

    teejay's Avatar
    Join Date
    Apr 2008
    Posts
    3,189
    Thank Post
    285
    Thanked 775 Times in 585 Posts
    Rep Power
    336
    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!

  4. #4
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,988
    Thank Post
    120
    Thanked 283 Times in 261 Posts
    Rep Power
    107
    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 08:33 PM.

  5. 2 Thanks to ChrisH:

    KarlGoddard (15th October 2008), maniac (13th October 2008)

  6. #5

    maniac's Avatar
    Join Date
    Feb 2007
    Location
    Kent
    Posts
    3,069
    Thank Post
    210
    Thanked 430 Times in 310 Posts
    Rep Power
    144
    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

    Mike.

    EDIT: or you could use the utillity that ChrisH has posted, it looks easier than CSVDE!

  7. #6
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,988
    Thank Post
    120
    Thanked 283 Times in 261 Posts
    Rep Power
    107
    Quote Originally Posted by maniac View Post
    or you could use the utillity that ChrisH has posted, it looks easier than CSVDE!
    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.

  8. #7

    maniac's Avatar
    Join Date
    Feb 2007
    Location
    Kent
    Posts
    3,069
    Thank Post
    210
    Thanked 430 Times in 310 Posts
    Rep Power
    144
    Quote Originally Posted by ChrisH View Post
    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.
    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.

    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.

    Mike.
    Last edited by maniac; 13th October 2008 at 08:55 PM.

  9. #8

    Join Date
    Apr 2008
    Location
    Bournemouth
    Posts
    472
    Thank Post
    34
    Thanked 28 Times in 26 Posts
    Rep Power
    27
    Cheers chaps ill try it next time I am in! Looks good stuff.

    In the mean time its interview preparation.

  10. #9

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,663
    Thank Post
    1,263
    Thanked 786 Times in 683 Posts
    Rep Power
    237
    Quote Originally Posted by Jiser View Post
    Was thinking their must be a way to import names via sims to AD some how?
    I really will sort out my SIMS-to-AD Python script Real Soon Now...

    --
    David Hicks

  11. #10

    Join Date
    Nov 2006
    Location
    Kendal
    Posts
    1,555
    Thank Post
    112
    Thanked 177 Times in 144 Posts
    Rep Power
    72
    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.

  12. #11

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    5,069
    Thank Post
    160
    Thanked 926 Times in 728 Posts
    Blog Entries
    3
    Rep Power
    273
    can 2nd wisesoft... i have used that bit of kit does the job nicely

  13. #12
    DSapseid's Avatar
    Join Date
    Feb 2007
    Location
    West Sussex
    Posts
    1,152
    Thank Post
    130
    Thanked 54 Times in 47 Posts
    Rep Power
    38
    3rd for wisesoft is really easy to use.

  14. #13


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by dhicks View Post
    I really will sort out my SIMS-to-AD Python script Real Soon Now...
    speak to penfold_99 he has a good vb script that works, I think he just needs some encouragement to document and release it

  15. Thanks to CyberNerd from:

    penfold_99 (14th October 2008)

  16. #14

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,697
    Thank Post
    862
    Thanked 662 Times in 435 Posts
    Rep Power
    501
    Use Dovestones ADBI too!
    Though getting the CSV template to work was tricky but think that was down to column header orders..

  17. #15

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    1,678
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    45
    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.

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

Similar Threads

  1. Script to track user logins
    By Gatt in forum Scripts
    Replies: 47
    Last Post: 2nd August 2013, 10:44 AM
  2. Prevent simultaneous logins and more ...
    By FAA in forum Windows Vista
    Replies: 0
    Last Post: 8th September 2008, 10:48 AM
  3. Child porn art exhibit
    By Geoff in forum General Chat
    Replies: 9
    Last Post: 28th September 2007, 06:02 PM
  4. Concurrent user logins on 2k3 domain
    By doco in forum Windows
    Replies: 4
    Last Post: 26th June 2007, 11:33 AM
  5. Speed up Service Pack 2 Logins
    By Nij.UK in forum Windows
    Replies: 4
    Last Post: 28th September 2006, 07:39 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
  •