Powershell Active Directory Users to Multiple Groups using CSV

Question

I'm trying to assign Groups to users in Active Directory. In a simple case, its just case for doing a loop through a CSV file. However, In my circumstances, My csv is different. Example of csv is as followed.

tjone,Time,Jones,Time Jones,[email protected],Time Jones,Home Work, Manager, Finance, Staff, "OU=Groups,DC=Home,DC=ac,DC=uk",Finance;HR,P@ssw0rd

The Script is as followed:

#Read the CSV file
$PathofCSV = "C:\Users\Administrator\Desktop\users.csv"

$Header = "sAMAccountName","givenName","sn","DisplayName","mail","cn","Company","Title","Department","OrgUnit","OU","Groups","Password"

$InfoCSV = import-csv $PathofCSV -Delimiter "," -Header $Header

ForEach ($user In $infoCSV)

{
Add-ADGroupMember -Identity $user.Groups -Members $user.sAMAccountName
}

This is slightly different as you can see I'm trying to process the Groups Column which has more than one name and to make the matter worse, they are separated by the ";". So when I run the script, it see two name as one.

Question is, is it possible to separate those two names and processing them i.e. assigning two or more group names from one column.

I'm in an unfortunate position as I can't change the csv which I have received.

Any sort of help world be appreciated.

"a;b;c" -split ";"

dugas
– dugas

2016-09-22 14:34:17 +00:00
Commented Sep 22, 2016 at 14:34 — dugas
– dugas, Commented Sep 22, 2016 at 14:34

Community · Accepted Answer · 2017-05-23 12:19:29Z

1

As has already been pointed out in comments, use the -split operator:

foreach($user in $infoCSV)
{
    foreach($group in $user.Groups -split ';')
    {
        Add-ADGroupMember -Identity $group -Members $user.sAMAccountName
    }
}

If this is PowerShell 2.0 (-split was introduced in version 3.0), you can use the String.Split() method:

foreach($user in $infoCSV)
{
    foreach($group in $user.Groups.Split(';'))
    {
        Add-ADGroupMember -Identity $group -Members $user.sAMAccountName
    }
}

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Sep 22, 2016 at 15:00

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

metho Over a year ago

Thanks Mathias, Your solution worked. never thought it was that simle. thank you again.

Collectives™ on Stack Overflow

Powershell Active Directory Users to Multiple Groups using CSV

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related