#Powershell to import AD OU Structure from a CSV

So the next step to this post (#Powershell to export AD OU Structure) is to import the OUs.  This is quite simple and uses ADSI to create new OUs.  The CSV need to have atleast a column called Path, and that could be in this format:

“Administration”
“AdministrationContacts”
“AdministrationGroups”
“AdministrationGroupsDomain Local Groups”
“AdministrationGroupsGlobal Groups”,

The script will then reverse the path and convert it to a DN and create the OUs.  If the OU exists, the script will error and continue.  Enjoy

#
#import-organizationalUnitFromCSV.ps1
#

$CSVin = Import-Csv c:psOUs.csv
$OUs   = $CSVin | Sort Path

#CSV file need to have atleast a column called Path

$CurrentDomain = [System.DirectoryServices.ActiveDirectory.Domain]::getcurrentdomain()
$DC            = $CurrentDomain.FindDomainController().name + “:389″ #”localhost:389”
$Forest        = $CurrentDomain.Forest.ToString()
$Forest        = “dc=” + $Forest
$Forest        = $Forest.Replace(“.”,”,dc=”)
$domain        = [ADSI]”LDAP://$dc/$Forest”

ForEach($OU in $OUs){
  #Using the OU Path from the CSV File, split it down
  $tmpOU = $OU.Path.Split(“”)

  #Reverse the Path and make it AD happy
  $ActualOU=””;For($i=$tmpOU.Length;$i–;$i -eq 0){IF($tmpOU[$i] -ne “”){$ActualOU+= “OU=” + $tmpOU[$i] + “,”}}

  #Remove the trailing comma
  $ActualOU = $ActualOU.Substring(0, $ActualOU.Length-1)
  $ActualOU

  #Add the OU.  If it exists it will error but continue
  $NewOU = $Domain.Create(“organizationalunit”, $ActualOU); $NewOU.SetInfo()
}#ForEach

Next step is to import users and groups from a CSV .. coming soon.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: