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 http://www.quest.com/QuestWebPowershellCmdletDwnld64bit

After install start powershell and type command

EXAMPLE:

Import-csv C:\importfolder\importFile.csv | foreach-object {Set-qaduser $_.samaccountname -telephoneNumber $_.telephoneNumber -company $_.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>