Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2010-09-15
3
Medium Priority
?
2,196 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 18

Accepted Solution

by:
Learnctx earned 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

A walk-through example of how to obtain and apply new DID phone numbers to your cloud PBX enabled users that are configured in Office 365. Whether you have 1, 10 or 100+ users in your tenant, it's quite easy to get them phone-enabled and making/rece…
Are you an Exchange administrator employed with an organization? And, have you encountered a corrupt Exchange database due to which you are not able to open its EDB file. This article will explain all the steps to repair corrupt Exchange database.
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…

636 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