Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Import fiields into AD from Excel

Posted on 2009-04-04
4
Medium Priority
?
815 Views
Last Modified: 2012-05-06
Hi

I have an excel sheet with the following columns. I need to import into AD to populate contact fields etc.The accounts are already created
the fields are:

User logon name  

Description:  (if entry exists, don't overwrite)
Office:  (if entry exists, don't overwrite)
Telephone Number:

Mobile:

City:

Title:
Department:
Company:

Manager
      Name:  if i input a user logon name, will this resolve?


I will run from workstation with Adminpak (w2k3) installed & excel. Domain admin rights.

Any help would be much appreciated, I am hopeless at scripting..

TIA
0
Comment
Question by:Danno2013
  • 3
4 Comments
 
LVL 9

Accepted Solution

by:
tl121000 earned 1500 total points
ID: 24068988
use this it works...


    • or go into ASDI edit -
    • don't change anything in ASDI edit just view and search for attrubutes if need be.

0
 
LVL 9

Assisted Solution

by:tl121000
tl121000 earned 1500 total points
ID: 24069013
The only drawback with this that I have found is that you need to lax your password policy in AD under the default domain policy to get this imported.
  • You can then select all users at once - right click on users and restet password.
    • set the passwords to a genraic password that meets the criteria of your environment with prompt user to change at next logon.
      • Switch back your defualt domain password policy to your typical settings.
0
 

Author Comment

by:Danno2013
ID: 24070383
Thanks for the link. That appears to be for creating users. I want to update their fields. I don't want to reset their passwords

eg  User logon name is the defined profile identifier against which other fields will be populated.

0
 
LVL 9

Assisted Solution

by:tl121000
tl121000 earned 1500 total points
ID: 24071887
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Question has a verified solution.

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

Group policies can be applied selectively to specific devices with the help of groups. Utilising this, it is possible to phase-in group policies, over a period of time, by randomly adding non-members user or computers at a set interval, to a group f…
It’s time for spooky stories and consuming way too much sugar, including the many treats we’ve whipped for you in the world of tech. Check it out!
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
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.
Suggested Courses

571 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