Re: Quick-and-Dirty Data Entry with LibreOffice3?

Rich

On Mon, 2011-09-26 at 11:38 -0700, Rich Shepard wrote:

> Rather than writing an application right now to enter data into a table I
> thought of trying LibreOffice as a front end. But, it doesn't seem to work
> as OO.o did. This leads to two questions:
>
> 1) Can someone show me how to use LO as a front end to a postgres table?

> 2) Is there another tool suitable for a linux box for some data entry
> work?
>
> Rich
>

Which version of LO are you using and which Linux? I have some
experience with using LO as a front-end when pgAdmin is not the best
tool.

I have noticed that with Ubuntu you need to use the 3.3.x series from
the repository. There is pg connector for LO 3.3.x in the repository.
Getting 3.4.x to connect is more of a pain in Ubuntu. I think the
correct driver is libreoffice-sdbc-postgresql.

The steps I use are
1 Open Base and select connect to an existing database.
2 Scroll down to postgresq and select (it will be there if the correct
driver is present)
3 On the next screen you will need to enter the connection information
(dbname = ????, host = ////)
4 On the next screen enter your user information
5 On the next screen I usually enter the defaults
6 You should be in Base.

--
Jay Lozier
jslozier(at)gmail(dot)com