Hi,
I am at a point where I need tools to design a simple database application - can coffeecup provide me with what I need. It is a single user app where I pull csv files into a database once a month, then review and add a couple of codes to the data using a lookup table. I then print a couple of reports based on the data - different sorts and selects and groupings. Yes I could do it on a spreadsheet, but I want to make it as simple and robust as possible and it should be in a database. Not really too hard, but I can't find software to do this which isn't overkill. Any advice would be appreciated.I am working in windows 7 ultimate - 64 bit. Thanks in advance.

Derek Archibald

Do you already have an application putting the data in the database?

This data is it online or on your computer. If it is online you can do it with php if on your computer a macro in Access or Open Office. Even if the data is online then it can be downloaded, Access/Open Office provides a database.
They are the tools to manipulate and report. How? that depends on what manipulation is required. That sort of thing tends to be a one off requirement to suit the type of reports desired

Rolly - No application. That's what I want to create.
Assume I have the CSV on the computer and have created a database and data tables to accept the csv file formats.

What I then need is

1) A bit of code to append the CSV data to a data table. The CSV files would be in a fixed format that would not change
2) A Screen to review the appended data and add some codes to each record. (Pref by table look-up)
3) A reporting function to print the data - screen or printer.

Things like Delphi seem overkill (and overpriced for my little app) with a steep(ish) learning curve.
I saw in Web Form Builder the ability to save to MySQL, but can't try this out on trial version.

I have trialled Open Office but thats not where I want to go. These tools come up short when you want longevity of your application. I only want to build this once.

All I really need to know is this outwith coffeecup softwares capabilities ? and if so where should I go look ?

Thanks.

This thread might interest you.
http://www.coffeecup.com/forums/web-for … post183500

Thanks Rolly,

Thats given me something to research.

Derek.

That's the trouble with a form Eric it is a one way device. Input in. There is so many ways the data can be handled, I will be interested in CC's approach.
To you Derek, If you Google php csv files you will get a ton of examples on how to read, display and manipulate but there is not just one fix does all. If you take it one step at a time you will find it fairly easy to put together a script to do what you want. I will start you off. This is how you read a csv file. It was a bit of code I used for one of the demo's below.


Change it to suit your file
Once you understand this the rest is easy
You could try Hotscripts, You might get a script that will come close or pay someone to code it for you.
It all depends if it is done online or on your desktop. There are Database applications for the desktop. You will still have to manipulate the data yourself though.