Depending on how large the org is, there could be lots of dupe Display Names. Account name would be ideal.
Regards, Don Guyer Catholic Health East - Information Technology Enterprise Directory & Messaging Services 3805 West Chester Pike, Suite 100, Newtown Square, Pa 19073 email: [email protected]<mailto:[email protected]> Office: 610.550.3595 | Cell: 610.955.6528 | Fax: 610.271.9440 For immediate assistance, please open a Service Desk ticket or call the helpdesk @ 610-492-3839. [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of David Lum Sent: Thursday, July 18, 2013 11:34 AM To: [email protected] Subject: [NTSysADM] AD update from external CSV Issue: HR has an app that will output employee data to tab-delimited CSV that we'd like to use to update AD with. Example output: Name Location Department Job Title Manager Smith, Steve P Portland Accounting Accountant Doe, Jane R Of course I need to massage it to let scripting tools import it. ADFIND/ADMOD is what I've used before to do bulk imports, but that's when I just modify ADFIND export data. I can do it with Excel and Macros, but that's clunky. Ideally I could point something at the CSV file and it would work magic to update the matching field in AD...programmatically I guess it would take the name field, massage lastname,firstname to match AD's "Display Name", then update Location, Department, Job Title and Manager with values from the CSV. The trick is the HR output frequently includes the middle initial which we don't usually have in AD, but there's no real reason why AD can't include it so part of the conversion would add the "initials" attribute, if present. Is this one for PowerShell? David Lum Sr. Systems Engineer // NWEATM Office 503.548.5229 // Cell (voice/text) 503.267.9764 Confidentiality Notice: This e-mail, including any attachments is the property of Catholic Health East and is intended for the sole use of the intended recipient(s). It may contain information that is privileged and confidential. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please delete this message, and reply to the sender regarding the error in a separate email.
<<inline: image001.jpg>>
