How to create exchange users through excel?

Question

PowerShell

You need to create users from excel
An excel is created with columns fullname OU SAM name lastname password UPN, then exported to csv (MSDOS)
there are Russian names with Cyrillic, then opened with notepad and saved in UTF-8
, then the script
Import-CSV c:\users is done. csv | ForEach-Object {New-Mailbox -Name $_.”fullname” -Alias ​​$_.”alias” -OrganizationalUnit $_.”OU” -SamAccountName $_.”SAM” -FirstName $_.”name” -LastName $ _.”lastname” -Password (ConvertTo-SecureString _.password -AsPlainText -Force) -UserPrincipalName $_.”UPN” -ResetPasswordOnNextLogon $false }
and nothing happens, what could be the catch?

Answer 1

A snag in some problems.

Answer 2

first, learn the -Encoding switch and in the import-csv cmdlet,
in particular, in the format you save, you can use -Encoding OEM
AND, just in case, -Delimiter to specify the specific list separator to use.
Secondly, as you have already been told, the problem can be literally in every step that you perform with the cmdlets for creating a new mailbox: from the inability to connect to exchange services or the lack of access to create users in the corresponding OU AD, to banal typos in the cmdlet text.
Give the text of errors for analysis and help. The content of psychics in the state translates into a pretty penny.
$_.”fullname” why are there quotes here?

Answer 3

thanks, Cap!

Answer 4

I advise you to read "How to ask questions correctly": segfault.kiev.ua/smart-questions-ru.html