Hello, John,

I am Takashi Nakamoto, a member of Japanese NLP. Once I posted some
mails about the event held in Japan to this list several years ago.
It has been long time since I last posted.

> I have a cron job that collects all the bouncer data every night, cleans 
> it up, and loads it into a MySQL database. That's where the graphs on 
> the Marketing Planet page etc come from.

It's very good to know.

> There's no reason why the cron job couldn't store the data on the OOo 
> website for other people to analyse.

Could you allow me read-only access to that MySQL database?
I'm not sure it is possible. If it is impossible unfortunately due to
a security reason or something else, then, could you make some query
forms to investigate download counts?

I would like to know the download counts for Japanese edition and
compare to the other ones.  In addition, I also want to analyze more
details of download counts. For example, I want to know transition of
download counts between two specified days to check the efficiency of
our announcements and events.

Even now we can analyze such data by reading the bouncer logs, but, you
know, it doesn't make sense because it is very slow to scan all bouncer
logs each time we inquire.

Best regards,
-- 
Japanese Native-Language Project
Takashi NAKAMOTO <[email protected]>

On Mon, 18 May 2009 21:37:11 +0100
John McCreesh <[email protected]> wrote:

> Takashi NAKAMOTO wrote:
> > Hello, Cor,
> > 
> > On Sat, 16 May 2009 21:39:28 +0200
> > Cor Nouws <[email protected]> wrote:
> > 
> >> Hi Takashi,
> >>
> >> Takashi NAKAMOTO wrote (16-5-2009 21:04)
> >>> Hello, all,
> >>>
> >>> I would like to know how many downloads are carried out for each
> >>> localized version. Do you have charts or download counters for
> >>> localized versions?
> >>> [...]
> >> You can find data here.
> >> http://openoffice.bouncer.osuosl.org/logstats/20090515/
> >> And so on.
> >> [...]
> > 
> > I know there they are. Once I investigated the download counts of 3.0
> > Japanese edition, I referred to those logs.
> > 
> > I just want to know if there are such charts or download counters or
> > not. If they already exist, I don't make duplication of work and will
> > just check them. It is the easiest way. Unfortunately, if they don't,
> > then, I will collect the download data from the bouncer log of
> > localized versions, make fancy charts or tables and open them to all
> > of you. Investigating all localized versions is not a big deal compared
> > to the same investigation only for Japanese because their data are
> > stored in the same format.
> > 
> >> I once asked - with the same Idea in mind as you describe - if there is 
> >> a way to easily get cumulative data for one localized version.
> >> But alas that did not lead to a solution.
> > 
> > As you asked the similar question before, it didn't seem that there is
> > an easy way to observe the cumulative data like nice charts on our
> > marketing project website. In this case, I will make things like
> > the charts for localized versions.
> > 
> > If you have any other useful information, please let me know.
> 
> I have a cron job that collects all the bouncer data every night, cleans 
> it up, and loads it into a MySQL database. That's where the graphs on 
> the Marketing Planet page etc come from.
> 
> There's no reason why the cron job couldn't store the data on the OOo 
> website for other people to analyse.
> 
> John
> -- 
> John McCreesh - Marketing Project Lead - OpenOffice.org
> Developers - join us! see http://council.openoffice.org/developers.html
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to