• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2199
  • Last Modified:

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.
0
xguitox
Asked:
xguitox
1 Solution
 
LearnctxEngineerCommented:
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

Featured Post

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

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