Solved

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

Posted on 2010-09-15
3
2,181 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 17

Accepted Solution

by:
Learnctx earned 500 total points
ID: 33681775
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
ID: 33681875
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to resolve IMCEAEX NDRs in Exchange or Exchange Online related to invalid X500 addresses.
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
In this video we show how to create a Contact 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 Recipients >> Contact ta…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

730 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