bernardb
asked on
Upload an Excel Data into AD 2012r2
Hello Experts,
We have an Excel spread sheet with Employ full names (not their usernames) and a birth month (ie june). We'd like to upload the birth month into an empty unused field (as soon as I figure out how to find one!) with AD.
Windows 2012r2 AD.
Can this be done? How? Can I create a field OR use a field that's not normally visible, like....phone number 3 or IP Phone etc.
Any recommendations are appreciated.
We have an Excel spread sheet with Employ full names (not their usernames) and a birth month (ie june). We'd like to upload the birth month into an empty unused field (as soon as I figure out how to find one!) with AD.
Windows 2012r2 AD.
Can this be done? How? Can I create a field OR use a field that's not normally visible, like....phone number 3 or IP Phone etc.
Any recommendations are appreciated.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Side suggestion: You could just make a OU for birth months and a group for each month, then add users to that group.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't do a lot of work from excel these days (joys of reaching the level of Systems Architect), but thanks for the recommendation. I'll look at it :D
There are scripts which you could modify on the script gallery which import content into the notes field of user
https://gallery.technet.microsoft.com/scriptcenter/Powershell-Append-Info-5f613638
https://powershell.org/forums/topic/set-aduser-append-to-ad-notes-field/
https://gallery.technet.microsoft.com/scriptcenter/Powershell-Append-Info-5f613638
https://powershell.org/forums/topic/set-aduser-append-to-ad-notes-field/
No response from user. Noted answers provide a good solution to the problem, though.