What is wrong? How can I Fix it?

Question

What is wrong? How can I Fix it?

Abdel loukan 41

Issue scripting:

Import-CSV address BulkuserMailboxes.csv | ForEach {New-Mailbox -Alias
$ .alias -Name $.name -userPrincipalName $.UPN -Database “Mailbox Database 2091411052” -OrganizationalUnit Users -Password $Password}

csv text:
Alias Name UPN
Bulkuser_1 Bulkuser1 ******@extraining.com
Bulkuser_2 Bulkuser2 ******@extraining.com

errorr:

Rich Matheisen 48,201 Reputation points

2021-12-01T19:48:41.713+00:00

Without knowing what problem you're having it's impossible to tell you how to fix it!

I don't see where you assign a value to the variable $password. Could that be the problem? Or maybe that the CSV doesn't use a comma as the separator character?

Also, when you post code, please use the "Code Sample" editor. It's the 5th icon from the left on the Format Bar (it has the graphic "101 010"). The normal editor mangles the code.

Answer accepted by question author

KyleXu-MSFT 26,406

@Abdel loukan

This screenshot is not visible.

So, I provide a script which could work in my lab:

CSV file:

Script:

$users = Import-CSV c:\temp\users.csv  
$PassWord = ConvertTo-SecureString -String "Password123" -AsPlainText -Force  
  
ForEach($user in $users){  
    New-Mailbox -Alias $user.alias -Name $user.name -userPrincipalName $user.UPN -Database "DB16" -OrganizationalUnit Users -Password $Password -ResetPasswordOnNextLogon $true  
}

Run this script(.PS1 file) in EMS:

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 comments

1 additional answer

Your answer

Rich Matheisen 48,201 Reputation points

2021-12-01T19:48:41.713+00:00

Without knowing what problem you're having it's impossible to tell you how to fix it!

I don't see where you assign a value to the variable $password. Could that be the problem? Or maybe that the CSV doesn't use a comma as the separator character?

Also, when you post code, please use the "Code Sample" editor. It's the 5th icon from the left on the Format Bar (it has the graphic "101 010"). The normal editor mangles the code.

Answer 1

Abdel loukan 41

thank you guys, for some strange reason , excel worked notepad did not. Was prop the PS mode

0 comments