Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!feeder.news-service.com!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Date: Tue, 06 Sep 2011 09:09:17 +1000
From: Simon Cropper <simoncropper@fossworkflowguides.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.21) Gecko/20110831 Lightning/1.0b2 Thunderbird/3.1.13
MIME-Version: 1.0
To: python-list@python.org
Subject: Re: Hello, and request for help with 'dynamic grids'
References: <mailman.765.1315202654.27778.python-list@python.org> <624f5caf-e3c1-4a88-9861-606f7e2705e8@x14g2000prn.googlegroups.com>
In-Reply-To: <624f5caf-e3c1-4a88-9861-606f7e2705e8@x14g2000prn.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.785.1315264164.27778.python-list@python.org>
Lines: 61
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: x330-a1.tempe.blueboxinc.net comp.lang.python:12798

On 06/09/11 00:40, alex23 wrote:
> On Sep 5, 3:18 pm, Simon Cropper<simoncrop...@fossworkflowguides.com>
> wrote:
>> My investigations have generally found that windows/forms/data entry
>> screen can be created for a specific table or view, but these are
>> hard-wired during development. Is there anyway of rapidly defining the
>> grid during runtime so any table can be viewed?
>
> The commercial product Resolver One provides a grid/spreadsheet style
> interface with Python scripting capabilities. I'm not sure of its
> current licensing status but I believe it used to be free if used on
> open source projects.
>
> http://www.resolversystems.com/products/resolver-one/
>
> Each spreadsheet itself is Python code; I think it should be quite do-
> able to take something with introspective SQL capabilities like
> SQLAlchemy and have it title columns and fill them with the correct
> fields accordingly.
>
> Hope this helps.
>
>

Alex,

The Resolver Package looks good. Not exactly open source though. I 
equate it to a proprietary package that can at times be used for free by 
select groups.

The product creates spreadsheets with python code in the background 
(instead of say VBA in Excel or Basic in Calc).

Access to a database still needs to be hard-wired, so it does not act as 
a 'dynamic' viewer. The product works pretty much like Excel and Calc in 
this manner.

Sheets can be shared, although the Resolver Exchange website does not 
clarify the licence under which samples are released (GPL, CC, etc), so 
it is debatable how any of this could reliably be used in creation of 
derivatives.

 From what I can glean from this page...

      http://www.resolversystems.com/opensource/

      ... Resolver will allow you to use the package if you are an open 
source project to create spreadsheets that can be redistributed. For 
people to use these sheets they need to download the viewer or purchase 
the package.

-- 
Cheers Simon

    Simon Cropper - Open Content Creator / Website Administrator

    Free and Open Source Software Workflow Guides
    ------------------------------------------------------------
    Introduction               http://www.fossworkflowguides.com
    GIS Packages               http://gis.fossworkflowguides.com
    bash / Python        http://scripting.fossworkflowguides.com