MOSS Profile Field Aggregator
March 31, 2007 - 00:49, by Dostalek, Kevin
Hey! I wrote my first reusable utility for MOSS this evening. I'll describe it here so you can remember it if you ever find yourself in a position where it could be useful. I won't bore you with the details of how it's coded or anything though.
If you ever need to populate a field in the MOSS profile database via some deterministic formula (see below) based on a combination of literals and other profile fields, this is the tool for you. Here's the scenario I had:
We needed to populate all the PictureURL fields in the profiles to point to pictures that were all located in a shared image library and named lastname_firstname.jpg. With hundreds of employees in the profiles database, this is not something you want to have to tackle manually in the admin profile list (which doesn't even support basic aids such as the datalist view).
So basically I wrote a quick command line app that lets you configure:
- The URL to any MOSS site that using this SSP
- The field you want to update (in this case PictureUrl)
- The pattern for replacement (in this case it was: http://teamweb/employeepictures/[lastName]_[firstName].jpg)... note here that the items in brakets [] are other profile properties and will be replaced on each profile entry.
- Whether you want to update all profiles or only those that have null or empty strings in the target property
Anyway, if anyone wants to know more, let me know.
Hey! I wrote my first reusable utility for MOSS this evening. I'll describe it here so you can remember it if you ever find yourself ...