Archive for the 'Lotus Notes' Category

Lotus Notes/Domino BlackBerry integration using MDS Studio and Web Services

September 10 2009No Commented

Categorized Under: Lotus Notes

BlackBerry is a widely used wireless handheld device today. Though it was originally used for e-mail applications, it extended its capabilities to build many PDA applications based on APIs. Web Service is the standard way of communicating between disparate systems over internet protocol. Domino provides out of the box support for web service from version 7 onwards. MDS Studio is a powerful IDE for creating BlackBerry applications using component based approach.

Parsing XML in Lotus Notes using Java

September 6 20095 Commented

Categorized Under: Lotus Notes

XML is the de facto standard for exchanging information between disparate systems. Suppose you are a furniture manufacturing company and your dealer/distributor wants to place order requests to you. You create a mail-in database and ask your client to email order requests in XML format. In mail-in database you parse the XML and create Notes order request documents. Once order request went through approval cycle in Lotus Notes, sales order is generated in your backend legacy or ERP system. Sounds cool?

Lotus Notes/Domino RDBMS integration using JDBC

June 29 20094 Commented

Categorized Under: Lotus Notes

Domino provides out of the box support for Java through agents, servlets and Java classes. Java dominates web programming space and is widely used by many enterprise applications. Here I am providing one example where Domino communicates with RDBMS through JDBC.

AutoComplete feature in Domino web environment using AJAX

June 28 2009No Commented

Categorized Under: Lotus Notes

If you use Google for search in web, you might have experienced Google suggest feature. As you type in search box, it offers you suggestions. Let us try this kind of feature in Domino.

Date Picker for date fields in Domino web environment

June 27 20094 Commented

Categorized Under: Lotus Notes

Lotus Notes default date picker do not work in web. There are plenty of custom date pickers available in web. Here I am providing one of them.

Lotus Notes/Domino RDBMS integration using ODBC

June 23 20096 Commented

Categorized Under: Lotus Notes

In practical scenario there are so many instances where you need to integrate Lotus Notes with RDBMS. The company’s mission critical data storage system might be in RDBMS like Oracle or ERP’s like SAP. One of the examples is Leave Management System. The approval workflow is built in Lotus Notes and the leave data is updated in RDBMS once it’s approved. Similarly Purchase Requisition System may be built in Lotus Notes and the details are updated to backend RDBMS after approval workflow.

Names, Authors and Readers fields in web application

June 20 2009No Commented

Categorized Under: Lotus Notes

You are planning to create web interface for Lotus Domino application. Chances are that these datatypes exist as design elements. In notes environment, generally you create these fields and select address dialog for choices. But address dialog do not work in web. Even if you create a dialog list/Combobox field with formula as choices, this field is saved as text, not names data type. Solution?

Generate report in Excel from Lotus Notes client using OLE

June 20 20092 Commented

Categorized Under: Lotus Notes

Reporting in Lotus Notes has its own limitation, which does not provide much flexibility. You may use Rich Text field for generating simple reports but when your requirement goes beyond that you have to look at other alternatives. You boss may be well versed in MS Office and he will be happy in generating reports in Excel/Word documents. Once you export data in Excel the data may be manipulated in variety of ways.