Archive

Archive for the ‘Lotus Notes Solution’ Category

Error when open document in local with “Linked Document Cannot Be Found In The View.”

Some how when user use local replica and have issue in replica database and make user can’t open document with error

“Linked Document Cannot Be Found In The View.”

Full Error Message: 

“The Linked Document cannot be found in the view when replying to an email”

I think this issue cause replica database have some issue and I found some solution can resolve this issue below.

Suggested Solution

1. It casue Replica of database not updated. If user has multi replica icons on the laptop then please check if these are

Read more…

Viewed 20387 times by 5338 viewers

Lotus Notes Migration migrate to Sharepoint Checkpoint

The simplest upgrade is often unsatisfactory: It takes advantage of many new features WSS 3.0/MOSS 2007. It requires numerous manual operations “post upgrade”. Often the best solution is to define a period of interregnum, and manage the transition.

Restructure means:
1. Building a new environment of SharePoint 2007 (able to take advantage of all the news)
2. Migrate data or content (documents, lists, pages, etc..) in a transit
3. Transfer the contents to the new and renovated SharePoint 2007 environment
4. Manage and update policies redirects paths (URLs)

Read more…

Viewed 23342 times by 6563 viewers

Deletion Stubs Performance in lotus Notes

Minimize Deletion Stubs
In a database that gets archived frequently, or that has a large number of “temporary” documents that get removed on a scheduled basis, you can keep your database lean by reducing the number of deletion stubs it maintains.

You can use the “Remove Documents Not Modified in Last X Days” setting in the database replication options to minimize deletion stubs in databases with a lot of deletions. Deletion stubs get purged at about one half the number of days specified in this setting, regardless of whether or not the setting is active (normally you do not want this setting to be active, but the number of days affects the deletion stub purge interval regardless).

Read more…

Viewed 27407 times by 7674 viewers

‘Field is too large (32k) or view’s column and selection formulas too large’ when saving document

This issue can be found when you save document but sometime it can save by schedule agent and raise error when save it again.

This behavior is relative to the basic call, rather than a specific LotusScript ComputeWithForm method. For example, there are reports in the Lightweight Directory Access Protocol (LDAP) behavior is affected large areas and types of settings are not as expected in the case.

Read more…

Viewed 33626 times by 10063 viewers

How to exclude multiple groups to an individual name.

I would like to know how, except to send a letter to many individuals. We’ll save by using a group mailing. Group is a member of the lotus notes group. Each can be more than one group. How do I use lotus script to ensure that a person can only receive emails.
It’s not so easy since Lotus Notes Address Book can be used in a way that many will have to be short like this.

Working Step

1. In LotusSession get all address books (s.AddressBooks)
Read more…

Viewed 34931 times by 9982 viewers

Validate a Richtext field : has a File Attachment, Doc link and many Notes Item.

I think many Notes Developer find way to Validate a Richtext field. It hard to find direct lotusScript to check it in

Lotus Notes Document.  Please try this function for Validate a Richtext field, it can validate list below.

DOCLINK
FILEATTACHMENT
OLE
SECTION
TABLE
TABLECELL
TEXTPARAGRAPH
TEXTRUN

I think this topic in Lotus Notes tutorial is useful for you. Thanks.

Function HasFileAttachment(doc as NotesDocument ,uidoc as NotesUiDocument,body as NotesRichTextItem ,fieldName as String) As Boolean

Read more…

Viewed 37393 times by 11476 viewers

Check Empty Rich Text Field by backend in Lotus Notes

The problem is very basic: I found some lotus notes agent like export excel raise error when it refer attach file in rich text field. Because some notes document not have attach file and make it not have embedded object when code call to that document and make me can’t check text rage in rich text field.

The solution:

Read more…

Viewed 30908 times by 10873 viewers

Create real time access to LDAP directory server from Lotus Notes application

With the increasing demand today for centralized management, directory services business to scale, you’ll soon have to integrate your application with the Domino LDAP directory server. Domino application, you can have fields in a Notes form automatically populated with information from an LDAP directory server. One possibility for achieving this integration is to write a Java agent that connects to the corporate directory server using Java Naming and Directory Interface (JNDI).
Read more…

Viewed 33226 times by 11747 viewers

Transfer attachments from a BLOB data type into Notes Rich Text field

This behavior is expected because the conversion format Notes did not note the header files specified in the RTF (Rich Text Field) to transfer files from the column drops to Notes. RTF follow these steps.

  1. Create a File Connection Document (in LEI 3.x) or a Connection to File System Document (in LEI 6.x), checking the option “Binary File Contents”.
  2. Create a Direct Transfer Activity in which you specify in the field Subdirectory the Directory on the hard drive where the files will be transferred (below Data directory).
  3. You can have a column of varchar type in the RDB in which you specify the file name. When you create the Direct Transfer Document, map this column with the Target Field “Filename”. Also, map the BLOB field containing the attachment with the target Field “Content” (LEI says that “Content” is of type Text, but it works.).
  4. Run the Direct Transfer Activity. The files will be placed on the hard drive in the specified directory.
  5. Use a LotusScript agent to insert the files from the shared directory into the RTF. To fetch the right file with the LS agent, you can use the file name that had been previously replicated into the Notes document, using a Direct Transfer Activity, for instance.

Read more…

Viewed 36817 times by 12713 viewers

Play with Pivot Table in Lotus Notes

I finally got this job for use Pivot table in Lotus Notes. It appears that you must use numbers to set some string values of objects. For example, a field can have a pivot function (As sum, avg, min, max, etc.). In VBA, you should enter. Function.xlAverage (without quotes) to generate an average value for the field. Is necessary in LotusScript write. Function = “2″ (the third element of the list of functions availalable, the count begins with “0″). In general, if you find a property or method that has mulitple value options, check the OLE aid options and convert text into a number string that begins with “0″. You’ll need to experiment with each specific range of options to make sure they follow the pattern.

Read more…

Viewed 34985 times by 12333 viewers