Announcement

Collapse
No announcement yet.

Import CSV files into AD

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Import CSV files into AD

    i have created a csv file with that contains active directory users and passwords , now how is the best tool to import this csv file into active directory with the password

    thanks.

  • #2
    Re: Import CSV files into AD

    You can use either csvde or ldifde to import into active directory.

    I have personally used csvde..

    here's a Microsoft KB Article about it

    http://support.microsoft.com/kb/327620
    Daniel Frei
    -Windows Operations Server Administrator
    -Exchange Guru
    -Cisco Fanatic
    -SharePoint Hippie
    -Volkswagen Enthusiast

    www.lazynetworkadmin.com

    Comment


    • #3
      Re: Import CSV files into AD

      LDIFDE does not work with CSV files.
      CSVDE is unable to add passwords, when you import an account it is given a null password.

      So, change the domain policy to allow blank passwords, run CSVDE and, use a separate VBScript to set the passwords and enable accounts (vbscripts can read from the csv-file)

      samples
      http://www.computerperformance.co.uk/ezine/ezine23.htm
      http://technet.microsoft.com/en-us/l...7091.aspx#EBAA


      \Rems
      Last edited by Rems; 14th October 2009, 18:20.

      This posting is provided "AS IS" with no warranties, and confers no rights.

      __________________

      ** Remember to give credit where credit's due **
      and leave Reputation Points for meaningful posts

      Comment


      • #4
        Re: Import CSV files into AD

        That script on powershall + dsadd tool seems to work, I'll check it at work tomorrow in the morning

        (dsadd - tool, avaible on server 2003 DCs http://technet.microsoft.com/en-us/l...8WS.10%29.aspx )
        Code:
        $inputFile = Import-CSV  <insert filepath here>
        foreach($line in $inputFile)
        {
            dsadd user -samid $line.Username -pwd $line.Password
        }

        Comment

        Working...
        X