What is included

1. Heatmap solution

2. Script to create coordinates table

3. Scripts to create necessary stored procedures

What you will need to do

1. Add the solution to your Visual Studio projects

2. Run the table and stored procedure scripts and, if necessary, give proper access permissions to the stored procedures

3. Add the appropriate connection string to the web.config.

To begin testing, open Default.aspx. You will notice five buttons and a multiline textbox. The buttons are to test the jQuery unload call as well as the AJAX call to the webservice and the textbox will show you the click coordinates. Click around the page however many times you want and be sure to arbitrarily concentrate on a certain area here and there.

When you're finished clicking, open Plot.aspx and the heatmap will appear. If the heatmap does not appear, then check to see that the T_HeatMapCoordinates table has coordinates stored. If not, be sure that the AJAX call and the web service is working properly.

If the heatmap is now working, go and take a full screenshot of the webpage you would like to overlay the heatmap on. A quick and easy way of grabbing a shot of the entire web page is the FireFox extension ScreenGrab! or you could simply put your browser in full screen mode and Copy/Paste the image into an image editor and save it.

Save the screenshot to your project's directory and reference its location in the #heatmaparea class in the style.css.

Open Plot.aspx and the heatmap should plot over the screenshot image.

Last edited Jun 21, 2012 at 5:49 PM by jbates, version 3


jbates May 21, 2013 at 6:24 PM 
Download is back up.

jbates May 21, 2013 at 6:07 PM 

This is purely up to how you want to store the data and how often you want to either archive or remove it. Even if you are going to use this for an extended amount of time, you shouldn't have too much of a problem given that it is only storing x & y coordinates of mouse-clicks. We have used this application at my current place of employment and we've received and handled seamlessly over 250,000 hits a day with no problems.

I am working on a minor bug-fix at the moment and will re-enable the download as soon as I get everything in working order.

jbates May 21, 2013 at 6:04 PM 
I apologize for the lack of table scripts. I will get those up asap.

mdameron76 Mar 15, 2013 at 1:06 AM 
where is the sql script??????

poorpaddy Jan 4, 2013 at 10:30 PM 
Question, what are the storage implication for this on a site that receives roughly 25,000 visits per day? BTW, there doesn't appear to be any downloads for this.

dinc Jul 9, 2012 at 11:31 PM 
Hi, Very interested in testing this out, however I cannot find the script to create coordinates table in the downloads.