multiple user modifications

[Guest]

I need to make bulk changes to existing AD users, the attributes will be common but the values will be different e.g manager, telephone numbers, we also have extended the schema to create new attributes.

I would like to use csv files that I can populate and then import the csv file. I understand csvde.exe can be used to import a csv to create new accounts.

If I had common attribute values to change I could use ldifde.exe, and search & replace common attribute values before importing.

But what can I use to import csv files to modify existing account details.

Many thanks

 

[Ace Fekay [MVP]]

In

I need to make bulk changes to existing AD users, the attributes will
be common but the values will be different e.g manager, telephone
numbers, we also have extended the schema to create new attributes.

I would like to use csv files that I can populate and then import the
csv file. I understand csvde.exe can be used to import a csv to
create new accounts.

If I had common attribute values to change I could use ldifde.exe,
and search & replace common attribute values before importing.

But what can I use to import csv files to modify existing account
details.

Many thanks

Unfortunately you cannot use CSVDE to modify existing accounts. You would
need to export them using LDIFDE, modfiy the attributes, change the "add" to
"modify", and use LDIFDE to pump them back in.

Just in case, here's specific instructions on how to export the accounts
with just that specific attribute you want to change (instead of it giving
you the whole kit and kaboodle), how to change the file, and how to import
it back in:

237677 - Using LDIFDE to Import and Export Directory Objects to Active
Directory:
http://support.microsoft.com/default.aspx?kbid=237677

--
Regards,
Ace

Please direct all replies to the newsgroup so all can benefit.
This posting is provided "AS-IS" with no warranties and confers no
rights.

Ace Fekay, MCSE 2000, MCSE+I, MCSA, MCT, MVP
Microsoft Windows MVP - Active Directory

HAM AND EGGS: A day's work for a chicken; A lifetime commitment for a
pig. --
=================================

 

[Guest]

But is there a way of importing from a csv file without using CSVDE.

Many thanks
Matt

 

[Ace Fekay [MVP]]

In

But is there a way of importing from a csv file without using CSVDE.

Many thanks
Matt

Natively not that I'm aware of, unless a 3rd party tool exists.

--
Regards,
Ace

Please direct all replies to the newsgroup so all can benefit.
This posting is provided "AS-IS" with no warranties and confers no
rights.

Ace Fekay, MCSE 2000, MCSE+I, MCSA, MCT, MVP
Microsoft Windows MVP - Active Directory

HAM AND EGGS: A day's work for a chicken; A lifetime commitment for a
pig. --
=================================

 

[Cary Shultz [A.D. MVP]]

Matt,

I typically use ADModify or ldifde for this sort of thing.

ADModify is a wonderful tool that will allow you to make bulk changes to a
lot of user account objects at one time. However, the caveat here is that
the value would have to be the same for all of the user account objects.
For example, everyone in the Houston office would have the same address of
123 Main Street, Houston, TX 77013. This would be really simple with
ADModify. It would be very doable with ldifde as well but would require a
bit more work.

ldifde might just be your answer here. To expound upon what Ace gave you:

Say that you have 10 user account objects and you need to enter each
person's direct telephone number. Obviously, the attribute will be the same
( telephoneNumber ) but the value will be different in each case.

Take the dn: from each user account object ( on the first line ), on the
second line make it "changeType: modify" and then on the third line make it
"replace: telephoneNumber". On the fourth line you would enter
"telephoneNumber: 713.555.1212". Do not forget the little dash "-" on the
fifth line. Skip a line and then repeat the process for the second user.
And so on and so on.

I might suggest that you consider creating a separate .ldf file for each
attribute that you need to modify. So, you would have a telephone.ldf file
for that attribute, a manager.ldf file for that attribute, etc. etc. etc.

Getting the dn: for each user can be a pain. Not really, though. You can
easily create the initial .ldf file that will have the attributes that you
need by using your existing AD. Then use the 'features' of NotePad to make
any global change that you need ( changeType: add to changeType: modify, for
example ).

HTH,

Cary

I need to make bulk changes to existing AD users, the attributes will be

common but the values will be different e.g manager, telephone numbers, we
also have extended the schema to create new attributes.

I would like to use csv files that I can populate and then import the csv

file. I understand csvde.exe can be used to import a csv to create new
accounts.

If I had common attribute values to change I could use ldifde.exe, and

search & replace common attribute values before importing.