Alaska Software Inc. - WAA Statistics
Username: Password:
AuthorTopic: WAA Statistics
Phil Ide
WAA Statistics
on Wed, 25 Aug 2004 14:18:44 +0100
In another NG (bugreport?) I posted an HTML page showing an anlysis of the
WAA logs. This displayed data in several layers with the top layer giving
summary information and the lower layers showing statstics at the package
and then the form-function level.

The application I used to generate these statistics is written in Xbase++
(of course), is very fast and command-line driven (so it can be called by
Windows Scheduler).

I'm looking for a few people to play with it and give me some feedback
before I release it.

Regards,

Phil Ide

***************************************
* Xbase++ FAQ, Libraries and Sources: *
* goto: http://www.idep.org.uk/xbase  *
***************************************

A wise man never plays leapfrog with a unicorn
Robert MajorRe: WAA Statistics
on Wed, 25 Aug 2004 12:40:02 -0400
Hi Phil,

I much liked your (disgustingly) fast Perl version but I
will be glad to try out your Xbase++ version.

Robert
Phil Ide
Re: WAA Statistics
on Thu, 26 Aug 2004 09:31:16 +0100
Robert,

> I much liked your (disgustingly) fast Perl version but I
> will be glad to try out your Xbase++ version.

Sent by email - you'll find it a lot more powerful in the stats it
produces.

Regards,

Phil Ide

***************************************
* Xbase++ FAQ, Libraries and Sources: *
* goto: http://www.idep.org.uk/xbase  *
***************************************

Morals for sale, never used. Contact Bill Clinton.
Robert MajorRe: WAA Statistics
on Thu, 26 Aug 2004 08:48:12 -0400
Hi Phil,

All I can say is WOW !!

Your generated html page is simply amazing -- I will need to
study carefully how you create those "snazzy" tabbed table
displays.

The stats are very useful and I can already see that some
package functions may need to be tweaked.

Overall, it's the kind of excellence in programming we have
come to expect from you (and how you keep the rest of us oh
so humble ).

The only thing that threw me is that once webstats.exe
completes, nothing happens.  I guess I expected the page to
be displayed.  I may add a runshell to start IE to display
waastats.htm.

Many thanks.

Robert
Phil Ide
Re: WAA Statistics
on Fri, 27 Aug 2004 10:53:58 +0100
Robert,

> All I can say is WOW !!

Thank you <blush>.

> Your generated html page is simply amazing -- I will need to
> study carefully how you create those "snazzy" tabbed table
> displays.

It's very simple.  For the tabs themselves, simply create a table.  Each
cell has border attributes set for top, left and right but not bottom.  The
cell itself has an onClick event which calls a javascript function (more
about this in a moment).

The data itself is all embedded on the page, but the display attribute is
set to 'none', which tells the browser not to display it (i.e. hide it).

When you click on a tab, the function changes the background colour of two
of the 'tab' cells - the currently highlighted one and the one you just
clicked, so that the correct one is highlighted.  It then sets the display
attribute of the data currently displayed to 'none' to hide it, and the new
data section has the display:none attribute removed.

Couldn't be simpler 

> The stats are very useful and I can already see that some
> package functions may need to be tweaked.
> 
> Overall, it's the kind of excellence in programming we have
> come to expect from you (and how you keep the rest of us oh
> so humble ).

Thanks to Thomas, I've included some new ideas and have added a few more on
top of that.  The next version will be much easier to use since it will
automatically handle copying of the data from db\ to db\current and back
again.

> The only thing that threw me is that once webstats.exe
> completes, nothing happens.  I guess I expected the page to
> be displayed.  I may add a runshell to start IE to display
> waastats.htm.

Yes, this is deliberate. I wrote it specifically with the intention of
running it from Windows Scheduler.  I have a batch file which calls
webstats and then copies waastats.html to the intranet.

Regards,

Phil Ide

***************************************
* Xbase++ FAQ, Libraries and Sources: *
* goto: http://www.idep.org.uk/xbase  *
***************************************

Keyboard not found...THINK F1 to continue.
Phil Ide
Re: WAA Statistics
on Fri, 27 Aug 2004 10:56:29 +0100
Robert,

> The only thing that threw me is that once webstats.exe
> completes, nothing happens.  I guess I expected the page to
> be displayed.  I may add a runshell to start IE to display
> waastats.htm.

Thinking about this, I'll add an option to toss the page at the registered
web browser - or even launch the page as an HTA application.

Regards,

Phil Ide

***************************************
* Xbase++ FAQ, Libraries and Sources: *
* goto: http://www.idep.org.uk/xbase  *
***************************************

The gene pool could use a little chlorine.
Bruce AndersonRe: WAA Statistics
on Thu, 26 Aug 2004 10:10:37 -0500
I will be honored to try it. I need the light.
Bruce Anderson
Phil Ide
Re: WAA Statistics
on Fri, 27 Aug 2004 10:55:01 +0100
Bruce Anderson,
> I will be honored to try it. I need the light.
> Bruce Anderson

I shall mail you a copy as son as I have updated the docs - the setup and
configuration and the way it is run have changed.

Regards,

Phil Ide

***************************************
* Xbase++ FAQ, Libraries and Sources: *
* goto: http://www.idep.org.uk/xbase  *
***************************************

In case of rapture, please grab the wheel.
Phil Ide
Re: WAA Statistics
on Tue, 31 Aug 2004 15:25:39 +0100
All,

An update for all you wonderful testers out there.  The next version is
coming along well, with only a few scripting bugs to sort out.
Enhancements and fixes came from suggestions by you, with some some
particularly helpful ones from Thomas:

1. Configuration is now not done on the command-line, but by using an INI
file.

2. Internationalisation is now better, and you can change the character set
for the HTML page in the INI file (the default is now ISO-8859-1, which
should be good for most countries using roman fonts)

3. Text is now rendered using 'em' sizes, allowing for better scaling

4. HTML template is now embedded as a resource, (and has been greatly
modified)

5. Multiple servers are now handled properly, so you get a seperation
between the statistics for each server

6. Now automatically handles saving, backing up and restoring of imported
data, and defaults to a temporary import for the current months data

7. You can optionally create the resulting page as an HTML document or as
an HTA application

8. You can optionally have the resulting page automatically launched on
completion

9. You can change (via the INI file) the target (HTML/HTA) file name and
location, the document title and the page heading

10. You can generate the report without importing (new) data

In order to achieve all this, particularly the seperation of statistics for
individual servers, some major changes were necessary.  In particular, a
class has been introduced to handle data at the server level.  Also the
code which generates the HTML has necessarily become much more complex, and
additional JavaScript has been necessary.

Regards,

Phil Ide

***************************************
* Xbase++ FAQ, Libraries and Sources: *
* goto: http://www.idep.org.uk/xbase  *
***************************************

If it ain't broke yet, let me have a shot at it.
Phil Ide
Re: WAA Statistics
on Wed, 01 Sep 2004 11:43:47 +0100
All,

> An update for all you wonderful testers out there.  The next version is
> coming along well, with only a few scripting bugs to sort out.

I also forgot to mention that the tables are left-justified rather than
centered, to stop the tabs from jumping around the screen.

I believe I've now fixed all the bugs, so I'm just updating the docs.

Regards,

Phil Ide

***************************************
* Xbase++ FAQ, Libraries and Sources: *
* goto: http://www.idep.org.uk/xbase  *
***************************************

I came, I saw, I confused.