Monthly Archives: August 2009

A few Toronto Festivals in September: Junction Arts, Ukrainians, Poles and Movie Stars

By Ian | August 28, 2009

The Junction Arts Festival is back on Sept 9 to 13, 2009 of its 17th occasion in Toronto’s west end on Dundas Street West between Keele Street and Quebec Avenue. The festival presents visual, musical, performance, new media and site-specific works to over 150,000 people transforming Dundas Street West into a pedestrian-only, urban cultural destination.
September [...]

Posted in Art, Culture, Food, Junction City, Toronto | 1 Comment

Sacha Chua shares her Lotus Notes mail merge from a Microsoft Excel spreadsheet

By Ian | August 27, 2009

Toronto’s Connector extraordinaire Sacha Chua developed this super-nifty Lotus Notes script which does a flexible mail merge from a Microsoft Excel spreadsheet to Lotus Notes, as documented and shared in Lotus Notes mail merge from a Microsoft Excel spreadsheet.
Keep on Coding, Sharing, Story telling, and Connecting!

Posted in Code, Lotus Domino, Show-n-Tell+Thursday, Toronto | 1 Comment

SNTT : using LotusScript to launch file attachements (EmbeddedObjects) in Lotus Notes

By Ian | August 26, 2009

I wanted to launch a excel (xls) file which was stored in a Profile document, from a Notes Client (tested in r8.5 but I see no reason this will not work in versions going back to r5)
(Making it available to all users of a certain type of document with making hundreds of replicate copies, and [...]

Posted in Lotus Domino, Show-n-Tell+Thursday | 3 Comments

SNTT : Don’t hard code your Selectedable Years in a Lotus Notes dialog box.

By Ian | August 13, 2009

Hard coding is bad, bad , bad. Very bad, okay? (see Avoiding Hard Coding of Group Names).
Here’s a quick and dirty way to have a drop down dialog which selects the “Year” and not be hard coded.
1234currentYear := @Year(@Now );
@Text(currentYear-1) :
@Text(currentYear) :
@Text(currentYear+1)
which results in a multip value list of (for this year) “2008″ : [...]

Posted in Lotus Domino, Show-n-Tell+Thursday | Leave a comment

SNTT adding http onto URL strings in Lotus Notes

By Ian | August 13, 2009

The challenge was to have end users enter url’s (or uri’s) for content and have it presented as a link on the read only end part of the site. The problem is that means having “http” (or “https”) -which indicates Hypertext Transfer Protocol – appended to the string, if it was not supplied by [...]

Posted in Lotus Domino, Show-n-Tell+Thursday | Leave a comment