Home       About Genii       Products       Downloads       News & Events       Support       Weblog   
February, 2010
SMTWTFS
 01 02 03 04 05 06
07 08 09 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28
January, 2010
December, 2009
November, 2009
October, 2009
September, 2009
August, 2009

Show all 81 months


Search the weblog

Ben Langhinrichs
E-mail address - Ben Langhinrichs

Photograph of Ben Langhinrichs



©2003-2009 Genii Software Ltd. All rights reserved. The rights to all logos, images, etc. are owned by their respective owners.

The views expressed in this weblog are mine alone, but since I am President and Owner, they necessarily also reflect the views of Genii Software, Ltd.
Genii Weblog
Genii Weblog

OpenSesame: @DbColumn on a spreadsheet

Thu 22 Mar 2007, 11:58 PM

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:

586.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?

586.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).

586.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.

Have your say:

Name *:
E-mail:
e-mail addresses will not be displayed on this site
Comment *:


<HTML is not allowed>
Linking: Add links as {{http://xxx|title}}, and they will be activated once approved
Blocked? Unable to post a comment? Please read this for a possible explanation...

Copyright © 1996-2009 Genii Software Ltd. All Rights Reserved. Some images courtesy of BigFoto.com  Nedstat