Bulk Modify Attributes

stavros mitchell 56

Hell Everyone i created an excel sheet to bulk update some attributes for example Display Name , UPN, Addres , Office Number , Mobile Number, country , city, title, company.

But i cannot seem to get a powershell command to work. Would anyone have any suggestions

thanks

1 answer

Rich Matheisen 45,111 Reputation points

2020-08-24T21:21:56.623+00:00
What command?

Post the script you're using.

I think you'd be better off using a CSV file (just export the contents of the Excel file) than dealing with Excel automation to get the data.

Something like this can be used as a model:

import-csv <your-file-name-here> | ForEach-Object{ $ReplaceParams = @{ DisplayName = $_."Display Name" UPN = $_.UPN etc. etc. } Set-ADUser -Identity $_.Identity -Replace $ReplaceParams }
Please sign in to rate this answer.
stavros mitchell 56 Reputation points

2020-08-25T12:59:20.627+00:00

Thanks for the help this is what i am trying

Import-module ActiveDirectory
import-csv c:\POC.csv |
ForEach-Object{
$ReplaceParams = @{
DisplayName = $.DisplayName
UserPrincipalName = $.UPN
StreetAddress = $.address
Office = $.Office
Country = $.Country
Title = $.title
City = $.City
PostalCode = $.PostalCode
PhoneNumber = $.PhoneNumber
State = $.State
Company = $.company
}
Set-ADUser -Identity $.DisplayName -Replace $ReplaceParams
}

But getting an error saying "Cannot validate argument on parameter 'Replace'. The argument is null or an element of the argument
collection contains a null value"

thanks

Rich Matheisen 45,111 Reputation points

2020-08-25T15:33:14.69+00:00

One problem is that there's no "PhoneNumber" parameter available on the Set-ADUser cmdlet. There's a "-MobilePhone", an "-OfficePhone", and a "-HomePhone". There's also a "-Fax" parameter. You'll have to pick one of those.

Another problem is that you may have to use a "@" instead of a "$" in front of the hash argument. E.g., "-Replace @ReplaceParams".

If "PhoneNumber" is really the attribute you want to replace, I believe you an add another has as a member of the $ReplaceParams hash. Something like this:

**. . . Company = $_.company OtherAttributes = @{ PhoneNumber = $_.PhoneNumber }**
Sign in to comment

Share via

Bulk Modify Attributes

1 answer