generating reports

we are in the process of developing reports
like page visits,entry page etc

unique visitors

this is a screen shot of the report showing the unique visitors to the site being monitored.

reports

we have started generating different reports that our tool requires.

Column name in postgre SQL

In postgre SQL if we give column name like userId,it will look for userid and we will get error:
ERROR: column "userid" does not exist

To avoid this error ,give column name in lower cases

ScreenShot of first version of loginpage

progress so far

We have set up the filter.
We have connected to a postgres datase and logged the
relevant details into a table.
We have started work on the report generating part of
the tool.

Apache Tomcat

Apache Tomcat is the servlet container that is used in the official Reference Implementation for the java servlet and JSP technologies.We are using tomcat 5.5

Filter mapping

Tomcat Filter

A filter dynamically intercepts requests and responses to transform or use the information contained in the requests or responses.

Logging data into database

We are using a tomcat filter to capture requests made to the
site .Then we log this data into a database table.

Filter or AccessLogValve

We have been studying about using filters to log the requests and collect the required data so that it can be entered into a database.Another alternative is to use the AccessLogValve in Tomcat so
that log files can be created and it can be used to enter the values into the database.

SRS version1.0

we have come out with our first version of
the requirements

Project Discussion

On friday(16/02/2007) we had discussion with R Ajith Kumar
and Praveen Kumar.
We decided to start work on the SRS for our webanalytical tool