Need help with an agent

HCL Domino Domino Forum
1

I have an application that use the field type names and address dialog for lookup.

We had a reorg and they changed the group names. There are thousand of documents in this app that now have old names.

Since the fields are multi-value, I can’t figure out how to automatically change them

The value is FSG-groupname and needs to be TFG-groupname.

I appreciate any help.

2

Subject: Lotusscript agent

Just write a Lotusscript agent.

It could work something like this:

  1. Build a list of the fields to update. I assume that you have several different forms, and the names fields are named differently on the different forms. So I would use the field name as list tag together with the form name, to get a guaranteed unique value. Like this: “formname:fieldname”. I would make it all lower case.

The value in the list element can be anything, perhaps the same as the list tag. You use this list to perform a check later on.

  1. Loop though all documents in the database. For each document, loop though all fields. For each field, concatenate the form name and the field name togther with a “:” between them, and convert to lower case. Now you just use IsElement() to check if you have a list item with this value. If IsElement() returns true, you process the field, otherwise just get the next field, etc.

  2. When you process the field, split the values into an array (remember that all Notes fields are arrays) and loop through the array items. Perform a Replace() on the items, then save the array back again to the document.

Done.