home recent topics recent posts search faq
Home » Password Control - Password Control - General » Bulk Modify - UPDATE not REPLACE attribute Messages in this topic - RSS
|
2/16/2010 8:49:22 AM
joanne.finger
joanne.finger
Posts 2 		I need to add a word to the Company field of some user objects. I have the users in a CSV. Problem is it replaces anything already in the Company field, as opposed to adding to it. Is it possible to update but not replace? So even if the company name is there, I want the new word to appear before it.
2/16/2010 10:35:08 AM
admin
admin
Posts 331 		Hi,

There are a couple of ways to do this depending on your exact requirements. I'd suggest using Bulk AD Users over Password Control for bulk updates.

The first step is to add the company attribute to the grid if it isn't already there - Use the Properties to load dialog.

The next thing you need to do is to select the user accounts you want to modify in Bulk AD Users. There might be a few ways for you to identify the users - if no other method exists, you can use the "From List" method. You should be able to copy/paste the user accounts from the CSV using Excel - The application expects 1 username per line.

You should now have the user accounts you want to modify in the grid - the next step is to decide on the method you want to use to perform the update. If you are prefixing the same value for all user accounts, you can do it in the Bulk Modify dialog. e.g.

myprefix<attr>company</attr>

If the prefix value is different for each user, you will need to use a different method - You could extract the data to CSV, edit the data as required and update from the new CSV file. You could also use the "Edit In Excel" feature to perform the update directly in MS Excel. I don't know how familiar you are with MS Excel, but it's quite a powerful tool for manipulating data - You could use a lookup function to match the correct values to each user account.

Hope this helps,

David
2/16/2010 12:28:07 PM
joanne.finger
joanne.finger
Posts 2 		Thanks for the quick response David. Sounds good, will give this a go.
pages: 1
|
Home » Password Control - Password Control - General » Bulk Modify - UPDATE not REPLACE attribute