Hi,

where have the error?

$ou = "OU=Users,DC=domain,DC=local"

Error:

Thanks

$ou='OU=Users,DC=domain,DC=local'

Import-Csv C:\smtp.csv |
    Foreach {
        [array]$proxyAddresses=$_.ProxyAddresses -split ";"
        if($proxyAddress[0] -notmatch '^smtp:'){"BAD ADDRESS"}
        Get-ADUser -SearchBase $ou -Filter "userPrincipalName -eq '$($_.userPrincipalName)'" | 
                 Set-ADUser -Add @{proxyAddresses=$proxyAddreses[0]}
 }		

Hi JRV. Thanks

the script gives me an error

• Edited by ThorElPoderoso 11 hours 42 minutes ago

the if statement says $proxyAddress[0] rather than $proxyAddresses[0]. Also, at the end it will only add the first proxy address, remove the [0], in order to add the array of addresses

Just do this to test your file.

Import-Csv C:\smtp.csv |
    Foreach {
        Write-Host "UPN->>$($_.UserPrincipalName)" -fore green
        Get-ADUser -Filter "userPrincipalName -eq '$($_.userPrincipalName)'" |
    }

the if statement says $proxyAddress[0] rather than $proxyAddresses[0]. Also, at the end it will only add the first proxy address, remove the [0], in order to add the array of add

Hi

the result :(

Foreach {

Check your spelling of variables, the error messages indicate

For this?  $proxyAddreses

I change for :  Set-ADUser -Add @{proxyAddresses=$proxyAddresses}

What I don't understand is the split command. What with "," works with ";" not?

Clayman is confusing the issue here.

Please resolve the following:

The names are not there because the field is empty and it will throw an error.  You cannot run this with an empty field. Either use data or filter out the null entries.

But all fields are null. I don't need to check them, just write the field

Why are all of the fields in your CSV null?  What is it that you are trying to do.  YOu cannot use a CSV with all empty fields.

No, sorry, explain me evil. There is no ninfun datoi null the CSV. I mean that the ProxyAddress are empty of allusers

What the hell is that supposed to mean?  It is not English.  It is not Spanish.  It is just nothing.

What is in the CSV.  We have not ever been referring to anything but the contents of the CSV.

Post the first two or three lines of the CSV.

CSV

userPrincipalName,ProxyAddresses
user01@domain.com,smtp:user01@domain.com;smtp:user01@domain.onmicrosoft.com;
user02@domain.com,X500:user02@domain.com;smtp:user02@domain.onmicrosoft.com;

The original script is, but what I don't understand is why the ';' does not work.

$ou = "OU=Users,DC=domain,DC=local"

The original script is, but what I don't understand is why the ';' does not work.

Because the field is bad.  It ends in a semicolon which creates an array with a blank entry.

I was trying to get you to see that and then show you how to fix it. You have to use a different split method.

$_.UserPrincilpeNames.Split(';',[System.StringSplitOptions]::RemoveEmptyEntries)

you have reason. Not that I have posted in that. Many thanks for your patience

Set-ADUser -Add @{ProxyAddresses = ($_.proxyaddresses.Split(';',[System.StringSplitOptions]::RemoveEmptyEntries))} 

You do not need to use the search base.  UPN is indexed and must be unique.

Get-ADUser -Filter "userPrincipalName  -eq '$($_.userPrincipalName)'"

All that other decoration will likely slow dowsn the process and make it more prone to error.

Using "-like" with no wildcards serves no purpose over "-eq".  We have a lot of superstitious people here who believe it adds some special thing to the search.  It doesn't.

One last thing. If the CSV tnego end;, and exclude it will not start the PorxyAddresswith a space?

userPrincipalName,ProxyAddresses
user01@domain.com,smtp:user01@domain.com;smtp:user01@domain.onmicrosoft.com; ;
user02@domain.com,X500:user02@domain.com;smtp:user02@domain.onmicrosoft.com; ;

One last thing. If the CSV tnego end;, and exclude it will not start the PorxyAddresswith a space?

If the CSV which have provided me a last null value, as I exclude it?

user01@domain.com,smtp:user01@domain.com;smtp:user01@domain.onmicrosoft.com; ;
user02@domain.com,X500:user02@domain.com;smtp:user02@domain.onmicrosoft.com; ;

The Split() method of string removes ALL null entries.

Thanks!!!

I'm going to try it

Hi JRV. Thanks

the script gives me an error

• Edited by ThorElPoderoso Tuesday, July 21, 2015 7:28 PM

Hi JRV. Thanks

the script gives me an error

• Edited by ThorElPoderoso Tuesday, July 21, 2015 7:28 PM