import bulk atribute to user; bulk import user; import atribute to ad using logonname

First you must install powershell 2.0 if not exist, if it is installed on Win 2008 R2 PowerShell 2.0 is present.

Next, you must install ActiveRoles Management Shell for Active Directory 64-bit

you can download from this location

After install start powershell and type command


Import-csv C:\importfolder\importFile.csv | foreach-object {Set-qaduser $_.samaccountname -telephoneNumber $_.telephoneNumber -company $ -physicalDeliveryOfficeName $_.physicalDeliveryOfficeName}

Example of importFile.csv :

samaccountname, telephoneNumber, company, physicalDeliveryOfficeName
user1, 12345, ibm, finance
user2, 12345, ibm, finance
user3, 12345, ibm,finance

dpejic has written 85 articles

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>