[Glastonbury] OOo and MySQL

[Alistair Parsons]

Hi

heres my thoughts

rekall is the main way to go, however you can only download the source, rpms are commecrial

or

Kexi,  is still not ready to be released but it promises to be very simple for claiters etc

in the short term:
if you are just printing reports i would suggest a php front end for data entry and a Kugar (part of koffice) report using qt driver
 i had an email from the kugar developer last week and im still trying to get it to work, however when it does it should be completely idiot proof click and print

if you did want to buy the rpm for rekall id be more than happy to devote A LOT of spare time to help you get it to work

Al
support at microbitz.co.uk
-----Original Message-----
From: Rob Cornelius <root at htmler.org>
To: "The Linux User Group of Glastonbury (LUGOG)" <glastonbury at mailman.lug.org.uk>
Date: Sun, 25 Jan 2004 09:20:13 +0000
Subject: Re: [Glastonbury] OOo and MySQL

I tried Rekall... or rather i didnt as I couldnt get it to compile at 
all. Tried looking on the totalrekall site and I cant see what I have to 
do to get the full versions at all, there seems to be some sort of need 
to purchase code but no way that I can see to actually do it!

(oh and I dont like Gnome, its perfectly possible to have RH9 running KDE ;)

I /think/ I now know how to get an ODBC datasource set up on a linux 
box. Hopefully I can then connect OOo to the MySQL server through this 
route. Otherwise I will have to get Java sorted out on the machine and 
try and use JDBC to connect.

So far all I have is this screenshot to show them

http://www.openoffice.org/dev_docs/features/1.1/images/dbase.jpg

The next problem will be the data they have is all over the place and 
they have to use some Access wizard type queries to process it each 
time. But they cant sort out the data once and update the database 
because "that wouldnt be right, we might want to change it later" (I 
have already had to do this sort of thing twice where they said 
duplicated data was bad then changed their minds.... dont ask). So once
I have got it all working I will have to find a way of translating
bizzarely generated AccessSQL to something MySQL can cope with. /Then/
find a way of getting them to use it!

Rob