Solved

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

Posted on 2010-09-15
3
2,175 Views
Last Modified: 2012-05-10
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
Comment
Question by:xguitox
3 Comments
 
LVL 16

Accepted Solution

by:
Learnctx earned 500 total points
Comment Utility
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
 

Author Comment

by:xguitox
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now