Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2991
  • Last Modified:

Import External Contacts in Office 365 <Cannot bind argument to parameter 'Name' because it is an empty string.>

I am trying to import a list of 150+ external contacts into Microsoft 365.  I am following the directions on this page.

http://community.office365.com/en-us/wikis/exchange/579.aspx


I have used the example file to create an importation list.  I get the below error message.  I know that the data set should be fine, I am unsure as to why the import will not work.

I have attached the example file as well as an excerpt of the file I am trying to use to upload.


Cannot bind argument to parameter 'Name' because it is an empty string.
    + CategoryInfo          : InvalidData: (:) [New-MailContact], ParameterBin
   dingValidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationErrorEmptyStringNotAl
   lowed,New-MailContact
    + PSComputerName        : pod54444444psh.outlook.com
ExternalContacts-sampleCSV--1-.txt
fdafdsfasdfsdfsdafsdafsdafsdasdf.txt
0
Daeta42
Asked:
Daeta42
1 Solution
 
SubsunCommented:
I can see your csv file is tab separated, so when you read the file you need to use parameter -Delimiter `t with Import-Csv
For example..
Import-Csv .\ExternalContacts.csv -Delimiter `t | %{New-MailContact -Name $_.Name -DisplayName $_.Name -ExternalEmailAddress $_.ExternalEmailAddress -FirstName $_.FirstName -LastName $_.LastName}

Open in new window

0
 
Daeta42Author Commented:
Thank you, Thank you!!!  I'd have never figured that out myself!!!
0
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now