On Fri, Jul 25, 2014 at 11:35 AM, Tal Daniel <[email protected]> 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. Regards, -Rob > > and ... > Hebrew, Full Installation timeline (month by month download/installation > counts) > Hebrew, Language Pack timeline (month by month download/installation counts) > > This would allow me/us to see whether good translation improves downloads, > and whether people appreciate our work and upgrade AOO, or... abandon AOO. > > I believe this could be done using Google Analytics, and then share a link > to viewing the [public] data, instead of updating the stats page. > > Tal --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
