Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
How to i enter hebrew characters in New-MailContact (CSV bulk import)
Hi
I am trying to run a bulk import to my Exchange 2010 from a CSV file.
I run the following in a powershell script:
Import-Csv C:\contacts.csv | ForEach { New-MailContact -Name $_.displayName -Firstname $_.FirstName -LastName $_.LastName -ExternalEmailAddress $_.EmailAddress -OrganizationalUnit "YourDomain.Local/Contacts
It runs great, but the problem is that the CSV file has hebrew characters, and those are entered as question marks instead. Is there some setting i am missing?
Thanks
Jaime
I am trying to run a bulk import to my Exchange 2010 from a CSV file.
I run the following in a powershell script:
Import-Csv C:\contacts.csv | ForEach { New-MailContact -Name $_.displayName -Firstname $_.FirstName -LastName $_.LastName -ExternalEmailAddress $_.EmailAddress -OrganizationalUnit "YourDomain.Local/Contacts
It runs great, but the problem is that the CSV file has hebrew characters, and those are entered as question marks instead. Is there some setting i am missing?
Thanks
Jaime
Who is Participating?
Thanks, it does load the hebrew characters alright, although the Alias field is filled with question marks for all contacts, is there something i can do?
Do you have problem after changing the encoding? if yes please post some sample words/usernames which you have issue, so I will test it..
I think i didn't explain well.
I opened the csv file and saved it as Unicode.
Then i run the import code from my first post, and it runs successfully, and when checking, all the contacts were created successfully *with correct hebrew characters*.
Just when browsing the contacts themselves, i noticed the Alias field (which is created automatically i guess, during the import ) is all question marks. I wondered if there was a way for me to set the value for this field so it's in hebrew as well.
Jaime
I opened the csv file and saved it as Unicode.
Then i run the import code from my first post, and it runs successfully, and when checking, all the contacts were created successfully *with correct hebrew characters*.
Just when browsing the contacts themselves, i noticed the Alias field (which is created automatically i guess, during the import ) is all question marks. I wondered if there was a way for me to set the value for this field so it's in hebrew as well.
Jaime
If you have a list of contacts to modify, then you can try with set mailbox.. Something like the following should work..
Import-csv "c:\newalias.csv" | % {Get-MailContact - Identity $_.Name | Set-MailContact -Alias $_.Alias}
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
gc c:\old-file.csv | Out-File -en unicode c:\new-unicode.csv
Or you can just open the csv file in notepad and save it in unicode format before you run import-csv..