[prev in list] [next in list] [prev in thread] [next in thread] 

List:       analog-help
Subject:    RE: [analog-help] Cumulative reports
From:       "Jeremy Wadsack" <jeremy () 7simplemachines ! com>
Date:       2006-12-06 17:32:38
Message-ID: 5A0B1FEE2FDB6242AD55AAFCCA58B3D7198618 () bagheera ! ssm ! local
[Download RAW message or body]

You can use

	OUTPUT COMPUTER
	COMPSEP ,

If you want to send output to a comma-separated-value format for further analysis in \
Excel. However, the COMPUTER output format is meant to be read by a machine and is \
slight cryptic:

	http://analog.cx/docs/computer.html

If you have a relatively recent version of Excel you can open HTML files in it, which \
is probably your best bet. Just use the normal HTML output and then open from the \
File menu in Excel. It will convert all the tables to cells in the spreadsheet and \
will preserve the formatting and charts (although the charts will just be images -- \
not Excel charts, of course).

--
 
Jeremy Wadsack
Seven Simple Machines


> -----Original Message-----
> From: analog-help-bounces@lists.meer.net [mailto:analog-help-
> bounces@lists.meer.net] On Behalf Of Jeanne Ilchuk
> Sent: Wednesday, December 06, 2006 7:07 AM
> To: Support for analog web log analyzer
> Subject: Re: [analog-help] Cumulative reports
> 
> Thanks for responding so quickly, as I took another look at the error
> messages and analog couldn't find my cfg file.  When we moved from
> linux to sun, the file locations changed.  I have the cache files for
> the past few years.  I ran a directory report.  I'll get back to you -
> I'm having problems reading the output into excel, which is what the
> client wants.  I may need help with that.  I want to run a few more
> test with the data.
> 
> Jeanne
> 
> Aengus wrote:
> > On Wednesday, December 06, 2006 6:14 AM [EDT],
> > Jeanne Ilchuk <ilchuk@wrlc.org> wrote:
> > 
> > > Can the cache files be used for text delimited reports ?
> > 
> > If you can generate the output with ordinary log files, you can generate
> > it with cache files.
> > 
> > > I'm not
> > > getting any results.  I may have my statements incorrect.  Do you have
> > > any examples ?
> > 
> > There isn't a "how-to" document for cache files. As with any aspect of
> > Analog, it's always a good idea to start simple, with a small logfile.
> > 
> > A very simple example is to create a cache file from the sample logfile
> > that comes with Analog:
> > 
> > First, create the cace file:
> > analog logfile.log +C"cacheoutfile cache1"
> > (this also creates the default Report.html).
> > 
> > Then run Analog against the cache file:
> > analog +C"cachefile cache1" +Ocache.html
> > 
> > If you look at cache.html (created from a cache file) and Report.html
> > (created from logfile.log), you'll see that they are basically the same
> > report, even though th cache file is less than one third the size of the
> > logfile.
> > 
> > Aengus
> > +-----------------------------------------------------------------------
> -
> > > TO UNSUBSCRIBE from this list:
> > > http://lists.meer.net/mailman/listinfo/analog-help
> > > 
> > > Analog Documentation: http://analog.cx/docs/Readme.html
> > > List archives:  http://www.analog.cx/docs/mailing.html#listarchives
> > > Usenet version: news://news.gmane.org/gmane.comp.web.analog.general
> > +-----------------------------------------------------------------------
> -
> 
> 
> +------------------------------------------------------------------------
> > TO UNSUBSCRIBE from this list:
> > http://lists.meer.net/mailman/listinfo/analog-help
> > 
> > Analog Documentation: http://analog.cx/docs/Readme.html
> > List archives:  http://www.analog.cx/docs/mailing.html#listarchives
> > Usenet version: news://news.gmane.org/gmane.comp.web.analog.general
> +------------------------------------------------------------------------

+------------------------------------------------------------------------
> TO UNSUBSCRIBE from this list:
> http://lists.meer.net/mailman/listinfo/analog-help
> 
> Analog Documentation: http://analog.cx/docs/Readme.html
> List archives:  http://www.analog.cx/docs/mailing.html#listarchives
> Usenet version: news://news.gmane.org/gmane.comp.web.analog.general
+------------------------------------------------------------------------


[prev in list] [next in list] [prev in thread] [next in thread]