On Mon, Nov 08, 2004 at 10:25:25AM +0000, Laurie Brown wrote:
Chris Green wrote:
My migration of my Access databases to mysql has started. I've got mysql, PHP and apache up and running and I've imported the data from my Access database. I can see it all in phpMyAdmin, most impressive!
Now I need to be able to design/build replacements for the Access data input forms and the Access reports.
Freshmeat and sourceforge are your friends here:
http://freshmeat.net/search/?q=mysql+forms%C2%A7ion=projects&Go.x=0&...
These look promising:
http://freshmeat.net/projects/phormation/ http://freshmeat.net/projects/phpformgenerator/ http://freshmeat.net/projects/dadabik/ http://freshmeat.net/projects/mysqlfm/ http://freshmeat.net/projects/formapp/
Yes, I've been through just about all of those. See my specific comments on dadabik which is one of the better ones.
They are all far too 'form on a web page' oriented. They all seem to assume a database in which multiple users 'out there' will be modifying one line (probably their 'own' line) in the database. Thus they all tend to provide a means for finding a record and then a form for entering/modifying all the fields in that one record.
This sort of approach is fine for that sort of application but it's awful for entering/modifying multiple transactions in an accounts journal. The easiest way to find a transaction to modify is very often a simple scrolling list, I only use a search if I really get stuck. Then I want to modify the data 'in place', apart from anything else it's often very useful to be able to see adjacent entries when working out what one has to enter (e.g. what was the cheque number on the last payment, etc.).
What I really want is a 'table view' with the additional facility of a few automatic calculations on some fields.
Further searching on Freshmeat and sourceforge found what looks like what I want. Abu is unfortunately only for postGres but knoda looks like it will do what I want for mysql. The only problem is that it is a KDE application and thus I will need a load of KDE libraries I expect.