Modify Header / Footer items via Lotusscript ( and API )

Friday, March 5th, 2010

Header / Footer items are of type Richtext and you cannot modify them directly using standard LotusScript. I' ve put together all the necessary code and wrapped the API calls into a class to achive the goal. The class works on Windows and Linux. Mac support is possible but I have ...

LotusScript Debugger on Linux

Wednesday, December 30th, 2009

I wanted to debug Lotusscript on my VM Linux Box. The OS is Ubuntu 9.10 and the client is Notes 8.5.1. When I switch on the debugger and step into the script, the debugger loses focus on every step, regardless if you use the mouse or F8. Anyone else having the ...

Calendar Cleanup – undocumented LS functions

Saturday, December 12th, 2009

I am researching the Calendar Cleanup action in the Lotus Notes Calendar view. The action executes a LotusScript agent that has two undocumented db calls CreateArchiveSettings and ArchiveNowByPolicy. The functions are used since the feature was introduced in Notes 7. Obviously nobody ever looked into the code as there are no Google ...

Get Logical / physical size and DAOS size with LotusScript

Monday, November 30th, 2009

The admin client shows information about logical / physical size as well as DAOS size for a database. But how to get this information via LotusScript? For the logical size you can use db.size. For the physical size there is no property in the NotesDatabase Class. But C-API to the rescue. Put ...

Get Column Totals with LotusScript

Wednesday, December 31st, 2008

Here is a quick post in addition to my recent post on how to get sums / subtotals for a given category in a view with LotusScript. Assume, you want to get the total number of solved tickets. In my sample the value in question is located in column 7 at ...

More (Yet) Undocumented Database Properties

Saturday, September 13th, 2008

Here is a list of yet undocumented values for the GetOtion / SetOption method of the NotesDatabase class. GetOption(82) / SetOption(82,true) = Enable Compress document data GetOption(81) / SetOption(81,true) = Use DAOS Use DAOS also created a new field $DAOS in the NotesIcon design note if the field is not available and update ...

Undocumented NotesDatabase.Get / SetOptions

Friday, September 12th, 2008

Today, I was looking for which value to use with the SetOption method of the Notesdatabase class, I discovered as few other undocumented values that can be used to get and set some database options programmatically using Lotus Script. 75 = Support Response Thread History 76 = Don't allow simple search And, finally ...

Export View Data (Update)

Friday, September 12th, 2008

Last month I wrote about the new "Disable View Export" feature in Notes 8.0.2. In another post I stated that it is not possible to set this option programmatically using LotusScript. Yesterday I stumbled upon an IBM Lotus Software Knowledgebase technote. This technote says that Enabling or disabling of this option can ...

Programmatically Check If Export Of View Data Is Disabled

Saturday, August 30th, 2008

In Lotus Notes /Domino 8.0.2 you can disable the export of view data by selecting this option in the application properties. To programmatically check if the export is disabled, you can use the following LotusScript. Function IsExportDisabled () As Boolean IsExportDisabled = False Dim s As New NotesSession Dim db As NotesDatabase Set db ...

Mail Rules Extended

Tuesday, May 13th, 2008

I recently posted an idea on IdeaJam to enhance the mail rules dialog on a Domino server to overcome the restriction of only use the "hard coded" conditions. There have been several attemps to enhance the dialog in the past ( Chris Linfoot for example ), but none of them ...

Is User A Member Of A (Nested) Group ?

Sunday, April 27th, 2008

Working with nested groups, it can be hard to determine if a user is member of the "base" group. The following class contains a method to do the job. IsGroupMember ( GroupName, UserName ) calls method ExplodeGroup, which fills an array with all members of the group. It also resolves nested ...

WordPress Plugin For LotusScript And Formula Syntax Highlighting

Monday, April 14th, 2008

I'm using wordpress for blogging and have wp-syntax installed for quite a while as a syntax colour code/highlighter. wp-syntax supports many languages. But it does not support Lotus Script or @Formula language out of the box. You can easily add support for these languages by adding a file to GeSHi, the ...

Programmatically Change The Design Of A Local Database

Tuesday, April 8th, 2008

From the Lotus Notes KnowledgeBase (#1280243) You want to programmatically change or update the design of a local Lotus Notes® database from a template. For your particular scenario, replication is not an option. The database is local to the client, and there is no server replica to pull the ...

Get A JSONReader And JSONWriter For FREE

Friday, February 1st, 2008

Troy Reimer of SNAPPS donates LotusScript JSONWriter and JSONReader to the community. You can download Version 1.0 of JSONReader and JSONWriter here. The database (json.nsf) contains LotusScript classes for parsing and creating JSON text. These classes are contained in five script libraries: ls.snapps.JSONArray, ls.snapps.JSONObject, ls.snapps.JSONReader, ls.snapps.JSONWriter, and ls.snapps.JSONWrapperConverters. The JSONArray and JSONObject classes ...

SnTT: @ServerAccess in LotusScript

Thursday, January 31st, 2008

You can use @ServerAccess to check if a specified user has a specified administrative access level to a server. For a list of keywords to represent the access level you want to check for take a look at the designer help either on your local client or on the ...

What Is Wrong With Year 1700?

Friday, January 25th, 2008

2008 is a leap year again. The Gregorian calendar, the current standard calendar in most of the world, adds a 29th day to February in 97 years out of every 400, a closer approximation than once every four years. This is implemented by making every year divisible by 4 a ...

Display Date Range As Bar In Notes Views

Saturday, January 12th, 2008

You can find a lot of stuff on the internet like Chris Blatnick's " Using Color Columns To Make A Gantt Chart" to display column values either as color or as picture ( you might take a look at "A Splash of Color" as well ). Today I would like to ...

Instance member…does not exist’ when enabling Out Of Office

Thursday, January 3rd, 2008

Today I had a lot of calls in our helpdesk regarding Out Of Office. Users complained that the had enabled the agent before Christmas and it worked fine but when they tried to disable the agent it does not disable. Instead the Out Of Office profile shows the following message: Even ...

Compare Two Arrays

Wednesday, December 26th, 2007

For one of my projects I needed a function to compare two arrays. The following function returns true if both array have the same elements (regardless of their position in arrays). Function ArraysAreEqual (vA As Variant, vB As Variant) As Variant Dim IsEqual As Variant ArraysAreEqual = True Forall a In vA IsEqual = False Forall ...

Mail Archivierung – Ein Praxisproblem

Thursday, October 25th, 2007

Eigentümer einer Maildatei können Zugriffe auf Mails und Kalender über "Werkzeuge - Vorgaben - Zugriff und Delegierung" selbstständig steuern. Bei der geplanten Archivierung von Mails ergeben sich daraus aber Probleme beim Zugriff auf archivierte Dokumente. Ein Archivsystem sichert neben den eigentlichen Inhalten der Mail auch die zu diesem Zeitpunkt existierende ACL. Lt. der ...