[analog-help] Analyze CSV File

[Aengus]

Aengus <analog07 at eircom.net> wrote:
> Raj Hungund <RHungund at comcastnets.com> wrote:
>> Here's the full string:
>>
>> REGION PLAY_DATE PLAY_TIME ACCOUNT_NUMBER MAC_ADDRESS
>> PRODUCT PROVIDER ASSET_KEY TITLE
>> AUSTIN 1-Jul-07 0:00:23 XXXXXX XXXXXXX ProductName
>> XXXX XXXXX Some Title
>
> Which fields do you actually care about? Do you care about the Region?
> Do you need both Account Number and MAC address? What's the different
> between Product and Title?
>
> If I throw away the Region field, and use the Account number as the
> User field, the Product as the Virtual Host field, and the Title
> field as the Request field, I get something like this:
>
> Region:  %j

You can report on the Regions as well by using the Browser report. Use 
%B instead of %j

> Play_Date:  %d-%M-%y
> Play_Time:  %h:%n:%j
> Account Number:  %u
> MAC Address:  %j
> Product:  %v
> Provider:  %j
> Asset_Key:  %j
> Product Name:  %r

Add these lines to your analog.cfg:

LOGFORMAT (REGION%j)
LOGFORMAT (%B\t%d-%M-%y\t%h:%n:%j\t%u\t%j\t%v\t%j\t%j\t%r)
LOGFILE cvs.log

REQFLOOR 1r
USER ON
VHOST ON
VHOSTFLOOR 1r
VHOSTSORTBY requests   (**** I had this wrong in the original message)
FULLBROWSER ON
FULLBROWFLOOR 1r
FULLBROWSORTBY requests


You can turn off any reports that aren't useful.

Analog.cx/docs/hierreps.html
Analog.cx/docs/timereps.html
Analog.cx/docs/othreps.html

Aengus