Mass find/replace on formulas

HCL Domino Domino Forum
1

I’m fairly new to the development side having been an administrator for about 15 years. I occasionally used the designer client for minor issues, but now I’m in full blown dev mode.

Our Domino server is moving and the file paths are changing as well. The developers who worked our interconnected DBs used hard coded server/path names on hundreds upon hundreds of fields. I’m faced with trying to update all of the instances of them, mostly in pick lists so they are formula-based. Not sure how to do this in scale as it would take a month of Sundays to finish. An example of what exists is below:

Ans:=@PickList([Custom]:[Single];“Server A” : “filepath.nsf” ;“ItemViewSP”;“Select Part Number”;“Part Number”;1);

@SetField (“PAddCBR_12”; @DbLookup(“”:“NoCache”;“Server A” : “filepath.nsf”;“ItemViewSP”;Ans;1));

@SetField (“PDescrip1_2_12”; @DbLookup(“”:“NoCache”;“Server A” : “filepath.nsf”;“ItemViewSP”;Ans;2));

Is there a way in the client to do this? Designer find/replace tells me nothing found when I search/replace or even a plain search for Server A or filepath.nsf.

2

Subject: This is with the “Search” menu in Designer?

Pretty often I select-all, then search from the menu.

It only manages to track down one design element type at a time, but I was pretty sure it found the text of @functions. But true, I’m on a higher version of Designer.

3

Subject: I’m using the find/replace in the edit menu

We have only the 7 designer client available so I’m wondering if this is a bug or my ignorance.

4

Subject: I think it came in with 8.

I’m not sure if Designer 8 is still available for single-use download, but it’s possible it’s still out there somewhere.

5

Subject: Still the same with 9 designer

I’m now in possession of the 9 designer client. Still not able to find the design elements (hot spot buttons) that contain the server name. Guessing I’ve done something wrong in my attempt.

6

Subject: Pretty sure, find/replace will only work on text on the page

It won’t go through formula.

What you can do is, find every that has the reference you want to find by using the design synopsis and searching that, then at least you know where to make the changes.

Some of the 3rd party tools like Ytria tools might like you find and replace.

7

Subject: Checked with Ytria their tool doesn’t offer this

The design synopsis is what I used last time but its still terribly slow to get through hundreds of these.

Thank you everyone for at least confirming that I hadn’t missed something.

Merry Christmas!

Tim

8

Subject: Agents

Look for simple action/@Formula agents (Help)

9

Subject: DXL?

I haven’t used it for a year or so, but I think you could export the database design to DXL (See “Exporting and Importing DXL” in the Help File). It’s a bit fiddly, but I think you’ll be able to find/replace the filepaths in the output file and import it back in.I’ll have a bit more of a think over the weekend and maybe write some test code.

Phil

EDIT: I’ve just seen the date on your question - I hope you found a non-manual way of doing it!