Statistics??

[mads]

Hi

Is there a way I can see how much time a specified user has used in the wiki?? or just some kind of Statistics of how much the wiki is used??

[AaronF]

"What's new" will show recent changes, you can subscribe to RSS feeds, and you also have: http://doc.opengarden.org/Special:Popularpages .

[mads]

"What's new" will show recent changes, you can subscribe to RSS feeds, and you also have: http://doc.opengarden.org/Special:Popularpages .

Yes I know and I use these functions every day.. they are very good.. But is there some way to collect the following:

- Total login time for a user?
- Total number of pages a specified user have written?

The managers in our company would like to know how much time people spent on writing documentation.
So it would be cool if I could export these information’s from the wiki and show them..

[AaronF]

I'll leave this one to SteveB. I know he wrote a stats service, but I'm not sure if this is in the Hayes release.

[SteveB]

I don't think we have a way of calculating currently the total login time.

For total pages written, it should be pretty easy. Just to clarify, by "written" to you mean "contributed" (i.e. a page was changed or created) or "created" (i.e. that person created the page)?

Also, did you notice that the recent changes feed now shows how many words were added or removed by each edit. At some point, I'd love to tally those numbers and associated them with users. So you'll immediately see how active individual users are.

[mads]

I don't think we have a way of calculating currently the total login time.

For total pages written, it should be pretty easy. Just to clarify, by "written" to you mean "contributed" (i.e. a page was changed or created) or "created" (i.e. that person created the page)?

Also, did you notice that the recent changes feed now shows how many words were added or removed by each edit. At some point, I'd love to tally those numbers and associated them with users. So you'll immediately see how active individual users are.

First it would be nice just to see "contributed" pages from the user. Second it would also be nice to se how many pages the user has changed.
But the last thing you mentions, where you are able to count words pr. user would also be really cool..

So do you have a script or something I can use to get these information's??

[SteveB]

The quickest way is to use the new MySql Live Data service. Create a read-only MySql user and initialize the MySql service with it. Then, create a new page to hold the results and add the following html code to it:

<pre class="live" function="mysql.table">SELECT user_name AS "User Name", (SELECT COUNT(*) FROM pages WHERE user_id = page_user_id) + (SELECT COUNT(*) FROM old WHERE user_id = old_user) AS "Total Edits" FROM users ORDER BY user_name</pre>

This will generate a table listing all users and how many pages they have edited.

[mads]

The quickest way is to use the new MySql Live Data service. Create a read-only MySql user and initialize the MySql service with it. Then, create a new page to hold the results and add the following html code to it:

<pre class="live" function="mysql.table">SELECT user_name AS "User Name", (SELECT COUNT(*) FROM pages WHERE user_id = page_user_id) + (SELECT COUNT(*) FROM old WHERE user_id = old_user) AS "Total Edits" FROM users ORDER BY user_name</pre>

This will generate a table listing all users and how many pages they have edited.

Okay cool... But I have never used the MySql Live Data service before, but I can create a new user by using PHPMyAdmin.. will that work?

Just to be sure.. does this work with Gooseberry++ ??

[SteveB]

No, sorry. That only works in Hayes. You could achieve something similar in Gooseberry++, but you'd have to modify actual code.

Do you need it in a hurry or can you wait for Hayes to roll out?

[mads]

No, sorry. That only works in Hayes. You could achieve something similar in Gooseberry++, but you'd have to modify actual code.

Do you need it in a hurry or can you wait for Hayes to roll out?

Okay.. year that depends on when Hayes rolls out??