:) ¡Gracias, Platonides!
Ya yo estaba pensando que no era posible, pero esa idea tuya es buena para
lo que busco:
El período que quisiera revisar es del 1ero de abril al 31 de mayo de 2014
Ahora, si sé eso... ¿cómo puedo sacar ese volcado de las imágenes que
estuvieron en esa categoría? Con CatScan podría comparar después y sacar el
número así como tú dices.
La segunda pregunta es para sacar eso mismo que tienes en ese link. ¡Está
perfecto!
Y bueno, así son las cosas :) Pero para que conste en los registros, yo no
participo. Solo contribuyo como usuario. Lamentablemente, según las bases,
yo no puedo participar. :( Pero hay algo más interesante: el usuario más
antiguo ha sido de hecho el primer participante.
¡Muchas gracias!
Fhaidel.-
-------- English for the community --------
Thanks Platonides,
I already was thinking it wasn't possible but your idea is good for what
I'm looking for:
I know the time frame I would like to check: Apr 1st - May 31st 2014
Now, if I know it... how can I get an old dump for images that were in that
category? Then, using CatScan I can compare and get the number in the way
you comment.
My second question was looking for what you exactly got in your link.
That's great!
And well... facts are facts :) Just for the records, I'm not a participant
but a contributor user. Sadly I'm not a participant according to the
contest rules. :( But there's something more interesting: the oldest user
is in fact the first participant.
Thank you so much!
Fhaidel.-
2014-05-11 22:07 GMT+02:00 Platonides <platonides(a)gmail.com>om>:
On 06/05/14 12:40, Fhaidel Domínguez wrote:
Hi everybody,
Does anybody know any tool to get a list of deleted images under a
category in commons,
You can't. Once a page is deleted, it no longer belongs to any category.
If you know a time frame you could check (categorylinks) on an old dump for
images that were in that category, and then filter out those who still
exist.
and any other tool to get a list of a category
users details such as user name and registration
date?
I'm appointing to get some management tasks and internal metrics for
"Wikiviajes por Venezuela 2014" a photo contest run by Wikimedia
Venezuela currently.
This is the category:
https://commons.wikimedia.org/wiki/Category:Wikiviajes_por_Venezuela_2014
Assuming you want the user that uploaded the first version of each of the
images on that category, what you want is:
SELECT DISTINCT user_name, user_registration FROM
categorylinks LEFT JOIN
logging ON (log_page = cl_from AND log_type='upload' and
log_action='upload') LEFT JOIN user ON (user_id = log_user) WHERE cl_to
='Wikiviajes_por_Venezuela_2014';
I've left the list of 398 users at
http://toolserver.org/~
platonides/sandbox/Usuarios-Wikiviajes_por_Venezuela_2014-
20140511200000.txt
As expected, most are new users:
2014 370 92.9648% (1 in March, 187 in
April, 182 in May)
2013 6 1.50754%
2012 6 1.50754%
2011 3 0.753769%
2010 6 1.50754%
2009 2 0.502513%
2008 2 0.502513%
2007 1 0.251256%
2006 2 0.502513%
Fun fact: you are the second oldest participant. ☺
Any help is appreciated,
Thanks,
You're welcome
_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org