Import users with Powershell; Skip manager field when its blank.

hello,

i’ creating powershell script import users. works fine till leave manager field blank. ‘am getting following error:

new-aduser : identity info provided in extended attribute: 'manager' not resolved. reason: 'cannot find object identity: '' under: 'dc=domain,dc=local'.'. @ e:\script\userimport.script.ps1:36 char:5 +     new-aduser -name $detailedname -samaccountname $sam -userprincipalname $sam  ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~     + categoryinfo          : invaliddata: (cn=name surname...ons,dc=domain,dc=nl:string) [new-aduser], adidentityresoluti    onexception     + fullyqualifiederrorid : activedirectorycmdlet:microsoft.activedirectory.management.adidentityresolutionexception    ,microsoft.activedirectory.management.commands.newaduser

the poweshell script:

import-module activedirectory  $users = import-csv -delimiter ";" -path ".\users.csv"   foreach ($user in $users)   {   	$ou = "ou=users,ou=bv,ou=organisations,dc=domain,dc=local"   	$password = $user.password  	$detailedname = $user.firstname + " " + $user.lastname  	$userfirstname = $user.firstname  	$firstletterfirstname = $userfirstname.substring(0,1)  	$sam =  $firstletterfirstname + $user.lastname  	$office = $user.office 	$company = $user.company 	$department = $user.department 	$title = $user.jobtitle 	$initials = $user.initials 	$city = $user.city 	$country = $user.country 	$state = $user.state 	$postalcode = $user.zip 	$homepage = $user.webpage 	$officephone = $user.businesstel 	$mobilephone = $user.mobilephone 	$homephone = $user.homephone 	$manager = $user.manager 	$streetaddress = $user.street 	$description = $user.description 	$fax = $user.businessfax 	$emailaddress = $user.userlogon 	$displayname = $user.displayname     new-aduser -name $detailedname -samaccountname $sam -userprincipalname $sam -displayname $displayname -emailaddress $emailaddress -fax $fax -description $description -street $streetaddress -manager $manager -homephone $homephone -mobilephone $mobilephone -officephone $officephone -homepage $homepage -postalcode $postalcode -city $city -country $country -state $state -initials $initials -title $title -givenname $user.firstname -surname $user.lastname -company $company -department $department -office $office -accountpassword (convertto-securestring $password -asplaintext -force) -enabled $true -path $ou   }

the cvs file:

lastname;firstname;password;office;company;department;jobtitle;initials;city;country;state;zip;webpage;businesstel;mobilephone;homephone;manager;street;description;businessfax;userlogon;displayname surname;name;p@$$w0rd!2;m2;s;admin;spec;ib;city;nl;state;7805lc;ww.home.nl;05;0611;0524;;street;omschrijving;444;name@email.nl;cordisk surname;name;p@$$w0rd!2;m2;s;admin;spec;ib;city;nl;state;7805lc;ww.home.nl;0569;0622;0528;managername;street;omschrijving;44;;ilondisk

when leave manager field blank fails, there command or attribute to skip  a field when leave blank?

kind regards,

michel

this solution, i'am testing right now:

https://social.technet.microsoft.com/forums/windowsserver/en-us/bef97d7c-6fe4-42bc-81a3-31edb26d5912/powershell-how-do-i-skip-blank-field-?forum=winserverpowershell

Windows Server  >  Directory Services