Needing help with powershell to update/add data in AD

[Vanattenhoven-Jo]

Hello everyone, I’ have a csv file (; delimiter and as columns: samaccountname, extensionattribute2,extensionattribute1, employeeid, userprincipalname, extensionattribute3, extensionattribute4 and extensionattribute5. The goal is that it check for every user (samaccountname) if the other fields are already filled in, if not it needs to add the values from the csv file. The problem is it worked for 1 line, but when I added a 2nd row it didn’t work.

Import-Module ActiveDirectory
Import-Csv -Path ".\test2.csv" -delimiter ";" | ForEach-Object {
   Set-ADUser $_.samAccountName -add @{
   ExtensionAttribute1 = "$($_.ExtensionAttribute1)"
   ExtensionAttribute2 = "$($_.ExtensionAttribute2)"
   ExtensionAttribute3 = "$($_.ExtensionAttribute3)"
   ExtensionAttribute4 = "$($_.ExtensionAttribute4)"
   ExtensionAttribute5 = "$($_.ExtensionAttribute5)"
   EmployeeID = "$($_.EmployeeID)"
   UserPrincipalName = "$($_.Userprincipalname)"
    }
}

This is the script was using, but probably I’ve done something wrong.

Jo

[Evan7191]

For the second row, did the script throw an error, or did it populate incorrect values?

[Vanattenhoven-Jo]

For some reason it is working now. I’m getting errors but those can be handled. The biggest part is handled correctly. My apologies.