Please Read: Significant Update Planned, Migrating Forum Software This Month

See more
See less

Import CSV files into AD

  • 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


  • #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
    Daniel Frei
    -Windows Operations Server Administrator
    -Exchange Guru
    -Cisco Fanatic
    -SharePoint Hippie
    -Volkswagen Enthusiast


    • #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)


      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


      • #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 )
        $inputFile = Import-CSV  <insert filepath here>
        foreach($line in $inputFile)
            dsadd user -samid $line.Username -pwd $line.Password