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"):
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
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]
