Pre-Populating Lotus Connections Tags - A manual test run!

I am working with a client implementing Lotus Connections 2.5 and they want to look at ways of pre-populating some tags for the user profiles. After digging around the database structure you can see there is a table called PEOPLE_TAG. This is the table that stores all of the tags.



The columns are PROF_TAG_ID (This is simply a UUID randomly generated), PROF_SOURCE_KEY (This is the user that created the tag), PROF_TARGET_ID (This is the user that the tag is assigned to), and lastly the PROF_TAG (which is the actual tag itself).

So as a test I used the DB2 Control Centre to create a new row in this table. For the PROF_TAG_ID i used http://www.famkruithof.net/uuid/uuidgen which will generate a random UUID for you (Version 4 is needed for Connections). I then looked up a user in the EMPLOYEE table that will be the source (our Admin user) and used another user for the target. You simply copy their PROF_ID and add it to the appropriate column for the new tag record. And then just enter your tag in lowercase in the PROF_TAG column.

And that is it! Go to your connections, open the target user in Profiles, and they will have the tag.

The next step will be to automatically populate this table using TDI!