Archive for June, 2009

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.