Coding Thoughts

DXL To The Rescue

2010-10-22T15:05:00.003-04:00

The other day I came across an issue in a lotus notes application that was kind of weird. The user was getting the ***** error when trying to edit a group in the ACL.

The first thing that came to mind was to check the users access, but they had Manager access to the application. They just wanted to remove a \ that was put in the name of a group by mistake, so I tried to make the change myself, but I also got the same error. I also tried to remove the entry from the ACL, but also got the same error. The next thing that came to mind was to code an agent to remove the entry by using the back-end lotusscript objects.

So this is what I came up with:

    Dim targetDB As NotesDatabase
    Dim targetACL As NotesACL
    Dim targetEntry As NotesACLEntry

    Set targetDB = New NotesDatabase("", "")

    If(targetDB.Open("Server", "db.nsf"))Then
        Set targetACL = targetDB.Acl
        Set targetEntry = targetACL.Getentry("Group With / in its name")
        If(Not(targetEntry Is Nothing))Then
            'targetEntry.Name = "TestEntry"
            Call targetEntry.Remove()
            Call targetACL.Save()
        Else
            Print "Entry not found in ACL"
        End If
    Else
        Print "Not able to open db"
    End If

But when I tried running the agent I got the same error when trying to execute the line Call targetACL.Save(). I then did some searching on the web and found a few people with the same error, but most of them suggested the ACL was corrupt and that the way they solved the issue was to create a new application and copy the data over, but this would only be an option for me as a last resort. Since it seemed like the cause was the ACL had become corrupt I thought I'd export the ACL to DXL and verify if there was anything strange in the XML.

I created the following agent to export the ACL:

    Dim s As New NotesSession
    Dim targetDB As NotesDatabase
    Dim fileName As String

    Set targetDB = New NotesDatabase("", "")

    If(targetDB.Open("Server", "db.nsf"))Then
        REM Open xml file named after target database
        Dim stream As NotesStream
        Set stream = s.CreateStream()
        fileName = "c:\temp\" & Left(targetDB.FileName, Len(targetDB.FileName) - 3) & "xml"
        If Not stream.Open(fileName) Then
            Print "Cannot open " & fileName
            Exit Sub
        End If
        Call stream.Truncate

        Dim exporter As NotesDXLExporter
        Set exporter = s.CreateDXLExporter

        REM Create note collection of actions
        Dim nc As NotesNoteCollection
        Set nc = targetDB.CreateNoteCollection(False)
        nc.Selectacl = true
        Call nc.BuildCollection

        Set exporter = s.CreateDXLExporter(nc)

        Call exporter.SetInput(nc)
        Call exporter.SetOutput(stream)

        ' Stops the from being added to output.
        exporter.OutputDOCTYPE = False

        Call exporter.Process
    Else
        Print "Could not open db"
    End If

After running this agent the following content was generated in the Test.xml:

replicaid='852574830021CC9F' path='CN=Test/OU=Test/OU=Server/O=Test!!db.nsf'
title='Test DB' usejavascriptinpages='false'>

percentused='97.7727051598594' numberofdocuments='39'>
dst='true'>20101006T162213,08-04
>20101007T094423,47-04

writepublicdocs='false'/>

deletedocs='true'/>

level='editor' deletedocs='true' createpersonalagents='false' createpersonalviews='false'
createsharedviews='false' createlsjavaagents='false'/>
10/06/2010 04:20:38 PM Test User/Test/Test updated Test Admins
10/06/2010 04:20:31 PM Test User/Test/Test added Test Admins

Since I did not see anything strange in the ACL DXL I decided to create an agent that would import the ACL DXL after removing the group with the / in it's name from the DXL. This is what the agent looked like:

    Dim s As New NotesSession
    Dim targetDB As NotesDatabase
    Dim fileName As String

    Set targetDB = New NotesDatabase("", "")

    If(targetDB.Open("Server", "db.nsf"))Then
       REM Open xml file named after target database
       Dim stream As NotesStream
       Set stream = s.CreateStream()
       fileName = "c:\temp\" & Left(targetDB.FileName, Len(targetDB.FileName) - 3) & "xml"
       If Not stream.Open(fileName) Then
            Print "Cannot open " & fileName
           Exit Sub
       End If

       If stream.Bytes = 0 Then
            Print "File did not exist or was empty"
           Exit Sub
       End If

        'Import DXL into new database
       Dim importer As NotesDXLImporter
       Set importer = s.CreateDXLImporter(stream, targetDB)
       importer.ReplicaRequiredForReplaceOrUpdate = False
       importer.ACLImportOption = DXLIMPORTOPTION_REPLACE_ELSE_IGNORE

       Call importer.Process
    Else
        Print "Could not open db"
    End If

After running this agent I verified the ACL of the application and the group was no longer there. I also tested that new entries could be added and modified without issues.

Has anybody run into similar issues before, where you had to resort to DXL for a fix?

Donate For A Good Cause

2010-04-27T07:45:00.001-04:00

Photo By michaelwm25

It's that time of the year again and this Saturday, May 1st, 2010 I will be competing at the Tampa Bay Dragonboat Races as part of the Tampa Blade Runners Red Team. Participating in this event gives us the opportunity to help with fund raising for two great organizations: FACTors Breast Cancer Patient Support Program at Moffitt Cancer Center and the Florida Aquarium.

So please help with any amount you can Make a Donation

If you live in the Tampa Bay area come watch the races behind the St Pete Times Forum --> Map

My First iPhone App - pSimon

2010-03-15T15:57:00.001-04:00

Photo By Tech-Innova Solutions, LLC

Well I've been busy since my last blog post working on my final project(more on this coming in separate posts) and other personal projects. Anyways it's been a while since I started learning iPhone development and last December I released my first app pSimon for sale on the iTunes Store. pSimon is a modern implementation of the classic “Simon Says” game that was popular in the 80s. On March 4, 2010 I released a Lite version of pSimon Lite which only included the easiest level of the game and some ads. I released the Lite version to see if I could make extra income with the ads. While I've made more income from the paid app up to this point, I have to say that I saw an explosion of downloads for the Lite version the first week that I would have not imagined. I will keep this in mind for the release of the other two apps I'm working on right now. It seems like a good marketing strategy is to release a Lite and Full version at the same time and the Lite version will drive sales for the Full version.

If you enjoyed playing the "Simon Says" game back in the day, try pSimon Lite and leave feedback as I'm constantly trying to find ways to make the game more challenging.

Masters Degree Final Project

2009-08-27T10:25:00.001-04:00

Photo By The Wolf

As part of my Masters degree in Computer Science I have to do a final project. I have decided to use the eclipse Rich Client Platform as the environment to develop/implement my project. The idea is to polish my skills on the Rich Client Platform while doing something useful :-), so for the next 3 to 6 months I will be posting my progress and the tips/tricks I find useful when working with RCP.

Stay tuned.

Risks of Cloud Computing

2009-08-08T15:30:00.001-04:00

Photo By schoschie

This is an interesting read, specially for those contemplating migrating to the cloud.

The Hidden Risks of Cloud Computing

Creating Image Maps in Joomla

2009-06-26T11:31:00.003-04:00

Photo By cocoate.com

Lately I've been working on some joomla sites for some friends and in one of the sites my friend wanted to add an imagemap. So I started researching what was the best way to go about doing this in a joomla site. I even posted a question in Stackoverflow. Well my search lead me here, it is a plugin for the default editor(TinyMCE) included in joomla that adds the ability to create and modify image maps in articles. After following the instructions on that page I still couldn't see the image map button on the TinyMCE toolbar. I found some installation instructions within the downloaded package and they didn't match the ones on the page, so I decided to give those a try, but there were some problems.

These are the instructions from the page referenced above:

copy files from plugin_tinymce{x}.zip to {yourjoomlainstance}/plugins/editors/tinymce/jscripts/tiny_mce/plugins/imgmap/
edit {yourjoomlainstance}/plugins/editors/tinymce.xml, after 'directionality' add lines:
<param name="imgmap" type="radio" default="1" label="Imagemap" description="Imagemap"> <option value="0">Hide</option> <option value="1">Show</option> </param>
edit {yourjoomlainstance}/plugins/editors/tinymce.php, after 'XHTMLxtras' add lines:
if ( $imgmap ) { $plugins[] = 'imgmap'; $buttons3[] = 'imgmap'; $elements[] = 'img[usemap|class|src|border=0|alt|title|hspace|vspace|width|height|align|onmouseover|onmouseout|name],map[id|name],area[shape|alt|coords|href|target]'; }

go to Joomla admin/Plugin manager/Editor - TinyMCE 2.0/Advanced Parameters, and make sure Imagemap is set to Show.
go to article editor, click on any image, and notice the button highlighted on the toolbar, you are done:)

These are the instructions found within the downloaded package:

copy files to plugins/imgmap/

set up your instance in the tinyMCE.init method to use the plugin, like:
plugins : "table,save,advhr,advimage,imgmap,...",

set up your instance to use the imgmap button, for example:
theme_advanced_buttons3_add : "emotions,iespell,...,imgmap",

you might need to add:
extended_valid_elements : "img[usemap|class|src|border=0|alt|title|hspace|vspace|width|height|align|onmouseover|onmouseout|name],map[id|name],area[shape|alt|coords|href|target]",

Ok so I had done the first step since I had already done the five ste.s. I never found the tinyMCE.init mentioned in the second step so I decided to skip the step. I didn't understand where I was supposed to make the change mentioned in the third step so I decided to skip it as well. The parameter mentioned in the fourth step took a while to figure out, but I finally found it by going to Plugin Manager-->Editor - TinyMCE and it is in the Plugin Parameters(below is a screenshot).

After doing this last step I finally got the image map button to show on my TinyMCE toolbar.

In conclusion, to get this to work I had to use a combination of both instructions. The actual instructions should be:

Copy files to plugins/imgmap/

Edit {yourjoomlainstance}/plugins/editors/tinymce.xml, after 'directionality' add lines:
<param name="imgmap" type="radio" default="1" label="Imagemap" description="Imagemap"> <option value="0">Hide</option> <option value="1">Show</option> </param>
Edit {yourjoomlainstance}/plugins/editors/tinymce.php, after 'XHTMLxtras' add lines:
if ( $imgmap ) { $plugins[] = 'imgmap'; $buttons3[] = 'imgmap'; $elements[] = 'img[usemap|class|src|border=0|alt|title|hspace|vspace|width|height|align|onmouseover|onmouseout|name],map[id|name],area[shape|alt|coords|href|target]'; }
Add the following to the "Extended Valid Elements" parameter:
img[usemap|class|src|border=0|alt|title|hspace|vspace|width|height|align|onmouseover|onmouseout|name],map[id|name],area[shape|alt|coords|href|target]

Notes Net Forums xPages Design Update

2009-05-15T10:44:00.002-04:00

Photo By qisur

I was looking through the notes.net forums last night and it occurred to me that they badly need a design update. So I went to ideajam and searched to make sure that nobody had already created an idea about this, it turns out someone had, so I promoted the idea and I urge everyone that uses the forums to do the same. I'm a bit surprised as to why IBM hasn't already updated the design of the forums to the new xPages design, I mean it seems like the logical thing to do since it shows off the cool stuff you can do with the new version of domino. I mean what better way is there to show off xPages? The forums are used daily by hundreds of users yellowbleeders, newbies, and most importantly people that don't like notes/domino but are forced to work with it where they work. Who knows maybe these last people will start to like notes/domino a bit more once they see the new cool stuff that can be done with xPages.

Head over to ideajam and promote the idea if you haven't already--> Improve notes.net forums

Code That Makes You Say... Huh? #1

2009-05-06T14:24:00.001-04:00

Photo By Andyrob

Most of the work I do at my current job is maintenance to existing applications within my team. A while ago I found an interesting line of code within a lotusscript library.

TStamp = Evaluate("@Text(@Now)")

It seems the developer that did this doesn't know that there is a Now function in lotusscript.

I have found this same line in most of the applications that I maintain and I've also seen it in applications that I don't maintain. Worst of all most of these applications are used globally and this line is used to capture the date and write it to an audit trail. What's wrong with this you ask? Well you don't have a consistent audit trail, for example the date format in the UK is not the same as in the US.

Two solutions to fix this would be:

Make the audit trail date field a multi value date field and use the Now function to append the date value to the field. With this approach you can use the field properties to adjust the format for displaying the dates. This allows you to display the dates in the users local format or choose a specific format.
Use the Format function in combination with the Now function to get the same date format everytime. With this approach you ensure a consistent date format within the audit trail, but you loose the ability to display the dates in the users local format.

Have you found code that makes you say Huh in applications you maintain?

P.S. I've tried telling the developer that maintains the other applications to modify the code, but that's another story...

You Can Help!!!

2009-04-28T15:31:00.001-04:00

Photo By ViNull

This Saturday I'm going to be competing at the Tampa Bay Dragonboat Races as part of the Big Blue Dragons Team. As part of the event we are asked to help with fund raising with the proceeds going to two great organizations: FACTors Breast Cancer Patient Support Program at Moffitt Cancer Center and the Florida Aquarium.

So if you can please Make a Donation

If you make a donation remember to fill out our team name as Big Blue Dragons and my name as individual paddler Carlos Rivera.

If you live in the Tampa Bay area come watch the races behind the St Pete Times Forum --> Map

Better Lotus Notes DB Icons

2009-04-08T10:50:00.001-04:00

Photo By Theresa Thompson

If you haven't done so, please head over to the Notes Design blog and ideajam and give your input. We have been asking for application icons to allow more colors for as long as I can remember. The application icon is the first thing the user sees and let's face it, 16 color icons does make the application look like legacy software. So anyways just head over to ideajam and promote the ideas the more votes it has the more likely it will be done.

Allow Notes Database icon to have 24-bit (=16.7 million) colors
Allow .png and .svg image resources

Better Java Development with Domiclipse

2009-04-06T15:25:00.001-04:00

I have been using Domiclipse for over 2 years now and it is a great tool when doing java development within Notes. It's basically a set of plugins that allow you to import a notes application as a java project into eclipse and do development using all the great tools included in eclipse. Then it lets you sync your changes back into your notes application with a click of a button. Anyway, I decided to post a step-by-step tutorial of how to install Domiclipse into your existing copy of eclipse.

First we open up the eclipse environment and we click on the Help-->Software Updates... menu item.

Next we have to add the update site url for Domiclipse. On the Software Update and Add-ons window click on the Available Software tab and then click on the Add Site... button on the right.

Next we add http://www.domiclipse.com/domiclipse/update.nsf as the location in the Add Site window and click on OK.

Once we have added the site to the Available Software, expand the site by clicking on the + on the left of the new site and this will fetch the available plugins from the Domiclipse site. Next we want to expand the eclipse category and check the box next to the Domiclipse Java Feature. The next thing to do is click the Install... button on the right and this will start the installation.

The next screen will ask you to confirm your choice, just click on the Next >

Next you will be asked to accept the license, here you will have to click on the I accept the terms of the license agreement radio button and then click on the Finish button.

After the installation finishes you will need to shutdown eclipse and open the properties for your eclipse shortcut. Here you will have to edit the Start in: property to match your Notes program directory in my case it is C:\Notes

The final step would be to start up eclipse and verify that you have the Domiclipse icons on your toolbar.

Congratulations you have just installed Domiclipse into your eclipse environment. Hope this helps some of you new that are new to java and eclipse. Domino designer 8.5.1 is supposed to have most of the eclipse features, but Domiclipse will still be a great asset to those that don't upgrade right away, which I'm guessing is most of us.

Learning some PHP

2009-03-18T12:03:00.002-04:00

Photo By CalEvans

During the last few weeks I decided to learn some PHP since I've had some requests to work with joomla. For those that don't know joomla is a opensource CMS built on PHP. Also PHP seems to be a big deal now a days, most of the jobs on freelance sites require you to know PHP and it doesn't hurt to know a bit about another technology. So first thing I did was setup my dev environment. I downloaded XAMPP which is an all in one Apache distribution containing MySQL, PHP and Perl. Next since I'm a fan of eclipse I downloaded the eclipse PDT (PHP Development Tools Project). After that I found this very helpful article of how to configure the eclipse PDT and XAMPP as to have a working development environment on my PC. After having the development environment setup I searched for some PHP tutorials to go through and found w3schools.com had a very simple walkthrough of examples for PHP (PHP Tutorial). In the end I got a very good feel of what can be done with PHP and I feel comfortable digging into some more advanced code.

WASCE Datasource in Portlet Factory

2009-02-23T09:56:00.001-05:00

Photo By MorBCN

This weekend I was messing around with Websphere portlet factory 6.1.2 and trying to set up a datasource to the included WebSphere Application Server Community Edition proved to be more of a challenge than I had anticipated. I found Development WAS CE Deployment Scenario in the Portlet Factory wiki which helped, but it seems to need a fix for the new version of Portlet Factory. In the datasource creation section it describes changes to two files, one is within your Portlet Factory project (WEB-INF\bin\deployment\wasce.web.xml) and the other is supposed to be within one of the folders of the Portlet Factory designer installation (WPFDesigner\FeatureSets\Web-App_6.0.2\Deployment\antscripts\templates\WEB-INF\geronimo-web.xml). It seems this was the case for Portlet Factory 6.0.2, but for 6.1.2 I couldn't find the second file in the specified location. After searching all over the Portlet factory designer installation files I decided to search the workspace since it was the only other logical place to search, and BINGO! The geronimo-web.xml is now included in the same directory as the wasce.web.xml.

IBM Offering to Move People to India

2009-02-05T13:07:00.001-05:00

Photo By atterhorn

I read an interesting article on the InformationWeek site today, where IBM explains that it has a new program called "Project Match" that consists of helping laid off workers move to new jobs in developing markets like India, China, and Brazil.

So let me get this straight, they not only offshore jobs, but now they want to offshore people too? Isn't the off shoring one of the mayor reasons the economy is the way it is? Sorry but I'm just against the off shoring. The experiences some of my clients have gone through with off shoring have proved that it is not all that it is made out to be. Anyway read the article to get all the details on IBM's "Project Match".

Download All Lotusphere 2009 Slides at Once

2009-01-26T13:17:00.001-05:00

Nice blog post that explains how to download all lotusphere slides by Karsten Lehmann --> How to automatically download all the Lotusphere slides

Lotusphere 2009

2009-01-23T16:36:00.001-05:00

Photo By thomas-lang

Wow! I had five great days of sessions and fun at Lotusphere 2009. The Blue Man Group was the entertainment for the opening general session and the guess speaker was Dan Aykroyd. Like all other years I had a hard time selecting the sessions to go to since there were so many great sessions to choose from. For the closing session we got to listen to a great speech by Bejamin Zander. He even got all the lotus geeks in the closing session to sing "Ode to Joy" in German. This was the best closing session I've been to so far at Lotusphere.

After the closing session I went to the Blogger Open for some mini golf fun. Thanks CuriousMitch for organizing this event, it was fun and a great way to meet others from the community.

I will definitely be back for Lotusphere 2010.

See you all there!

Lotusphere 2009 A Bit Late But Made It

2009-01-18T01:03:00.000-05:00

Photo By kbuilder

Well I made it to the Dolphin 20 minutes before registration closed. I wanted to make it to B.A.L.D. but didn't make it on time. I have a very busy schedule with all the sessions I plan to attend, but I'm looking forward to meeting some of the other bloggers in person. I will also be blogging all the cool stuff I see this week so stay tuned.

Lotus Notes 8.5 First Impressions

2009-01-11T13:57:00.000-05:00

Photo By ineal

Well I finally got around to upgrading my Lotus Notes 8.5 Beta installations on my iMac and on my Thinkpad at home yesterday. I'm happy to say that performance is way better than that of the beta and also of the 8.0.2 client, specially loading time. I also noticed that memory usage is also less on 8.5. I plan on upgrading my development server later today so I will post a follow up on my impressions on that.

Great job IBM!

Lotus Notes DB User Activity

2009-01-05T11:05:00.001-05:00

Photo By bluelakefreepress

Last week I was asked to provide some stats from an existing application which didn't have logging built into it. After extensively searching on google and other search engines the only method I found was to use the NotesUserActivity class from the Lotus Sandbox. This class uses the C api to get at the user activity data of a lotus notes database.

I know the user activity is in no way a replacement for building logging into the application, but this is an existing application which didn't have logging. The issue I ran into was that the user activity in a notes database only holds 1400 records, so this means that if the database is used heavily you might only get a few hours of usage data. Luckily the application I'm reporting on isn't used that heavily so I got about a month worth of usage data, but I was asked to provide stats since the release of the application. So I was just wondering if there another way to get usage data from a lotus notes application that doesn't have logging built into it?

Trim Down Windows XP for Your Virtual Machines

2008-12-15T11:20:00.001-05:00

Photo By nebelcarrillo

This article from lifehacker explains how to remove unnecessary components of your WinXP installation cd. This allows you to install WinXP on older hardware or virtual machines where resources are sometimes lacking. They also mention an application to trim down existing installations of WinXP. I'm trying it out on one of my existing virtual machines and will blog later on my findings.

Embbeded Docs in Form

2008-12-04T19:53:00.000-05:00

I ran into a strange situation the other day in a lotus notes application I have to maintain at work. When I edited the main form the first time and saved it, it took over 5 minutes to save!! When I looked at the size of the template is was over 90MB, it didn't have any data in it, and the % utilized was 99%. So first thing I tried was to delete all design elements except for the form and compacted the template, that didn't help. Next I decided to export the form using DXL, since opening it in the designer didn't show anything out of the ordenary.

What I found was very interesting, at the end of the form element there seemed to be over 5 MS word documents "attached". I also found some weird fields that seem to be stuff attached to the form also. Using the technique described in Make a Notes view list design elements I created an agent to create a view to show the form element, then I created an action to delete the weird fields from the form. As soon as I ran that action and compacted the template it went down to 30MB.

I for one have never seen this situation before, have any of you ran into something similar? What was the cause?

Notes Views with Colors

2008-11-25T09:38:00.001-05:00

After reading Jake Howlett's blog entry How-To: Shade Your Views Based on Document's Age, I wanted to try the technique out on an application that runs on the lotus notes client and I would use the built in feature in Notes for assigning colors to rows.

To use this feature you check the "Use value as color" property of the column

Then, assign the column a formula that will evaluate to either a list of three numbers between 0 to 255 or a list of six numbers also between 0 to 255. If you send only three values that will become the RGB color for the text and if you send six values the first three will become the RGB for the background and the other three will be for the text. It is also good to mention that these colors will take effect on all columns right of the color column, so it is not a good idea to create this column at the end of the view.

Example of values for column:
255:0:0 - Red Text
143:255:87:0:0:0 - Green background with black text
255:0:0:0:0:0 - Red background with black text

Here is a screenshot of the resulting view. By adding these visual indicators I could even remove the creation date column and users would be able to tell the age of the documents.

The documents in the application I'm planning to use this technique on are measured in minutes and not on days, so I would schedule the agent to update the view column formula every 5 minutes instead of nightly.

So now I ask, what kind of performance impact would this have on the database if any?

Lotusscript Dir Function Causes Domino Crash

2008-11-07T10:36:00.001-05:00

After many debugging and troubleshooting efforts IBM has provided a hotfix for the issue I discussed in Attachment ExtractFile Limitation post. It seems that the lotusscript Dir function causes a server crash in version 7.0.2 and it seems that it may also be the case for version 8 and probably pre 7 versions. When a path longer than 255 characters is passed to the Dir function it causes a crash instead of throwing an error. This can easily be fixed by checking the path length before sending it to the Dir function, but it was a bit troublesome to track down because you don't expect the server to crash when calling a simple function so most of the time attention is focused on other more complex functions and third-party functions.

Hope this helps anybody that runs into the same situation.

Gmail Less Downtime Than Exchange & Lotus

2008-11-04T10:25:00.001-05:00

Found this blog entry interesting.

Gmail Downtime Less Than Exchange & Lotus

Using POI to Export Lotus Notes Data to Excel

2008-10-20T22:00:00.001-04:00

As those who have been reading my previous posts have seen, I have been working on a project that involves exporting meta data from Lotus Notes documents to an excel sheet. I'm using the CreateObject("Excel.Application") function to do this. The problem is that the agents that do this export are scheduled and run on a server. This means that excel has to be installed on that server for the process to work and most of the admins that I had to work with did not like the idea of having excel on a server they have to support.

For this reason I started messing around with the apache project POI. This project has pure java ports of file formats based on Microsoft's OLE 2 Compound
Document Format. So it has classes for creating excel spreadsheets without having excel installed on the server, which would make the admins happy. So I created this simple class to create and write rows to an excel file.

package com.clr.excel;

import java.io.FileOutputStream;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class ExcelWriter {
    private int curRow;
    private HSSFWorkbook curWB;
    private HSSFSheet curSheet;

    public boolean writeExcelHeader(String[] rowValues) {
        try {
            this.curRow = 0;
            this.curWB = new HSSFWorkbook();
            this.curSheet = this.curWB.createSheet("Sheet1");

            //This will write the header row
            return(this.writeToExcel(rowValues));
        } catch(Exception ex) {
            ex.printStackTrace();
            return(false);
        }

    }

    public boolean writeToExcel(String[] rowValues) {

        try {

            HSSFRow row = this.curSheet.createRow(this.curRow);

            for(int i = 0; i < rowValues.length; i++) {
                row.createCell(i).setCellValue(new HSSFRichTextString(rowValues[i]));
            }

            this.curRow++;

        } catch(Exception ex) {
            ex.printStackTrace();
            return(false);
        }

        return(true);
    }

    public boolean writeExcelFile(String fileName) {
        try {
            //Auto fit content
            for(int i = 0; i < 20; i++) {
                this.curSheet.autoSizeColumn((short)i);
            }

            // Write the output to a file
            FileOutputStream fileOut = new FileOutputStream(fileName);
            this.curWB.write(fileOut);
            fileOut.close();
        } catch(Exception ex) {
            ex.printStackTrace();
            return(false);
        }

        return(true);

    }

}

Again I used LS2J to use this class from my lotusScript agent.

These declarations are needed to use LS2J

Uselsx "*javacon"
Use "ExcelWriter"

Agent to create excel sheet.

Sub Initialize
    On Error Goto ErrorHandler
    Dim session As New NotesSession
    Dim db As NotesDatabase
    Dim view As NotesView
    Dim doc As NotesDocument
    Dim js As JAVASESSION
    Dim xlWriterClass As JAVACLASS
    Dim xlWriterObject As JavaObject
    Dim rowValues(1 To 3) As String
    Dim folderName As String

    Print "Started Running CreateExcel"

    folderName = "C:\Temp\"

    'Initialize column headers
    rowValues(1) = "Title"
    rowValues(2) = "Date"
    rowValues(3) = "Name"

    'Initialize Excel Writer class
    Set js = New JAVASESSION
    Set xlWriterClass = js.GetClass("com.clr.excel.ExcelWriter")
    Set xlWriterObject = xlWriterClass.CreateObject
    If(Not(xlWriterObject.writeExcelHeader(rowValues)))Then
        Print "Error creating excel sheet!"
        Exit Sub
    End If

    Set db = session.CurrentDatabase
    Set view = db.GetView("MainView")

    Set doc = view.GetFirstDocument
    Do While(Not(doc Is Nothing))

        rowValues(1) = doc.Title(0)
        rowValues(2) = doc.selectedDate(0)
        rowValues(3) = doc.Name(0)

        'Write metadata
        If(Not(xlWriterObject.writeToExcel(rowValues)))Then
            Print "Could not write to excel!"
        End If

        Set doc = view.GetNextDocument(doc)
    Loop

Finished:
    xlWriterObject.writeExcelFile(folderName & "workbook.xls")

    Exit Sub

ErrorHandler:
    Print "Error " & Error & " on line: " & Erl

    Resume Finished

End Sub

Enjoy the code here.