Link to home
Start Free TrialLog in
Avatar of barnyhall

asked on

Powershell User Import Script Server 2012 ADS

Hi looking for a script to create a user account with the below info from a CSV can anyone help?

I have always done this with VBS but in 2012 it doesn't seem to work

Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

$users = import-csv C:\..\Accounts.csv 
foreach ($user in $users) {
New-ADUser -Name $user.displayName -GivenName $user.givenName -Surname $ `
-samAccountName $user.sAMAccountName -Enabled $true -Description $user.description `
-AccountPassword  (ConvertTo-SecureString $user.password -AsPlainText -force) -passthru

Import-Csv c:\..\accounts.csv | New-ADUser -Name $_.displayName -GivenName $_.givenName -Surname $ -samAccountName $_.sAMAccountName -Enabled $true -Description $_.description -AccountPassword  (ConvertTo-SecureString $_.password -AsPlainText -force) -passthru

Open in new window

Avatar of barnyhall


powershell just opens and closes with the above script  I have been trying with the below as well which dose seem to run but errors with

you cannot call a method on a null-valued expression

Import-Module ActiveDirectory
$Users = Import-Csv -Delimiter ";" -Path ".\2013.csv"  
foreach ($User in $Users)  
    $OU = "OU=test,DC=internal,DC=site,DC=com"  
    $Password = $User.password
    $Detailedname = $User.firstname + " " + $
    $UserFirstname = $User.Firstname
    $FirstLetterFirstname = $UserFirstname.substring(0,1)
    $SAM =  $FirstLetterFirstname + $
    New-ADUser -Name $Detailedname -SamAccountName $SAM -UserPrincipalName $SAM -DisplayName $Detailedname -GivenName $user.firstname -Surname $ -AccountPassword (ConvertTo-SecureString $Password -AsPlainText -Force) -Enabled $true -Path $OU  
Typically the only reason that ve3ofa's wouldn't work would be because of the CSV - if its format is odd, or the headers don't match with the properties called in the script, or if you don't have headers.  Can you post a sample of the CSV?
That's not a lot of help.  Is that the header row?  Or just an example of what each line contains?
An actual file would be much better with something like the first 3 lines.  You can put in some generic info if you want.  How is the file created?  I've seen issues where a BOM in the file messed up an import, but is not visible in Notepad and some other methods, hence an actual file is more useful.
Example attached thanks
Well, there's no problem with the CSV you provided.
Can you just run the New-ADUser command from the console and just fill in the info for each parameter instead of $  This would be a test trying to limit down where an error might be occurring.
can you send me a copy of the script that works for you please
Avatar of footech
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If my last post with the script (http:#a39238520) helped you, or any other post, please accept those as solutions instead of your own post.
script worked thanks