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
