SnT Thursday – LotusScript Calls & Format Formula
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!
Update: I lost the database in my transition to WordPress, so if anyone has it please send it to me, thanks.