Hot Downloads

Welcome, Guest
Username: Password: Remember me

TOPIC: Need to get 200 users into AD

Need to get 200 users into AD 7 years 2 months ago #31973

  • Stephanie
  • Stephanie's Avatar
  • Offline
  • Frequent Member
  • Posts: 55
  • Karma: 0
I have an excel spreadsheet with 200 names that I need to import into my AD w/ email addresses? What's the easiest way....don't say start creating IDs!

The spreadsheet has the following fields: Last name, first name, email.

Any suggestions?

Stephanie
The administrator has disabled public write access.

Re: Need to get 200 users into AD 7 years 2 months ago #31975

  • ZiPPy
  • ZiPPy's Avatar
  • Offline
  • Expert Member
  • Posts: 500
  • Karma: 0
Look into CSVDE - Comma Separated Value Data Exchange. Described as "CSVDE is the type of program that you learn for a specific task and then forget about."

Link: www.computerperformance.co.uk/Logon/Logon_CSVDE.htm


Cheers,

ZiPPy
ZiPPy
The administrator has disabled public write access.

Re: Need to get 200 users into AD 7 years 2 months ago #31979

  • KiLLaBeE
  • KiLLaBeE's Avatar
  • Offline
  • Expert Member
  • Posts: 466
  • Karma: 0
I actually used the above site a few months ago when I wanted to learn how to do this. It was quite fun. I spent hours importing users with all sort of AD fields populated. It made me realize how sophisticated it makes your directory when most of the objects' attributes are populated.

A few other bits of advice:
Familiarize yourself with some basic Excel formulas so you can concatenate and split information when needed. If you don't have a strategy on how to approach the task from point A (organizing the spreadsheet) to point B (executing the import command), then you may find yourself spending more time messing with the spreadsheet than if you had manually started with the IDs

Keep in mind that CSVDE does not create a password for the users that you import. By default, it'll create the users with blank passwords, and if your domain security policy prohibits blank passwords, then the accounts will be disabled by default. To set passwords for them, you'll need to use a VBScript or some other method to set the users' passwords.

If you want to see a list of all the available AD attributes, export your existing directory to a CSV file and isolate the user accounts. Keep in mind that although the exported CSV file will contain all attributes, not all of them can be imported with CSVDE (some area automatically created by AD)

There's also LDIFDE, but because of its format and difficulty of use, CSVDE is preferred for this kind of task.
The administrator has disabled public write access.

Re: Need to get 200 users into AD 7 years 2 months ago #31980

  • ZiPPy
  • ZiPPy's Avatar
  • Offline
  • Expert Member
  • Posts: 500
  • Karma: 0
KiLLaBeE is a close friend of mine, and has helped me with Microsoft side troubleshooting and implementations on numerous occasions. He is definitely the man to talk to about this kind of stuff.


Cheers,

ZiPPy
ZiPPy
The administrator has disabled public write access.
Time to create page: 0.078 seconds

CCENT/CCNA

Cisco Routers

  • SSL WebVPN
  • Securing Routers
  • Policy Based Routing
  • Router on-a-Stick

VPN Security

  • Understand DMVPN
  • GRE/IPSec Configuration
  • Site-to-Site IPSec VPN
  • IPSec Modes

Cisco Help

  • VPN Client Windows 8
  • VPN Client Windows 7
  • CCP Display Problem
  • Cisco Support App.

Windows 2012

  • New Features
  • Licensing
  • Hyper-V / VDI
  • Install Hyper-V

Linux

  • File Permissions
  • Webmin
  • Groups - Users
  • Samba Setup