Update AD users for CVS file

[Gil]

hi,
I have a 200 users that I have to update their AD user properties like the
phone number and the title .
I want to make a CVS file with all the update details of those users , then
I want to import those details to the AD users. (if the user has an old
phone number I want that the cvs file will put the new phone number instead
of the old one).
Can I do it, or I need a third party tool for this ?
Someone knows a tool that do it good ?
thanks....

 

[Jerold Schulman]

hi,
I have a 200 users that I have to update their AD user properties like the
phone number and the title .
I want to make a CVS file with all the update details of those users , then
I want to import those details to the AD users. (if the user has an old
phone number I want that the cvs file will put the new phone number instead
of the old one).
Can I do it, or I need a third party tool for this ?
Someone knows a tool that do it good ?
thanks....

Yes.

Use a FOR command to parse the CSV file.
Use ADMOD, tip 8233 in the 'Tips & Tricks' at http://www.jsiinc.com to update the attributes.
See tips 7714 and 8570.


Jerold Schulman
Windows: General MVP
JSI, Inc.
http://www.jsiinc.com

 

[ptwilliams]

Off the top of my head I think (but am not 100%) that you can do this with
csvde.

Alternatives would be LDIFDE (not .csv files, but text files ;-) and a
script.

--

Paul Williams

http://www.msresource.net
http://forums.msresource.net
______________________________________
hi,
I have a 200 users that I have to update their AD user properties like the
phone number and the title .
I want to make a CVS file with all the update details of those users , then
I want to import those details to the AD users. (if the user has an old
phone number I want that the cvs file will put the new phone number instead
of the old one).
Can I do it, or I need a third party tool for this ?
Someone knows a tool that do it good ?
thanks....

 

[Cary Shultz [A.D. MVP]]

Gil,

If you are talking about csvde then you can not use it to update existing
user account objects. csvde - with use of a properly formatted Excel
spreadsheet in the .csv file format - allows you to create new user account
objects ( via importing ) or to export existing user account objects.
Unfortunately you can not use csvde to modify existing user account objects.
Sorry.

Now, Paul suggested that you could use ldifde to do this. You sure could.
However, this is not as easy as you would think. It is not difficult,
though, if you have an idea on how to best accomplish this. This is what I
would normally do:

1) create the DN: line for everyone ( since it all ready exists - aka AD -
simply use ldifde to do this for you )
2) create the 'changeType: modify' and the 'replace: telephoneNumber' and
the 'telephoneNumber: 540.555.1212' line for the first user and then copy
and paste it to all 200 DN:'s - rather tedious but better than manually
doing this over and over and over.....
3) then go to each and correct the phone number ( as each user account
object will - at this moment - have the same phone number as the first user
account object ). Rather tedious, isn't it?

There is a utility that would be very beneficial to you - but not for this
particular attribute. Please download ADModify from the following link and
play with it in a test lab. Let's just say, for example, that in addition
to the corrected telephone number you wanted to make sure that all 200 of
your user account objects had the address of the office in which they worked
( say, 123 Main Street Roanoke, VA 24014 ) and you wanted the name of the
Company listed. Well, you could also do this with ldifde. I have before.
But, ADModify would be so much nicer and easier. It would take all of 35
seconds to do this! There is a lot that ADModify can do. Since I do not
script ( just now talking the plunge - VBScripting with WMI and ADSI are hot
and heavy with me right now ) ADModify is a God send!

Oh, shoot. here is the link:

ftp://ftp.microsoft.com/PSS/Tools/Exchange%20Support%20Tools/ADModify/

There are two versions: 1.6 and .NET. If you do not have the .NET Framework
installed on your Domain Controllers then you would want version 1.6.
However, if you do then you will most likely really enjoy ADModify.net.

Jerold has probably the best suggestion - if you can do that!

HTH,

Cary