Csvde can import a CSV file, but you need to do some manipulation first to construct a unique identifier that matches a unique identifier in AD. That's pretty easy to do in VBScript
Cheers Ken From: [email protected] [mailto:[email protected]] On Behalf Of David Lum Sent: Friday, 19 July 2013 1: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
