Running Domino/Notes R6 (Yes, I know I'm in the 3rd of Dante's rings running Notes).
We've got a discussion group database (I think it's running the version 4 template of the Discussion Group) and somewhere along the line someone created duplicate categories (keywords, tags) for one of the standard reports we run and post daily, so some days the reports end up in one category and and others days they end up in the other.
It has fallen to me to migrate nearly 700 topics in the incorrect category to the correct one and to remove the incorrect category so as to preven this issue going forward.
However, I'm not finding any admin panel or tool that will allow me to either bulk edit all the topics posted in this category or to merge the two categories, or however Notes developers conceived to do such a thing, if indeed they did.
I have admin account access and access to the Domino Administrator in addition to the Notes client, the console, and all other standard notes admin tool thingies.
What do I do?
UPDATE response to two answers below:
OK, looks like I'll have to read up on @Formula and LotusScript. I'll do a bit of self-education and then get back with the results or further questions (more likely the latter).
UPDATE for Ken's solution below:
So, using the Domino Designer, I've created a new agent in the desired Discussion database, set it to run when I select it from the menu on all selected documents. It runs the formula:
FIELD Category := "05. JCG Daily Loan Report"; SELECT @All
The SELECT @ALL was added by the designer automatically.
I select a few of the desired documents, go to Actions and select my agent "Change Category", a process status window shows briefly the status and goes away once complete. However, the documents are not changed.
In the Designer, the Change Category agent has a check in the No Refresh column. Thinking I had to refresh the database view manually, I pressed F9 in the discussion group after running the agent, but this made no difference.
Right-clicking on the agent in the Designer window, I select Log... and it tells me the agent has never been run.
Where have I gone wrong?
UPDATE further information:
Closing and reopening the Designer I not get a log. It reports that of the 6 documents I'd selected, it modified all 6. However, the documents still have the incorrect category.
Looking through the New Main Topic form, I find in Reference both Categories and Category. Should I be running this script against the Categories?