Re: Feature request: Export to SQL

[Jody Goldberg <jody gnome org>]

On Mon, Feb 02, 2004 at 04:44:30PM -0600, Mike Perry wrote:
> Thus spake Jody Goldberg (jody gnome org):
>
> > On Mon, Feb 02, 2004 at 03:12:26PM -0600, Mike Perry wrote:
> >
> > The gnumeric side would be trivial.  There are lots of examples on
> > how to write an export filter.
>
> Excellent. I assume you mean in the src tree itself?

Yes, although there are examples outside the tree too.  Inside is
currently much simpler.
 
> > > I suppose the hardest part would be exporting db functions.. But a nice
> > > start would be just to take a snapshot of all values, and export to SQL
> > > just so you can run some quick queries.
> >
> > I suspect that you'd want some sort of gui to configure what goes
> > where.  That is less well defined.  Only the text exporter handles
> > that currently.  It's not hard, just not as pretty as I'd like.
> > The main limitiation is that there is nowhere to store the
> > parameters right now for resaving.  That will get addressed in the
> > 1.3.x cycle.
>
> So by this you mean there is no way to restore the gnumeric functions
> and their arguments once you export to a flat format, like text or
> simple SQL?

No.  Although that would be something of an issue for columns
exported by value.  My meaning was that there could be a fair amount
of configuration needed to map the sheet data to external tables.
It would be useful if that configuration could be stored and used
for multiple saves.

> Can I view the 1.3.x roadmap anywhere? What is the timeframe on it?

The roadmap is quite general.  Release is targeted for june.  We
have several features that would be nice to get in before then.
Anything not sufficiently stable will be bumped.  If we hit all of
them the next version is 2.0, otherwise it will stay 1.4.

High level feature targets are
    1) win32 build
    2) scriptting
    3) conditional formats
    4) pivot tables

Architecturally the only major goal is to pull whatever is necessary
out of gnumeric and into libgoffice so that it can be released.