Add multiple users to multiple groups from one import csv

user2402045 picture user2402045 · May 20, 2013 · Viewed 51.8k times · Source

I have a csv with 2 columns, one column is AD group names and one is user account names. I am trying to read the csv and import the users into their corresponding group.

Here is what i have to so far. It's saying both arguments(identity,member) are null, which makes no sense since the headers are correctly specified.

import-module activedirectory
$list = import-csv "C:\Scripts\Import Bulk Users into bulk groups\bulkgroups3.csv"

Foreach($user in $list){       
    add-adgroupmember -identity $_.Group -member $_.Accountname
}

Heres whats in the csv file

Group             Accountname 
group1            user1 
group1            user2 
group1            user3 
group2            user4 
group2            user5 
group3            user6 
group3            user7 
group3            user8 
group4            user9 
group5            user10 

EDIT Command and error

Here is my script, error i receive and csv.

Import-Csv "C:\Scripts\Import Bulk Users into bulk groups\bulkgroups.csv" | 
ForEach { get-aduser $_.Accountname | add-adgroupmember $_.Group}

enter image description here

enter image description here

enter image description here

Answer

EBGreen picture EBGreen · May 20, 2013

Change this:

add-adgroupmember -identity $_.Group -member $_.Accountname

To this:

add-adgroupmember -identity $user.Group -member (Get-ADUser $user.Accountname)