Solved

Upload an Excel Data into AD 2012r2

Posted on 2016-07-27
7
23 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 13

Assisted Solution

by:Dustin Saunders
Dustin Saunders earned 250 total points (awarded by participants)
ID: 41731754
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 13

Expert Comment

by:Dustin Saunders
ID: 41731760
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 40

Accepted Solution

by:
Adam Brown earned 250 total points (awarded by participants)
ID: 41731835
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
Office 365 Advanced Training for Admins

Special Offer:  Buy 1 course, get 2nd free!  Buy the 'Managing Office 365 Identities & Requirements' course w/ Accelerated TestPrep, and automatically receive the 'Enabling Office 365 Services' course FREE!

 
LVL 13

Assisted Solution

by:Dustin Saunders
Dustin Saunders earned 250 total points (awarded by participants)
ID: 41731841
@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 40

Expert Comment

by:Adam Brown
ID: 41731844
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 20

Expert Comment

by:compdigit44
ID: 41736750
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 40

Expert Comment

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

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article demonstrates probably the easiest way to configure domain-wide tier isolation within Active Directory. If you do not know tier isolation read https://technet.microsoft.com/en-us/windows-server-docs/security/securing-privileged-access/s…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
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 from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

737 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