Re: spreadsheet interface

On Monday 17 December 2007 3:10 pm, hjenkins wrote:
> Hello, all,
>
> >Dave Page writes:
> >pgAdmin will copy arbitrary blocks of cells to spreadsheets, and will
> >accept rows pasted into the edit grid. It should work out of the box
>
> with >Excel and OpenOffice - if not, check the copy delimiter/quoting
> options >under file->options.
> That sounds perfect, but I can't get it to work, even with OO. I can't
> find any copy delimiter/quoting options >under file->options.
>
> When you say "pgAdmin does work with a little effort", Mr. Hart, do you
> mean that I can set it up so that one can cut-and-paste multiple cells, as
> Mr. Page is describing, or that there is a work-around which requires more
> effort per-use than cut-and-paste?
>
> Using OpenOffice:
> OO driver: http://dba.openoffice.org/drivers/postgresql/index.html
> JDBC driver: http://jdbc.postgresql.org/
> ODBC driver: http://pgfoundry.org/projects/psqlodbc/ and others
>
> Since the JDBC driver is in Gentoo-portage, I tried that, but
> OpenOffice can't load org.postgresql.Driver as the JDBC Driver class... If
> I use this, I'll let you know how it goes.
You need to set up OpenOffice. Do following:
1) From Menu bar Tools --> Options
2) Click on OpenOffice.org --> Java
3) Make sure a Java Runtime Environment is set up
4) Click on the Class Path button
5) Click on Add Archive and browse for location of the Postgres JDBC jar file.
6) Back out of menus
7) Restart OpenOffice
>
> I'm too... experienced with Access (several days worth)... to want to use
> it, personally, but it might work for this application. I'll have a look.
> I've been using Python scripts to generate the COPY functions and piping
> them to psql -f. I doubt, though, that my co-workers will be keen on doing
> this each time they want to move three cells into a report, especially
> since they have neither Python nor a UNIX shell.
>
> Belatedly, I've found a similar if outdated post at
> http://lists.suse.com/archive/suse-slox-e/2003-Aug/0149.html
> but it's been taken down; only a cached version.
>
> Thanks for all the replies. Honestly, you have to hover over your inbox on
> this mailing list, it pounces so quickly.
>
> Regards,
> H.Jenkins

--
Adrian Klaver
aklaver(at)comcast(dot)net