## ----Set Variables----
$vcenter = localhost
$hostscsv = Import-Csv "C:\PowerCLI\hosts.csv"
$datacsv = Import-Csv "C:\PowerCLI\data.csv"
$foldercsv = Import-Csv "C:\PowerCLI\folder.csv"
$clucsv = Import-Csv "C:\PowerCLI\clu.csv"

## ----Connect to VirtualCenter----

Connect-VIserver $vcenter

## ----Add Datacenters From CSV----

$datacsv | % {
$Name = $_.Datacenter
$Location = Get-Folder -Name $_.Location

New-Datacenter -Location $Location -Name $Name
}

## ----Add Folders From CSV----

$foldercsv | % {
$Name = $_.Folder
$Location = Get-Datacenter -Name $_.Location

New-Folder -Location $Location -Name $Name
}

## ----Add Clusters From CSV----

$clucsv | % {
$Name = $_.Cluster
$Location = Get-Folder -Name $_.Location
$DRS = $_.DRS
$DRSMode = $_.DRSMode
$HA = $_.HA

if ($DRS -eq "No" -AND $HA -eq "No")
{
New-Cluster -Location $Location -Name $Name 
}
elseif ($DRS -eq "No" -AND $HA -eq "Yes")
{
New-Cluster -Location $Location -Name $Name -HAenabled:$true
}
elseif ($DRS -eq "Yes" -AND $HA -eq "Yes")
{
New-Cluster -Location $Location -Name $Name -DRSEnabled -DRSMode $DRSMode -HAenabled:$true
}
elseif ($DRS -eq "Yes" -AND $HA -eq "No")
{
New-Cluster -Location $Location -Name $Name -DRSEnabled -DRSMode $DRSMode
}
}


## ----Add Hosts From CSV----

$hostscsv | % {
$PW = $_.Password
$HN = $_.Hostname
$Cluster = $_.Cluster
$User = $_.User
$Folder = $_.Folder
$getfolder = Get-Folder -Name $_.Folder
if ($Cluster -ne "n/a")
{
$getcluster = Get-Cluster -Name $_.Cluster
}
#$gethost = Get-Host -Name $_.Hostname

if ($Cluster -eq "n/a")
{
	Add-VMhost -Name $HN -User $User -Password $PW -Location $getfolder -Force
}
else
{
	Add-VMhost -Name $HN -User $User -Password $PW -Location $getcluster -Force

}
}

## ----Disconnect From VirtualCenter----

Disconnect-VIServer -Server * -Confirm:$false -Force:$true