+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 19
Windows Server 2000/2003 Thread, Mass User Creation in Technical; Hello Does anybody know of a way to create a list of new users in Active Directory from file? I ...
  1. #1
    Bankesy's Avatar
    Join Date
    Jan 2011
    Location
    Chelmsford
    Posts
    90
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Mass User Creation

    Hello

    Does anybody know of a way to create a list of new users in Active Directory from file?

    I have all the new users details in a spread sheet and wondered if there was an easier way than setting them all up manually and individually.

    Thank you
    Last edited by Dos_Box; 4th July 2014 at 01:27 PM.

  2. #2
    Norphy's Avatar
    Join Date
    Jan 2006
    Location
    Harpenden
    Posts
    2,233
    Thank Post
    50
    Thanked 271 Times in 209 Posts
    Blog Entries
    6
    Rep Power
    108
    There are so, so many ways. Here is a Powershell script which can import users from a CSV:

    Script Import users in Active Directory from CSV file

    You can do it with VBScript

    http://www.computerperformance.co.uk...preadsheet.htm

    Plus there are a plethora of third party applications which can do it too.

  3. #3

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,816
    Thank Post
    873
    Thanked 1,675 Times in 1,458 Posts
    Blog Entries
    12
    Rep Power
    444
    This is a really good and easy tool to do it - Account Management Spreadsheet

    All easy, no scripts etc and a full GUI. Just copy and paste your data into it.

  4. #4

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    2,708
    Thank Post
    144
    Thanked 545 Times in 489 Posts
    Rep Power
    149
    ^^Been using the Account Management spreadsheet for years now. It's ace - gives enough visual feedback while having flexibility and ease of use. Typical Wisesoft really.

  5. #5
    gtg93's Avatar
    Join Date
    May 2010
    Posts
    306
    Thank Post
    176
    Thanked 40 Times in 32 Posts
    Rep Power
    15
    Flo user Manager is pretty good - free evaluation copy but you have to pay to use the full thing.

  6. #6

    Join Date
    Aug 2010
    Location
    Grimsby
    Posts
    13
    Thank Post
    3
    Thanked 5 Times in 4 Posts
    Rep Power
    9
    Specops software do\did a free bit of software that allows you to use a spreadsheet/csv file and map columns to AD fields and import users on mass.

  7. #7
    jamesreedersmith's Avatar
    Join Date
    Sep 2009
    Location
    Ruskington
    Posts
    1,148
    Thank Post
    77
    Thanked 253 Times in 227 Posts
    Rep Power
    76
    active user manager, CSVDE, DSADD, LDIFDE, Powershell.....

    The list goes on, you pays your money (or not as most are free) and you takes your choice!!!

  8. #8

    Join Date
    Mar 2009
    Posts
    42
    Thank Post
    21
    Thanked 7 Times in 6 Posts
    Rep Power
    12
    Do any of the suggestions so far have the ability to create the user in AD, create the home folder on the server with permissions set, and set a share on that folder? The wisesoft spreadsheet one does the first two but not the third.

    Edit: Just seen this thread is for server 2000/2003. We're using 2012.

  9. #9


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    6,572
    Thank Post
    228
    Thanked 851 Times in 730 Posts
    Rep Power
    294
    Quote Originally Posted by protocol View Post
    Do any of the suggestions so far have the ability to create the user in AD, create the home folder on the server with permissions set, and set a share on that folder? The wisesoft spreadsheet one does the first two but not the third.

    Edit: Just seen this thread is for server 2000/2003. We're using 2012.
    so as well as creating the folder you using something like \\server\%username%$ as the home folder rather than \\server\users$\group\%username% ?

  10. #10


    Join Date
    May 2009
    Posts
    2,908
    Thank Post
    259
    Thanked 769 Times in 584 Posts
    Rep Power
    270
    There are some example powershell scripts which do this Here.

  11. #11

    Join Date
    Mar 2009
    Posts
    42
    Thank Post
    21
    Thanked 7 Times in 6 Posts
    Rep Power
    12
    Quote Originally Posted by sted View Post
    so as well as creating the folder you using something like \\server\%username%$ as the home folder rather than \\server\users$\group\%username% ?
    Correct.

    Quote Originally Posted by pcstru View Post
    There are some example powershell scripts which do this Here.
    Will take a look thanks.

  12. #12


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    6,572
    Thank Post
    228
    Thanked 851 Times in 730 Posts
    Rep Power
    294
    might be easier to create them and write a quick n dirty batch file to create the shares assuming it sets the home dir attribute correctly

    something like

    dir d:\users\group > c:\temp\users.txt
    for /f %%u in (c:\temp\users.txt\users.txt) do net share %%u$="d:\users\group\%%u" /grant:everyone,full /cache:none

  13. Thanks to sted from:

    protocol (4th July 2014)

  14. #13
    Sephiroth's Avatar
    Join Date
    Mar 2009
    Location
    The Ninth Circle
    Posts
    88
    Thank Post
    8
    Thanked 17 Times in 17 Posts
    Rep Power
    20
    Quote Originally Posted by protocol View Post
    Do any of the suggestions so far have the ability to create the user in AD, create the home folder on the server with permissions set, and set a share on that folder? The wisesoft spreadsheet one does the first two but not the third.

    Edit: Just seen this thread is for server 2000/2003. We're using 2012.
    All of my user accounts are created in powershell. If you want some pointers or examples, just ask.

    That applies to anyone who wants it

  15. Thanks to Sephiroth from:

    protocol (4th July 2014)

  16. #14


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    6,572
    Thank Post
    228
    Thanked 851 Times in 730 Posts
    Rep Power
    294
    heres my solution for doing it. Its a bit of a frankenstein spreadsheet. Basically fill it in and then copy and past the contents of the last 2 sheets to notepad and save as a batch file

    users using dsadd v3 inc dollar.xls

    all the school specific stuff is on sheet 1 and it auto generate usernames from name its currently set to last digit of you first initial first 5 or surname

  17. Thanks to sted from:

    protocol (4th July 2014)

  18. #15

    Join Date
    Mar 2009
    Posts
    42
    Thank Post
    21
    Thanked 7 Times in 6 Posts
    Rep Power
    12
    Quote Originally Posted by Sephiroth View Post
    All of my user accounts are created in powershell. If you want some pointers or examples, just ask.

    That applies to anyone who wants it
    That would be appreciated thanks. Ain't got a clue about powershell.

    Quote Originally Posted by sted View Post
    heres my solution for doing it. Its a bit of a frankenstein spreadsheet. Basically fill it in and then copy and past the contents of the last 2 sheets to notepad and save as a batch file

    users using dsadd v3 inc dollar.xls

    all the school specific stuff is on sheet 1 and it auto generate usernames from name its currently set to last digit of you first initial first 5 or surname
    Really handy thanks.

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

Similar Threads

  1. AUP logon acceptance program
    By mark in forum Downloads
    Replies: 10
    Last Post: 12th May 2010, 08:15 PM
  2. Mass Home Folder Creation?
    By Blind in forum Windows
    Replies: 11
    Last Post: 1st September 2007, 08:05 PM
  3. Mass Logon
    By FN-GM in forum Network and Classroom Management
    Replies: 28
    Last Post: 18th August 2007, 07:45 PM
  4. mass remote logon.
    By starscream in forum Windows
    Replies: 3
    Last Post: 26th July 2007, 07:55 PM
  5. Microsoft patches arrive en-mass
    By Dos_Box in forum IT News
    Replies: 4
    Last Post: 16th June 2005, 11:22 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
  •