openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rob Weir <robw...@apache.org>
Subject Re: Statistic data per single country
Date Mon, 01 Sep 2014 16:00:49 GMT
On Mon, Sep 1, 2014 at 11:38 AM, Vladislav Stevanovic
<stevanovicvladislav@gmail.com> wrote:
> Tom, thanks for tips. Just one question: When set up is like in this link
> below (just "Home", not particular version), what exactly is counted?
> http://sourceforge.net/projects/openofficeorg.mirror/files/stats/timeline
>  Downloads for all version of AOO with language packages or just downloads
> for all verison of AOO but just instalation files?

Everything in that directory:  /files

So to get all the Serbian versions you would need to look here:

http://sourceforge.net/projects/openofficeorg.mirror/files/4.1.1/binaries/sr/stats/timeline

And then for the 4.1.0, 4.0.1 and 4.0.0 directories, and so on.

A simpler approach, if you need only language-level detail and don't
need the breakdown by language and OS, is to use this tool:

https://svn.apache.org/repos/asf/openoffice/devtools/aoo-stats/detail-by-day.py

Also download the data file:
https://svn.apache.org/repos/asf/openoffice/devtools/aoo-stats/all.lst

Then you can run:

python detail-by-day.py all.lst 2012-05-07 2014-05-07 >out.csv

It will take a few hours to run, but you will get a CSV file with
download counts for each day.  There is a column for each language.

The output format will be similar to this file:

https://svn.apache.org/repos/asf/openoffice/devtools/aoo-stats/100m.csv

Regards,

-Rob


> Regards,
> Wlada
>
> 2014-08-31 22:38 GMT+02:00 Tal Daniel <tal.reads@gmail.com>:
>
>> On Fri, Aug 29, 2014, Vladislav Stevanovic wrote:
>>
>> > Hello,
>> > Is it possible to make some video tutorial how to get statistic  data
>> about
>> > AOO (downloads AOO per country)? For download statistic for Serbian, from
>> > begining (from 2012-05-07) and end day is 2014-05-07 .
>> > Regards,
>> > Wlada
>> >
>>
>> Here's one way to get statisticts on downloads:
>>
>> 1. Visit SourceForge's API:
>>
>> http://sourceforge.net/projects/openofficeorg.mirror/files/4.1.1/binaries/sr/stats/timeline
>> 2. change the dates in the input field (top-right)
>> 3. copy & paste into OpenOffice Spreadsheet.
>> 4. repeat steps 1–3 for every version released since 2012-05-07.
>> 5. sum up the counts :)
>>
>> Video? sorry, but I don't have the time to record it.
>>
>> Tal
>>

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org


Mime
View raw message