Tuesday, March 16, 2010

Linux Mysql OpenOffice Connector

I use MySQL quite a lot as part of my Home Automation and various information web pages.

As a Linux dude, I need an application to easily update various tables.

There are not many open source utilities that would fit my requirements.

An obvious fella would be to use OpenOffice to connect to MySQL.

I previously set-up OpenOffice to connect to MySQL. It did work but often the wheels fell off and it involved varying degrees of difficulty to get the wheels back on.

Not so any more.

I am not sure when but with OpenOffice 3, things are much easier.

Here is what you need:

1. Access to a Mysql database.
2. An install of OpenOffice.
3. The latest connector extension for OpenOffice.

The Linux Mysql OpenOffice Connector is available here:

Get the connector and follow this link to complete the set-up.

Top Tip:

If you want to be able to edit the MySQL table, the table must have a Primary Key' defined. Otherwise, the result is Fecked.

A Primary Key, is simply a field in the table that has unique contents.

I used this command line to set it:

mysql> alter table "table" add constraint primary key ("field");

That's all.

JTJ (Just the job)