PowerShell-Skript zum Importieren ins AD aus einer csv

$Csvfile = "Z:\import.csv"  
$Users = Import-Csv $Csvfile

# Import the Active Directory module
Import-Module ActiveDirectory

# Loop through each user
foreach ($User in $Users) {
    $GivenName = $User.'First name'  
    $Surname = $User.'Last name'  
    $DisplayName = $User.'Display name'  
    $SamAccountName = $User.'User logon name'  
    $UserPrincipalName = $User.'UPN User principal name'  
#    $AccountPassword = $User. 'User Password' 


 # Create new user parameters
    $NewUserParams = @{
        Name                      = "$Surname $GivenName"  
        GivenName             = $GivenName
        Surname                  = $Surname
        DisplayName           = $DisplayName
        SamAccountName   = $SamAccountName
        UserPrincipalName  = $UserPrincipalName
        #AccountPassword   = (ConvertTo-SecureString "$AccountPassword" -AsPlainText -Force) 
	Path			 = "OU=Pfad,OU=zu,OU=Benutzern,DC=Meine,DC=Firma,DC=de"  
        Enabled                    = $true
        ChangePasswordAtLogon = $false # Set the "User must change password at next logon" flag 
    }

    try {
        # Create the new AD user
        New-ADUser @NewUserParams
        Write-Host "User $SamAccountName created successfully." -ForegroundColor Cyan  
    }
    catch {
        # Failed to create the new AD user
        Write-Warning "Failed to create user $SamAccountName. $_"  
    }
}

"GivenName","Surname","DisplayName","SamAccountName","UserPrincipalName"  
"Lisa","Muster","Muster Lisa","MusterLi","MusterLi@Meine.Firma.de"