SnT Thursday - LotusScript Calls & Format Formula
Bookmark :
Thanks Rocky for the SnT idea, and also to Vince for the SnT image. This will be two parts a show and a tell.
Tell
Rocky asked everyone to use Julian's LotusScript 2 HTML on Joe Litton's page for those of you trying to Show or Tell some LotusScript. Ester Storm was thinking of writing a Formula to HTML which has been around for about a year.
Show
Back in December Craig Schumann published a tool called LS Calls. I liked the concept of using LS Calls to determine which variables are no longer being used, and variables are being used before they are ever set. The only thing that I did not like is having to type the command in every time, so I took Chris Doig concept that he used for Set Template Version and applied it to LS Calls as seen in the screenshot:
When editing a LotusScript Calls Configuration there will be help available just as Craig defined. One other feature that I like is the ability to open the output in NotePad or anything else you wish.
The code is very simple until I needed to have LotusScript wait for the execution of LSCalls before it tried to open the output or import the CSV. Ken Yee came to the rescue with 'Can you start a program in Notes and wait for it to finish?' from 1998. There was one other gotcha, having to write the command to a batch file and executing the batch file, so if anyone has a better idea let me know.
The LotusScript Calls database is not that fancy but maybe the concept storing and running command type programs from Domino. Enjoy!