Learn how to a build a cloud-first strategyRegister Now


Active Directory Update

Posted on 2004-11-17
Medium Priority
Last Modified: 2010-04-10
Hi guys,
     I am not very familiar with Active Directory, but ours needs updating badly, and I was wondering about the process of updating it. Our HR department can easily provide data in the form of a spreadsheet (Excel). What would be the best way to update Active Directory using these spreadsheets? Thanks.
Question by:isaacr25
  • 3
  • 2
LVL 11

Expert Comment

ID: 12610508
Update Active Directory?????

What is that you are talking about? Give me some example? What's the content of those worksheets? What do you want to update? Personal data of your employees?

LVL 11

Expert Comment

ID: 12610516
Anyway, Active Directory can (not so easy) be scripted! Therefore you do can automate most tasks using AD Scripts.
So ... please, be more specific about what r u trying to achieve here!
Sorry for the dbl post.


Expert Comment

ID: 12613131
I believe the HR departmen got a list of employee in excel format,  he don't want to key them one by one(it is horror to him if he needs to key in 200 users in the active directory ).  So, he was wondering if he can import the excel into active directory.

It doesn't take a genius to understand what he is trying to achieve,
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 12614057
All I need to know is if its possible to update Active Directory (employee data: name, department, numbers, new employees etc.) using spreadsheets that I can get from Human Resources. I know that it is probably not a direct import/export or something like that, but I need to know if its indirectly possible. Thanks.

LVL 11

Accepted Solution

rafael_acc earned 750 total points
ID: 12620799
Hey binary_1001010 ...

What is wrong with you ? Get some more expertise on this topic and after that I can meet you privately and have some discussion about active directory; I mean, you might learn something from me or from each other! It's not wise to approach people like you did! Considering how the question was asked and that I usually try to give pretty much clear explanations to people, I had to ask about what was he/she trying to achieve! Additionally, I don't know the Isaacr25 knowledge about AD therefore I had to be sure about what is he asking! IS THAT CLEAR ENOUGH FOR YOU NOW, GENIUS?!

But it's clear enough to me that you just don't know much about AD!!!

One more thing! I'm happy I'm not a genius!

Take it easy next time man. We are all here to help not to offend each other!

Now, isaacr25!! It is possible indeed. All you have to do is develop a script and take the data from the excel worksheet and add it to your Users's accounts. I could do that for you should I had time. Try posting this same question in the "Programming" section.

Author Comment

ID: 12624869
     That's all I wanted to know... whether or not it was technically possible. Thanks.


Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

If you’re involved with your company’s wide area network (WAN), you’ve probably heard about SD-WANs. They’re the “boy wonder” of networking, ostensibly allowing companies to replace expensive MPLS lines with low-cost Internet access. But, are they …
Microsoft Office 365 is a subscriptions based service which includes services like Exchange Online and Skype for business Online. These services integrate with Microsoft's online version of Active Directory called Azure Active Directory.
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

810 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