Takashi NAKAMOTO wrote:
Hello, John,
On Wed, 20 May 2009 08:23:21 +0100 (BST)
"John McCreesh" <[email protected]> wrote:
On Mon, May 18, 2009 23:02, Takashi NAKAMOTO wrote:
[snip]
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.
The cleaned download files by month are now available on
http://marketing.openoffice.org/bouncer<yyyy><mm>.csv
e.g.http://marketing.openoffice.org/bouncer200905.csv for the current
month's data
Thanks to Bernhard's indication, I successfully checked what you
actually uploaded.
(Unfortunately, I failed to see that page, too. I don't know why.)
If this is what you need, please let me know and I can set up a cron to
update them daily
Great! It's clean and doesn't have any garbage like what bouncer logs
have. And it is very good for us because we can open this file by Calc
and make fancy charts easily by ourselves.
Then, could you set up the cron please? I would like to use such CSV
fils for localized marketing analysis.
Hopefully, I want to have a direct access to the MySQL database because
scanning CSV files might be also slow. Anyway, I can start with CSV
files for the meanwhile.
Best regards,
Oops, a little typo, they're in a /bouncer/ directory:
http://marketing.openoffice.org/bouncer/<yyyy><mm>.csv
e.g.http://marketing.openoffice.org/bouncer/200905.csv for the current month
I'll set the cron running - just need to remind myself how to do date
arithmetic in bash :-)
I'm not too keen on opening up my firewall for MySQL access via the
internet - could you load the csv's into MySQL (or Base) on your own PC?
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]
