Hi,
I have a csv file like this:
FirstName;LastName;Site;Alias;UPN;DisplayName;Password
Eric;Jens;Paris;E.Jens;Eric.Jens@mahui.com;Eric Jens;Welcome
And I have my Script:
## Import data from csv and store it in variable 'data'
$data = import-csv $args[0]
## Function to convert password into a secure string
function New-SecureString([string] $plainText)
{
$secureString = new-object System.Security.SecureString
foreach($char in $plainText.ToCharArray())
{
$secureString.AppendChar($char)
}
$secureString
}
foreach ($i in $data)
{
$ss = new-securestring $i.password
## Mailbox Database Path
$db = "Server_Name\SG01\MDB"
## Organization Unit
$ou = "OU=Users,OU=Administration,DC=Mahui,DC=COM"
New-Mailbox -Alias $i.Alias -Name $i.DisplayName -OrganizationalUnit $ou -FirstName $i.FirstName -LastName $i.LastName -UserPrincipalName $i.UPN -Database $db -Password $ss -ResetPasswordOnNextLogon $true
}
When I run my script c:\mail.ps1 c:\mail.csv
It returns this error:
New-Mailbox : The argument cannot be null or empty.
At C:\mail.ps1:28 char:20
+ New-Mailbox -Alias <<<< $i.Alias -Name $i.DisplayName -OrganizationalUnit $
ou -FirstName $i.FirstName -LastName $i.LastName -UserPrincipalName $i.UPN -Dat
abase $db -Password $ss -ResetPasswordOnNextLogon $true
Does anyone have an idea?
Thx