Firstly I always recommend to people to try out the Quest AD cmdlets.
They are free and take some of the pain out of managing AD from powershell.
http://www.quest.com/powershell/activeroles-server.aspx
Lets say your CSV fields are firstname, initial, lastname
Breaking down the script i would do this:
#Obtain your user details from your CSV file and store them in an array, then obtain the group properties for the 2 groups to join users to
$NewUsers
=
import-csv
c:\folder\filename.csv
$group1
=
Get-QADGroup
"groupname1"
$group2
=
Get-QADGroup
"groupname2"
#Start looping through the users in the array and create an account for each one, then join that account to the 2 groups
foreach
($User
in
$NewUsers)
{
#Build your username from your requirements above (first letter, initial, lastname), substring lets us select character 0 and we only want 1 character
$LogonName
=
$User.firstname.Substring(0,1)
+
$User.initial
+
$User.lastname
#create the actual user account in the correct OU
$CreatedUser
=
new-qadUser
-ParentContainer
'OU=companyOU,DC=company,DC=com'
-FirstName
$User.firstname
-LastName
$User.lastname
-Initials
$User.initial
-SamAccountName
$LogonName
#join the user to both groups
Add-QADGroupMember
$group1
$CreatedUser
Add-QADGroupMember
$group2
$CreatedUser
}
As always use scripts at your own risk, test in a test environment etc...etc....
