I am trying to create a listing of most popular profiles and groups (Top 10 list) based on profile views and display profile view count to profile owner. I have found the ProfileViews count in the database, but all research in the forums to locate the proper token(s) to access this have turned up zero results.  Is there a token for this?

Where did you find the ProfileViews count? I found a ViewCount column in the activesocial_user table, but in my database it is showing what appears to be extremely low numbers compared to what I expect.

FYI - I used the following SQL query to find the column.

..and for those who prepend to the dnn tables to isolate them, you can change this to:

Posted By Ray Dixon on 15 Jan 2011 10:52 PM
Where did you find the ProfileViews count? I found a ViewCount column in the activesocial_user table, but in my database it is showing what appears to be extremely low numbers compared to what I expect.

FYI - I used the following SQL query to find the column.

SELECT t.name AS table_name,

SCHEMA_NAME(schema_id) AS schema_name,

c.name AS column_name

FROM sys.tables AS t

INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID

WHERE c.name LIKE '%view%' AND t.name LIKE '%activesocial%'

ORDER BY schema_name, table_name;

Hey Ray, how did you get this formatting in here? Did you just copy and paste html or are there groovy tags we can employ (i only know the quote tag)
thanks, drew..

I used the Format Code Block button on the editor toolbar. It is between the Horizontal Rule button and the Bold button.

ahh.. damn, i feel like my dad now, who asked rather than pushing buttons to find out how to do something  ;)  thanks!

You are correct.. it is the ViewCount column in the activesocial_user table. At it appears to be quite accurate from my testing. I wrote a perl script that logs in and views select profiles randomly during the day, it queries the database to get the current viewcount, then views the profile and queries again to see if it increments.. It has been spot on each and every time..

So how do we expose it for display? Could there please be a token...

Posted By drew curry on 16 Jan 2011 11:37 AM
ahh.. damn, i feel like my dad now, who asked rather than pushing buttons to find out how to do something  ;)  thanks!

LOL No worries. It's not an obvious button, until you know what to look for.

C Poole, thanks for the confirmation. I'll have to take a look at our data to see what's up with our numbers. One way to present this list is using the DNN Reports module that pulls from the active_social user table with an HTML visualizer.

Ok, but I actually want it to display on the profileview right under the EDIT PROFILE PIC link for the profile owner. This displays the text for the owner only but I still need the token or method of extracting it.

We haven't really released the profile stats feature yet. Yes, we are tracking views and few other items in preparation for when we release the Profile Stats feature. We did the same thing with Groups. We put the code in place so that we could gather some data and have something to show when it is actually released. We should be able to expose the view counter as a token in the next release.

Hmmm, Available tomorrow? Just kidding, glad to see you are working it, will that be 2.0?

Posted By Will Morgenweck on 16 Jan 2011 11:49 AM
We haven't really released the profile stats feature yet. Yes, we are tracking views and few other items in preparation for when we release the Profile Stats feature. We did the same thing with Groups. We put the code in place so that we could gather some data and have something to show when it is actually released. We should be able to expose the view counter as a token in the next release.

Is the ViewCount field a recent addition? If so, that would explain why the numbers seemed low on our site.

It will be in the next release. That could be 1.9.2 or 2.0, whichever comes first.


I think it was in the 1.8.x time frame.

Hey Will, we are at 1.9.3 these days... Is the ViewCount field available via a token yet?

How about an update Will?? ;) Trying a polite bump here..

Bumpin again.. Please update.

I spoke with Will, and I'm unsure if this will help your situation but it seems there are a lot of wonderful things regarding Active Social that's supposed to be released in January in a new DNN version. I feel like this is one of the reasons for a lack of response, as they are dealing with the core implementation.

Happy New Year!

- Patrick

Posted By Patrick on 28 Dec 2011 11:01 AM
I spoke with Will, and I'm unsure if this will help your situation but it seems there are a lot of wonderful things regarding Active Social that's supposed to be released in January in a new DNN version. I feel like this is one of the reasons for a lack of response, as they are dealing with the core implementation.

Happy New Year!

- Patrick

Patrick, I would really like to believe that this could be true that DNN 6.2.0 would release in January and be full of AS in the Core with a lot of wonderful things. But I was contacted by Will also and my interpretation was that the social collaboration in the core would follow a testing period much like DNN 6 did with 2 CTPs followed by 2 Beta releases. So I don't think it is possible to do all this release testing in the next four weeks. Maybe Will can clarify. Maybe he is referring to an AS 2.0 release in January with some of the added features. Only time will tell.