Need advice bulk addreess book change

[kolasinski]

I hope the experts here have a solution to what seems like a feature that should be built in to Lotus Notes.

First off we use Lotus notes 6.5

I need the easiest, automated way to find and replace names in my address book caused by customer changing their mail domain.

Specifically, when Daimler-Chrysler exsisted, the domain names most of us put in our address books were nameXYZ@daimlerchrysler.com, or nameXYZ@dcx.com. Since the purchuse by Cerebus, they are changing their server so that only emails addressed to nameXYZ@chrysler.com will get through.

I know I personally have over 100 email addresses that this will affect, and others do too.

Is there a simple find and replace tool that can be pointed to my notes address book that can handle this apparently simple task?



Thanks

 

[pmonett]

No, I don't think there is an easy, simple tool already available.

But it is not too difficult to write an agent that will do what you wish for :

WkDomain := @Uppercase(@right(InternetAddress;"@"));
WkNewDomain := @if(WkDomain="DAIMLERCHRYSLER.COM";"CHRYSLER.COM";WkDomain);
FIELD InternetAddress := WkNewDomain;""

That should just about do it. Of course, backup your data beforehand, and make sure that the agent runs only on all documents in view or, better yet, only on selected documents.

Pascal.


I've got nothing to hide, and I'd very much like to keep that away from prying eyes.

 

[kolasinski]

Pascal.

Thanks for your reply. I had not known about agents, and was successull in changing one field by sort of trial and error.

I was able to use the "simple agent" to highlight multiple addresses and change the "business, Company".

I was not able to use your formula script to change the @domain.com however. I noticed Lotus calls that field "mailaddress", not WKdomain, and even when changing that I couldn't get it to work.

Also, I was wondering why you had "uppercase" mentioned in your formula. Could you elaborate on that, too?

Any other ideas?

 

[kolasinski]

With a little more trial and error, I found a formula agent that does work:

olddom := @Right(MailAddress; "@");
SELECT @LowerCase(olddom) = "old_domain.com";
local := @Left(MailAddress; "@");
newdom := "@new_domain.com";
FIELD MailAddress := local + newdom

Pascal, thanks