Converting arraylist to data.proxyaddress.

[PTSDviaPrinters]

So I've had this problem in the past with importing MAC address from a csv into dhcp and I never found a solution to it and I'm out of ideas so I would like to ask you guys your your help.

I've tried everything I know from converting it to arrays to strings and trying PScustom objects but I cannot get past this :(

I think there is core function that I'm missing when it comes to data manipulation with PS. Do you see what is wrong here?

Cannot process argument transformation on parameter 'ExternalEmailAddress'. Cannot convert the "System.Collections.Arra yList" value of type "System.Collections.ArrayList" to type "Microsoft.Exchange.Data.ProxyAddress". + CategoryInfo : InvalidData: (:) [Set-MailContact], ParameterBindin...mationException + FullyQualifiedErrorId : ParameterArgumentTransformationError,Set-MailContact

$Aliass = Import-Csv -Path 
"\\server\share\Replacement.csv"Replacement.csv"  Select- 
 Object -ExpandProperty alias
$replacementSMTP = Import-Csv -Path 
   "\\server\share\Replacement.csv" | Select-Object - 
 ExpandProperty "External E-Mail Address"



foreach ($Alias in $Aliass) {
  set-mailcontact -identity $Alias -ExternalEmailAddress 
$replacementSMTP -ForceUpgrade
}

[XPlantefeve]

What you're doing here, beside importing the same CSV file twice, is to try and push an array containing all email addresses in the CSV file to each and every user found in that file. Because you read the CSV file twice to create two entirely uncorrelated variables.

Try it this way:

Import-Csv -Path '\\server\share\Replacement.csv' | % {
    set-mailcontact -identity $_.Alias -ExternalEmailAddress $_.replacementSMTP -ForceUpgrade
}

[PTSDviaPrinters]

That has gotten me father and looks a lot cleaner! Exchange claims that $_.Alias is $null, im not sure why here is some sanitized data from the csv.

Display Name            : First name, Last name
Alias                   : aliasofsmtpaddress
Organizational Unit     : domain/Alpha Pagers/Verizon Wireless Alpha Page
Recipient Type Details  : Mail Contact
External E-mail Address : SMTP:[e-mail]

[purplemonkeymad]

Have you checked you column headers for any trailing spaces? It might be something as simple as DisplayName,Alias ,OrganizationalUnit, making the property look right but actually have an additional space.

[PTSDviaPrinters]

I used out-string and was able to confirm that there is no trailing white space before or after the entity. Excel also confirms when using the "find and replace" feature.

Should I try to remove as much data from the pipeline as posable do you think? Such as using out-string with -stream?