Genii Weblog

OpenSesame: @DbColumn on a spreadsheet

Thu 22 Mar 2007, 11:58 PM

by Ben Langhinrichs
Another one of my "projects" as part of OpenSesame (see earlier post on Edit view in spreadsheet) is the ability to do an @DbColumn or @DbLookup on an OpenDocument spreadsheet in Notes 8.  This is what I have working tonight::

Colors := @DbColumn("OpenS""c:\\temp\\trial.ods""Sheet1""F4-F999");
Colors := @Implode(@Trim(@Unique(Colors)); ",");
@Prompt([Ok]; "All Colors"; Colors);

gives a result of:

Results of @DbColumn

with the spreadsheet:

Spreadsheet view of data

Copyright 2007 Genii Software Ltd.

What has been said:

572.1. Tim Tripcony
(03/22/2007 10:43 PM)

Whoa. Now that's cool. Just curious, are you anticipating that UNC paths will be supported for the file location?

572.2. Ben Langhinrichs
(03/23/2007 03:31 AM)

Certainly. They work now. I just tried

@DbColumn("OpenS"; "\\\\hamster\\cdrive\\share\\trial.ods"; "Sheet1"; "F4-F999");

and it works fine (\\hamster being a shared network drive here where I copied the file). Watch for the parameters possible for @DbLookup, as I think they are very cool (Rocky Oliver helped me think them up).

572.3. Ben Langhinrichs
(03/23/2007 04:41 AM)

I should also point out that when this ships, it should also work with an attached ODS file, probably with the syntax:

@DbColumn("OpenS"; @DbName; @DocumentUniqueID; "MyInvoice.ods"; "Sheet1"; "F4-F999");

and there may be other variations. It is just likely people would want to act on an attached spreadsheet.