Solved

Importing Users via CSV

Posted on 2013-01-07
2
801 Views
Last Modified: 2013-01-08
Hello,

I'm making a mistake somewhere in the process of reading a CSV containing user records and using the New-ADUser cmdlet to add them to AD.  I'm running these commands on a patched 2008R2 domain controller.

the csv file is as follows (also attached):

Object_Path,Object_Name,name,samaccountname,userprincipalname,givenname,sn,displayname,company,streetaddress,l,st,postalcode,telephonenumber,facsimiletelephonenumber,homephone,mobile,mail,title,department,physicaldeliveryofficename,info,tempPassword
LDAP://TL,TL,testuser7,testuser7,testuser7@structures.com,Test,User,"Test User 7",testuser7,Address,Greenwood Village,CO,80111,303-555-5555,303-555-5555,303-555-5555,303-555-5555,tuser7@redacted.com,Toady,Custodial,Denver,This is a notes field,abc123456@@@

Open in new window


the script is:

Import-Csv .\test_ad_users2.csv
foreach-object {
	#$password = $_.tempPassword
	New-ADUser `
		-SamAccountName $_.SamAccountName `
		-UserPrincipalName $_.userprinicpalname `
		-DisplayName $_.name `
		-Name $_.name `
		-GivenName $_.cn `
		-SurName $_.sn `
		-Department $_.Department `
		-Path "OU=ImportTest,DC=ifs,DC=local" `
		-AccountPassword (ConvertTo-SecureString "abc123456@@@" -AsPlainText -force) `
		-Enabled $True `
		-PasswordNeverExpires $True `
		-PassThru `
		}

Open in new window


I'm getting the error:

New-ADUser : Cannot validate argument on parameter 'Name'. The argument is null or empty. Supply an argument that is not null or empty and then try the command again.
At C:\adimport\ADMUserCreation.ps1:10 char:8
+         -Name <<<<  $_.name `
    + CategoryInfo          : InvalidData: (:) [New-ADUser], ParameterBindingValidationException
    + FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.ActiveDirectory.Management.Commands.NewADUser

I've tried everything I can think of to understand what this message means in my context.  If I run the following I get the name attribute "testuser7" returned:

import-csv c:\adimport\test_ad_users.csv | foreach-object { $_.name}

Open in new window


that tells me the error isn't what it seems to be.  Anyone have any ideas?  Any help would be appreciated.

Thank you.

Mitch
0
Comment
Question by:mfishco
2 Comments
 
LVL 40

Accepted Solution

by:
Subsun earned 500 total points
ID: 38753300
In your script, you didn't pipe the Import-Csv output to foreach-object. Try..
Import-Csv C:\test_ad_users2.csv | foreach-object  {
	#$password = $_.tempPassword
	New-ADUser `
		-SamAccountName $_.SamAccountName `
		-UserPrincipalName $_.userprincipalname `
		-DisplayName $_.name `
		-Name $_.name `
		-GivenName $_.cn `
		-SurName $_.sn `
		-Department $_.Department `
		-Path "OU=ImportTest,DC=ifs,DC=local" `
		-AccountPassword (ConvertTo-SecureString "abc123456@@@" -AsPlainText -force) `
		-Enabled $True `
		-PasswordNeverExpires $True `
		-PassThru `
		}

Open in new window

0
 

Author Comment

by:mfishco
ID: 38754993
Thank you!  Such a small thing taking so much time and energy...
0

Featured Post

Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
A brief introduction to what I consider to be the best editor for PowerShell.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question