Data in individual text files

[RiverRidge]

My cash register generates a sales report each day that is output as a text file. The format and contents are identical with the data for that day changed. One of the data elements is sales by hour with the number of sales and the dollar volume of sales for each hour of the day.

I would like to compile average sales by hour by day.

I can open the daily files as a text document and can read them into Calc.

I need some suggestions on how to compile them. Other than by brute force of individually copying each Calc worksheet into a master worksheet, I have not had any luck. I have looked at BASE and assume that this is the hammer to use on my nail, but I am not sure was approach to take.

Any suggestions? All comments gratefully accepted.

Later............ jt

[Villeroy]

Create a data pilot in Calc with your registered database as source. You can split imported dates and times by Menu:Outline>Group...(F12).

Edit: See issue 53244, which states that time fields nor date-time fields of imported data don't work. Sorry, this is really annoying. http://dba.openoffice.org/specification ... tions.html describes all functions that should work with select queries against simple data sources such as text (*.csv). It includes HOUR, DAY, MONTH, YEAR

[wurzel]

You could also try using the HSQLDB function of declaring text tables (i.e. CSV files) directly as table sources for your database.
To do this, you might want to read up on the HSQLDB documentation first.

Alex

[wurzel]

See here for more info :

http://hsqldb.sourceforge.net/doc/guide/ch06.html


These instructions are SQL statements that should be able to be carried out from within your database document, via the menu
Tools > SQL from within OpenOffice.org once you have created an initial database document.

Alex