Lotus Notes Performance Tips. This page contains a variety of Lotus Notes and Domino related performance tips, with links to additional information where possible. In particular, you should visit the links in the 'Required Reading' section of this page. Those pages and documents have a number of performance tips beyond what I mention here. Lotus Notes access error: 'database is not opened yet' I have written Web services in Lotus Notes Domino R7, but receive the error, 'database is not opened yet' when trying to access the Lotus Notes database from another Domino server. My Web service is signed with the Lotus Notes ID to run a Web service or agent on the specified Domino server.

Lotus Notes Insufficient Memory Too Many Design Elements Formed
Lotus Notes Insufficient Memory Too Many Design Elements Must
Ibm Lotus Notes Insufficient Memory Too Many Design Elements
Lotus Notes Insufficient Memory Too Many Design Elements Desk Design Pool
Lotus Notes Insufficient Memory Too Many Design Elements Called

Please note that this is a converted HTML file so some spots may not make
sense, but the basic information is all there. Enjoy.

BEGIN -- Cut Here -- cut here
Lotus Notes FAQ

Welcome to the Lotus Notes FAQ (Frequently Asked Questions) Web page. This
document contains answers to some of the most frequently asked questions on
the comp.groupware.lotus-notes.misc Usenet newsgroup and on the LNOTES-L
mailing list. If there is a question/answer you think should be in this
FAQ, please send mail to the FAQ Maintainer.

Standard Disclaimer for the Lawyers: Lotus Notes is a Trademark of Lotus
Development Corporation. Most of this information was culled from the above
sources and personal experience; there is no intention to misrepresent
anyone or anything. The author is not related in any way with any
commercial products mentioned here and will not profit by any
recommendations. Use any of these tips at your own risk. All copyright
rules apply as appropriate. If there is anything illegal here, let the
author know and it will be removed immediately.

* Programming Tips
* Administration Tips
* Notes Platforms
* Mail Gateways
* Internet Gateways
* FTP Archives
* Web Sites
* Mailing Lists
* Books and Magazines
* Notes 4.0
* Credits

There is also a more detailed Table of Contents.
---------------------------------------------------------------------------

Programming Tips

How do you generate unique document numbers?

Because of the nature of Notes database replication, there is no way to
generate unique document numbers. What is normally done to give each
document a unique 'key' is to concatenate the user's name or initials with
the date, and the time of document creation. An example can be found in
Lotus Notes' Call Tracking Database example. Another example is below:

TimeNow := @Now;

YearString := @Right(@Text(@Year(TimeNow)); 2);

MonthString := @Select(@Month(TimeNow); '01'; '02'; '03'; '04'; '05'; '06';
'07'; '08'; '09'; '10'; '11'; '12');

DayNumber := @Day(TimeNow);

DayString := @Select(DayNumber; '01'; '02'; '03'; '04'; '05'; '06'; '07';
'08'; '09'; @Text(DayNumber));

HourNumber := @Hour(TimeNow);

HourString := @If(HourNumber = 0; '00'; @Select(HourNumber; '01'; '02';
'03'; '04'; '05'; '06'; '07'; '08'; '09'; @Text(HourNumber)));

MinuteNumber := @Minute(TimeNow);

MinuteString := @If(MinuteNumber = 0; '00'; @Select(MinuteNumber; '01';
'02'; '03'; '04'; '05'; '06'; '07'; '08'; '09'; @Text(MinuteNumber)));

SecondNumber := @Second(TimeNow);

SecondString := @If(SecondNumber = 0; '00'; @Select(SecondNumber; '01';
'02'; '03'; '04'; '05'; '06'; '07'; '08'; '09'; @Text(SecondNumber)));

UniqueID = YearString + MonthString + DayString + HourString + MinuteString
+ SecondString + @Left(@UserName; 1) + @MiddleBack(@UserName; ' '; 1)

How do you generate sequential document IDs?

A company called DSSI also makes a Sequential Number Generator for Notes;
call (818)991-0200.

A company called Sentor Communications also has a product called SequelNum.
Call (61 2 907 9788) or email for more info. The list price is US$190.

How do you set up a database to provide a menu when it is opened?

Create your default view with a selection formula: Form = 'Menu'. Sort it
by a hidden field called 'Sequence'. Make one visible field with the
formula: MenuText. Assign a large bold font in a pretty color to that
column.

Create a form called 'Menu', and design it to have two fields: Sequence
(numeric) and MenuText (text). Hide all these fields when reading. Add a
rich text field that is not hidden. In the Form Attributes dialog, be sure
to specify that this form is not to be displayed on the Compose menu.

Create a macro that allows you (or other database designers) to compose
'Menu' docs. Compose Menu docs that give your users the following default
view:

Welcome to NiftyApp! This is the Main Menu.

Double-click on your selection:

Compose Nifty Doc

View Nifty Things

etc. Compose some Menu docs with blank MenuText fields to space things
nicely. In the rich text fields of the Menu docs, put in text that
describes available choices, such as 'Push here to compose a Nifty Widget',
and buttons with formulas that execute that action. You can hide all forms
and views from Notes menus, leaving the only available choice on the View
menu 'Nifty App Main Menu'.

How do you create a Doclink automatically?

Add these lines to your macro:

Bride and prejudice movie download 720p full. @Command([FileOpenDatabase];'database';'view';'key';'1';'1');

@Command([EditMakeDocLink]);

@Command([FileCloseWindow]);

@command([EditDown];'1'); > how many fields down from your button

@command([EditPaste]);

Does Section Security work?

With Notes 3.0c, If you add a section with Security, the security for that
section holds over to any sections below that section. Upgrade server and
clients to ver. 3.2 or above.

How do I automatically categorize incoming mail?

Add the following to the Mail/Paste macro for your mailbox:

FIELD Categories :=

@If(@Contains(From; 'lnotes-l'); 'LNOTES-l Internet';

@Contains(From; 'QuoteCom'); 'QuoteCom';

@Contains(SendTo; 'SATL-CON'); 'Satl-Con'; ');

SELECT @All

How do I set up an automatic 'I'm on Vacation' mail message?

Set up a background macro in your mail database. This should be run on
documents not processed by the macro and it should be run your mail server.
The formula is:

@If(DeliveredDate = ' | From = 'Your Name'; @Return ('); DeliveredDate >
[06/30/93 05:00:00 PM]; @MailSend(From;';'Your Name'; '; 're: Memo sent
to Your Name' + Subject; 'Thank you for your correspondence. I shall
return.'); @Return('));

SELECT @All

Remember to put your name ('Your Name' in the above example) and the date
to check (6/30 in the above example) in the correct places in the macro.

How do I get the week ending date for a specific day?

Assuming tdate contains the day you'd like to convert:

@If(tdate != '; @Adjust(tdate; 0; 0; @Modulo(8 - @Weekday(tdate); 7); 0;
0; 0); tdate)

How do I calculate the number of weekdays between two date fields?

Use the following formula counts the number of weekdays (no weekend days):

diffDays := (EndDate - StartDate) / 86400 + 1;

strtDay := @Modulo(@Weekday(StartDate); 7);

endDay := @Modulo(@Weekday(EndDate); 7);

result := (diffDays - endDay + strtDay - 8) * 5 / 7 - @Max(-2; -strtDay) -
@Min(1; endDay) + 5 - strtDay + endDay

Can I lookup Rich Text using @Db functions?

Yes, but if the value you are trying to look up is in a view column, it
will fail.

Can I look up a DocLink using @Db functions?

Yes, but you will have to perform two Lookups. One Lookup will return the
contents of the Rich Text Field containing the DocLink itself, and the
other will return the contents of the field called, '$LINKS.' This second
Lookup must return its value to a field also called, '$LINKS.' The
information in the $LINKS field is the pointer information which tells the
DocLink where to go. When you perform the two Look

Lotus Notes Insufficient Memory Too Many Design Elements