Script to fix a Mail File Location in a Person Document

Language

Admin Scripts

Tags

administration formula mailfile name

Author

Keith Brooks

Submitted on

October 9, 2021 at 3:49 PM

Rating

Downloads

Notes

This is a simple thing, but one that is very valuable, especially when doing server folder or drive changes, email migrations or corporate mergers.
The important piece which people forget is what to do when the syntax is caps or lower case.
This script sets the syntax to lowercase.

Instructions:
NOTE: Presumes you already have your Directory/NAB (Names.nsf) open
1) From the Notes top menu, click on Create, then click on Agent. In the window that opens, give the agent a name and description
2) Select FORMULA
3) Copy then paste in the code
4) Edit the directory name (mail2 in this example) to whatever one you are trying to change that is in the person document.
5) Edit the directory name it should be changed (mail in this example)
6) Save your agent
7) Test the agent by going back to your Directory and go to a test person in the list of users
8) Click on Action from the Notes Menu and find your new Agent and click on it to run it
9) Open the person doc and see if all looks good, if not, check your syntax

SELECT Form = "Person";
@If(
	MailFile=""; "";
	@Do(
		mf := @LowerCase(MailFile);
		tmp := @ReplaceSubstring(mf; "mail2";"mail");
		@SetField("MailFile"; tmp)
	)
)

All code submitted to OpenNTF XSnippets, whether submitted as a "Snippet" or in the body of a Comment, is provided under the Apache License Version 2.0. See Terms of Use for full details.

No comments yetLogin first to comment...