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.
bernardbAsked:
Who is Participating?
 
Adam BrownConnect With a Mentor Sr Solutions ArchitectCommented:
In order to create a field, you have to modify the AD schema, which is usually a process that is over anyone's head (except for some programmers).

If you have Exchange in your environment, there are a number of "Custom Attribute" values that can be used for any kind of info you want. Otherwise you can just use the Notes: attribute as was mentioned.

All of that stuff can be added through powershell very easily, as long as you convert the excel file to a CSV (comma separated value) file. The actual script to do so would depend on the headings your file uses for the columns. If you can provide that info, I or someone else can probably whip up a quick script for you.
0
 
Dustin SaundersConnect With a Mentor Director of OperationsCommented:
The most popular choice is 'Notes:' on the Telephones tab.  We dump items in there separated by semicolons when we need a variable associated with an AD user.
0
 
Dustin SaundersDirector of OperationsCommented:
Side suggestion:  You could just make a OU for birth months and a group for each month, then add users to that group.
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
Dustin SaundersConnect With a Mentor Director of OperationsCommented:
@acbrown - You may be interested in this module, I use it to work with Excel documents and import them without having to drop to a csv.
0
 
Adam BrownSr Solutions ArchitectCommented:
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
0
 
compdigit44Commented:
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/
0
 
Adam BrownSr Solutions ArchitectCommented:
No response from user. Noted answers provide a good solution to the problem, though.
0
All Courses

From novice to tech pro — start learning today.