Bulk change the employee ID from a .csv file

NYAdmin 1

I have a csv file with a list of (student)employee ID that are set incorrect and we need to update them to the new ID in the CSV file. I get an error message saying cannot find an object with Identity.

$Students = Import-Csv -Delimiter "," -Path "C:\Users\admin\Desktop\StudentIDChangeTest.csv"
foreach ($Student in $Students)
{
$SAM = $Student.USERNAME
$StudentID = $Student.STUDENTID
Set-ADUser $SAM -Add @{employeeID="$StudentID"}
}

James Hamil 21,621 Reputation points Microsoft Employee

2022-07-25T19:51:55.49+00:00

Hi @NYAdmin , do you have a more detailed error/ error code? If so can you paste it? I can then help you further.

Best,
James
NYAdmin 1 Reputation point

2022-07-25T20:17:26.387+00:00
Sure thanks.

Here are the columns in the spreadsheet.

I have the studentID being mapped to the EmployeeID in AD. I need to take the spreadsheet and change the old employeeID numbers with the new StudentID from this spreadsheet.

When I run this command i get this error string

Set-ADUser : Cannot find an object with identity: '' under: 'DC=XXXXXX,DC=XXXXXXX,DC=XXX'.
At D:\Scripts\Student ID Change.ps1:12 char:5

Set-ADUser $SAM -Add @{employeeID="$StudentID"}

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

CategoryInfo : ObjectNotFound: (:ADUser) [Set-ADUser], ADIdentityNotFoundException

FullyQualifiedErrorId : ActiveDirectoryCmdlet:Microsoft.ActiveDirectory.Management.ADIdentityNotFoundException,Microsoft.ActiveDirectory.Managemen
t.Commands.SetADUser