On Wed, Mar 19, 2014 at 11:43 AM, Oliver-Rainer Wittmann <[email protected]> wrote: > 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. >
That must be it. If I filter my results to show only those who entered a comment then my script matches Rainer's results. Well, almost. I'm "off by 1" on the commenter count. For February I see: 99 people submitted 181 new bugs 181 people contributed 2513 comments Regards, -Rob > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
