Wusage and Your Spreadsheet Software

Many administrators wish to create additional reports beyond those produced by wusage. A good way to do this is to import the wusage database into your spreadsheet. Fortunately, this is very straightforward.

The file database.dat, found in your report directory, contains the historical data used by wusage to generate its historical graphs. This data is stored as tab-delimited ASCII, which any spreadsheet program can open directly.

The first row contains titles identifying each of the totals you have configured using the totals option. Each subsequent row contains the date at which the time period began, the number of days in the time period (always 1 or 7 at this time), and the amount of activity (both accesses and bytes if your server log contains bytes transmitted information) for each of your totals during that time period.

It is not recommended that you alter and save changes to the database.dat file. However, if you do, keep in mind that the file must continue to contain tab-delimited ASCII only, the number of columns should not change, and the "days" column must contain either 1 or 7 for each time period (day or week).

Table of Contents

Boutell.Com, Inc - PO Box 63767, Philadelphia PA, 19147, USA
Phone/Fax +1 206. 658. 8176