TexasSwede
texasswede@gmail.com
  • About this blog
  • My Website
  • My Resume
  • XML Export Tool
  • Photos

Category Archives: Programming

Code – Get date range as years, months and days

Posted on July 4, 2015 by Karl-Henry Martinsson Posted in IBM/Lotus, Lotusscript, Programming 1 Comment

There is a question in the IBM DeveloperWorks forum for Notes/Domino 8 about how to calculate the number of years, months and days between two dates. Then the poster wanted to calculate the sum of two such date ranges and return that as years, months and days as well.

Since the lack of formatting in the forum makes it hard to read the code, I decided to simply post it here on my blog. As always, there are several ways to write the code. One could for example use Mod (a very under-used function that many developers don’t even know about) to help calculate the number of years, months and days.

I also include a function I use to calculate the number of business days between two dates. This could be used to calculate how long a ticket has been open in a help desk system, where you usually don’t want to include Saturday and Sunday in the count.
Simply change diffOne = Days(startDate,endDate) to diffOne = BusinessDays(startDate,endDate).

Enjoy!

Option Public
Option Declare

Type Components
	yearCount As Integer
	monthCount As Integer
	dayCount As Integer	
End Type

Sub Initialize
	'*** Declare variable for componentized date 
	Dim compOne As Components
	Dim compTwo As Components
	Dim compSum As Components
	'*** Declare variables for day difference count
	Dim diffOne As Integer
	Dim diffTwo As Integer 
	'*** Declare start and end date variables
	Dim startDate As String
	Dim endDate As String
	
	'*** First date range
	startDate = "01/01/2011"
	endDate = "03/02/2013"
	diffOne = Days(startDate,endDate)
	Call DayCountToComponents(diffOne, compOne)
	MsgBox compOne.yearCount & " years " & _
	compOne.monthCount & " months " & compOne.dayCount & " days"
	
	'*** Second date range	
	startDate = "04/03/2012"
	endDate = "08/17/2015"
	diffTwo = Days(startDate,endDate)
	Call DayCountToComponents(diffTwo, compTwo)
	MsgBox compTwo.yearCount & " years " & _
	compTwo.monthCount & " months " & compTwo.dayCount & " days"
	
	'*** Sum of first and second date range
	Call DayCountToComponents(diffOne + diffTwo, compSum)
	MsgBox compSum.yearCount & " years " & _
	compSum.monthCount & " months " & compSum.dayCount & " days"
End Sub


%REM
	Function DayCountToComponents
	Description: Convert day count to years, month and days
%END REM
Function DayCountToComponents(dayCount As Integer,components As Components) As Boolean
	Dim daysLeft As Integer
	On Error GoTo errHandler
	components.yearCount = Int(dayCount/365)
	daysLeft = dayCount - components.yearCount * 365
	components.monthCount = Int(daysLeft/30)
	daysLeft = dayCount - (components.yearCount * 365) - (components.monthCount * 30) 
	components.dayCount = daysLeft
	'*** Return
	DayCountToComponents = True
exitFunction:
	Exit Function
errHandler:
	DayCountToComponents = True
	Resume exitFunction	
End Function

%REM
	Function Days
	Description: Get the number of days between two dates
%END REM
Function Days(startDate As Variant,endDate As Variant) As Integer
	Days = Int(CDbl(CDat(endDate))-CDbl(CDat(startDate)))
End Function

%REM
	Function BusinessDays
	Description: Get the number of business days (Monday-Friday) between two dates
%END REM
Function BusinessDays(startDate As Variant,endDate As Variant) As Integer
	Dim startDT As NotesDateTime
	Dim endDT As NotesDateTime
	Dim cnt As Integer 
	On Error GoTo errHandler
	Set startDT = New NotesDateTime(startDate)
	Set endDT = New NotesDateTime(endDate)
	cnt = 0
	Do Until CDbl(startDT.Lslocaltime) > CDbl(endDT.Lslocaltime)
		If Weekday(startDT.Lslocaltime)<7 Then
			If Weekday(startDT.Lslocaltime)>1 Then
				cnt = cnt + 1
			End If	
		End If
		Call startDT.Adjustday(1, True)  
	Loop 
	BusinessDays = cnt
exitFunction:
	Exit Function
errHandler:
	BusinessDays = 0
	Resume exitFunction	
End Function

 

Code – Read from and Write to Windows Registry in Lotusscript

Posted on June 23, 2015 by Karl-Henry Martinsson Posted in Lotusscript, Notes/Domino, Programming 3 Comments

A question was posted in the IBM DeveloperWorks forum for Notes/Domino 8 about the possibility to detect from within Notes if a computer is equipped with a touch screen. The answer was that you have to check if a specific DLL is installed, which is done though the registry.

The original posted then asked how to do that in Lotusscript, so I deceded to simply post some code I am using. I did not write this code, and I don’t know who originally did. I think I may have taken some VB code and simply adapted it for Lotusscript. I plan to rewrite this a s a class when I have some time. In the mean time, here is the code.

 

Option Public
Option Declare

Dim REG_NONE As Long 
Dim REG_SZ As Long 
Dim REG_EXPAND_SZ As Long
Dim REG_BINARY As Long 
Dim REG_DWORD As Long 
Dim REG_DWORD_LITTLE_ENDIAN As Long
Dim REG_DWORD_BIG_ENDIAN As Long
Dim REG_LINK As Long
Dim REG_MULTI_SZ As Long
Dim REG_RESOURCE_LIST As Long
Dim REG_FULL_RESOURCE_DESCRIPTOR As Long

Declare Function RegCloseKey Lib "advapi32.dll" (Byval hKey As Long) As Long

Declare Function RegCreateKeyEx Lib "advapi32.dll" Alias "RegCreateKeyExA" (Byval hKey As Long, _
Byval lpSubKey As String, Byval Reserved As Long, Byval lpClass As String, _
Byval dwOptions As Long, Byval samDesired As Long, Byval lpSecurityAttributes As Long, _
phkResult As Long, lpdwDisposition As Long) As Long

Declare Function RegOpenKeyEx Lib "advapi32.dll" Alias "RegOpenKeyExA" (Byval hKey As Long, _
Byval lpSubKey As String, Byval ulOptions As Long, Byval samDesired As Long, _
phkResult As Long) As Long

Declare Function RegSetValueExString Lib "advapi32.dll" Alias "RegSetValueExA" (Byval hKey As Long, _
Byval lpValueName As String, Byval Reserved As Long, Byval dwType As Long, Byval lpValue As String, _
 Byval cbData As Long) As Long

Declare Function RegSetValueExLong Lib "advapi32.dll" Alias "RegSetValueExA" (Byval hKey As Long, _
Byval lpValueName As String, Byval Reserved As Long, Byval dwType As Long, lpValue As Long, _
Byval cbData As Long) As Long 

Declare Function RegQueryValueExString Lib "advapi32.dll" Alias "RegQueryValueExA" _
(Byval hKey As Long, Byval lpValueName As String, Byval lpReserved As Long, lpType As Long, _
Byval lpData As String, lpcbData As Long) As Long

Declare Function RegQueryValueExLong Lib "advapi32.dll" Alias "RegQueryValueExA" _
(Byval hKey As Long, Byval lpValueName As String, Byval lpReserved As Long, lpType As Long, _
lpData As Long, lpcbData As Long) As Long

Declare Function RegQueryValueExNULL Lib "advapi32.dll" Alias "RegQueryValueExA" _
(Byval hKey As Long, Byval lpValueName As String, Byval lpReserved As Long, lpType As Long, _
Byval lpData As Long, lpcbData As Long) As Long

' --- Registry key values
Const HKEY_CLASSES_ROOT = &H80000000
Const HKEY_CURRENT_USER = &H80000001
Const HKEY_LOCAL_MACHINE = &H80000002
Const HKEY_USERS = &H80000003
Const HKEY_CURRENT_CONFIG = &H80000005

' --- Registry return values
Const ERROR_NONE = 0
Const ERROR_BADDB = 1
Const ERROR_BADKEY = 2
Const ERROR_CANTOPEN = 3
Const ERROR_CANTREAD = 4
Const ERROR_CANTWRITE = 5
Const ERROR_OUTOFMEMORY = 6
Const ERROR_INVALID_PARAMETER = 7
Const ERROR_ACCESS_DENIED = 8
Const ERROR_INVALID_PARAMETERS = 87
Const ERROR_NO_MORE_ITEMS = 259

' --- Registry access key
Const KEY_ALL_ACCESS = &H3F
Const REG_OPTION_NON_VOLATILE = 0


Sub Initialize
	REG_NONE = 0
	REG_SZ  = 1
	REG_EXPAND_SZ = 2
	REG_BINARY = 3
	REG_DWORD = 4
	REG_DWORD_LITTLE_ENDIAN = 4
	REG_DWORD_BIG_ENDIAN = 5
	REG_LINK = 6
	REG_MULTI_SZ = 7
	REG_RESOURCE_LIST = 8
	REG_FULL_RESOURCE_DESCRIPTOR = 9
End Sub


Function SetValueEx(Byval lngHKey As Long, strValueName As String, lngType As Long, varValue As Variant) As Long
	Dim lngValue As Long
	Dim strValue As String
	
	Select Case lngType
	Case REG_SZ
		strValue = varValue & Chr(0)
		SetValueEx = RegSetValueExString(lngHKey, _
		strValueName, _
		0&, _
		lngType, _
		strValue, _
		Len(strValue))
	Case REG_DWORD
		lngValue = varValue
		SetValueEx = RegSetValueExLong(lngHKey, _
		strValueName, _
		0&, _
		lngType, _
		lngValue, _
		4)
	End Select
End Function


Sub RegistryCreateKey(dblHiveID As Double, strBaseKey As String, strKey As String, strData As String)
	Dim lngResult As Long
	Dim lngDisplay As Long
	Dim intReturn As Integer
	
	lngResult = 0
	lngDisplay = 0
	intReturn = RegCreateKeyEx(Byval dblHiveID, _
	Byval strBaseKey, _
	Byval 0&, _
	Byval "REG_SZ", _
	Byval 0&, _
	Byval KEY_ALL_ACCESS, _
	Byval 0&, _
	lngResult, _
	lngDisplay)
	intReturn = RegSetValueExString(Byval lngResult, _
	Byval strKey, _
	Byval 0&, _
	Byval 1&, _
	Byval strData, _
	Byval Len(strData))
End Sub 


Function RegistryGetValue(dblHiveID As Double, strKeyName As String, strValueName As String, _
strDefaultValue As Variant) As Variant
	Dim lngReturn As Long    ' result of the API functions
	Dim lngHKey As Long      ' handle of opened key
	Dim varValue As Variant  ' setting of queried value
	
	On Error Goto RegistryGetValueError
	lngReturn = RegOpenKeyEx(dblHiveID, strKeyName, 0, _
	KEY_ALL_ACCESS, lngHKey)
	lngReturn = RegistryQueryValueEx(lngHKey, strValueName, varValue)
	RegCloseKey (lngHKey)
	If (varValue = "") Then
		RegistryGetValue = strDefaultValue
	Else
		RegistryGetValue = varValue
	End If
	Exit Function
RegistryGetValueError:
	RegistryGetValue = strDefaultValue
End Function


Function RegistryQueryValueEx(Byval lngHKey As Long, Byval strValueName As String, _
varValue As Variant) As Long
	Dim lngDataPntr As Long
	Dim lngReturn As Long
	Dim lngType As Long
	Dim lngValue As Long
	Dim strValue As String
	
	On Error Goto RegistryQueryValueExError
    ' Determine the size and type of data to be read
	lngReturn = RegQueryValueExNULL(lngHKey, strValueName, 0&, _
	lngType, 0&, lngDataPntr)
	If (lngReturn <> ERROR_NONE) Then
		Error 5
	End If
	Select Case lngType
        ' For strings
		Case REG_SZ:
			strValue = String(lngDataPntr, 0)
			lngReturn = RegQueryValueExString(lngHKey, _
			strValueName, 0&, _
			lngType, strValue, lngDataPntr)
			If (lngReturn = ERROR_NONE) Then
				varValue = Trim(Left(strValue, lngDataPntr - 1))
			Else
				varValue = FullTrim("")		'returns empty
			End If
   	     ' For DWORDS
		Case REG_DWORD:
			lngReturn = RegQueryValueExLong(lngHKey, _
			strValueName, 0&, _
			lngType, lngValue, lngDataPntr)
			If (lngReturn = ERROR_NONE) Then
				varValue = lngValue
			End If
		Case Else
            ' all other data types not supported
			lngReturn = -1
	End Select
RegistryQueryValueExExit:
	RegistryQueryValueEx = lngReturn
	Exit Function
RegistryQueryValueExError:
	Resume RegistryQueryValueExExit
End Function

Free Code – Class to read URL name-value pairs

Posted on November 20, 2014 by Karl-Henry Martinsson Posted in ConnectED, Lotusscript, MWLUG, Notes/Domino, Web Development 4 Comments

Here is another little code snippet I want to share. I use it all the time in my Lotusscript-based Domino web agents, and I figured that other could benefit from it as well. It is just an easy way to check for and read the name-value pairs (arguments) passed from the browser to the web server by HTTP GET or POST calls.

Put the code below in a script library, I call it Class.URL:

%REM
	Library Class.URL
	Created Oct 9, 2014 by Karl-Henry Martinsson
	Description: Lotusscript class to handle incoming URL (GET/POST).
%END REM
Option Public
Option Declare

%REM
	Class URLData
	Description: Class to handle URL data passed to web agent
%END REM
Class URLData
	p_urldata List As String
	
	%REM
		Sub New()
		Description: Create new instance of URL object from NotesDocument 
	%END REM
	Public Sub New()
		Dim session As New NotesSession
		Dim webform As NotesDocument
		Dim tmp As String
		Dim tmparr As Variant  
		Dim tmparg As Variant
		Dim i As Integer
		
		'*** Get document context (in-memory NotesDocument)
		Set webform = session.DocumentContext
		'*** Get HTTP GET argument(s) after ?OpenAgent
		tmp = FullTrim(StrRight(webform.GetItemValue("Query_String")(0),"&"))
		If tmp = "" Then
			'*** Get HTTP POST argument(s) after ?OpenAgent
			tmp = FullTrim(StrRight(webform.GetItemValue("Request_Content")(0),"&"))	
		End If
		'*** Separate name-value pairs from each other into array
		tmparr = Split(tmp,"&")		 
		'*** Loop through array, split each name-value/argument 
		For i = LBound(tmparr) To UBound(tmparr)
			tmparg = Split(tmparr(i),"=")
			p_urldata(LCase(tmparg(0))) = Decode(tmparg(1))
		Next
	End Sub
	
	%REM
		Function GetValue
		Description: Get value for specified argument.
		Returns a string containing the value.
	%END REM
	Public Function GetValue(argname As String) As String
		If IsElement(p_urldata(LCase(argname))) Then
			GetValue = p_urldata(LCase(argname))
		Else		
			GetValue = ""	
		End If
	End Function
	
	%REM
		Function IsValue
		Description: Check if specified argument was passed in URL or not.
		Returns boolean value (True or False).
	%END REM
	Public Function IsValue(argname As String) As Boolean
		If IsElement(p_urldata(LCase(argname))) Then
			IsValue = True
		Else		
			IsValue = False	
		End If
	End Function
	
	
	'*** Private function for this class
	'*** There is no good/complete URL decode function in Lotusscript
	Private Function Decode(txt As String) As String
		Dim tmp As Variant 
		Dim tmptxt As String
		tmptxt = Replace(txt,"+"," ")
		tmp = Evaluate(|@URLDecode("Domino";"| & tmptxt & |")|)
		Decode = tmp(0)
	End Function
	
End Class

It is now very easy to use the class to check what values are passed to the agent. Below is a sample agent:

Option Public
Option Declare
Use "Class.URL"

Sub Initialize
    Dim url As URLData

    '*** Create new URLData object
    Set url = New URLData()

    '*** MIME Header to tell browser what kind of data we will return
    Print "content-type: text/html"

    '*** Check reqired values for this agent
    If url.IsValue("name")=False Then
        Print "Missing argument 'name'."
        Exit Sub
    End If

    '*** Process name argument
    If url.GetValue("name")="" Then
        Print "'Name' is empty."
    Else
        Print "Hello, " + url.GetValue("name") + "!"
    End If

End Sub

It is that easy.

If my proposal for a session at ConnectED is accepted, you will about how to use jQuery and Bootstrap to retrieve data in .NSF databases through Lotusscript agents, and I will be using this class in my demos. So see this as a preview.
If the session doesn’t get selected by IBM, I plan to record it and post it somewhere online later.

The premise of the session is that you have data in a Domino database, but for some reason you can’t use XPages. Your company may be on an older version of Notes/Domino with no plans/budget to upgrade, the web developer don’t know XPage and have no time to learn it, or the data will be retreived from some other Web based system, perhaps WordPress.

Update: The session was not accepted at ConnectED, but I will present it at WMLUG in Atlanta on August 19, 2015.

#ThrowbackThursday – Worst Practices at Connect 2013

Posted on September 18, 2014 by Karl-Henry Martinsson Posted in Administration, Connect, IBM/Lotus, Lotusphere, Lotusscript, Notes/Domino, Programming Leave a comment

Paul Mooney and Bill Buchan returns with a brand new Worst Practices at IBM Connect 2013.

This session alone is almost worth the cost to attend Lotusphere/Connect/ConnectED.

There is a slight skip towards the end, when I had to switch batteries. Otherwise you have the whole session, including the warm-up performance.

#ThrowbackThursday – JMP 101 from Lotusphere 2012

Posted on September 4, 2014 by Karl-Henry Martinsson Posted in Connect, ConnectED, IBM/Lotus, Lotusphere, XPages Leave a comment


I recorded this video of the session JMP101 IBM Lotus Domino XPages JumpStart at Lotusphere 2012 in Orlando. The conference, later renamed IBM Connect and now renamed again to IBM ConnectED, will take place again in January 2015. Perhaps this video will get you inspired to do some XPages development, or you can show it to your boss as a good example of what you can learn at ConnectED.

Hope to see you in Orlando in January!

The joy of programming

Posted on August 6, 2014 by Karl-Henry Martinsson Posted in Life, Personal, Programming Leave a comment

I have been programming since the beginning of 1983. I started over 30 years ago with Basic, then went to Pascal after about 3 years. I then in fairly quick succession went to C, Visual Basic, VBA and then a few years later (in 1996) to Lotusscript. Along the way I also picked up Javascript, as well as web design with HTML and CSS (even if it may be questionable to call the latter two “programming languages”).

During June and most of July this year, I did not do much/any programming, due to me recovering from surgery. At work I also do more administration work and research, leaving less time for actual programming and even less time to pick up new skills like XPages.  Coming back and starting writing code again made me realize how much I enjoy programming.

I miss writing code and solving problems by writing a program that help our users (or me) accomplish something faster and better than before. I enjoy posting code here on my blog, as well as on Stack Overflow and in the developerWorks forums. If I can help someone, like so many have been helping me in the past, at the same time as I get to write code and have fun, that is a double whammy.

But even writing code for myself, just for fun and to learn new things is enjoyable to me even after all these years. In a way it is me against the computer. I get to make the machine do what I want by taking a problem or process and breaking it down in smaller and smaller pieces until I have a working solution. Every time I come up with a smarter or more clever way to do something, I get excited and happy.

I love learning new things, and in the field of programming (as in the rest of IT), learning never ends. Hopefully I soon will have time to sit down and view some courses at Lynda.com as well as watch some of David Leedy’s excellent Notes-in-9 tutorials, to improve my skills and add more/new tools to my toolbox. And to have fun.

Happy coding!

Code snippet – DateClass

Posted on July 21, 2014 by Karl-Henry Martinsson Posted in Lotusscript, Notes/Domino Leave a comment

Here is a small Lotusscript class I wrote some years ago. I use it in a number of other classes where I need to use date functionality of different kind. For example, I have a class that communicates with a FoxPro database, using a COM object. Some of the methods in that class uses XML while other just pass a few arguments to the COM object. The COM object expects the date values to be in ISO 8601 format (yyyy-mm-dd). In addition, sometimes the date comes from a field in a Notes document where they usually are stored in US format (mm/dd/yyyy), sometimes it is the current date.

So I decided to create a this class to just make the code cleaner and to avoid having to do the same conversions over and over again. This class can of course be extended with more functionality if you like.

I simply put the class in a script library called “Class.Date” and then use that script library in my other classes or agents.

Class DateClass 
  Private dt As NotesDateTime	
  Public ErrorMsg As String

  Public Sub New(value As Variant)
    Dim datestring As String
    ' *** Check what data type was passed and take actions.
    ' *** If value is blank or Nothing, use today's date.
    Select Case Typename(value)		
      Case "EMPTY" : datestring = Format$(Today(),"Short Date")
      Case "STRING" : 
        If Fulltrim(value) = "" Then
          datestring = Format$(Today(),"Short Date")
        Else
          datestring = value
        End If
      Case "DATE" : datestring = Cstr(value)
    End Select
    ' *** Also check that the value is a valid date
    If Isdate(datestring) = False Then
      ErrorMsg = "Class.Date:New() - '" & datestring & "' received is not a valid date."
      Set dt = Nothing
      Exit Sub
    End If
    ErrorMsg = ""
    Set dt = New NotesDateTime(datestring)	
  End Sub
	
  Public Function DateOnly As String
    ' *** Return date-part only, in format selected by the system
    DateOnly = dt.DateOnly		
  End Function

  Public Function DateOnlyISO As String
    ' *** Return date-part only, in ISO 8601 (big endian) standard format
    DateOnlyISO = Format$(dt.dateOnly,"yyyy-mm-dd")
  End Function
	
  Public Function DateOnlyUS As String
    ' *** Return date-part only, in US (middle-endian) format
    DateOnlyUS = Format$(dt.dateOnly,"mm/dd/yyyy")
  End Function

End Class

And this is how I use the class, this is the first few lines of a function in another script library:

Public Function GetPolicyData(Byval policynumber As String, Byval lossdate As Variant) As Integer
  Dim DoL As DateClass
  Dim result As Integer
  Set DoL = New DateClass(lossdate)
  If DoL Is Nothing Then
   '*** Display message, including error message from DateTime class
    MsgBox = |Failed to initialize New DateTimeClass with LossDate "| & _
    lossdate & |". | & DoL.ErrorMsg  
    Exit Function
  End If
  '*** Call COM object with policy number and date of loss in ISO 8601 format
  result = object.GetPolicyData(policynumber, DOL.DateOnlyISO())
  ...

There you have it. Easy, isn’t it?

In memory of Tim Tripcony

Posted on May 12, 2014 by Karl-Henry Martinsson Posted in IBM/Lotus, Lotusphere, Personal, XPages 2 Comments

A couple of hours ago, I was reached by the terrible news that Tim Tripcony is no longer with us.

Tip Tripcony at Lotusphere 2009

Tip Tripcony at Lotusphere 2009

I have known Tim for several years, and meeting him at Lotusphere (later Connect) was always a treat. He is one of the most brilliant programmers I have met, and he always had time to talk to me about some question I had or just discuss some technical concept. Every time I met Tim, it felt like a little of his intelligence rubbed off on me.

A couple of years ago, I started looking at XPages, and when I ran into a problem, I asked Tim for some help on Skype or Sametime (don’t remember now which one it was). As the helpful and generous person he was, he took the time out of his busy day to help me with my problem.

Tim was one of the early adopters and champions of XPages, and I have been reading his excellent blog and been to his sessions at Lotusphere. He is one of the developers I admired the most, and that is no easy feat, with all the brilliant individuals we have in the ICS (“Yellowsphere”) community.

Tim, thanks for all your help and ideas over the years. My thoughts goes out to your family, your friends and co-workers, and to everyone else who were fortunate to know you. You will be missed.

Code snippet – Disable agent using external file

Posted on May 1, 2014 by Karl-Henry Martinsson Posted in Lotusscript, Notes/Domino, Programming Leave a comment

Yesterday I was asked to create a way to let us disable agents running on a Domino server in an easy way before the Domino server comes back from a crash.

The reason for this request is that for a while we have been having one particular agent crash, taking the whole Domino server down with it. It only happens occasionally, and seems to be related to the document being processed. When the server comes up after a crash like that, a consistence check is done, then the agent manager launches the agent again, causing the server to go down again. I added code to the offending agent, so it would flag the document before processing and un-flag after processing is done. This way, when the agent encounters an already flagged document, it will be skipped as it was processed during a previous crash.

For some reason this did not work yesterday morning, when one of those rare corrupted(?) documents was encountered. The logic in the code was faulty, because the document was of a new type, so it was never flagged as being processed. The same document was processed over and over again, taking the server down every time.

So I simply created two functions, put them in a global script library where I keep utility functions used in many places, and added 3 lines of code to each agent where I wanted this functionality.

The first function is simply to check if a specified file exists. I am using en error handler to catch any error (for example missing directory).

Function FileExists(filename As String) As Boolean
    On Error GoTo errHandler
    If Dir$(filename)<>"" Then
        FileExists = True
    Else
        FileExists = False
    End If
exitFunction:
    Exit Function
errhandler:
    FileExists = False
    Resume exitFunction
End Function

The second function is the one where I check for the existance of a file named the same as the agent, with an extension of .disabled. If that file does not exist, I check for a file with the extension .enabled. If that file is missing, I simply create a blank file with that name. This way, the first time any agent is executed, the file will be created for us, and I don’t have to sit and manually create them all.

Function DisableAgent() As Boolean
    Dim session As New NotesSession
    Dim agentname As String
    Dim filename As String 

    agentname = session.CurrentAgent.Name
    filename = "D:\NotesAgentControlFiles\" + agentname + ".disabled"
    If FileExists(filename) Then
        DisableAgent= True
    Else
        filename = "D:\NotesAgentControlFiles\" + agentname + ".enabled"
        If Not FileExists(filename) Then	
            Open filename For Output As #1
            Print #1, ""
            Close #1
            Print "Created control file " & filename
        End If
        DisableAgent= False
    End If
End Function

Finally, in each agent I want to be able to disable like this, I add this code in the beginning:

'*** Check if disable-file exists, exit in that case
If DisableAgent() Then
    Exit Sub
End If

Just a few lines of code, but hopefully it will save someone a few minutes of work. Of course, you ca use this technique for many other things, your imagination is the limit.

Code snippet – jQuery

Posted on March 15, 2014 by Karl-Henry Martinsson Posted in HTML/CSS, jQuery, Lotusscript, Notes/Domino, Programming 6 Comments

This morning I was working on a web application, and I came up with a pretty neat and simple little solution. So I just wanted to share it, in case anyone else need something similar.

I have a webpage with an HTML form. Each input tag has an attribute called notesfield, matching the name of the field in Notes where the value is stored:

<div class="col-md-3">
    <label>First Name</label>
    <input class="form-control" type="text" notesfield="FirstName" value="" />
</div>
<div class="col-md-2">
    <label>Initial</label>
    <input class="form-control" type="text" notesfield="MiddleInitial" value="" />
</div>
<div class="col-md-3">
    <label>Last Name</label>
    <input class="form-control" type="text" notesfield="LastName" value="" />
</div>

Then I created a simple function that will call an agent on the Domino server, which will return all the fields on the specified document as JSON. This function is called after the HTML page is fully loaded.

function loadNotesFields(docunid) {
	var notesfieldname = "";
	$.ajax({
		url: "/database.nsf/ajax_GetNotesFieldFields?OpenAgent", 
		data: {"NotesUNID":docunid},
		cache: false
	}).done(function(data) {
		$('input[notesfield]').each(function() {
			notesfieldname = $(this).attr("notesfield");
			$(this).val(data[notesfieldname]);
		});
	});
}

The function is actually extremely simple, and here you can see the power of jQuery. What I do is to perform an Ajax call to a Domino URL, passing a UNID to the agent to use in the lookup. I set cache to false, to avoid the browser from reusing previously retrieved data (this is a good thing to do if the data retrieved can be suspected to change frequently).

The jQuery .ajax() functions returns the JSON in the data object, and when the call is done, the callback function loops through each input element with an attribute of notesfield, reads the value of said attribute and then sets the value of the input element to the corresponding Notes value.

The only thing left is to write the agent that will return the JSON. It could look something like this:

Dim urldata List As String

Sub Initialize
	Dim session As New NotesSession
	Dim webform As NotesDocument
	Dim db As NotesDatabase
	Dim doc As NotesDocument
	Dim urlstring As String
	Dim urlarr As Variant
	Dim urlvaluename As Variant
	Dim i As Integer
	Dim json As String

	Set webform = session.DocumentContext
	'*** Remove leading "OpenAgent" from Query_String
	urlstring = StrRight(webform.Query_String_Decoded(0),"&")
	'*** Create list of arguments passed to agent
	urlarr = Split(urlstring,"&")
	For i = LBound(urlarr) To UBound(urlarr)
		urlvaluename = Split(urlarr(i),"=")
		urldata(urlvaluename(0)) = urlvaluename(1)
	Next
	Set thisdb = session.CurrentDatabase
	'*** Create content header for return data
	Print "content-type: application/json"
	'*** Get Notes document baed on NotesUIND argument
	Set doc = db.GetDocumentByUNID(urldata("NotesUNID"))
	'*** Build JSON for all fields in document except $fields
	json = "{" + Chr$(13)
	ForAll item In doc.Items
		If Left$(item.Name,1)<>"$" Then
			json = json + |"| + item.Name + |":"| + item.Text + |",|+ Chr$(13)
		End If
	End ForAll
	'*** Remove trailing comma and line break
	json = Left$(json,Len(json)-2)	
	json = json + "}"
	'*** Return JSON
	Print json	
End Sub

Happy coding!

Stack Exchange

profile for Karl-Henry Martinsson on Stack Exchange, a network of free, community-driven Q&A sites

Recent Posts

  • Domino 14 is now available
  • Domino 14 Early Access Program
  • Announced: Engage 2024
  • Integrate Node-RED with Notes and Domino
  • Notes and Domino v12 is here!

Recent Comments

  • Theo Heselmans on Announced: Engage 2024
  • Lotus Script Multi-thread Message Box [SOLVED] – Wanted Solution on ProgressBar class for Lotusscript
  • Viet Nguyen on Keep up with COVID-19 though Domino!
  • Viet Nguyen on Keep up with COVID-19 though Domino!
  • Mark Sullivan on Looking for a HP calculator? Look no further!

My Pages

  • How to write better code in Notes

Archives

  • December 2023 (1)
  • October 2023 (2)
  • September 2023 (1)
  • June 2021 (1)
  • April 2021 (2)
  • March 2021 (1)
  • August 2020 (3)
  • July 2020 (2)
  • April 2020 (2)
  • March 2020 (1)
  • December 2019 (2)
  • September 2019 (1)
  • August 2019 (2)
  • July 2019 (2)
  • June 2019 (3)
  • April 2019 (2)
  • December 2018 (1)
  • November 2018 (1)
  • October 2018 (5)
  • August 2018 (2)
  • July 2018 (3)
  • June 2018 (2)
  • May 2018 (1)
  • April 2018 (2)
  • March 2018 (1)
  • February 2018 (2)
  • January 2018 (4)
  • December 2017 (3)
  • November 2017 (2)
  • October 2017 (2)
  • September 2017 (1)
  • August 2017 (2)
  • July 2017 (6)
  • May 2017 (4)
  • February 2017 (1)
  • January 2017 (2)
  • December 2016 (2)
  • October 2016 (3)
  • September 2016 (4)
  • August 2016 (1)
  • July 2016 (2)
  • June 2016 (2)
  • May 2016 (3)
  • April 2016 (1)
  • March 2016 (4)
  • February 2016 (2)
  • January 2016 (4)
  • December 2015 (3)
  • November 2015 (2)
  • October 2015 (1)
  • September 2015 (2)
  • August 2015 (1)
  • July 2015 (5)
  • June 2015 (2)
  • April 2015 (2)
  • March 2015 (3)
  • February 2015 (2)
  • January 2015 (10)
  • December 2014 (1)
  • November 2014 (3)
  • October 2014 (3)
  • September 2014 (13)
  • August 2014 (6)
  • July 2014 (5)
  • May 2014 (3)
  • March 2014 (2)
  • January 2014 (10)
  • December 2013 (5)
  • November 2013 (2)
  • October 2013 (5)
  • September 2013 (4)
  • August 2013 (7)
  • July 2013 (3)
  • June 2013 (1)
  • May 2013 (4)
  • April 2013 (7)
  • March 2013 (8)
  • February 2013 (9)
  • January 2013 (5)
  • December 2012 (7)
  • November 2012 (13)
  • October 2012 (10)
  • September 2012 (2)
  • August 2012 (1)
  • July 2012 (1)
  • June 2012 (3)
  • May 2012 (11)
  • April 2012 (3)
  • March 2012 (2)
  • February 2012 (5)
  • January 2012 (14)
  • December 2011 (4)
  • November 2011 (7)
  • October 2011 (8)
  • August 2011 (4)
  • July 2011 (1)
  • June 2011 (2)
  • May 2011 (4)
  • April 2011 (4)
  • March 2011 (7)
  • February 2011 (5)
  • January 2011 (17)
  • December 2010 (9)
  • November 2010 (21)
  • October 2010 (4)
  • September 2010 (2)
  • July 2010 (3)
  • June 2010 (2)
  • May 2010 (3)
  • April 2010 (8)
  • March 2010 (3)
  • January 2010 (5)
  • November 2009 (4)
  • October 2009 (7)
  • September 2009 (1)
  • August 2009 (7)
  • July 2009 (1)
  • June 2009 (4)
  • May 2009 (1)
  • April 2009 (1)
  • February 2009 (1)
  • January 2009 (3)
  • December 2008 (1)
  • November 2008 (1)
  • October 2008 (7)
  • September 2008 (7)
  • August 2008 (6)
  • July 2008 (5)
  • June 2008 (2)
  • May 2008 (5)
  • April 2008 (4)
  • March 2008 (11)
  • February 2008 (10)
  • January 2008 (8)

Categories

  • AppDev (10)
  • Blogging (11)
    • WordPress (5)
  • Design (5)
    • Graphics (1)
    • UI/UX (2)
  • Featured (5)
  • Financial (2)
  • Food (5)
    • Baking (3)
    • Cooking (3)
  • Generic (11)
  • History (5)
  • Hobbies (10)
    • LEGO (4)
    • Photography (4)
  • Humor (1)
  • IBM/Lotus (178)
    • #Domino2025 (14)
    • #DominoForever (8)
    • #IBMChampion (46)
    • Administration (7)
    • Cloud (7)
    • CollabSphere (9)
    • Community (49)
    • Connect (33)
    • ConnectED (12)
    • Connections (3)
    • HCL (15)
    • HCL Master (1)
    • IBM Think (1)
    • Lotusphere (46)
    • MWLUG (25)
    • Notes/Domino (99)
      • Domino 11 (7)
    • Sametime (8)
    • Verse (14)
    • Volt (3)
    • Watson (6)
  • Life (8)
  • Microsoft (7)
    • .NET (2)
    • C# (1)
    • Visual Studio (1)
  • Movies (3)
  • Old Blog Post (259)
  • Personal (23)
  • Programming (84)
    • App Modernization (11)
    • Formula (4)
    • Lotusscript (47)
    • NetSuite (4)
      • SuiteScript (3)
    • node.js (4)
    • XPages (4)
  • Reviews (9)
  • Sci-Fi (4)
  • Software (24)
    • Flight Simulator (2)
    • Games (4)
    • Open Source (2)
    • Utilities (6)
  • Technology (37)
    • Aviation (3)
    • Calculators (2)
    • Computers (6)
    • Gadgets (7)
    • Mobile Phones (7)
    • Science (3)
    • Tablets (2)
  • Travel (7)
    • Europe (1)
    • Texas (2)
    • United States (1)
  • Uncategorized (16)
  • Web Development (50)
    • Frameworks (23)
      • Bootstrap (14)
    • HTML/CSS (12)
    • Javascript (32)
      • jQuery (23)
  • Prev
  • 1
  • …
  • 3
  • 4
  • 5
  • 6
  • 7
  • …
  • 9
  • Next

Administration

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Tracking

Creeper
MediaCreeper
  • Family Pictures
© TexasSwede 2008-2014