Yearly Archives: 2006

The Cookies of Xmas

By Ian | December 23, 2006

ET has been busy, and the results have been yummy:
a small plate of short bread, and xmas biscotti, almond crescent, Amoretti cookies, & hazelnut button cookies

sugar cookies

gingerbread men

more gingerbread folk

Happy Newtonmas!

Posted in Food | 1 Comment

SNTT Structured DbColumn’s in Lotus Notes

By Ian | December 21, 2006

Back in February I posted Structured DBlookup’s in Lotus Notes. Very popular. Implicit in that was that the same could be applied to DbColumn’s, but the web (and Google) is all about being explicit, so here we go :
12345678class := "Notes";
Cache := "NoCache";
server := @Subset(@DbName; 1);
database := @Subset(@DbName; -1);
view := "In Progress";
columnNumber :=1;
value [...]

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

SNTT : Export any Lotus Notes View to Excel from Domino Web, automagically

By Ian | December 14, 2006

As an update to Export any Lotus Notes View to CSV or Excel, automagically, and as an answer to a being asked how you would do this, here is some similar code to export a view from the web brower to Excel :
WebExcelPrint.txt
Import it into a Lotus Script Agent, and call it with a url [...]

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

SNTT : Export any Lotus Notes View to CSV or Excel, automagically

By Ian | December 7, 2006

Here is a some very generic code which will work on any Lotus Notes View to print out the contents to a Comma Separated Value (CSV) file, or as an Excel File, with minimum formating, as a general export routines.

Posted in Code, LinkedIn, Lotus Domino, Show-n-Tell+Thursday | 8 Comments

CosPlay Cafe comes to Toronto

By Ian | December 2, 2006

Restaurants and Cafes devoted to “costume play,” or cosplay as the Japanese call it, first appeared in Akihabara, Tokyo’s discount electronics store district, in the late 90’s.
Well during the summer, iMaid Cafe opened in Toronto’s east end at 1883 McNicoll Ave. (at Kennedy Rd close to Pacific Mall.), to provide the french maid variation of [...]

Posted in Asian, Culture, Hong Kong & China, Toronto, kawaii | 4 Comments

Startup Camp coming to Toronto

By Ian | November 9, 2006

Wonderful news: (Via Rob Hyndman) that people are looking at bring a Startup Camp, The Unconference for the Startup Community, to Toronto (in the winter/spring 2007), inspired by the first Startup Camp recently held in California land.
Many details still to be decided (okay almost all the details are TBD: like the the When , Where [...]

Posted in DemoCamp, Toronto | 2 Comments

Opening a Lotus Notes Profile Document in Read Only mode

By Ian | October 25, 2006

I needed to display for “regular” users information that was maintained database wide (preferable via a profile form). Although the usual “@Command( [EditProfileDocument] ; formname; uniqueKey )” worked fine for the db admin people to edit/maintain the information, there was no corresponding “OpenProfileDocument” or such. I wasn’t having much luck [...]

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

Demo Camp Toronto 10 : The return to MARS

By Ian | October 24, 2006

A good size crowd of 100+ of Toronto greekry (want is a word for horde of geeks?) made it out for the 10th DemoCamp monthly show and tell’s return to the auditorium at MaRs.

Posted in DemoCamp, LinkedIn, Toronto | 1 Comment

Q&D Action button to set Date Value with Lotus Notes Formula Language

By Ian | October 12, 2006

A quick and dirty way for doing this. No error checking, big assumptions about the input to the prompt being right.
12345nd := @Prompt([OKCANCELEDIT]; "Enter the New Date"; "YYYY/MM/DD."; @Today);
@If (nd ="";@Return("");"");
y := @Left (nd;"/");
m := @Left(@Right (nd;"/");"/");
d:= @right(@Right (nd;"/");"/");
12FIELD DateFieldOnForm := @Date(@TextToNumber (y) ;@TextToNumber ( m)
;@TextToNumber ( d) )
the Key is parsing the string [...]

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

Using Lotus Notes ACL Roles rather than Groups Names in our ACL

By Ian | October 5, 2006

Why should you use Role names to define functionality? Because : it’s easier to check if someone belongs to a role than a group, and I can’t control what a client (or the Notes Administrator) is going to call a given group.
ACL settings for a pseudo Role-Group need to be documented perhaps in the [...]

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