[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

10/02/2009 at 02:07PM PDT, ID: 24781579
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.3

How do I keep my Google Mini from messing up my download statistics?

Asked by BYU-Studies in Programming for ASP.NET, Search Engines, Internet Search Engine Optimization

Tags: ASP.NET, Google Mini, HTML, SQL

Every time someone clicks on a pdf article on my site, I make an entry in the Download table with the article number and the time the article was downloaded so that I can keep stats (like top 10 articles downloaded). The problem is that I have a Google mini (hardware) in my server rack that crawls my site every night, and every time it hits one of my article links, it adds an entry into my Download table, so now my stats are worthless. How can I recognize when it's the Google Mini crawling my site so that I don't make an entry into my Download table?

Here's the code for recording a download. When the pdf link is clicked, it hits a download page, records the download, then immediately redirects to the pdf.
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
Partial Class articleDownload
    Inherits System.Web.UI.Page
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim aArticle As New Article
        Dim aDownload As New Download
        Dim aTitleID As String
        aTitleID = Request.QueryString("title")
        aArticle.load(aTitleID)
 
        Dim downloads As Integer = aArticle.getDownloads()
        downloads = downloads + 1
        aArticle.setDownloads(downloads)
 
        'Saves the updated download information for the article to the DB'
        aArticle.sendUpdateToDb()
        aDownload.recordDownload(aTitleID)
 
        Response.Redirect("PDFLibrary/" & Request.QueryString("linkURL"))
        aArticle.dispose()
 
    End Sub
End Class
 
 
 
 
    'records to the database that a title has been downloaded
    Public Sub recordDownload(ByRef titleId As Integer)
        _titleIdFk = titleId
        conn = New SqlConnection(connString)
        cmd = New SqlCommand("INSERT INTO _Download(downloadId, titleIdFk, dateTime) Values(@downloadId, @titleIdFk, @dateTime)", conn)
        cmd.Parameters.Add(New SqlParameter("@downloadId", SqlDbType.Int))
        cmd.Parameters("@downloadId").Value = CreateID.GetNextID("_Download")
        cmd.Parameters.Add(New SqlParameter("@titleIdFk", SqlDbType.Int))
        cmd.Parameters("@titleIdFk").Value = getTitleIdFk()
        cmd.Parameters.Add(New SqlParameter("@dateTime", SqlDbType.DateTime))
        cmd.Parameters("@dateTime").Value = DateTime.Today.Now
 
        Try
            conn.Open()
            cmd.ExecuteNonQuery()
        Finally
            cmd.Dispose()
            conn.Close()
        End Try
    End Sub
End Class
 
Keywords: How do I keep my Google Mini from me…
 
Loading Advertisement...
 
[+][-]10/07/09 06:47 PM, ID: 25521868

View this solution now by starting your 30-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Programming for ASP.NET, Search Engines, Internet Search Engine Optimization
Tags: ASP.NET, Google Mini, HTML, SQL
Sign Up Now!
Solution Provided By: Solar_Flare
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20090824-EE-VQP-74 - Hierarchy / EE_QW_3_20080625