Could you please provide user names, like in earlier years?
Then I can plug the new data file into existing code.
Wikistats works with user names anyway, and later this month, when all dumps are in,
we also want to find user names that did not occur earlier on any wiki.
Cheers,
Erik
From: effeietsanders@gmail.com [mailto:effeietsanders@gmail.com] On Behalf Of Lodewijk Sent: Monday, October 01, 2012 11:00 PM To: Wiki Loves Monuments Photograph Competition Cc: Erik Zachte Subject: Re: [Wiki Loves Monuments] Statistics - list of usernames?
Erik, does this help you to help us? :)
Thanks,
Lodewijk
2012/10/1 Platonides platonides@gmail.com
On 01/10/12 19:04, Lodewijk wrote:
Hi all,
Like last year, we would like to run some statistics again. I know we're only very short after the competition, but could someone create a list of all usernames that participated in WLM2012? Erik Zachte would like to run some early stats on that. I realize we need to make corrections and all, but we can do that later and make the list again. If you could give the list in a csv/txt I think that would be most convenient.
Thanks a lot!
Lodewijk
time sql commonswiki_p "SELECT distinct wlm_author FROM u_platonides_wlm_p.wlm2012 WHERE wlm_source = 'commons' and wlm_author <> 0" > wlmUsers.txt
http://toolserver.org/~platonides/sandbox/wlmUsers.txt
They are user ids, not user names, but that's equivalent for the stats. Uploads from 123POI, flickr etc. are excluded from that list.
_______________________________________________ Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org