Smart Referrer Installation
Installing Smart Referrer for MS SQL Server Database
A. Contents of the zip file in the zip file you downloaded
You will find the following files:
- SmartReferrer.sql (SQL scripts for generating required tables and stored procedures)
- smart_Referrer.htm (sever side include file to be included in pages requiring monitoring)
- SmartReferrerAdmin.asp (Administration panel for pages to be monitored and referrer reports)
- Readme.txt (content similar to this page section)
B. Installation steps
- Important: Place the
smart_referrer.htm file anywhere convenient for you (since
it is to be used as an server side include file). Files
3,4 and 5 should be under the same folder e.g Admin folder.
- Important: To create
the required tables and stored procedures run the sql
scripts file (SmartReferrer.sql). You can also open the
file in Notepad, copy the contents of the file, paste
it into your SQL Server Query Analyzer, choose the correct
database into which you want the Referrer data to go to
and then run the queries.
Note: If your SQL Server Database owner is something else other than 'dbo' then replace 'dbo' with it in the .sql file before running it.
- Very Important NOTE:
All Monitored pages must be .asp files and buffering should
be turned ON. Hint: Place the following code right
at the beginning (1st line onwards) of your page.<%@LANGUAGE = "VBSCRIPT"%>
<% Option Explicit
Response.buffer = True %>
- Include the smart_Referrer.htm file as a server side
include(SSI) in all pages needing monitoring (recommended
at the bottom).
just add this code : <!--#include virtual="/your_folder_path/smart_Referrer.htm" -->
Note : Make sure the path is right.
- The Administration panel
is for activating, editing, deleting and deactivating
pages that need monitoring and accessing the reports.
Add the complete URL of the pages to be monitored in the
admin panel i.e., in SmartReferrerAdmin.asp. for eg. We
need to add http://www.smartwebby.com/default.asp for
our default page.
- Also view the referrers to your page in the SmartReferrerAdmin.asp
page. There are very comprehensive complete reports on
the hits to your page.
- Brief Report : Reports the total hits till date, This week's hits, Today's hits, Last recorded date's hits and Last recorded week's hits for the monitored page.
- Today's Report : Gives information on all the referrers that have monitored your page today.
- General Report : This report gives you the total hits till date, This week's hits, Today's hits, Last recorded date's hits and Last recorded week's hits for each of the referrers.
- No Hits Report : This report gives all the referrers that have not accessed you page today.
- Display of monitored and archived pages : Here you can see all the pages that are monitored and also the pages that are archived or deactivated.
- Important: To make
your SmartReferrer work you need to give the connection
string to your SQL Server Database in the smart_Referrer.htm
and SmartReferrerAdmin.asp pages. Open the code view of
this page and you will immediately find the following
lines clearly marked out for your convenience.
Substitute the following with your SQL Server database details, that would have been assigned to you when you bought the database space, as listed below:
- yourServerIPAddressOrName - this is your SQL Server database IPAddress or Name.
- yourUserID - your SQL Server database's User Name.
- yourPassword - your SQL Server database's Password.
- your SQL Server database Name.
If your database connection needs to be a DSN type then give your DSN name as an additional clause in the above connection string. Just replace 'yourSystemDSNName' or 'yourFileDSNName' according to your DSN type with your assigned DSN Name like in the example string below and place it in the code.
For a System DSN the connection string will be:
For a File DSN the connection string will be:
Good Luck and Best Wishes from the Smart Webby Team! If you have any problems or suggestions please contact us at firstname.lastname@example.org.
SmartWebby.com - 2001-2008 All Rights Reserved.
This product has been created by SmartWebby.com for free distribution.
We will not be held responsible for any unwanted effects due to the usage of this product or any derivative.
No warrantees for usability are given or implied.