Visitor Tracking HttpModule

Last Update

11 November 2012

Regular License

$10

Sales

12

Product Description

This module is used in order to keep a each request parameters in the database for analysis. The main feature is that: the http module creates the item queue and executes a thread to process those items, so incoming request creates queue item and adds that item to the queue and continue without a big delay. In the same time queue thread saves each item in the database, so the incoming request doesn’t wait the completion of saving a tracking item in the database.

History V1.0 Released – November 10, 2012

Main Features

• HTTPModule Implementation (track visitors for any ASP .NET application) • MS SQL Server 2008 (possible compact edition 4.0) • MySQL 5.x (The InnoDB Storage Engine)

Requirements

• ASP .NET 4.0 • MS IIS 7 /6 • MS SQL Server 2008 (possible compact edition 4.0) • or MySQL 5.x (The InnoDB Storage Engine)

Package Content

SimpleTools.Libs – MySQL binary files for .NET 2.0/3.0/4.0 (To compile the module for different ASP .NET versions) SimpleTools.SQLScript – VisitorTracking table SQL script SimpleTools.VisitorTracking.Logic – Database logic SimpleTools.VisitorTrackingHttpModule – HttpModule logic

Install HttpModule

1. Execute VisitorTracking.sql script in your database (it will create the VisitorTracking table);

2. Copy to your app Bin directory the following files: MySql.Data.dll (SimpleTools.Libs/.NET4.0 or 2.0), SimpleTools.VisitorTracking.Logic.dll, SimpleTools.VisitorTrackingHttpModule.dll

3. Add the following configuration params to your application config file in order to save traking items in the database:

<!-- MS SQL Example: --> <appSettings> <add key="SimpleTools.VisitorTracking.Connetion.String" value="server=localhost\SQLEXPRESS;database=SimpleTools.YourApp;user id=SimpleTools.YourApp; password=SimpleTools.YourApp" /> <add key="SimpleTools.VisitorTracking.Database.Provider" value="MSSQL"/> </appSettings>

Or

<!-- MySQL Example: --> <appSettings> <add key="SimpleTools.VisitorTracking.Connetion.String" value="Server=localhost;Database=SimpleTools.YourApp;Uid=SimpleTools.YourApp;Pwd=SimpleTools.YourApp;Allow User Variables=true"/> <add key="SimpleTools.VisitorTracking.Database.Provider" value="MySQL"/> <appSettings>

...

<!-- For MS VS developmentserver --> <system.web> <httpModules> <add name="SimpleTools.VisitorTrackingHttpModule" type="SimpleTools.HttpModules.VisitorTrackingHttpModule" /> </httpModules> </system.web>

...

<!-- For production server --> <system.webServer> <validation validateIntegratedModeConfiguration="true"/> <modules> <add name="SimpleTools.VisitorTrackingHttpModule" type="SimpleTools.HttpModules.VisitorTrackingHttpModule" /> </modules> </system.webServer>

Please read article below to debug this module on MS Studio development server: http://stackoverflow.com/questions/2708187/vs2010-development-web-server-does-not-use-integrated-mode-http-handlers-modules

MySQL .NET Providers: ftp://mysql.sh.cvut.cz/mysqlDownloads/Connector-Net/