Glad to see me there. :)

Regards, Jee

On Thu, Feb 5, 2015 at 9:48 PM, Richard Farmbrough <richard@farmbrough.co.uk

wrote:

Who was most thanked?

On 5 February 2015 at 15:47, Fæ faewik@gmail.com wrote:

...

Hi,

After reading an interesting related discussion on GenderGap, I have queried the top 10 users of the thanks feature last month, on both the English Wikipedia and Commons. Snapshot image attached and report link below.

Perhaps someone might think of a suitable barnstar and award these folks for "being nice"? :-)

Link:

http://commons.wikimedia.org/w/index.php?title=User:F%C3%A6/sandbox&oldi...

...

P.S. This is a long query to run, taking 20 to 30 minutes due to the nature of the logging tables. However if someone wanted to make a monthly summary on-wiki somewhere, part of an active "be nice" campaign, I would be happy to set up an automated monthly report (if someone discovers this is already reported somewhere, that's cool we can use that).

Fae

faewik@gmail.com https://commons.wikimedia.org/wiki/User:Fae

---

Wikimedia-l mailing list, guidelines at: https://meta.wikimedia.org/wiki/Mailing_lists/Guidelines Wikimedia-l@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, mailto:wikimedia-l-request@lists.wikimedia.org?subject=unsubscribe

-- Landline (UK) 01780 757 250 Mobile (UK) 0798 1995 792 _______________________________________________ Wikimedia-l mailing list, guidelines at: https://meta.wikimedia.org/wiki/Mailing_lists/Guidelines Wikimedia-l@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, mailto:wikimedia-l-request@lists.wikimedia.org?subject=unsubscribe

Fæ, 05/02/2015 18:47:

Top 10*most thanked* users in Jan 2015:

English Wikipedia:

Looks like edit wars pay back in this rank.

Nemo

A good idea! I think "thanks divided by edit count" would be nice to see, too - that way power users and regular users can be compared!

Richard Symonds Wikimedia UK 0207 065 0992

Wikimedia UK is a Company Limited by Guarantee registered in England and Wales, Registered No. 6741827. Registered Charity No.1144513. Registered Office 4th Floor, Development House, 56-64 Leonard Street, London EC2A 4LT. United Kingdom. Wikimedia UK is the UK chapter of a global Wikimedia movement. The Wikimedia projects are run by the Wikimedia Foundation (who operate Wikipedia, amongst other projects).

*Wikimedia UK is an independent non-profit charity with no legal control over Wikipedia nor responsibility for its contents.*

On 5 February 2015 at 16:37, Risker risker.wp@gmail.com wrote:

On 5 February 2015 at 10:47, Fæ faewik@gmail.com wrote:

...

Hi,

After reading an interesting related discussion on GenderGap, I have queried the top 10 users of the thanks feature last month, on both the English Wikipedia and Commons. Snapshot image attached and report link below.

Perhaps someone might think of a suitable barnstar and award these folks for "being nice"? :-)

Link:

http://commons.wikimedia.org/w/index.php?title=User:F%C3%A6/sandbox&oldi...

...

P.S. This is a long query to run, taking 20 to 30 minutes due to the nature of the logging tables. However if someone wanted to make a monthly summary on-wiki somewhere, part of an active "be nice" campaign, I would be happy to set up an automated monthly report (if someone discovers this is already reported somewhere, that's cool we can use that).

Fae

This is interesting stuff, Fae - thanks for sharing, and for doing all the legwork to produce the report. It's a much more interesting metric than a lot of others that get collected! Perhaps colleagues on other projects might want to borrow the script and see the results there.

I'll admit to sharing Rich's curiosity about who was most thanked.

Risker/Anne _______________________________________________ Wikimedia-l mailing list, guidelines at: https://meta.wikimedia.org/wiki/Mailing_lists/Guidelines Wikimedia-l@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, mailto:wikimedia-l-request@lists.wikimedia.org?subject=unsubscribe

HI,

https://meta.wikimedia.org/wiki/User:Faebot/thanks

I have now set up a monthly report of the top 10 "thankers" / "thankees" with an index to the different project reports on the above link. These have been generated retrospectively for 2014 and I will shortly set this up on WMF labs to run at the beginning of each month to add last month's results.*

Thank you for this very interesting tool :-)

Regards.

Hi, an outcome of the old milgram experiments suggests that not always nice people do oppress others less:

http://m.mic.com/articles/92479/psychologists-have-uncovered-a-troubling-fea...

Rupert On Feb 25, 2015 8:31 AM, "Ricordisamoa" ricordisamoa@openmailbox.org wrote:

Thanks Fæ, those reports are very interesting from my perspective. However, even though the number of thanks received may be more reliable than the usual edit count, none of them could ever measure the invaluable impact of our contributors :-)

Il 23/02/2015 16:57, Fæ ha scritto:

...

https://meta.wikimedia.org/wiki/User:Faebot/thanks

I have now set up a monthly report of the top 10 "thankers" / "thankees" with an index to the different project reports on the above link. These have been generated retrospectively for 2014 and I will shortly set this up on WMF labs to run at the beginning of each month to add last month's results.*

Rather than running this automatically for several hundred projects, I am happy to add projects on request (so long as the thanks extension is being regularly used by more than 10 people!). Just drop a note on my meta talk page to request the addition. I have haphazardly picked 6 of the busiest projects to get started on, mainly as a multi-language test, not because I favour one language Wikipedia over another. :-)

Time for someone to create a "thank you barnstar of super thanks" ?

This is one of many ad-hoc reports run as Faebot, but if it becomes especially useful or critical to outreach projects I'll consider moving a stable version to a special bot account or similar.

• • At the time of writing, the tables for 2014 are being generated.

This may take the rest of the day to complete! If your project has recently been added, the reports might have to wait for the next monthly run depending on how much free wiki-time I have.

Fae

---

Wikimedia-l mailing list, guidelines at:https://meta.wikimedia.org/ wiki/Mailing_lists/Guidelines Wikimedia-l@lists.wikimedia.org Unsubscribe:https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, mailto:wikimedia-l-request@lists.wikimedia.org?subject=unsubscribe

---

Wikimedia-l mailing list, guidelines at: https://meta.wikimedia.org/ wiki/Mailing_lists/Guidelines Wikimedia-l@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, mailto:wikimedia-l-request@lists.wikimedia.org?subject=unsubscribe

Re:https://meta.wikimedia.org/wiki/User:Faebot/thanks

I am glad the tables are useful, hopefully stimulating more positive use of the thanks notifier by contributors.

The reports are updating *slowly*, currently at April 2014... This is in part because of the WMFlabs outage yesterday, though in general any report of the "logging" table is going to be slow (it is the largest table on the wiki database). The first run-through will take several days as it is going back through all of 2014. Once it is only reporting on the previous month, I suspect it will finish monthly updates within the first first day.

OPT-OUT There was an interesting debate about the report for the German Wikipedia,[1] with some users feeling it was intrusive or may introduce "competitive" use of thanks that could be negative. I suspect that many users of the thanks notifier may have been under the impression that the logs were not visible or public. I did not expect this to be contentious, so I am pleased that the extra cautious approach of only adding projects on request, means that I had time to add a global opt-out as a courtesy for individual users that contact me. I have decided to not report on the German Wikipedia thanks log unless there is a consensus from that community that they want to have it. :-)

Links: 1. https://de.wikipedia.org/wiki/Wikipedia_Diskussion:Kurier#Danke-Bot_listet_T...

Cheers, Fae

On 25 February 2015 at 13:30, Rodrigo Padula rodrigopadula@gmail.com wrote:

Excellent!!

Great initiative, congratulations!

Thank you for answering my request for inclusion of pt.wikipedia!

Best regards

Rodrigo Padula

2015-02-23 12:57 GMT-03:00, Fæ faewik@gmail.com:

...

https://meta.wikimedia.org/wiki/User:Faebot/thanks

I have now set up a monthly report of the top 10 "thankers" / "thankees" with an index to the different project reports on the above link. These have been generated retrospectively for 2014 and I will shortly set this up on WMF labs to run at the beginning of each month to add last month's results.*

Rather than running this automatically for several hundred projects, I am happy to add projects on request (so long as the thanks extension is being regularly used by more than 10 people!). Just drop a note on my meta talk page to request the addition. I have haphazardly picked 6 of the busiest projects to get started on, mainly as a multi-language test, not because I favour one language Wikipedia over another. :-)

Time for someone to create a "thank you barnstar of super thanks" ?

This is one of many ad-hoc reports run as Faebot, but if it becomes especially useful or critical to outreach projects I'll consider moving a stable version to a special bot account or similar.

• • At the time of writing, the tables for 2014 are being generated.

This may take the rest of the day to complete! If your project has recently been added, the reports might have to wait for the next monthly run depending on how much free wiki-time I have.

Fae

---

Wikimedia-l mailing list, guidelines at: https://meta.wikimedia.org/wiki/Mailing_lists/Guidelines Wikimedia-l@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, mailto:wikimedia-l-request@lists.wikimedia.org?subject=unsubscribe

---

Wikimedia-l mailing list, guidelines at: https://meta.wikimedia.org/wiki/Mailing_lists/Guidelines Wikimedia-l@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, mailto:wikimedia-l-request@lists.wikimedia.org?subject=unsubscribe

Now the run has been running a bit longer, it can be seen[1] that the real sink is the logging table from wikidata. Other projects are pretty quick from a few minutes to Commons taking half an hour. Wikidata takes 7 hours for each query. It's a big log!

I am testing out separating wikidata from the other queries, so this might get the majority done much more quickly. Either way, all the reports should be finished within about 3 days. After that the monthly updates should be done within an afternoon. :-)

Links 1. https://meta.wikimedia.org/wiki/Special:Contributions/Faebot

Fae

On 26 February 2015 at 06:02, MZMcBride z@mzmcbride.com wrote:

Fæ wrote:

...

Re: https://meta.wikimedia.org/wiki/User:Faebot/thanks

I am glad the tables are useful, hopefully stimulating more positive use of the thanks notifier by contributors.

The reports are updating *slowly*, currently at April 2014... This is in part because of the WMFlabs outage yesterday, though in general any report of the "logging" table is going to be slow (it is the largest table on the wiki database). The first run-through will take several days as it is going back through all of 2014. Once it is only reporting on the previous month, I suspect it will finish monthly updates within the first first day.

Hi.

Hmm, I'm not sure how you're measuring largest, but I imagine on most wikis there are more rows in the revision table than there are in the logging table. For example, on the English Wikipedia, there are approximately 598,859,006 rows in the revision table and 62,731,285 rows in the logging table. I suspect on most wikis, revision, text, and maybe archive would typically be larger than logging, except in weird cases such as loginwiki[_p]. And then of course there are the *links tables. But it depends on whether you're comparing size on disk or number of rows.

Yes I got it wrong! :-)

You probably want to use logging_userindex instead of logging. The former is typically significantly faster due to the way we use table views.

That's how it works. The key line is SELECT log_user_text, count(log_action) FROM {}wiki_p.logging_userindex

Where {} iterates over wiki short names.

I have a bit of experience with database reports. Off-hand I'd say it should be possible to query all of this information in under an hour. With the index on logging[_userindex].log_action, even a large table such as logging shouldn't be too awful to query for this information. If you have queries that are taking a very long time, we should probably investigate.

Maybe, I have experimented a little with ways of writing the query (such as using log_user rather than log_user_text) but have not found a magic trick yet. Remember I'm reporting all of 2014 first. After this first run, the time taken is unlikely to be noticed by anyone, so volunteer time vs. processing time will mean I'll probably get on with other projects, rather than spending my wiki-time making this SQL based report more efficient. Naturally, if someone wants to offer me some funding, or bribes me by nominating my Commons RFA, I'll look again. ;-)

Cheers, Fae

https://meta.wikimedia.org/wiki/User:Faebot/thanks

The 'Thanks report' is up and running again, after being out of action for the last few months. This seems down to time-outs when running the query for wikidata, along with Faebot being throttled on labs (now relaxed) and the more recent account problems needing rolling automated log-outs for everyone. The newest requested addition is the Outreach wiki.

See the meta page link above if you would like another wiki added (after making sure your community is happy with the idea), or want your account to be opted out of a current report.

Thanks, Fae

On 23 February 2015 at 15:57, Fæ faewik@gmail.com wrote:

https://meta.wikimedia.org/wiki/User:Faebot/thanks

I have now set up a monthly report of the top 10 "thankers" / "thankees" with an index to the different project reports on the above link. These have been generated retrospectively for 2014 and I will shortly set this up on WMF labs to run at the beginning of each month to add last month's results.*

Rather than running this automatically for several hundred projects, I am happy to add projects on request (so long as the thanks extension is being regularly used by more than 10 people!). Just drop a note on my meta talk page to request the addition. I have haphazardly picked 6 of the busiest projects to get started on, mainly as a multi-language test, not because I favour one language Wikipedia over another. :-)

Time for someone to create a "thank you barnstar of super thanks" ?

...