Hi,
On 18.03.2014 16:26, Rob Weir wrote:
On Wed, Mar 12, 2014 at 4:41 AM, Rainer Bielefeld
<[email protected]> wrote:
Hi all,
May be you are interested to know how who are the most active bug wranglers
in Bugzilla?
Because my scripting skills are not very good I used AOO Calc to find out
with following steps (something "quick and dirty"):
We should think of what stats we want. I can help with scripting it in Python.
1) Maybe a monthly summary, count of new bugs, closed bugs, etc.,
categorized by product. Also total comments, count of volunteers
contributing.
2) Highlight the bugs with most activity that month
3) Volunteers with most new bug reports
4) Volunteers with most comments/activity
0
Downloaded<https://mail-archives.apache.org/mod_mbox/openoffice-issues/201402.mbox>
1 Copied to a .csv
2 opened document in AOO Calc
3 Filtered for "--- Comment #" to find comment headings
4 Copied visible rows to new sheet
5 Deleted all until "From": Regular expressions find ".*from"
and replace with nothing
6 Delete anything behind name: Regular expressions find "<.*"
and replace with nothing
7 Copy to new table and sort
8 Filter for "not empty – no duplicates"
9 Behind every visible contents "=COUNTIF(A$1:A$3000;A1)"
(Example for row 1)counts number of duplicates
10 Copy to empty text documents and replace
tabulators by blanks for posting here
The result (only contributors with more than 3 comments) for February 2014:
Comments / Name
---------------
824 Edwin Sharp
294 Rainer Bielefeld
174 Armin Le Grand
142 Oliver-Rainer Wittmann
126 SVN Robot
089 Andre
051 hanya
041 [email protected]
041 [email protected] ---
035 Marcus
035 Regina Henschel
034 Ariel Constenla-Haile
025 [email protected] ---
023 zhaoshzh
022 Sam Jennings
018 V Stuart Foote
017 [email protected] ---
016 Andrea Pescetti
016 Thorsten Wagner
015 brinzing
014 liuping
013 Clarence GUO
012 jolatt
012 Rob Weir
011 [email protected] ---
011 Yuri Dario
010 bmarcelly
010 [email protected] ---
009 Kevin Chilton
009 lauhub
009 [email protected] ---
007 [email protected] ---
007 oooforum
007 Raphael Bircher
007 richlv
007 snoff
006 Apostolos Syropoulos
006 behnoosh
006 [email protected] ---
006 jmpoo
006 John
006 Shenfeng Liu
006 slacka
005 Aivaras Stepukonis
005 Andreas S=C3=A4ger
005 [email protected] ---
005 beckyfiedler
005 digulla
005 [email protected] ---
005 Jon Peli Oleaga
005 JP CASSOU
004 Akriti
004 bnjroo
004 [email protected] ---
004 Kay
004 Kim Tidwell
004 laura h
004 Oukcha
004 schlocke
004 SharPorz
004 Sreedevi
004 sworddragon
004 trebly
004 veathako
Some more statistics for February:
---------------------------------
2513 Comments
180 Commenters
I'm getting different results, though using a Python script, perhaps
with different assumptions.
I took all the posts from the February mbox for
[email protected]. I rejected ones that were release
blocker processing issues, the ones starting with "review" or
"4.1.0_release_blocker" in the subject.
For the remaining I looked at the "X-Bugzilla-Who" header to get the
name of the person who changed the BZ issue.
This gives me 3295 changes, from 228 people, more than what you have.
My top 10 list is:
[email protected]: 1020
[email protected]: 406
[email protected]: 212
[email protected]: 175
[email protected]: 126
[email protected]: 108
[email protected]: 90
[email protected]: 79
[email protected]: 62
[email protected]: 51
Maybe I'm counting more than comments and new issue reports? What
changes do not require a comment? Changing the priority of an issue,
for example?
Often, I add myself to or remove myself from CC without any comment.
For my review of issues fixed for AOO 4.1.0 I also just changed the
Target Milestone field.
Just my observations.
Best regards, Oliver.
Regards,
-Rob
Problems:
------------
New reports are not in the statistics, not a real problem, but my time was
too limited. Hope I did not integrate too many fallacies into my
calculations ;-)
Best regards
Rainer
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
