import bulk users with csv in exchange 2010 / outlook live@edu powershell

Hi all,

looking to
1. import ~700 students into live@edu/outlook.com exchange service,
2. automatically add them to a public group and set their passwords

using a csv file and powershell.

example of csv (headers and sample row):
DisplayName,FirstName,LastName,Alias,Group,EmailAddress,Password
Tom Thomas,Tom,Thomas,tom.thomas,6th Grade Students,tom.thomas@domain.com,3df5f!

I can connect to a powershell session with my live@edu server no problem. I'm aware of the import-csv command but am not sure exactly how to word the syntax to get this import to do what i need.

also, i am willing to split the csv file up into seperate 'group' files if you can only add to one group per script run.

thanks for the help in advance.
xguitoxAsked:
Who is Participating?
 
LearnctxConnect With a Mentor EngineerCommented:
To import and work with the CSV will be fairly easy. I have not done specifically what you're going to do with that service, maybe someone else can shed more light on that. As for working with the CSV (pardon me if I've misunderstood).
$import = import-csv "path to your csv file"

## To interact with the values
$import | ForEach-Object {
   $displayname = $_.DisplayName
   $firstname = $_.FirstName
   $lastname = $_.LastName
   etc
   etc
   etc
}

## alternatively

$import = import-csv "path to your csv file"

$import | ForEach-Object {
   whatevercommand.exe -username $_.username -password $_.password -etc -etc -etc
}

Open in new window

0
 
xguitoxAuthor Commented:
i understand how the import-csv works. i'm wondering what the specific $_.* are for public groups and passwords on live@edu and/or exch2010. is there a list of these somewhere?
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.

All Courses

From novice to tech pro — start learning today.