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: [EMAIL PROTECTED] [mailto:analog-help-
> [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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
+------------------------------------------------------------------------
