5,838
edits
Daily Summary: Difference between revisions
m
→Displaying daily statistics from a database table
m (→Introduction) |
|||
|
== Displaying daily statistics from a database table ==
=== Schema ===
Any script that reads from a database table needs two pre-requisites
# Something that loads the daily statistics into the database table - Functionality is included in Cumulus MX to do this either using the schema devised by Mark Crossley or your own
# The script needs to know the names of the columns it is to read from the database. Database designers talk about ''schema'' for the documentation that describes the design of the table, what the columns are called, and what type and size of variables they hold. For Cumulus 1, a script to create a database table, populate and update it from the daily summary log file is described in [[ImportCumulusFile|this Wiki article]]. There is some discussion in the forum about variants.
=== Some example Scripts ===
Look in the Website Development section of the Cumulus support forum - '''Web general''' sub forum:
*[http://sandaysoft.com/forum/viewtopic.php?f=14&t=15983#p122552 SQL dayfile data Viewer] - This script by Kocher shows selected statistics, you can scroll up and down through all available days and for those days (or all days) see some summary statistics at the foot of each column.
| |||