We help IT Professionals succeed at work.

tools to update attributes in AD

pcmm
pcmm used Ask the Experts™
on
I have a task to add data to the manager attribute in Ad (we've recently migrated to office 2010 and lync2010) and want to use more of the attributes in AD.  I've been given a spreadsheed with 600 employees and how each users manager is.  I've been trying to write the ldifde file to do the import,  but at the rate I'm going it would be easier to just manually make the edits.  Is there any tool out there that will allow me to import a spreadsheet of attributes, and either create the ldifde import file to midfy the existing users attributes,  or just do it from the tool??


Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011

Commented:
AD Manager Plus is a good tool. It will import csv files
Commented:
For tasks like this I like using powershell or adfind\admod from joeware.net. here is an example using powershell with the quest cmdlets. I am not sure what attributes you want to update or how your csv file is formed so you will have to modify to fit your needs.
The manager attribute is a DN so you will need either the full DN in your input file or just the logon name and do what i did below. I have not tested this so test on one user first.

$Users = import-csv c:\temp\users.csv
$Users | ForEach {
Set-qaduser $_.LogonName  -manager (Get-qaduser $_.manager).DN
}
AD Modify can be used