spreadsheet interface

hjenkins wrote:

Some people in my workplace are asking if there exists a GUI that will
allow cut-and-paste of multiple cells directly from (and, preferably,
directly to) spreadsheets. pgAdmin III, PGAccess, and TOra don't seem to.
Any suggestions?

By "spreadsheet" I'm going to assume you mean M$ excel. The best way I
can think of to pull that off is to set up an Access db with the
psqlODBC driver to connect to it. I believe you ought to at least be
able to copy from the db that way (btw pgAdmin does work with a little
effort, if you're too leet for access, though at that point you'd be
able to work with pgadmin (or even better yet, and deserving of two
levels of parantheses, use csv/txt files and COPY from psql at a dummy
terminal in amber text)).

Lol sorry to get off the point, but this is the first suggestion that
pops in mind.

--
Tom Hart
IT Specialist
Cooperative Federal
723 Westcott St.
Syracuse, NY 13210
(315) 471-1116 ext. 202
(315) 476-0567 (fax)

-------------- Original message ----------------------
From: "hjenkins" <hjenkins@uvic.ca>

Some people in my workplace are asking if there exists a GUI that will
allow cut-and-paste of multiple cells directly from (and, preferably,
directly to) spreadsheets. pgAdmin III, PGAccess, and TOra don't seem to.
Any suggestions?

OpenOffice. Set up a datasource using the Base component. You can drag and drop to the spreadsheet component.

--
Adrian Klaver
aklaver@comcast.net

Adrian Klaver wrote:

-------------- Original message ----------------------
From: "hjenkins" <hjenkins@uvic.ca>

Some people in my workplace are asking if there exists a GUI that will
allow cut-and-paste of multiple cells directly from (and, preferably,
directly to) spreadsheets. pgAdmin III, PGAccess, and TOra don't seem to.
Any suggestions?

OpenOffice. Set up a datasource using the Base component. You can drag and drop to the spreadsheet component.

--
Adrian Klaver
aklaver@comcast.net

Another good suggestion, if you're organization is/can use OpenOffice.
If you're stuck with M$ then you might be able to do this directly in excel.

--
Tom Hart
IT Specialist
Cooperative Federal
723 Westcott St.
Syracuse, NY 13210
(315) 471-1116 ext. 202
(315) 476-0567 (fax)

In response to "hjenkins" <hjenkins@uvic.ca>:

Some people in my workplace are asking if there exists a GUI that will
allow cut-and-paste of multiple cells directly from (and, preferably,
directly to) spreadsheets. pgAdmin III, PGAccess, and TOra don't seem to.
Any suggestions?

To add on to Thomas' comment. You can also install OpenOffice.org with
the pgsql ODBC driver and use the OOo spreadsheet to access data directly.

I haven't done this, personally, so I can't vouch for how well it works.

--
Bill Moran
http://www.potentialtech.com

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, 17 Dec 2007 16:47:41 -0500
Bill Moran <wmoran@potentialtech.com> wrote:

In response to "hjenkins" <hjenkins@uvic.ca>:

Some people in my workplace are asking if there exists a GUI that
will allow cut-and-paste of multiple cells directly from (and,
preferably, directly to) spreadsheets. pgAdmin III, PGAccess, and
TOra don't seem to. Any suggestions?

To add on to Thomas' comment. You can also install OpenOffice.org
with the pgsql ODBC driver and use the OOo spreadsheet to access data
directly.

I haven't done this, personally, so I can't vouch for how well it
works.

Well OpenOffice now has a native sdbc driver so no ODBC is required.
It seems to work very well.

Joshua D. Drake

- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHZvAAATb/zqfZUUQRAjCkAJoDVALSb4UT4u0BcjLKhKxVOGR7dQCZAcN9
s7AarPlnSCq/AdlWrxi6MMg=
=AAjl
-----END PGP SIGNATURE-----

------- Original Message -------
From: "hjenkins" <hjenkins@uvic.ca>
To: pgsql-general@postgresql.org
Sent: 17/12/07, 21:10:46
Subject: [GENERAL] spreadsheet interface

Some people in my workplace are asking if there exists a GUI that will
allow cut-and-paste of multiple cells directly from (and, preferably,
directly to) spreadsheets. pgAdmin III, PGAccess, and TOra don't seem to.
Any suggestions?

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.

Regards, Dave

On Monday 17 December 2007 1:47 pm, Bill Moran wrote:

In response to "hjenkins" <hjenkins@uvic.ca>:

Some people in my workplace are asking if there exists a GUI that will
allow cut-and-paste of multiple cells directly from (and, preferably,
directly to) spreadsheets. pgAdmin III, PGAccess, and TOra don't seem to.
Any suggestions?

To add on to Thomas' comment. You can also install OpenOffice.org with
the pgsql ODBC driver and use the OOo spreadsheet to access data directly.

I haven't done this, personally, so I can't vouch for how well it works.

For the record I have luck using OO with either the Postgres JDBC driver or
the native SDBC driver. I tried the ODBC driver with not too much success.

--
Adrian Klaver
aklaver@comcast.net

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@comcast.net