On Fri, Jul 25, 2014 at 8:06 PM, Rob Weir wrote: > On Fri, Jul 25, 2014 at 11:35 AM, Tal Daniel wrote: > > Hi, is there a way to extend the stats page a bit? > > (http://www.openoffice.org/stats/countries.html) > > > > For example, I wish I could see these data: > > > > Component x Version matrix: > > Hebrew, Full Installation (4.1.0; Released Dec 2013): 23,000 downloads | > > (4.1.1; Aug 2014): 10,000 | ... > > > > Hebrew, Language Pack (4.1.0; Released Dec 2013): 34,000 downloads | > > (4.1.1; Aug 2014): 14,000 | ... > > > > > All that data is available. > > The python scripts that gather the data are in SVN here: > > https://svn.apache.org/repos/asf/openoffice/devtools/aoo-stats/ > > The one I use to gather the daily download stats is this one: > > > https://svn.apache.org/repos/asf/openoffice/devtools/aoo-stats/detail-by-day.py > > You also need the all.lst data file which is in the same directory: > > https://svn.apache.org/repos/asf/openoffice/devtools/aoo-stats/all.lst > > You invoke like this, specifying the date range of interest: > > python detail-by-day.py all.lst 2014-07-01 2014-07-25 >out.csv > > It outputs a csv file that you should redirect. > > If you know python that is a good start. Otherwise the SourceForge > API is a REST service, and you can query it with any language. > > You can also grab the details from our 100 million milestone here: > https://svn.apache.org/repos/asf/openoffice/devtools/aoo-stats/100m.csv > > But that is before the Hebrew translation. > > One idea to simplify this: I can volunteer to upload an updated CSV > file of the details whenever I update the stats file. If you can > write some case that generates an HTML page, or even just a <table> > from that CSV file, we can easily copy in the new totals. > > That is how this page is produced: > http://www.openoffice.org/stats/countries.html I have a script > that generates that entire page from the SourceForge data.
Thank you Andrea, Rob. First of all, it's great we have stats. I'll try to compare 4.1.1 future release downloads with past 4.1.0 download rates, using the SourceForge charts. If not sufficient, I'll look deeper into your script, Rob. Thanks! Tal
