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
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.
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
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
On 01/10/12 23:06, Erik Zachte wrote:
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
I use userids for tracking who was each user, because they sometimes provide different "pretty names" (I show the name they provided in the page).
There go commons usernames:
time sql commonswiki_p "SELECT DISTINCT user_name FROM u_platonides_wlm_p.wlm2012 JOIN user ON (user_id=wlm_author) WHERE wlm_source = 'commons';" > wlmUsernames.txt
http://toolserver.org/~platonides/sandbox/wlmUsernames.txt
Or if we restrict to valid submissions (182 users less):
time sql commonswiki_p "SELECT DISTINCT user_name FROM u_platonides_wlm_p.wlm2012 JOIN user ON (user_id=wlm_author) WHERE wlm_source = 'commons' AND wlm_status='Participating';" > wlmParticipatingUsernames.txt
http://toolserver.org/~platonides/sandbox/wlmParticipatingUsernames.txt
I think it is fair to restrict to valid participants and thus the second list. Erik, I hope this helps :)
Thanks both!
Lodewijk
2012/10/2 Platonides platonides@gmail.com
On 01/10/12 23:06, Erik Zachte wrote:
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
I use userids for tracking who was each user, because they sometimes provide different "pretty names" (I show the name they provided in the page).
There go commons usernames:
time sql commonswiki_p "SELECT DISTINCT user_name FROM
u_platonides_wlm_p.wlm2012 JOIN user ON (user_id=wlm_author) WHERE wlm_source = 'commons';" > wlmUsernames.txt
http://toolserver.org/~platonides/sandbox/wlmUsernames.txt
Or if we restrict to valid submissions (182 users less):
time sql commonswiki_p "SELECT DISTINCT user_name FROM
u_platonides_wlm_p.wlm2012 JOIN user ON (user_id=wlm_author) WHERE wlm_source = 'commons' AND wlm_status='Participating';" > wlmParticipatingUsernames.txt http://toolserver.org/~platonides/sandbox/wlmParticipatingUsernames.txt
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org
wikilovesmonuments@lists.wikimedia.org