Re: [PROPOSAL] Enhance Statistics
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
[PROPOSAL] Enhance Statistics
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 | ... 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
Re: [PROPOSAL] Enhance Statistics
On 25/07/2014 Tal Daniel wrote: Hi, is there a way to extend the stats page a bit? (http://www.openoffice.org/stats/countries.html) That page is simply a static version of the full statistics that you can find here: http://sourceforge.net/projects/openofficeorg.mirror/files/4.1.0/stats/timeline You can change file and restrict statistics to what you prefer. Hebrew, Full Installation timeline (month by month download/installation counts) Something like this: http://sourceforge.net/projects/openofficeorg.mirror/files/4.1.0/binaries/he/Apache_OpenOffice_4.1.0_Win_x86_install_he.exe/stats/timeline?dates=2014-01-01+to+2014-07-25 but with the API (link at the bottom of that page) you can extract and aggregate more information. This is what the website scripts do. Regards, Andrea. - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
Re: [PROPOSAL] Enhance Statistics
On Fri, Jul 25, 2014 at 11:35 AM, Tal Daniel tal.re...@gmail.com 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: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
