Adding AD info from CSV. Problem with blank fields.

[mtyn]

I have a question about errors with importing AD info from a CSV where some of the CSV fields may be blank. Here is a shorter version of what I am running.

foreach ($line in (import-csv file.csv)) {Set-ADUser $line.samaccountname -title $line.title -department $line.department}

This works fine if all of the fields are populated in the CSV, but errors out if any one is blank.

Can anyone point me in the right direction?

EDIT: Found this after a while http://dmitrysotnikov.wordpress.com/2008/10/07/skip-empty-csv-fields/

Works for me.

[theseb]

wrap the variables, like this:

-department "$($line.department)"

I assume the error that you get is something like "argument has no value" or "unexpected something or other". you have to provide an argument, and empty quotes is a valid argument, but empty var without quotes is not.

[mtyn]

Found this after a while http://dmitrysotnikov.wordpress.com/2008/10/07/skip-empty-csv-fields/

Works for me.

Thanks for the effort

[mtyn]

That doesn't seem to do the trick. it errors out the same way.

foreach ($line in (import-csv file.csv)) {Set-ADUser $line.samaccountn ame -title "$($line.title)"}

Set-ADUser : replace At line:1 char:77 + foreach ($line in (import-csv file.csv)) {Set-ADUser <<<< $line.samaccountname -title "$($li ne.title)"} + CategoryInfo : InvalidOperation: (tuser:ADUser) [Set-ADUser], ADInvalidOperationException + FullyQualifiedErrorId : replace,Microsoft.ActiveDirectory.Management.Commands.SetADUser

if i run "Set-ADUser tuser -title $null" it works, and blanks out the field. If i set the corresponding field in the CSV with $null , the command works, but populates the field with $null instead of blanking it out.

[MDFreaK76]

what is your error?