Category Archives: Old Blog Post

Lotus Notes is a great tool, and I enjoy developing applications using the RAD capabilities in Domino Designer. But I also create some web applications on occasion.
This past week, when Hurricane Alex was moving in towards Texas, John, the CIO (and my boss), grabbed me first thing Wednesday morning and asked me to build a webpage. He wanted me to use the Google Earth plugin to consuming some KML files he created from the policy database (built using Visual FoxPro).

As I blogged about a year ago, I wrote some code to get the latitude and longitude for an address, and John had then rewrote the code for FoxPro so he could get the coordinates for the addresses he had in his system. So he could now very easily generate a couple of KML files, one of all our policies and one of the policy holders potentially in the path of the hurricane.
I built the webpage in a Domino database, that is usually the easiest way for me to put up a simple webpage. I added some overlays, the two different KML files that John created. I also found a KML file online with different projected paths, as well as one of the current path of Alex. The users could turn on and off these layers as they wanted. Suddenly it was very easy to see if we had any insured customers in the path, etc.

Of course, the same web page could as easily have been created using Notepad or any other tool, as it was pure HTML. But my next plan is to integrate this page with other Domino data, and we are talking about building a generic reporting tool with all different kind of geographic data. Imagine being able to map every accident/insurance claim, see where the accident happens, where the insured is located, etc. Perhaps run statistics showing the average distance from home the accidents take place, etc.

I think it is critical that I, as a Notes/Domino developer, show the power and business use of Notes by integrating it with different systems. When I first started working at this company, I was tasked with building a claim system, to handle insurance claims. The company had hired a pair of Notes consultants, who set up the environment and attempted to build a claim system. They failed, and they also told everyone that Notes and FoxPro could not talk to each other. Of course, when I came in and sat down with my (then) new boss after a few weeks at the new company, we quickly figured out a way to get the systems to communicate.
It took about 90 minutes to come up with the solution (using COM), write the basic specifications (yes, they changed some over the years, but not much), build the COM object and write some test code in Notes. Today, that COM object is used for all kind of things we never envisioned back then, in 2002. It even sends PDF files into our document imaging system.

Of course, it helps to have a CIO/manager who talks and thinks development. I don’t have to explain things that are obvious to me, we can go straight at the business logic or functionality. Something that would take 10-15 minutes to explain to a regular manager just takes seconds or a minute.

My next project, which I will start on Monday, is a database to document the claim system. There are so many design elements, with different functionality and access rights. Some buttons are hidden from certain users, using roles or document status, other design elements are restricted in other ways. Very little of this have been documented over the years, and I need to get all that documented in a good way. That is the power of Notes: I have a need, I build a solution.

Today is Father’s Day here in the US. In Sweden it is actually celebrated in November (Nov 14 this year). I am thinking about my dad, who passed away in 2001.
My dad was a very intelligent person. He may not have had a fancy education and degree. As a matter of fact, he just had six years of school back in the 1930’s (he was born in 1926), then he had to start working. But he could build pretty much anything. He built us a summer house from scratch. He even did the design and the drawings/blueprints himself. At home he had a real architect drawing table. But he also repaired all kind of things down in the basement. He built his own tools, a powerful electrical motor and some pieces of scrap metal, and he had a lathe. When my sister needed a violin, he simply built one. And yes, it sounded great!
After I moved to the United States in 1998, he got a computer, and at age 70 he started learning how to use it and to send email.

 Working on the summer house, circa 1974

 Taking a break from the hard work.

Building a violin.

But my dad was not always working. Yes, he did work a lot, both to support the family and to (litterally) put a roof over our heads. But he also had time for me and my sister.
We went fishing, sailing (he got us a small sail boat and put me and my sister in sailing classes), and worked in the vegetable patch together with mom.

 At Midsummer celebration, circa 1976.

There are so many things that make me proud of my dad, I can’t list them here. But he was a great role model for me, and I hope my son Erik one day will be able to think at me in a similar way. He was also, for a very brief time, a grandfather. He died in March 2001, but not until after he got to see and hold his first and only grandchild. Erik was born in August 2000, and he (together with my sister) visited us in early November.
I was told that he printed out the pictures I mailed him, and was showing them to all his friends. He was so proud! I wish he would have lived a few more years so he could have seen Erik starting to grow up.

 Holding his grandson Erik, Boston November 2000.

 One more of the proud grandpa.

 Funeral, April 2001.

This picture, and the two previous ones, were taken with my Nikon D90 fitted with a Tamron 18-270mm lens. No tripod was used. The pictures were taken yesterday evening around 19.30 in the Sundance Square area of Ft Worth. Click on the images to see the full versions.