+ Post New Thread
Results 1 to 12 of 12
Windows Thread, Bulk user import/export using CSVDE - great resource in Technical; Just noticed the CSVDE pages over at ComputerPerformance.co.uk. Looks very useful for those who need to bulk import/export user accounts. ...
  1. #1
    ajbritton's Avatar
    Join Date
    Jul 2005
    Location
    Wandsworth
    Posts
    1,632
    Thank Post
    23
    Thanked 75 Times in 45 Posts
    Rep Power
    34

    Bulk user import/export using CSVDE - great resource

    Just noticed the CSVDE pages over at ComputerPerformance.co.uk. Looks very useful for those who need to bulk import/export user accounts. CSVDE is 2003 only though

  2. #2

    Join Date
    Mar 2006
    Posts
    537
    Thank Post
    2
    Thanked 3 Times in 2 Posts
    Rep Power
    18

    Re: Bulk user import/export using CSVDE - great resource

    Are you sure? OK then what was that thing I was using two years ago on a Windows 2000 network?

  3. #3

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,272
    Thank Post
    613
    Thanked 1,567 Times in 1,407 Posts
    Rep Power
    412

    Re: Bulk user import/export using CSVDE - great resource

    only drawback is csvde can't set passwords.

    Ben

  4. #4

    Join Date
    Mar 2006
    Posts
    537
    Thank Post
    2
    Thanked 3 Times in 2 Posts
    Rep Power
    18

    Re: Bulk user import/export using CSVDE - great resource

    Just use the same CSV to feed usernames to net user.

    There three steps:

    CSVDE to create accounts
    then a foreach for the following two commands
    net user %1 password
    net user %1 /active:yes

    Accounts should be disabled by default and won' be enabled until the account meets the password policy for the domain.

  5. #5

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180

    Re: Bulk user import/export using CSVDE - great resource

    There's a VBScript on that site that will set all your passwords too.

    I used CSVDE this year to create my accounts and it was extremley easy to do.

  6. #6

    Join Date
    Mar 2006
    Posts
    537
    Thank Post
    2
    Thanked 3 Times in 2 Posts
    Rep Power
    18

    Re: Bulk user import/export using CSVDE - great resource

    I've been meaning to switch to LDIFE but now dsadd is here it's probably not worth the bother.

  7. #7


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339

    Re: Bulk user import/export using CSVDE - great resource

    CSVDE is 2003 only though
    MS say its good for 2000: http://support.microsoft.com/?id=327620

  8. #8
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,996
    Thank Post
    120
    Thanked 280 Times in 258 Posts
    Rep Power
    106

    Re: Bulk user import/export using CSVDE - great resource

    CSVDE is in the 2000 course track. Will obviously have been an older version.

  9. #9
    mark's Avatar
    Join Date
    Jun 2005
    Posts
    3,958
    Thank Post
    248
    Thanked 49 Times in 45 Posts
    Blog Entries
    2
    Rep Power
    46

    Re: Bulk user import/export using CSVDE - great resource

    I've always used CSVDE on 2000 and 2003 severs - It's simple, quick and I know it works.

    I set passwords to surnames. Export usernames and names into a spreadsheet and add the net user command.

  10. #10
    ajbritton's Avatar
    Join Date
    Jul 2005
    Location
    Wandsworth
    Posts
    1,632
    Thank Post
    23
    Thanked 75 Times in 45 Posts
    Rep Power
    34

    Re: Bulk user import/export using CSVDE - great resource

    Apologies everyone! Having never even used CSVDE, I misread one of the ComputerPerformance pages which seemed to say CSVDE was for use on 2003 only. I stand corrected. Since it works on 2K and 2K3 then the CP pages look like an even more useful resource for those trying to do bulk user creation for the first time. (That's who I guess my original post was aimed at, but I appreciate those who have set me right.)

    Protocol question: Should I edit the original post to correct my error? Again, I'm thinking of those admins seeking methods of bulk user creation.

  11. #11
    Gibson335's Avatar
    Join Date
    May 2008
    Posts
    929
    Thank Post
    257
    Thanked 133 Times in 106 Posts
    Rep Power
    79

    CSVDE limitations?

    I need to use this tool to create a list of parent contact e-mail addresses for Exchange, but can it also create Distribution Groups? The idea being that I can bulk import into a mailing group at the same time. Otherwise I may have 1000 contacts which have to be placed manually into a DG.

    Any thoughts?

  12. #12
    Wiseman82's Avatar
    Join Date
    Jan 2006
    Location
    North East
    Posts
    48
    Thank Post
    3
    Thanked 14 Times in 11 Posts
    Rep Power
    21
    Some people might find this useful as an alternative to CSVDE. It's an app I created a while ago that allows you to create users directly from Excel:
    WiseSoft - Account Management. Bulk Create User Accounts with Excel Spreadsheet.

    I also have an app for bulk reset of user passwords:
    Bulk Password Control - Reset Passwords for Active Directory User Accounts

    And an app (same one as above really) that allows you to update user attributes from CSV file, or use Microsoft Excel to edit user account data. You can see some of these features in action in the video below:

    http://www.youtube.com/watch?v=sVcA8OLCTUY

    They are all freeware apps.

SHARE:
+ Post New Thread

Similar Threads

  1. Bulk user Creation
    By Jamie_a in forum Windows
    Replies: 10
    Last Post: 14th January 2009, 06:30 PM
  2. Edit user accounts in bulk
    By edsa in forum Windows
    Replies: 10
    Last Post: 21st June 2007, 09:39 PM
  3. Replies: 2
    Last Post: 30th January 2007, 10:27 PM
  4. Bulk user creation
    By Dos_Box in forum How do you do....it?
    Replies: 63
    Last Post: 13th November 2006, 07:02 PM
  5. AD Bulk User Importer
    By ChrisH in forum Scripts
    Replies: 17
    Last Post: 9th May 2006, 07:50 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
  •