Solved

Upload an Excel Data into AD 2012r2

Posted on 2016-07-27
7
17 Views
Last Modified: 2016-08-22
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.
0
Comment
Question by:bernardb
  • 3
  • 3
7 Comments
 
LVL 12

Assisted Solution

by:Dustin Saunders
Dustin Saunders earned 250 total points (awarded by participants)
Comment Utility
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
 
LVL 12

Expert Comment

by:Dustin Saunders
Comment Utility
Side suggestion:  You could just make a OU for birth months and a group for each month, then add users to that group.
0
 
LVL 38

Accepted Solution

by:
Adam Brown earned 250 total points (awarded by participants)
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 12

Assisted Solution

by:Dustin Saunders
Dustin Saunders earned 250 total points (awarded by participants)
Comment Utility
@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
 
LVL 38

Expert Comment

by:Adam Brown
Comment Utility
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
 
LVL 19

Expert Comment

by:compdigit44
Comment Utility
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
 
LVL 38

Expert Comment

by:Adam Brown
Comment Utility
No response from user. Noted answers provide a good solution to the problem, though.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Every now and then, Microsoft does something that totally impresses me. It doesn't happen often, but in this case I must say I am thoroughly impressed with Windows Server Backup. One of the long time issues with Windows Backup has been the ability t…
OfficeMate Freezes on login or does not load after login credentials are input.
In this Micro Tutorial viewers will learn how to restore their server from Bare Metal Backup image created with Windows Server Backup feature. As an example Windows 2012R2 is used.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now