[analog-help] Analyze CSV File

2007-09-17 Thread Raj Hungund 
Hey all, I was wondering if Analog can analyze CSV data.  We are getting
log files for another type of service.

The first line of the csv file are some field names:
REGION  PLAY_DATE   PLAY_TIME   ACCOUNT_NUMBER  PRODUCT PROVIDER
KEY TITLE

Is there a way for Analog to decipher this information and put it into a
web type report?

Thanks.

+
|  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
+

RE: [analog-help] Analyze CSV File

2007-09-17 Thread Raj Hungund 
Here's the full string:

REGION  PLAY_DATE   PLAY_TIME   ACCOUNT_NUMBER  MAC_ADDRESS
PRODUCT PROVIDERASSET_KEY   TITLE
AUSTIN  1-Jul-070:00:23 XX  XXX ProductName
X   Some Title

Thanks!

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Aengus
Sent: Monday, September 17, 2007 12:26 PM
To: Support for analog web log analyzer
Subject: Re: [analog-help] Analyze CSV File

Raj Hungund  wrote:
 I haven't tried it yet...just wondering if it could be done =)

 Should I just research custom logformatting?

You could post an example of the actual data. But just at a wild guess

LOGFORMAT (%j %y:%m:d %h:%n:%j %u %r %f %j %B)

might work (though I have no idea how your PLAY_DATE and PLAY_TIME
fields are laid out, so they probably won't match, and Analog might spit
out the referrer and Borwser fields because they aren't formatted
properly).

Logformats are documented at http://analog.cx/docs/logfmt.html

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
+

RE: [analog-help] Need Help w/ Apache Log

2007-09-07 Thread Raj Hungund 
Thanks Aengus.  Looks like that worked. 

Best,

-Raj 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Aengus
Sent: Thursday, September 06, 2007 5:58 PM
To: Support for analog web log analyzer
Subject: Re: [analog-help] Need Help w/ Apache Log

On Thursday, September 06, 2007 8:36 PM [EDT], Raj Hungund
[EMAIL PROTECTED] wrote:

 Hey guys...I can't get even the most simplest of log analysis working 
 for Apache/Analog

 Here's my logformat:

 LogFormat %h %v %u %t \%r\ %s %b \%{Referer}i\
 \%{User-Agent}i\ %{EOL_GEO_COUNTRY}n %{EOL_GEO_REGION}n 
 %{EOLUSERID}n combined


 75.32.62.215 forums..com - [04/Sep/2007:00:00:39 -0700] GET 
 /style/style.jsp HTTP/1.1 200 49170 
 http://forums..com/thread.jspa?messageID=12791910#12791910;
 Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; YPC 3.0.3)
 US TX CTL4D9B11078F08418A7ADF39A5524ACB46

 75.32.62.215 forums..com - [04/Sep/2007:00:00:42 -0700] GET 
 /recent-history.jspa?messageID=12791910 HTTP/1.1 200 1763 
 http://forums..com/thread.jspa?messageID=12791910#12791910;
 Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; YPC 3.0.3)
 - - -

 75.32.62.215 forums..com - [04/Sep/2007:00:00:42 -0700] GET 
 /resources/scripts/prototype/prototype.js HTTP/1.1 200 14503 
 http://forums..com/recent-history.jspa?messageID=12791910;
 Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; YPC 3.0.3)
 - - -


 I've tried to cut it down to just:
 75.32.62.215
 APACHELOGFORMAT (%s)

Is %s a valid marker in a httpd.conf LogFormat command? Shouldn't it be
%h in apache?

 When I try:
 75.32.62.215 forums..com
 APACHELOGFORMAT (%h %v)

 It kind of works.

Unless the logformat in your httpd.conf works out of the box you're
better off ignoring the APACHELOGFORMAT command, and just build an
analog LOGFORMAT from scratch.

LOGFORMAT (%s %v %j [%d/%M/%Y:%h:%n:%j] %j %r %j %c %b %f %B %j
%j
%u)

matches your sample logfile lines, and treats the last field
(%{EOLUSERID}n) as the UserID field - the Geo fields are ignored.

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
+

[analog-help] Combine IIS and Apache Logs

2007-09-07 Thread Raj Hungund 
Hi all.  We have a web report that analyzes IIS logs and we would like
to include Apache logs into it.
Is this possible or do I need to create a separate report?  
Currently we specify the logfile in the command line.


analog.exe -G +CLOGTIMEOFFSET -420 +F070902 +T070902
+Oc:\webs\reports\%y%M%D.html +CLOCALCHARTDIR
c:\webs\reports\charts\%y%M%D +CCHARTDIR charts/%y%M%D -d
+gC:\Webs\website.cfg c:\WebLogs\ex070902* c:\WebLogs\media\ex070902* 


Thanks.

+
|  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
+

[analog-help] Need Help w/ Apache Log

2007-09-06 Thread Raj Hungund 
Hey guys...I can't get even the most simplest of log analysis working
for Apache/Analog
 
Here's my logformat: 
 
LogFormat %h %v %u %t \%r\ %s %b \%{Referer}i\ \%{User-Agent}i\
%{EOL_GEO_COUNTRY}n %{EOL_GEO_REGION}n %{EOLUSERID}n combined
 

75.32.62.215 forums..com - [04/Sep/2007:00:00:39 -0700] GET
/style/style.jsp HTTP/1.1 200 49170
http://forums..com/thread.jspa?messageID=12791910#12791910;
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; YPC 3.0.3) US
TX CTL4D9B11078F08418A7ADF39A5524ACB46
 
75.32.62.215 forums..com - [04/Sep/2007:00:00:42 -0700] GET
/recent-history.jspa?messageID=12791910 HTTP/1.1 200 1763
http://forums..com/thread.jspa?messageID=12791910#12791910;
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; YPC 3.0.3) - -
-
 
75.32.62.215 forums..com - [04/Sep/2007:00:00:42 -0700] GET
/resources/scripts/prototype/prototype.js HTTP/1.1 200 14503
http://forums..com/recent-history.jspa?messageID=12791910;
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; YPC 3.0.3) - -
-
 

I've tried to cut it down to just:
75.32.62.215
APACHELOGFORMAT (%s) 

I get errors.  


When I try:
75.32.62.215 forums..com
APACHELOGFORMAT (%h %v) 

It kind of works.  


Any ideas?  Very strange results.  

Thank you.


+
|  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
+