PLANET LOTUS.org (Profile: Wohill)

313 Lotus blogs updated hourly. Who will post next?

Latest 7 Posts
Comparing browser memory usage with Chrome's task manager Wed, Jan 7th 2009 25
Where to set the charset of a web application Mon, Jan 5th 2009 25
Initializing variables in Java and Lotusscript Wed, Dec 31st 2008 46
A tip on how to fit data in excel Mon, Dec 29th 2008 47
Google Chrome's resizable textarea Wed, Dec 24th 2008 32
Twitter stats for your profile as graphs and cloud Mon, Dec 22nd 2008 18
Upgrade and keep two Lotus Notes client versions on one computer Wed, Dec 17th 2008 78
Top 10
Migrating from Lotus Notes Wed, Oct 15th 2008 164
Open hidden views in the notes client Wed, Aug 20th 2008 113
Fancy icons for your website Fri, Nov 14th 2008 97
How to count and delete deletion stubs Mon, Aug 11th 2008 93
A web service consumer example Mon, Dec 15th 2008 90
Simple JavaScript for opening a (modal) window Fri, Aug 15th 2008 82
Cool widgets for your website Mon, Sep 15th 2008 82
What old notes files do I need for my new computer? Fri, Aug 8th 2008 78
Upgrade and keep two Lotus Notes client versions on one computer Wed, Dec 17th 2008 78
One thing that annoys me in Domino Designer 7 Fri, Sep 26th 2008 75

Testing a Lotus Notes Web Service provider with SoapUI
Oct 20, 2008 6:00p

Hits

Link Love

http://planetlotus.org/36dc3b

Category

Lotus Notes Domino

Keywords

domino forms ibm lotus lotusscript notes application database profile server

Author

Niklas Waller

I needed to create a simple Lotus Notes Web Service. Since this is version 7 we are talking about it is a provider. The consumer comes in version 8 although there are very good ways to mimic the behaviour.

These tutorials on creating web services in Lotus Notes by Julian Robichaux are great:
- Practical Web services in IBM Lotus Domino 7: What are Web services and why are they important?
- Practical Web services in IBM Lotus Domino 7: Writing and testing simple Web services
- Practical Web services in IBM Lotus Domino 7: Writing complex Web services

As I wrote there are good ways of creating a web service consumer even in version 7. See this article by Joachim Dagerot for more on this.

Anyway, to the core of this blog entry. I created a simple web service by first writing a lotusscript class with a couple of simple methods in it. I set the adjustments on the web service to 'RPC' as programming model and 'Doc/literal' as SOAP message format, since 'Doc/literal' was what the consumer wanted for some reason:

Class test2
Private session As NotesSession
Private db As NotesDatabase

Public Sub New ()
Set session = New NotesSession
Set db = session.CurrentDatabase
End Sub

Public Function PutAndGetModString (txt As String) As String
PutAndGetString = txt + "_mod"
End Function

Public Function GetDbName () As String
GetDbName = db.Title
End Function

Public Function GetTest () As String
Bla = "Response string"
End Function

End Class

I exported the WSDL-file by pressing the button 'Export WSDL'. In SoapUI (an extraordinary free application to test web services by the way) I created a project and imported this WSDL-file. Requests to try out are created by default. Double-click on one to open a new window and run it to send the request and receive the response. I had some initial problems that the address to connect to (specified in the wsdl-file) was set to localhost. This is easily fixed by editing the url in the request window. The address should be the web-address to the webservice, i.e. 'http://domainname/aFolder/database/webServiceName?WSDL'.

Using this the SOAP-request looks like this:

<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:DefaultNamespace">
<soapenv:Header/>
<soapenv:Body>
</soapenv:Body>
</soapenv:Envelope>

This brings the problem that calling the method GetDbName or GetTest returns the same response, i.e. from the GetDbName method. The reason for this is that the method is not defined in the SOAP-request and therefore the first one is chosen.

What I did that made it work was simply to replace 'Doc/literal' as the SOAP message format to 'RPC/encoded'. Maybe someone knows how to adjust something so that the correct WSDL-file is created from Lotus Notes when using 'Doc/literal' for this to work.

Exporting the WSDL-file with this setting makes the SOAP-request look like this instead. You can see that the method name is specificed in the body.:

See how the web service is represented in SoapUI with all the methods.

And how the request window looks like for a method.

Finally here is the code for a lotusscript class with methods to return some statistics about a database. Download the WSDL-file here or generate it yourselves if you'd like:

Class DatabaseStats
Private session As NotesSession
Private db As NotesDatabase
Private nc As NotesNoteCollection

Public Sub New ()
Set session = New NotesSession
Set db = session.CurrentDatabase'
End Sub

' Return database name
Public Function GetDbName () As String
GetDbName = db.Title
End Function

' Return server name
Public Function GetServerName () As String
GetServerName = db.Server
End Function

' Returns number of documents in the database
Public Function GetNumDocuments () As Integer
Set nc = db.CreateNoteCollection(False)
nc.SelectDocuments = True
Call nc.BuildCollection
GetNumDocuments = Cstr(nc.Count)
End Function

' Returns number of forms in the database
Public Function GetNumForms () As Integer
Set nc = db.CreateNoteCollection(False)
nc.SelectForms = True
Call nc.BuildCollection
GetNumForms = nc.Count
End Function

' Returns number of views in the database
Public Function GetNumViews () As Integer
Set nc = db.CreateNoteCollection(False)
nc.SelectViews = True
Call nc.BuildCollection
GetNumViews = nc.Count
End Function

' Returns number of agents in the database
Public Function GetNumAgents () As Integer
Set nc = db.CreateNoteCollection(False)
nc.SelectAgents = True
Call nc.BuildCollection
GetNumAgents = nc.Count
End Function

' Returns number of shared fields in the database
Public Function GetNumSharedFields () As Integer
Set nc = db.CreateNoteCollection(False)
nc.SelectSharedFields = True
Call nc.BuildCollection
GetNumSharedFields = nc.Count
End Function

' Returns number of pages in the database
Public Function GetNumPages () As Integer
Set nc = db.CreateNoteCollection(False)
nc.SelectPages = True
Call nc.BuildCollection
GetNumPages = nc.Count
End Function

' Returns number of outlines in the database
Public Function GetNumOutlines () As Integer
Set nc = db.CreateNoteCollection(False)
nc.SelectOutlines = True
Call nc.BuildCollection
GetNumOutlines = nc.Count
End Function

' Returns number of actions in the database
Public Function GetNumActions () As Integer
Set nc = db.CreateNoteCollection(False)
nc.SelectActions = True
Call nc.BuildCollection
GetNumActions = nc.Count
End Function

' Returns number of folders in the database
Public Function GetNumFolders () As Integer
Set nc = db.CreateNoteCollection(False)
nc.SelectFolders = True
Call nc.BuildCollection
GetNumFolders = nc.Count
End Function

' Returns number of script libraries in the database
Public Function GetNumScriptLibraries () As Integer
Set nc = db.CreateNoteCollection(False)
nc.SelectScriptLibraries = True
Call nc.BuildCollection
GetNumScriptLibraries = nc.Count
End Function

' Returns number of profile documents in the database
Public Function GetNumProfileDocuments () As Integer
Set nc = db.CreateNoteCollection(False)
nc.SelectProfiles = True
Call nc.BuildCollection
GetNumProfileDocuments = nc.Count
End Function

End Class

Wohill

Blog Title	Wohill - Creative design and development
Blog Description	Design focusing on everything from the smallest detail to whole concept solutions. Innovative in several fields of style and art. Drafts and sketches to drawings and fully fabricated products. Logos and company emblems containing argumentation and commentary, explaining the sophisticated feeling that meets the eye. Development focused on web development with new things to consider, tips, tricks, references, examples, tutorials, code and new stuff.
Blog URL	http://www.wohill.com
RSS Feed	http://www.wohill.com/development/feed
Validate Feed	feedvalidator.org or validator.w3.org
Feed Last Checked	Jan 09, 2009 6:53:37 PM EST. Realtime Update:
Twitter URL	http://www.twitter.com/nickwick76
Landed Here	Aug 08, 2008
Location	Stockholm, Sweden
Posts: # / 1st / Latest	77 - Jul 29, 2008 - Jan 07, 2009
Total Hits	2,944. myPL RSS Selections: 22

Wohill's Planet Lotus Keyword Cloud

admin administration agent ajax application applications archive blogger css database db2 designer development document domino facebook firefox google ibm integration interface java javascript linkedin linux lotus lotusscript macintosh microsoft mobile mysql network notes notes client office password php planet lotus planetlotus planetlotus.org profile properties richtext script library security server sql symphony template twitter workspace xml

Total: 317 Average per Post: 4.1169

Blog Posts
25	Comparing browser memory usage with Chrome's task manager Wed, Jan 7th 2009 6:58p Niklas Waller A feature in Google Chrome (Google's web browser) let's you not only see the memory usage for Google Chrome's different tabs and components but also for the other browsers that are currently running on the computer. It is called the task manager and can be started by either typing 'about:memory' in the address bar or by clicking the task manager. The task manager offers a summary view of the memory usage of the running browsers. You can see private, shared and total memory in the picture belo [read] Keywords: lotus firefox google planet lotus planetlotus planetlotus.org twitter
25	Where to set the charset of a web application Mon, Jan 5th 2009 5:55p Niklas Waller Mostly when I develop web solutions I set the charset to 'utf-8'. In some cases I need the charset 'iso-8859-1' for swedish characters. There are three places where I put the charset definition. The first is the meta tag: When using this one you have to take care of the html encoding yourself like for example the swedish characters å,ä and ö. If you're using 'iso-8859-1' you can print them as they are. The second one are sometimes used when receiving information using ajax. Then you have [read] Keywords: javascript ajax application
46	Initializing variables in Java and Lotusscript Wed, Dec 31st 2008 5:52p Niklas Waller In Java you have to initialize local variables, that is method variables or else the java file will not compile. Class variables or instance variables don't have to be initialized on the other hand. In fact it is probably seen as more good-programming to not initialize them. Here is an example of a function that takes an argument and checks if it is bigger than zero. If so, then set the local variable 'returnValue' to that value plus 5. The code below won't compile. The error message 'The local [read] Keywords: agent lotusscript script library java
47	A tip on how to fit data in excel Mon, Dec 29th 2008 6:55p Niklas Waller Sometimes you need to fit a lot of data into an excel spreadsheet. You might want to choose 7 or 8 as font size. When you start typing in information you suddenly notice that the text, that numbers the rows, are too big and gets cut off, see below. As far as I know there is no way of changing the size of the numbers and letters. If there is, then great, another way. But this is how you should do it otherwise. Keep the default size of 10 or 11 or what it is. Then zoom out, that is set the per [read] Keywords:
32	Google Chrome's resizable textarea Wed, Dec 24th 2008 6:52p Niklas Waller One thing I just realized was that Google Chrome has got a resizable textarea by default. That is you can grab it by the bottom-right corner and resize it. What happens is that the rest of the html on the page re-adjusts. However, you can not make it smaller than what you have defined it with using cols and rows. Take a look at this one and grab-and-drag! Yup, definately a textarea... Resizable in Chrome but not in Firefox or Internet Explorer Cool and handy! [read] Keywords: firefox google
18	Twitter stats for your profile as graphs and cloud Mon, Dec 22nd 2008 6:52p Niklas Waller A pretty new service on the web that's called TweetStats creates stats for your Twitter profile as several different graphs and also a cloud for your most used words. Here is an example of a graph. And the cloud for my profile. You can also look at general trends as graphs and clouds, i.e. what's currently being twittered about by all users. Cool service! Keep up the good work! [read] Keywords: profile twitter
78	Upgrade and keep two Lotus Notes client versions on one computer Wed, Dec 17th 2008 6:52p Randolph Guy If you for instance have Lotus Notes version 7 and would like to install version 8 on the side, i.e. you want to keep both installations on one computer. Then you have a good description of doing so here. According to the instructions you have to make copies and rename at some places. But you can also do it another way that takes a little bit longer time but really don't require more than one change on one installation window. So let's say you have version 7 and you want to install version 8.5. [read] Keywords: domino lotus notes notes client workspace
90	A web service consumer example Mon, Dec 15th 2008 6:51p Niklas Waller I have just for educational purposes created a simple web service consumer with Lotus Domino Designer 8.5 Beta 2. So I thought I'd share and perhaps make someone happy. For this example I found a web service on webservicex.net which was kind of funny. It is called BibleWebservice and let's you get biblic information by book, chapter and verse. The address to the WSDL-file can be found here. 1. Create a web service consumer element. Name it and point to the WSDL-file either local or the url. Th [read] Keywords: agent designer document domino lotus notes properties
14	Set Twitter status messages automatically from PHP Wed, Dec 10th 2008 6:52p Niklas Waller Since our blog here on Wohill is not a Wordpress or Blogger blog or something similar but instead our self-developed and designed one - we have had to create all these little nice to have things ourselves that otherwise would have been offered as a plugin just to install or marked as a chosen setting. I see this mainly as fun to work with though. One thing that I have missed for some time now is a way to automatically set a twitter status message whenever a blog post gets published. Since we ar [read] Keywords: blogger password php profile twitter
42	Working with transparent colors Mon, Dec 8th 2008 6:52p Niklas Waller As a web designer you might get into situations where you need to make elemens transperent so that they can be seen through each other. An example is a vertical menu that roll down over the rest of the page. It looks really nice if it is transparent so that you can still see the background for instance. A way to do this is simply to set a color for that element (div) and make it transperent to some degree. Here is an example on how to put several layers on an image with different colors on top [read] Keywords: designer css
50	Spice up your status messages Wed, Dec 3rd 2008 5:55p Niklas Waller Here's a fun way of creating a bit different status messages - just to spice it up a bit and create confusion or maybe discussion. I found it via a friend on facebook. RULES:1. Grab the book closest to you. Now. 2. Go to page 56. 3. Find the 5th sentence. 4. Write that sentence as your status. The original instructions contains two more steps but that's not applicable for all social sites and feels a bit unnecessary to me as long as everybody know the rules. Here they are anyway: 5. Copy these [read] Keywords: applications facebook linkedin network twitter
69	A nice Javascript photo gallery Mon, Dec 1st 2008 6:52p Niklas Waller A customer, who is a photographer, wanted a photo gallery for his creations. So Randolph designed it with a functionality in mind and my task was to try to make it real. This new site is not completely tested or filled with photos yet but should be working as expected. Take a look at it below or see it live. There is always a possibility of creating everything yourself, but it takes time, something that we didn't have much of in this project. So I needed an existing solution that I could mo [read] Keywords: administration javascript css php
16	Grade your Twitter profile Wed, Nov 26th 2008 6:52p Niklas Waller Now you can grade your Twitter profile and get a score of your Twitter profile power. The Twitter Grade measures the relative power of a Twitter user. It is calculated as a percentile score where it like websites is better to have followers or incoming links rather than following or having outgoing links. The score is calculated based on: - The number of followers you have - The power of this network of followers - The pace of your updates - The completeness of your profile - More... Well, I c [read] Keywords: network php profile twitter
You can rent this space for 30 days. Interested?
31	The best way to upload files and images with PHP Mon, Nov 24th 2008 6:52p Niklas Waller I have been searching for a good solution for uploading files and images from a html form to a server for some time and finally found the superior way - class.upload.php written by Colin Verot. "This PHP script uploads files and manipulates images very easily. The perfect script to generate thumbnails or create a photo gallery! It can convert, resize and work on uploaded images in many ways, add labels, watermarks and reflections and other image editing features. You can use it for files upload [read] Keywords: php server
19	Backup your data with phpMyAdmin and mySQL Fri, Nov 21st 2008 5:58p Niklas Waller If you, like us here at Wohill, run your blog or web site on an environment with PHP and MySQL, there might also be a chance that your admin interface is built with phpMyAdmin, which is a MySQL database administration tool. It is available in 55 languages with GPL License which basically means that anybody can use it, but read more about it to be sure. On the web hotel where our blog is hosted there is such an environment and I must say that it is very easy to use and also powerful. You can eas [read] Keywords: admin administration database interface mysql password php security sql
68	How to get web data into excel Wed, Nov 19th 2008 6:52p Niklas Waller There is an easy way of getting web data in excel for further managing the data, stastistical reasons or just saving as is. If you for some reason need to get live data from a domino server straight into excel or maybe you need to get data into excel from some other online source in a structured way - then Web Query Files (.iqy files) is what you need. These files can either be created manually in notepad or some other text editor or by using excel. An iqy-file contains 1-4 required lines: 1. [read] Keywords: document domino lotus richtext symphony template google integration microsoft office php properties server twitter xml
97	Fancy icons for your website Fri, Nov 14th 2008 6:51p Niklas Waller Here are a some links to different icons which could be worth browsing. They should all be free to use, but you should of course check that on the site hosting the icons first. I intend to keep this site updated and will add more links as I find them. Please add some more if you have any, in the comments, and I will put them on the list as well. - Create favicons (for the address bar, also animated) - AJAX icons/images. I.e. animated showing that something is loading. - Web application icons - [read] Keywords: ajax application archive development google php
14	A statistic distribution of browsers and OS's for Wohill Mon, Nov 10th 2008 6:52p Niklas Waller On Wohill we use Google Analytics to collect statistics for the blog. Wohill has been going live for almost a year now since the 3d of january and there are many interesting things to reflect over. We will publish more interesting visitor statistics at the end of the year. I looked at the statistics since the 3d of january until today's date for different browser and operating systems that our visitors have and it was quite interesting. Some of these I have never heard of and it was also inter [read] Keywords: firefox google linux macintosh microsoft mobile
60	Calculate attachments in size on databases or servers Wed, Nov 5th 2008 6:52p Niklas Waller The other day I needed to calculate how much space, i.e. size in Bytes, that all attachments took up in X specific Lotus Notes databases. So I googled some and found a very good solution already made by Stefan H Wissel. Using this you will get a good coverage on how many attachments there are per database and how much space it corresponds to in Bytes. Since this takes some time to run you can easily modify the script to loop through only a subset of predefined databases instead if you are on [read] Keywords: agent domino lotus notes database db2 server
32	The JavaScript confirmation function Mon, Nov 3rd 2008 6:52p Niklas Waller In Lotus Notes we have the prompt, dialog box and input box to communicate with the user and get feedback or input. To display a message to the user the Messagebox is most often used in Lotusscript. For displaying messages to users in JavaScript the alert function is something that everybody knows of that has worked with JavaScript. I have to admit that I didn't know of the very simple function to use when to get a yes or no from the user though - a confirmation. In case someone else also misse [read] Keywords: javascript lotus lotusscript notes
29	RedZee - A visual search engine Fri, Oct 31st 2008 7:52p Niklas Waller There are a zillion search engines everywhere on the Internet from regular ones to more niched. Some are more popular than others like Google, Yahoo and Altavista and some are rather new with specific ideas trying to create a new need. One of these are RedZee, which is a visual search engine. It works in the way that you can search on words in the same way as other search engines but the result are presented visual with images instead of with texts. A search on 'Wohill' provides a search result [read] Keywords: ibm google java php
32	Look at sites now and then in the Internet Archive Mon, Oct 27th 2008 7:52p Niklas Waller If you are not already familiar with the Internet Archive you should definately go there and play around for a while with the Internet Archive Playback Machine. 85 billion web sites from 1996 to a few months ago are archived so you can look at how sites have progressed in design over the years. If we take Google as an example it is not that big of a difference but still interesting. This image shows how the Google webpage looked like in 1998. It had just become a beta: And to illustrade the d [read] Keywords: ibm archive google microsoft php
32	An Ajax-based english-swedish dictionary Fri, Oct 24th 2008 6:55p Niklas Waller Nowadays whenever I need to translate any words from swedish to english or the other way around I use the site tyda.se. Tyda means 'interpret' by the way. It is a free, ajax-based dictionary which shows the possible translation(s) as you type the word. You can set it to only list swedish words, english words or both. The nice thing about the site except for the design, usability and content is that the users help building the content in a true web2.0 spirit. If you set it up to show both eng [read] Keywords: ajax web2.0
73	Testing a Lotus Notes Web Service provider with SoapUI Mon, Oct 20th 2008 6:51p Niklas Waller I needed to create a simple Lotus Notes Web Service. Since this is version 7 we are talking about it is a provider. The consumer comes in version 8 although there are very good ways to mimic the behaviour. These tutorials on creating web services in Lotus Notes by Julian Robichaux are great: - Practical Web services in IBM Lotus Domino 7: What are Web services and why are they important? - Practical Web services in IBM Lotus Domino 7: Writing and testing simple Web services - Practical Web serv [read] Keywords: domino forms ibm lotus lotusscript notes application database profile server
164	Migrating from Lotus Notes Wed, Oct 15th 2008 6:52p Niklas Waller I am currently involved in a large migration project in where my part of the work consists of defining the scope, mapping, washing and migrating the data. - Defining the scope is a work where you together with many other people in the organization talk about and define which data that should be moved to the new system. Once this is done, smaller scopes needs to be done to define which data in each database that should be moved, down to field level. We also have to define a map with any possible [read] Keywords: connections lotus notes application database email
32	Replacing the onclick event for IE or Chrome Mon, Oct 13th 2008 6:52p Niklas Waller One strange difference in my opinion between Firefox and Internet Explorer and most strange of all also a difference to Google Chrome is that the onclick-event is not recnognized. Here is a simple example just to illustrate. ACategoryWithCategoryNumberThree This works fine in Firefox, i.e. the function 'getCategories' gets called when choosing an object in the select box. This does not work for the other browsers though, the calls are not made and there are even no errors raised. The solution [read] Keywords: document javascript firefox google
29	Learning about cloud computing and Salesforce Fri, Oct 10th 2008 6:51p Niklas Waller In a project at work we are migrating a Lotus Notes based system to a cloud computing architechture called Salesforce, which is a so-called 'Platform as a Service' (PaaS) system. So I am spending quite some time now to both get a grip of the cloud computing architecture in general and on the migration project. I will shortly present the cloud computing architecture and Salesforce from my perspective in this blog post and later on the migration experiences I have gotten so far from the work befor [read] Keywords: ibm lotus notes application applications development eclipse google integration java microsoft network php properties security sql wiki
66	A limitation in Lotusscript Script Debugger Mon, Oct 6th 2008 6:52p Niklas Waller I was debugging some code the other day and I needed to look at a field value before and after it had been set for a document. But it was not possible since there seems to be a limitation of how many fields that are displayed for a document in the debugger. In this case the number of items for a document. The form that the document is based on contains 318 fields but the debugger can only list 256 items. After that it displays "..." to indicate that there is more. Ok, good to know, but I'd like [read] Keywords: document domino lotus lotusscript notes
54	Handling multiple values for checkboxes Wed, Oct 1st 2008 6:52p Niklas Waller I have a web form in which you can fill in basic information about a customer. The customer is divided into categories and subcategories, which means that the customer can be a member of several categories and several subcategories for each category. When you click on the save button an AJAX-request is sent to a backend-controller php page via the post method using dojo to save all the data. Categories and subcategories are stored in a database as a string separated by delimiters, eg. "#str1#s [read] Keywords: ajax database dojo php
28	JavaScript don't update the div occasionally on body onload Mon, Sep 29th 2008 6:52p Niklas Waller When loading a page I have a Javascript function that gets information using AJAX. The function is used in the onload-event of the body tag to be executed when the page is loaded: The getStuff function gets data from a backend controller page using AJAX and when the data is returned asynchronously a div is updated with the data. So what happens in the JavaScript function when data gets back is: document.getElementById('divId').innerHTML = response The div is just a tag in the body section: T [read] Keywords: document javascript ajax
75	One thing that annoys me in Domino Designer 7 Fri, Sep 26th 2008 6:51p Niklas Waller If I open many databases in Domino Designer they all come up as bookmarks on the left-hand side. Sometimes If they are more than up to about 4 or 5 I cant expand the ones below, i.e. on the 5th position or more. I have to move them up so that they are on the 1-4th position. This morning when I started Notes I didn't have this problem at all as I could easily expand all 7 seven bookmarks. Why does this happen? This could not be a special thing for just me since I have experienced it for as [read] Keywords: designer domino lotus notes
51	Query an SQL-database from Java Mon, Sep 22nd 2008 6:52p Niklas Waller I have done this many times with PHP and ASP and also with Lotusscript. But I haven't had the reason yet to try it with Java. It turned out to be very straight forward there as well and similar as the other languages. On my machine I have installed MySQL Community Server, the MySQL ODBC Connector and the GUI tools for the MySQL Query browser. The installation and configuration is very straight forward. When the installations and the standard configuration are done you can create a simple datab [read] Keywords: lotusscript community database java mysql odbc oracle password php server sql
61	Count all fields in a Notes database Fri, Sep 19th 2008 6:49p Niklas Waller I wanted to know how many fields there were in a Lotus Notes database. So here's a small lotuscript for this. It counts all "real" fields (i.e. not Computed for display fields) on all forms and prompts the result. It doesn't count unique fields however so if you make a copy of form A which have 10 fields 10 times the result is 100. Sub Initialize On Error Goto ErrorHandler Dim session As New NotesSession Dim ws As New NotesUIWorkspace Dim db As NotesDatabase Dim dbInfo As Variant Dim s [read] Keywords: domino forms lotus notes database
82	Cool widgets for your website Mon, Sep 15th 2008 6:57p Niklas Waller I like playing with widgets now and then. There are widgets for the web and for the desktop. You can read further on about the different meanings here. The ones that I refer to here are widgets for the web. Here is an abstract of the wikipedia article. "A web widget is a portable chunk of code that can be installed and executed within any separate HTML-based web page by an end user without requiring additional compilation. They are derived from the idea of code reuse. Other terms used to describ [read] Keywords: javascript lotus application desktop dhtml gadget ideajam ideajam.net planet lotus planetlotus planetlotus.org widget widgets wiki
25	My cell phones now and then Wed, Sep 10th 2008 9:02p Niklas Waller My first cellphone was a Motorola International 5200. The year was 1995, it was late summer and I was about to start the military service which would last for 17 months. I remember the excitement over this brick. Well it was not extremely big. Its ancestors were much bigger. Still it was very big, ugly and clumsy if you think back. But at the time it could not be better. Here are pictures of the model I found on Google images. Nowadays I actually have two, a Sony Ericsson w880i and an Apple [read] Keywords: apple applications development google iphone network wiki wireless
33	Development help for different browsers Mon, Sep 8th 2008 6:49p Niklas Waller When being a web developer there are several occassions where you need to analyse things like code, stylesheets, headers and responses (that you get from for example ajax requests) in a simple way. You could always check the source code, the JavaScript console or navigate to the css-file but sometimes the error messages are cryptical and hard to solve and then a more advance tool can come in very handy. Using the tools presented below will help you and ease your work a great deal. You can for e [read] Keywords: javascript ajax css development firefox google microsoft
25	Lady cartoon with a flowing hair-day Sun, Sep 7th 2008 6:49p Randolph Guy This time I have something from my sketch-book, where I make notes and write down what there is to do and what not. Most of all it gets filled with lots of sketches. After the meeting I usually sit down and go through my notes or mind-maps if you wish. Meetings all day long and far too long meetings by the way… you sit and wonder what kind of weather it is and what you are going to do as soon as you get out of the meeting. Finally I got out and had had a meeting where one of the ladies th [read] Keywords: notes
24	Surf’s up Sat, Sep 6th 2008 6:52p Jan "Nippe" Ka I just love it – the power of the waves pounding the cliffs! I’m pretty sure one more guy would have loved it - “The Duke” - the ancestor of modern surfing. Duke Kahanamoku was born and raised in Honolulu, Hawaii. As he was growing up by the sea it became his everything. He dropped out of school to become a “beach boy”. As a beach boy one lived by the sea and fed on what it can offer. He fixed fishing nets and surfboards among many other things for a living. W [read] Keywords: google
28	I wish I could be with you Lotusphere Fri, Sep 5th 2008 6:52p Niklas Waller I attended Lotusphere 2006 when i was working at an animal insurance company in Sweden who uses Lotus Notes. I came there alone both as a developer, administrator and a company representative (well I actually knew a few people). And was I impressed? Wow, it was really, really good and I was amazed. Cool general opening sessions, very good technical sessions all days long To be able to talk to experts/developers and people around you all over the place that have something in common, good arrang [read] Keywords: domino ibm lotus lotusphere lotusphere2009 notes planet lotus planetlotus planetlotus.org twitter
14	Cows everywhere eating grass Thu, Sep 4th 2008 6:58p Randolph Guy I have been out and about this summer. There are very many nice islands in the archipelago – some of them have beautiful meadows with lots of green grass and flowers. You can feel the scent of the flowers from far away. Cows are walking around and munching away on the grass. Nice coats they have and a very country-like feeling there is when they walk through the grass to find more to eat. Cows that are used to be free grazing like this seem to enjoy their life a lot. Sunshine, water and gr [read] Keywords:
14	List files in a directory with PHP Wed, Sep 3rd 2008 6:55p Niklas Waller If you for some reason would like to display files in a directory on the web server there is an easy way to do this. You might for example like to display all images in a directory in a select box on a web page. [read] Keywords: php server
26	Penguins are dressed in black and white Tue, Sep 2nd 2008 6:49p Randolph Guy I have drawn a penguin this time - one more bird with very special features. Lately there have been a few movies with penguins starring - “Happy feet” with lots of singing and dancing and some sweet characters getting through life. If you like surfing and surf movies - they made the movie ”Surf’s up” – about some penguins surfing and hanging loose - pretty fun little movie actually with very nicely made characters – cool postures and silly walks. Really [read] Keywords:
46	Validate email-addresses in Domino with Java Mon, Sep 1st 2008 6:52p Niklas Waller It's easy to validate an email address for a web application in JavaScript with the help of regular expressions since JavaScript follow the standards. When you need to do the same for a notes application you are either stuck with the @ValidateInternetAddress-formula or a hack to be able to use it in lotusscript (with evaluate) or by creating a VBScript RegEx object (I haven't looked into this myself but it seems to be powerful). Apart from this the regular expression functionality in lotusscri [read] Keywords: admin agent domino formula ibm javascript lotus lotusscript notes script library application email google java
31	Birds in the cartoon world Sun, Aug 31st 2008 6:49p Randolph Guy There are a lot of cartoon birds that have been made over the years. We have many famous versions of the duck for example. Everybody knows Donald Duck by Walt Disney. He made a whole bunch of cartoon characters while he was alive - even built fantasy-worlds like Disneyland and Disneyworld. When I was younger I visited Disneyland and enjoyed it tremendously. Recently I visited Disneyworld in Florida too. This time I would say that I am a bit older – but I still enjoyed it very much. It is f [read] Keywords:
25	The Wasp (Disambiguation) Sat, Aug 30th 2008 6:51p Jan "Nippe" Ka The wasp is a common insect in many places over the globe. In Sweden we have 36 different species, but globally seen there are over 3000 species. The adult wasps eat fruit and nectar but not the younger ones, they are fed with other insects caught and chewed by the adults. These are peaceful insects - if you don’t disturb them. If you mess with them they can be a bit cranky and might just bite you. In Sweden they cause the greatest amount of deaths of all living things - if you don’t [read] Keywords: bug
40	Do you remember this awesome movie clip? Fri, Aug 29th 2008 6:51p Wohill Do you remember the movie "Deliverance" from 1972, in swedish known as "Den sista färden". A good movie and it also had its scary moments as I recall. Four men played by Burt Reynolds, Jon Voight, Ned Beatty and Ronny Cox are going out into the wilderness in a canoe and many things will happen. The best and most outstanding clip in this film that I can think of instantly when someone mentions it, is the one with the banjo duel. Do you remember? If you are a music lover you probably do and you [read] Keywords: application
16	Birds have always fascinated mankind Thu, Aug 28th 2008 6:49p Wohill I think that I was only a few months old when my father took me flying. He was a member, and still is, of a flying-club that had a few aeroplanes. The model my father flew was the Piper cub. The one we flew was originally red and white and a two-seater plane. Through the years he has brought me along to fly in it may times. It’s an amazing experience. Flying in bigger planes is nice too but these small two-seater ones are a bit special. You really get the flying feeling. The wind is whizzi [read] Keywords:
34	Thoughts on Twitter Wed, Aug 27th 2008 6:49p Wohill Twitter has become a really big thing among Internet users and it also seems to have become a routine for many people to use every day at work and/or at home. I myself is not a heavy user but I try to post a status message at least once a day. I like to read the feed/timeline of what the people I follow do and I also find it both useful and amusing to socialize in this specific way, The way I see it Twitter is more common in the US but it has also come to grow in Sweden and the rest of Europe [read] Keywords: blogging iphone macintosh twitter widgets wiki
12	Dolphins at Costa Azul Tue, Aug 26th 2008 6:51p Wohill A few years ago I went to Mexico to Costa Azul. It was time for a vacation and some surfing. I was there with my family, and of course, my surfing Uncle. He surfs almost every day and is pretty good too. So he had recommended this wonderful surf-spot that was close to where we were going to stay. My cousin had booked a super house with all that and then some. My Uncle and I were out waiting to catch some waves. You know – sitting, waiting, dangling your legs and enjoying every second. I [read] Keywords:
19	Specify error documents with htaccess Mon, Aug 25th 2008 6:49p Wohill If you are using an Apache server for your site you can easily specify error documents to display depending on the error code. Here are some common ones and how you can write the lines in the .htaccess file: # Bad request ErrorDocument 400 /eDocs/400.php # Unauthorized ErrorDocument 401 /eDocs/401.php # Forbidden ErrorDocument 403 /eDocs/403.php # File not found ErrorDocument 404 /eDocs/404.php # Internal server error ErrorDocument 500 /eDocs/500.php When someone for example tries to type i [read] Keywords: document php server
45	Sweden, Switzerland or maybe both Sun, Aug 24th 2008 6:49p Wohill There are lots of different fantastic parts of the world - many wonderful places to enjoy, travel to or live in. Everybody, of course, doesn’t get the chance or have the possibility to travel around to see the world. Sometimes you read about something or see something that you like on television or the net - places that you would love to travel to. I myself have lots of places that I would love to travel to. Some of them are places I have already been to - that doesn’t make them les [read] Keywords: wiki
33	Killer Slug (Arion lusitanicus) Sat, Aug 23rd 2008 6:48p Wohill The Spanish slug is known as the killer slug. The name comes from all the damage they make in our gardens. They also eat other weaker and dead snails. This snail was originally seen in Spain and Portugal but is now common in other parts of the world and known for making trouble. By hitchhiking on plants, soil and garden waste they have spread themselves to new places. In Sweden we have other slugs like the cropland slug that looks just like the killer slug but doesn’t do any harm to the en [read] Keywords:
24	Now everybody want their own socal network Fri, Aug 22nd 2008 6:48p Wohill Barack Obama (the president candidate of the democrates of US) has with some help of Chris Hughes (one of the Facebook founders) built his own social network called my.barackobama.com. Besides of this Mr. Obama is registered on nearly every social network and web 2.0 site that is something today. You will find the complete list if you register. I follow him on Twitter by the way. This shows on a political person that is not only present in the "here and now" but also someone who wants to meet an [read] Keywords: facebook network twitter web 2.0
25	Shadows create mystical shapes Thu, Aug 21st 2008 6:48p Wohill Shadows have lots of different ways in which they can appear. You can have tall or short shadows or even wide shadows. They can follow you around or they can merge into other shadows and make really neat patterns. That might be where I get some of my inspiration for my pattern-designs. Shadows can be fun or maybe even be used in horror-movies as frightening - everything or anything to thrill the audience. So this design is strongest in black and with tone – so one clearly can see the sha [read] Keywords:
113	Open hidden views in the notes client Wed, Aug 20th 2008 6:48p Wohill A small trick that maybe not everyone know, especially not ordinary users, is that there are ways to open hidden views in the notes client without having to bribe the developer or gain access to Domino designer. If you don't have a frameset with an outline or navigator, the views are listed in the left frame when opening a database - only visible views though. To list hidden views press Ctrl-Shift when double-clicking the database on the workspace or when clicking Open in the open database dial [read] Keywords: designer domino formula lotus notes notes client database workspace
42	The wave is a powerful symbol Tue, Aug 19th 2008 6:51p Wohill Looking out over the horizon – a blue sky, waves roaring, echoing sounds of waves pounding on the beach - beautiful shapes – water spraying – colours flowing… there’s lots to see and take in. One can stand for hours watching the powerful ocean. I have been fortunate to see lots of different corners of the world - but somehow I enjoy coming back to the sea. Maybe it’s nature’s force that thrills the mind. It could even be hiking in the Rockies or sailing [read] Keywords:
42	JavaScript validation for a website address Mon, Aug 18th 2008 6:51p Wohill Here's a script that we are using to validate if an url has a proper format before submitting a form. In this function an empty url counts as valid, i.e. it is not mandatory. Someone else has written the script (don't know who) and I have made only small changes to it. Works ok for it's purpose though. You call this function from somewhere and if it returns true it is a valid url. function isURL(urlStr) { if (urlStr.indexOf(" ") != -1) { alert("Spaces are not allowed in a URL"); return fals [read] Keywords: javascript
34	Ladies’ shoes – designed in white Sun, Aug 17th 2008 6:48p Wohill Shoes for ladies exist in thousands of shapes and looks all over the world. I felt that it was time to design a look that is a bit more extraordinary than the clean or sleek look that they many times have. I think that a clean look many times is the way to go. But if you want the shoe to stand out and get noticed - if you might get dressed in a nice plain one-colour dress – this may be the shoe you are looking for – a touch of “art nouveau” in the patterns on the heel and [read] Keywords:
17	Bracken (Pteridium) Sat, Aug 16th 2008 6:52p Wohill This is one of the oldest land living plants on earth. By estimate they started their development over 400 million years ago. Back then, they were much larger and could make large forests. Their estimated height could be about 40 meters. Evolution through time has made the plant smaller but it is still one of the most common plants seen globally. Today, there are about 10.000 different species of the plant spread practically all over the globe. There are just the artic pools and the desserts tha [read] Keywords: development leak
82	Simple JavaScript for opening a (modal) window Fri, Aug 15th 2008 6:51p Wohill When I wrote this simple script I wanted to use the modal window functionality for all browsers. When a modal window opens the focus is on it and it isn't possible to work with the calling page until you close the modal window. I couldn't find a way to accomplish this in Firefox så therefore the window opens up as a modal window in IE and as a regular window in FF. /* Function for displaying a popup (modal) window */ function openWindow(url) { // If Internet explorer if (window.showModalDia [read] Keywords: javascript firefox microsoft
26	Elliptical patterns made by a psychedelic shape Thu, Aug 14th 2008 6:52p Wohill Patterns are fascinating to look at – so are organic and different elliptical shapes. The elliptical shape is easy for the eye to look at and has a nice and flow-some feeling. I first made a shape with a kind of psychedelic look. It’s a mix between a bland and some kind of being - a Pokemon kind of character - or at least a cartoon look-alike. You might see the fish-fins at the bottom of the figure or they could just as well be feet. I have used ellipses to build up the pattern. They [read] Keywords:
64	Sort and display fields for a form Wed, Aug 13th 2008 6:51p Wohill At the moment I am looking over a large Notes application and therefore I need to know some statistics about the databases and the design elements in them. Here is a script for displaying the field names on a form and the number of fields. The names of the fields comes in a non-alpabetical order. Assume we have a form 'showFields' with two fields 'numFields' and fieldNames''. Both fields are text fields and field 'fieldNames' are set to "Allow multiple values". Multi-value options on tab 3 of t [read] Keywords: agent domino ldd lotus notes script library application database properties
40	Drink a lot of milk Tue, Aug 12th 2008 6:52p Wohill When I grew up there always was a lot of milk served to breakfast, lunch and dinner. Or even at tea-time. I remember staying with my grandparents and the milk-man came by and left a couple of bottles on the door-step. The milk came in glass bottles and had a cap made of tinfoil. The top layer of the milk was almost like cream. My grandfather said: “Let the boy drink all of the milk – it will make him strong”. That and some ginger snaps -. I can still remember those days like ye [read] Keywords: wiki
93	How to count and delete deletion stubs Mon, Aug 11th 2008 7:52p Wohill Christophe Windelen wrote a blog entry a couple of years ago with a solution on how to delete deletion stubs for a Lotus Notes database. Take a look at his code to accomplish that, very nice! I have modified it just a little bit to be able to first choose which database to work on and then to choose if you only want to count or if you want to count and delete them (Options):Option Public Const wAPIModule = "NNOTES" ' Windows/32 (Declarations):Declare Private Sub IDDestroyTable Lib wAPIModule A [read] Keywords: domino lotus notes database server
20	Tiger-head in flames Sun, Aug 10th 2008 7:51p Wohill There are several different kinds of Tigers: Bengal, Indochinese, Malayan, Sumatran, Siberian and the South China Tiger. They all have special features and looks. The things they have in common are their stripes. I have used the stripes in this design too - just so one gets the feeling of the Tiger’s characteristics. The flames round about are also based on the Tiger-stripes. They also resemble Asian dragon designs that usually have clouds and flames surrounding the different beasts and an [read] Keywords:
26	Dead Oak Tree (Mortuus Quercus robur) Sat, Aug 9th 2008 6:54p Wohill This Sunday I will present my tenth picture and today I will show a more artistic one. The oak is a powerful tree in many ways: the tree can be over 1000 years old which makes the wood strong and a perfect building material. Oak is often used as a material for exclusive furniture and wooden floors, becoming a dark brown colour and its strength is excellent. The oak often grows big and can take remarkable shapes. The size of an old oak can be as big as 10 meters in diameter and over 30 meters hig [read] Keywords:
78	What old notes files do I need for my new computer? Fri, Aug 8th 2008 7:52p Wohill Now and then it's time for a new computer and when that time comes it's also time to install new programs. If you are an employée of a larger company these installations are most likely done for you but nevertheless you might still have to take care of some of your personal stuff. Your local notes stuff could be stored on disk and in that case it shouldn't be a problem but many times these local files are stored locally on your computer and it this case you have to make backups if you don't w [read] Keywords: admin document domino lotus notes roaming desktop server workspace
6	Tiger head as a tattoo Thu, Aug 7th 2008 6:54p Wohill A tiger , or in this case, a tiger’s head is a symbol of strength. Showing the Tiger’s stripes gives an extra feeling of power. I think it is clear that it is a tiger, even though one doesn’t use the colour orange to enhance the feeling of the design really being a tiger. Now one should remember there are actually tigers existing out there that are white and black. The red pupils or dots I have added in the eyes give the tiger a much stronger look. It is looking at you as a v [read] Keywords: wiki
6	Get number of different design elements in a Lotus Notes database Wed, Aug 6th 2008 6:00p Wohill When looking at performance for a notes application or just doing some inventory check it can be useful to get the number of different design elements for a lotus notes database. Here is an example script which can be run as an agent. When starting it a prompt displays with the database dialogue. You choose a database at some server and when clicking ok, the number of design elements are calculated and presented to the user in a message box. Sub Initialize Dim session As NotesSession Dim ws A [read] Keywords: agent domino forms lotus notes application database properties server
3	A lot of cool fish out there Tue, Aug 5th 2008 6:01p Wohill The Hot Tuna inspired fish I did before needed a friend or at least one more ugly fish in the sea. This could be great for a cool t-shirt or a pair of surf-trunks or maybe even a surf-logotype. The yellow and black stripes are meant to look a bit like tiger-stripes so as to give the fish a bit more of an aggressive feeling. The purple eye is to complement the yellow. In the future I might design a t-shirt and some surf-gear that can have these different ugly or cool fish on them. I have to [read] Keywords: community
5	Make highlighted word(s) in a textarea as propercase on right mouse click Mon, Aug 4th 2008 6:05p Wohill We received a comment lately from Dave asking for a specific scenario with the propercase function. The question was: "Was wondering if it would be possible to modify the code so that one could highlight a word in a document, etc, and invoke the code with a right mouse click?" We start by creating the scenario that we have a textarea in which you can type in text, highlight one or several words and then the propercase function will act upon these on a right mouse-button click. First we need a [read] Keywords: document javascript microsoft
4	Surfing in cool clothes from Hot Tuna Sun, Aug 3rd 2008 6:02p Wohill Back in the days – when we were a few years younger and had almost only one thing on our minds – surfing – we were catching waves when we were abroad or most of all we were all waiting for wind and talking about the last surf-session or the latest progress of the surf-team. Windsurfing was one of the main things we did in the summer vacation. Standing on the jetty looking over towards our home-spot “Paradise”. That’s what we called it anyway. It was a name tha [read] Keywords: wiki
4	The Maple Leaf Sat, Aug 2nd 2008 6:00p Wohill Welcome to this Sunday’s photo presentation. Today I will present another strong symbol - the Maple Leaf. As I mentioned before, plants and animals very often stand as symbols for different brands. The characteristic leaf of the Maple tree is, as you know, the national symbol of Canada. The symbol started seeing the daylight as early as in the beginning of the eighteenth century. The symbol became stronger and stronger and is today incorporated into their currency and their flag. In area t [read] Keywords:
10	Get selected document from embedded view Fri, Aug 1st 2008 6:00p Wohill Let's say that you for some reason have a form with an embedded view that lists a bunch of documents. You would like to mark one of the documents in the embedded view and get a grip of this document and do something with it. Sounds easy but could be a bit tricky! This is how I have solved it (with some help form the IBM developerWorks forums). Step 1In the view that is embedded in the form, add the following formula code to "Target Frame (single click)": @SetEnvironment( "eViewSelection"; @Te [read] Keywords: document domino formula ibm lotus lotusscript notes community </