Managing UCM users en masse
By Kyle Hatlestad on Feb 26, 2010
One of the handiest tools that I use with UCM is the Mass Metadata Update Excel spreadsheet. It lets you run searches against UCM and update content metadata in an Excel spreadsheet through web services. It was first created by Bex and then later enhanced by Jason Stortz.
For demonstration purposes, it's a great way to show how open and easy it is to do integrations with UCM. Just a few lines of VB script in an Excel macro and you've got an incredibly useful client tool.In thinking about other tasks that you may need to do in bulk in UCM besides dealing with content is managing users. Even with external user stores, information is captured and stored in UCM. So one of the first things I did with the spreadsheet was to modify it to add and delete users. Then I made further changes to be able to get a list of the users and to do edits on the users.
Someone recently asked me the best way to mass delete users that had been cached their from their old LDAP schema. In the User Admin applet, it doesn't let you multi-select so that becomes a very slow process. One alternative is to get the DBA involved and deal with the data directly in the database tables which isn't ideal either.
But with this spreadsheet, you can quickly add, edit, or delete the users in the system. When you open this in Excel, be sure you have your security set to allow macros.
When you first try to execute one of the commands, it will prompt you for your administrator username and password. Be warned though...once you click the confirmation dialog, it is set to perform that action. I'd recommend backing up the system before making any large-scale changes.
All of the code is right in the macros and can easily be modified to change the behavior such as adding more user metadata fields or filtering on certain user types.
You can download a copy of the. This should be treated just like a sample component which is provided as-is with no support or warranties.