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? 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]
