Commons talk:GLAM dashboard

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search

Sort wikis in usages list

[edit]

It would be nice if the usages were sorted in some way (any way), so that the diff is smaller. Currenty, they seem random? --Federico Leva (BEIC) (talk) 11:13, 26 January 2015 (UTC)[reply]

More than 100 categories

[edit]

Thanks again for this service. I and Marco Chemello are using Commons:BEIC/popular categories. I'm wondering if it would be possible to list more than 100 category, e.g. 1000 or all those above N (5?) files. Federico Leva (BEIC) (talk) 09:07, 8 April 2016 (UTC)[reply]

It is possible, but the idea of the dashboard reports is to stay short and "transcludable" into a dashboard page. For this reason an upper limit of the top 100 seems reasonable. If you need a full list of categories, then I suggest you borrow from the SQL script and use http://quarry.wmflabs.org/ to create a specific report that you can then tweak as you need. If you are not good with SQL, it would be worth asking around your local volunteer community, as it's a fairly common skill. The code looks a bit convoluted, but that's just to deal with recursive categories, if you have a bucket category holding all images, then it can be trimmed down to something a lot simpler.
I have bashed out a version for you at http://quarry.wmflabs.org/query/8936, which you can fork if you want to adapt it and rerun the query. The downloading options in Quarry are quite handy, so you can dump and reimport to, say, a spreadsheet for your own project reporting. -- (talk) 10:33, 8 April 2016 (UTC)[reply]
Well, I know how to use quarry, but I don't want to babysit the work on categories on a daily basis. People at BEIC should be able to work independently and a daily bot update is the easiest way; of course I could run a fork but that would seem wasteful.
I know the limit of 100 makes sense, I was thinking about an option: maybe a parameter in the template call, or a different subpage. Federico Leva (BEIC) (talk) 07:07, 10 April 2016 (UTC)[reply]