Update AD Users

• Wednesday, January 30, 2013 5:43 PM

   

   
  

  0

  Hi,

  I'm trying to update users in active directory from csv file with several values,

  but some of that users didn't update because one of the values are empty.

  Example

  as csv file contains user data in the format (mobile value did not set):
  samAccountName;givenName;sn;telephoneNumber;Pager;ipPhone;facsimileTelephoneNumber;mobile;physicalDeliveryOfficeName;department;description
  jondoe;jon;doe;+xxxxxxxx;xxxx;+xxxxxxxxxxx;+xxxxxxxxxxx;;place;IT department;IT officer

  I'm using following code to update users:

  Import-Module ActiveDirectory
  $users = Import-Csv -Path c:\ADMIN\Users.csv -delimiter ";"    
  foreach ($user in $users) {
      Set-ADUser -Identity $($user.SamAccountName) -Replace @{telephoneNumber = $($user.telephoneNumber); pager = $($user.Pager); ipPhone = $($user.ipPhone); facsimileTelephoneNumber = $($user.facsimileTelephoneNumber); mobile = $($user.mobile); physicalDeliveryOfficeName = $($user.physicalDeliveryOfficeName); department = $($user.department); description = $($user.description)}
  }

  Can someone help me how to update users that doesn't have all values in csv file?

  Much appreciated,

  Nenad

  • Reply
  • Quote