Hi Shay,

I ran the following:

# Set up variables $data = Import-CSV c:\import.csv
# Database where we are going to put the user mailboxes
$mdb = 'EX07SP1\Mailbox Database'
$ou = 'litwareinc.com/Users'
 #Import the data and create the new mailboxes
ForEach ($i in $data){ $i.password }  { $ss = ConvertTo-SecureString $i.password -asPlaintext -Force
$upn = $i.id + "@ehs.com"
New-Mailbox -Password $ss -Database $mdb -UserPrincipalName $upn -name $i.fullname -OrganizationalUnit $ou -SamAccountName $i.id -FirstName $i.firstname -LastName $i.lastname -Displayname $i.fullname }


When I ran this the mailbox wasn't created. I'm using Powergui script editor. I ran the script in external powershell window mode and the output was the contents of the script. I also ran the following script and had the same issue:

# Set up variables

$data = Import-CSV c:\import.csv
$ou = 'litwareinc.com/Users'

#Import the data and create the new mailboxes

ForEach ($i in $data){ $i.password }
{
$ss = ConvertTo-SecureString $i.password -AsPlainText -Force
$upn = $i.id + "@ehs.ucsb.edu"
new-QADUser -Password $ss -UserPrincipalName $upn -name $i.fullname -OrganizationalUnit $ou -SamAccountName $i.id -FirstName $i.firstname -LastName $i.lastname -Displayname $i.fullname -Department $i.department -Title $i.title -PhoneNumber $i.phone
}

I actually would like to get the password situation worked out with the NewQADUser script above as opposed to the new-mailbox script, but the password issue is the same with both scripts.

Thanks,
alex

Hi Shay,

I acutally ran a similar script as this is what I decided I need to run. Instead of the new-mailbox command I am running the new-QADuser command. I can create mailboxes later after the user is created. I am still having a problem with the password part though. The account gets created no problem but a password does not get created. Below is the output after the script is run. Here is an example from the csv file...

ID,fullname,LastName,FirstName,Password,title,department, Phone
john.doe,John Doe, Doe, Jon,dfkew#1, Manager, Human Resources,805-989-3433


Here is my code:

# Set up variables

$data = Import-CSV c:\import.csv
$ou = 'litwareinc.com/Users'

#Import the data and create the new mailboxes

ForEach ($i in $data)
{
$ss = ConvertTo-SecureString $i.password -AsPlainText -Force
$upn = $i.id + "@ehs.ucsb.edu"
##also try firstname . lastname
new-QADUser -Password $ss -UserPrincipalName $upn -name $i.fullname -OrganizationalUnit $ou -SamAccountName $i.id -FirstName $i.firstname -LastName $i.lastname -Displayname $i.fullname -Department $i.department -Title $i.title -PhoneNumber $i.phone
}

Here is the output of the script:



Name                           Type            DN
----                           ----            --
John Doe                       user            CN=John Doe,CN=Users,DC=LITWA...

ConvertTo-SecureString : Cannot bind argument to parameter 'String' because it
is null.
At C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\6a4b55df-de08-4fe2-b8c4-680f6a2eba57.ps1:
10 char:29
+ $ss = ConvertTo-SecureString  <<<< $i.password -AsPlainText -Force
New-QADUser : The argument cannot be null or empty.
At C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\6a4b55df-de08-4fe2-b8c4-680f6a2eba57.ps1:
13 char:56
+ new-QADUser -Password $ss -UserPrincipalName $upn -name  <<<< $i.fullname -Or
ganizationalUnit $ou -SamAccountName $i.id -FirstName $i.firstname -LastName $i
.lastname -Displayname $i.fullname -Department $i.department -Title $i.title -P
honeNumber $i.phone
ConvertTo-SecureString : Cannot bind argument to parameter 'String' because it
is null.
At C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\6a4b55df-de08-4fe2-b8c4-680f6a2eba57.ps1:
10 char:29
+ $ss = ConvertTo-SecureString  <<<< $i.password -AsPlainText -Force
New-QADUser : The argument cannot be null or empty.
At C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\6a4b55df-de08-4fe2-b8c4-680f6a2eba57.ps1:
13 char:56
+ new-QADUser -Password $ss -UserPrincipalName $upn -name  <<<< $i.fullname -Or
ganizationalUnit $ou -SamAccountName $i.id -FirstName $i.firstname -LastName $i
.lastname -Displayname $i.fullname -Department $i.department -Title $i.title -P
honeNumber $i.phone
ConvertTo-SecureString : Cannot bind argument to parameter 'String' because it
is null.
At C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\6a4b55df-de08-4fe2-b8c4-680f6a2eba57.ps1:
10 char:29
+ $ss = ConvertTo-SecureString  <<<< $i.password -AsPlainText -Force
New-QADUser : The argument cannot be null or empty.
At C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\6a4b55df-de08-4fe2-b8c4-680f6a2eba57.ps1:
13 char:56
+ new-QADUser -Password $ss -UserPrincipalName $upn -name  <<<< $i.fullname -Or
ganizationalUnit $ou -SamAccountName $i.id -FirstName $i.firstname -LastName $i
.lastname -Displayname $i.fullname -Department $i.department -Title $i.title -P
honeNumber $i.phone

PS C:\>