How to update user account attribs in AD?

[Jack]

We have a Win2k env. (single domain, empty forest root)
with about 700 user accounts.

I have an Excel file (in the form of a CSV) which contains
all the information for each user account (i.e., full
name, department, address, manager's name, etc). I need to
update AD with this information.

What is the best way to do this?
I am completely unaware of any scripting languages, so
please be kind enough to explain the procedure in detail!

 

[Herb Martin]

We have a Win2k env. (single domain, empty forest root)
with about 700 user accounts.

That seems contradictory -- if you have an "empty root" and
"700 accounts" then how can it be a "single domain forest"?

I have an Excel file (in the form of a CSV) which contains
all the information for each user account (i.e., full
name, department, address, manager's name, etc). I need to
update AD with this information.

What is the best way to do this?
I am completely unaware of any scripting languages, so
please be kind enough to explain the procedure in detail!

No way can anyone do that (teach you scripting in one email) but
you can find various scripts that you can modify or perhaps use as
is on the Microsoft site (probably MSDN and search for Scriptomatic
and Active Directory is your best bet.)

There is also a bulk import utility for CSV files (CSVDE.exe) but the
other (LDIFDE.exe) for LDAP import has more features.

 

[ys@work]

Using LDIFDE to Import and Export Directory Objects to Active Directory
http://support.microsoft.com/default.aspx?scid=kb;en-us;237677

HOW TO: Use Csvde to Import Contacts and User Objects into Active Directory
http://support.microsoft.com/default.aspx?scid=kb;en-us;327620

 

[Guest]

Download AD Infinitum from www.newfawm.com/adi14.exe
The trial version will let you import your info for all
700 users and will overwrite existing account details
with the new ones you are supplying. Select the Import
Properties task on the Setup tab - it's quite straight
forward.

 

[Cary Shultz [A.D. MVP]]

Jack,

Sorry for the late reply. Without taking anything into account other than
the request to update about 700 user accounts I might suggest that you look
at CSVDE ( mentioned already by Herb and 'ys@work' ) since you have a
spreadsheet already.

However, there is another utility that might be of great help to you:
ADModify. It is something that I use in every environment and use it
whenever it is appropriate. There are some attributes that it can not
modify...

HTH,

Cary