Iwould like to perform a bulk import of daat in order to poulate the user entried in AD's GAL/GAB with data such as phone number, address, etc. I would also like to populate the AD/Excchange fields for other values such as department to use dymanic groups in AD. We are not very familiar with Powershell or VBscript and are willing to look at 3rd party tools as well1) What are the command and syntax to do this? 2) I found the command LDIFDE but not a reall clear example on how to utilize it? 3) Is CSVDE any better to use? 4) Are ther 3rd party tools do do this as well Any good links to maunals, exmaples, usage for LDIFDE and CSVDE would be great

Hi, Please try to use CSVDE to export data from the AD into .csv files, and then you can edit these files via Excel. After that, please try to import data to the AD. How to use Csvde to import contacts and user objects into Active Directoryhttp://support.microsoft.com/kb/327620 CSVDE http://technet2.microsoft.com/windowsserver/en/library/1050686f-3464-41af-b7e4-016a Additional information: Please try to use the AD Attributes I could give you the Tool ADModify.net, which you can use to set specific AD Attributes through one step for more or all the User Objects:Using ADModify to Change Exchange Specific AD User Attributes in Bulk http://www.msexchange.org/articles/ADModify-Change-Exchange-Specific-AD-User-Attributes.htmlWindows Server 2003 - ADModify Support Tool Utility - http://www.computerperformance.co.uk/w2k3/utilities/admodify.htm http://www.codeplex.com/admodify/Release/ProjectReleases.aspx?ReleaseId=6065 Best regards, Xiu

Addition to Xius reply, you can use Quest Powershell AD CmdLet, lets say you want to update City & Department from CSV file then you can run below command to update City & Department for all users available in mentioned CSV file. Import-Csv CSVFileName | ForEach-Object { Set-QADUser -Identity $_.'Users Name' -City $_.'City' -Department 'Department'} PowerShell Commands for Active Directory http://www.quest.com/activeroles-server/arms.aspx