Mar 12 2023 03:22 AM - edited Mar 12 2023 03:23 AM
I'm using a script to create user accounts from a CSV file using powershell. The issue I keep running into is that the email and the principal name fields are always left blank on all the accounts and I'm not entirely sure on what I can do to change this other than going to each account and manually typing it in. I used the csvde command previously but kept getting an input error. A screenshot of the code is attached. Any suggestions on what I can change to make the script work would be greatly appreciated.
This isn't my code, I simply modified it to better suit what I needed it for.
Mar 13 2023 02:23 AM - edited Mar 13 2023 02:24 AM
SolutionPlease try the below code and let me know if its works for you. you add the write host if needed. please note that this script move your user to the corresponding OU specified in the CSV file as well
# Replace with the path to your CSV file
$csvPath = "C:\users.csv"
# Read the CSV file
$users = Import-Csv $csvPath
# Loop through each user in the CSV file
foreach ($user in $users) {
# Get the values from the CSV file
$username = $user.Username
$password = $user.Password
$firstname = $user.Firstname
$lastname = $user.Lastname
$email = $user.Email
$ou = $user.OU
# Create the new user object
$newUser = New-Object -TypeName System.DirectoryServices.AccountManagement.UserPrincipal([System.DirectoryServices.AccountManagement.PrincipalContext]::Domain)
$newUser.Name = "$firstname $lastname"
$newUser.DisplayName = "$firstname $lastname"
$newUser.UserPrincipalName = "$email address removed for privacy reasons""
$newUser.SamAccountName = $username
$newUser.SetPassword($password)
$newUser.Enabled = $true
$newUser.EmailAddress = $email
$newUser.Save()
# Move the user to the specified OU
$newUser = [ADSI]("LDAP://" + $newUser.DistinguishedName)
$newUser.psbase.MoveTo("LDAP://$ou")
}
Mar 13 2023 02:23 AM - edited Mar 13 2023 02:24 AM
SolutionPlease try the below code and let me know if its works for you. you add the write host if needed. please note that this script move your user to the corresponding OU specified in the CSV file as well
# Replace with the path to your CSV file
$csvPath = "C:\users.csv"
# Read the CSV file
$users = Import-Csv $csvPath
# Loop through each user in the CSV file
foreach ($user in $users) {
# Get the values from the CSV file
$username = $user.Username
$password = $user.Password
$firstname = $user.Firstname
$lastname = $user.Lastname
$email = $user.Email
$ou = $user.OU
# Create the new user object
$newUser = New-Object -TypeName System.DirectoryServices.AccountManagement.UserPrincipal([System.DirectoryServices.AccountManagement.PrincipalContext]::Domain)
$newUser.Name = "$firstname $lastname"
$newUser.DisplayName = "$firstname $lastname"
$newUser.UserPrincipalName = "$email address removed for privacy reasons""
$newUser.SamAccountName = $username
$newUser.SetPassword($password)
$newUser.Enabled = $true
$newUser.EmailAddress = $email
$newUser.Save()
# Move the user to the specified OU
$newUser = [ADSI]("LDAP://" + $newUser.DistinguishedName)
$newUser.psbase.MoveTo("LDAP://$ou")
}