$Domain = "regen.lan"
$OUs = @("Leerlingen", "Docenten", "Directie", "Administratie", "")
foreach ($OU in $OUs){
    New-ADOrganizationalUnit $OU
}


$Users = Import-Csv -Delimiter "," -Path "database.csv"
foreach ($User in $Users)
{
    $VolledigeNaam = $User.vnaam + " " + $User.tv + " " + $User.anaam
    $Voornaam = $User.vnaam
    $Achternaam = $User.anaam
    $OU = "CN=$User.ou, DC=regen, DC=lan"
    $Gebruikersnaam = $User.nummer
    $Group = $User.soort
    # $UPN = $User.Firstname + "." + $User.Lastname + "@" + $User.Maildomain
    $Wachtwoord = $User.wachtwoord
    $newGroup=New-ADGroup -Path $OU -Name $Group -GroupScope DomainLocal -GroupCategory Distribution
    New-ADUser -Name "$VolledigeNaam" -DisplayName "$VolledigeNaam" -SamAccountName $Gebruikersnaam -UserPrincipalName $Gebruikersnaam -GivenName "$Voornaam" -Surname "$Achternaam" -AccountPassword (ConvertTo-SecureString $Wachtwoord -AsPlainText -Force) -Enabled $true -Path "$OU" -ChangePasswordAtLogon $false –PasswordNeverExpires $true -server $Domain
}