NM: Common Name and Mail-in Database Name Translation are missing from the Name Translation Table (4321332)

Issue

Name Translations for certain Mail-In Database names do not appear in the translation view. midbname.Townsend.Board.Meetings@uknown.unk

Analysis

If an SMTP address is added to the full name field of the mail-in database record, the first entry in the full name field,  the common name of the room, does not show in the translation view. Typically when Mail-In Database are created in Domino they are given a common name,  "Marketing and Sales"  and not a hierarchical name "Marketing and Sales/Acme". If both entries in the 'Full Name' field are a hierarchical name and an SMTP address both entries will show in the translation view. It is only when both entries are a common name and an SMTP address that the common name entry ceased to exist and only the SMTP address will be listed. This results in the common name not being translated.

Solution

Follow the steps below to correct this issue:

1. Open Notes Migrator.nsf in Designer
2. Double Click on the ‘View’ view
3. Find the "Address Translation" view, and open
4. Click on the “From” column
5. Delete the existing code or copy and save it to Notepad .txt file.
6. Copy the following code and paste into the From column, replacing the existing code.
7. In the column formula field change the existing formula to:

NamesToSearch := @Unique(@LowerCase(FullName:ShortName)); 
m := @Trim(@LowerCase(MailDomain)); 
temp := ""; 
@For(n := 1; n <= @Elements(NamesToSearch); n := n + 1; 
x := @If(@Contains(NamesToSearch[n];"=");(NamesToSearch[n]):(@Name([Abbreviate];NamesToSearch[n])):@If(m !="";(NamesToSearch[n] + "@" + m):(@Name([Abbreviate];NamesToSearch[n]) + "@" + m);"");@Contains(NamesToSearch[n];"@");NamesToSearch[n];""); 
temp := @Trim(@Unique(temp:x)));

loopResult := @Unique(@Trim(temp)) : @lowercase(@Name([CN];@subset(fullname; 1))); 
@If((Type="Group" | Type="Database" | Type="Resource") & loopResult="";@If(m="";FullName;(FullName:(FullName + "@" + m)));loopResult)

8. Close Domino Designer
9. Return to Notes Migrator.nsf view the Lotus Notes client. Confirm you can see the users in the "Email repliability - Add Names to Translation Table" view. You may need to close and reopen the view, if the view was left open during this update.