[GRASS-user] Wiki: Openoffice.org with SQL Databases

GRASS GRASS user
1

Hi,

after discovering that Openoffice.org offers a *graphical* query
engine for databases (you know that for a long time certainly :-),
I thought that a wiki page would be useful:

http://grass.gdf-hannover.de/wiki/Openoffice.org_with_SQL_Databases
    * 1.1 PostgreSQL (OpenOffice.org 2.x)
          o 1.1.1 Installation of PostgreSQL driver
          o 1.1.2 Usage of PostgreSQL driver
    * 1.2 MySQL (OpenOffice.org 2.x)
    * 1.3 DBF files (OpenOffice.org 2.x)
    * 1.4 MS-Access mdb files (OpenOffice.org 2.x)
    * 1.5 SQLite files (OpenOffice.org 2.x)

Please extend...

Markus

2

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

Yes, and theoretically it should be not too difficult to have OOo draw
to display also PostGIS vectors...
I do not think Sun is too interested in this, though.
pc

Markus Neteler ha scritto:

Hi,

after discovering that Openoffice.org offers a *graphical* query
engine for databases (you know that for a long time certainly :-),
I thought that a wiki page would be useful:

http://grass.gdf-hannover.de/wiki/Openoffice.org_with_SQL_Databases
    * 1.1 PostgreSQL (OpenOffice.org 2.x)
          o 1.1.1 Installation of PostgreSQL driver
          o 1.1.2 Usage of PostgreSQL driver
    * 1.2 MySQL (OpenOffice.org 2.x)
    * 1.3 DBF files (OpenOffice.org 2.x)
    * 1.4 MS-Access mdb files (OpenOffice.org 2.x)
    * 1.5 SQLite files (OpenOffice.org 2.x)

Please extend...

Markus

- --
Paolo Cavallini
email+jabber: cavallini@faunalia.it
www.faunalia.it
Piazza Garibaldi 5 - 56025 Pontedera (PI), Italy Tel: (+39)348-3801953
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFE4BKI/NedwLUzIr4RAuhSAJ9mR3mRGZlMD0kwODSZ0OSZezjA2gCfTYd1
14xm9kTsU0ScpO4bgqN2zzE=
=bMIj
-----END PGP SIGNATURE-----

3

Markus Neteler napisa?(a):

Hi,

after discovering that Openoffice.org offers a *graphical* query
engine for databases (you know that for a long time certainly :-),
I thought that a wiki page would be useful:

http://grass.gdf-hannover.de/wiki/Openoffice.org_with_SQL_Databases

Please extend...

Hi All!

Following this path I "found out" that KEXI supports SQLITE too. You
might find some references here e.g.:
http://www.kexi-project.org/wiki/wikiview/index.php?KexiFAQ

I'm not using KEXI myself, so I can't give any details. I hope some
KDE/KEXI user could elaborate and extend WIKI in this regard. KEXI seems
cool.

Maciek

4

On Sun, Aug 13, 2006 at 09:48:42PM +0200, Markus Neteler wrote:

Hi,

after discovering that Openoffice.org offers a *graphical* query
engine for databases (you know that for a long time certainly :-),
I thought that a wiki page would be useful:

http://grass.gdf-hannover.de/wiki/Openoffice.org_with_SQL_Databases
    * 1.1 PostgreSQL (OpenOffice.org 2.x)
          o 1.1.1 Installation of PostgreSQL driver
          o 1.1.2 Usage of PostgreSQL driver
    * 1.2 MySQL (OpenOffice.org 2.x)
    * 1.3 DBF files (OpenOffice.org 2.x)
    * 1.4 MS-Access mdb files (OpenOffice.org 2.x)
    * 1.5 SQLite files (OpenOffice.org 2.x)

Please extend...

Done so :slight_smile:

Now the page comes with a graphical guide how to convert
Excel/whatever tables into an SQL DB using Openoffice-Base.

cheers
Markus

5

I was thinking about adding some pages to the FAQ category but it looks like
the option to add pages has been turned off. Or am I missing something.

Regards, Jerry

6

On Tue, Dec 19, 2006 at 01:02:50PM -0600, Jerry Nelson wrote:

I was thinking about adding some pages to the FAQ category but it looks like
the option to add pages has been turned off. Or am I missing something.

Jerry,

you need to register first. Then you can modify pages (needed
to keep spammers out).

Markus