Commons:Bots/Work requests

< Commons:Bots

Shortcut: COM:BR · COM:BWR

Bot policy and list · Requests to operate a bot · Requests for work to be done by a bot · Changes to allow localization  · Requests for batch uploads

Filing cabinet icon.svg
SpBot archives all sections tagged with {{Section resolved|1=~~~~}} after 1 day.


Is any bot operator interested in maintaining of 2 DB reports per monthly basis:

Such reports could be used for Commons maintenance: categorization, deletions (DRs), etc. --XXN, 01:40, 24 February 2017 (UTC)

SELECT page_title
FROM categorylinks
JOIN page ON page_id=cl_from
LEFT JOIN       imagelinks ON  il_to=page_title
LEFT JOIN globalimagelinks ON gil_to=page_title

WHERE cl_type="file" AND page_namespace=6
AND cl_to IN ("Personal_images", "User page images")
AND gil_to IS NULL AND il_to IS NULL;
The first one as a database query, you can run it with Quarry. Dispenser (talk) 02:54, 24 February 2017 (UTC)
Thanks for idea, Dispenser. This query returns only absolutely unused images. One derivated query with
AND gil_to IS NULL 
AND il_from in (select page_id from page where page_title like "OgreBot/Uploads%" AND page_namespace=2)
group by page_title
having count(il_from) = 1
can catch those images included in OgreBot's reports subpages. For the second requested report type, it tooks too long to execute to run such query on Quarry. XXN, 21:58, 11 March 2017 (UTC)

Import icons from The Noun ProjectEdit


The Noun Project has 1000s of very clean, well designed icons, many of which are available under a Wikimedia compatible license. Currently only a very small number are available on Wikimedia Commons. They would be incredibly useful for outreach projects, publications, Wikiproject pages etc, I have used them widely on the Connected Open Heritage project. The site has names and categories for each icon and clear licensing, it also has an API. Would some kindly wizard be able to take a look at if it is possible to mass import them? I would be very happy to do grunt work.


--John Cummings (talk) 22:38, 28 February 2017 (UTC)

Hello @John Cummings:, I have just checked their API and created an account for test purpose. Is there a specific collection you would like to import? If no how many icons should be imported?.--African Hope (talk) 15:02, 7 March 2017 (UTC)
Hi African Hope wonderful :), honestly I don't know where to start, I'm not clear on how many images the whole site has (I don't know if all of them is an acceptable answer). Could we start with a collection from a specific user? Its hard to browse users but I found this one that looks like as good a place as any to start.
Thanks very much
--John Cummings (talk) 16:46, 7 March 2017 (UTC)
Hey @John Cummings: from what I read so far, I needed to create a request at the Batch Uploading page for discussion and feedback. I just created the Commons:Batch uploading/TheNounProject sub-page. I'll keep you tuned. Greetings from Abidjan   --African Hope (talk) 23:04, 16 March 2017 (UTC)

Cleaning up Category:Author matching Creator template, Creator template not usedEdit

I think I may have found a solution to cleaning up a lot of the issues on Category:Author matching Creator template, Creator template not used. I set it up by using VisualFileChange.js, but I feel like this is something that should be done with a bot, and someone should lookover the code first. I've saved it at the bottom of User:Elisfkc/common.js as "Creator template fix". Elisfkc (talk) 22:14, 5 March 2017 (UTC)

Mass page renaming botEdit

Would it be possible to have a bot which could mass-rename a list of files from JSON or a table (after botop or administrator approval)? I've spent an inordinate amount of time manually renaming hundreds of BSicons, which is very tedious and is limited by both the slow JavaScript and the 8-per-minute quota. (Pinging JJMC89, who has helped me with various other bot tasks before.) Jc86035 (talk) Use {{re|Jc86035}}
to reply to me
14:28, 9 March 2017 (UTC)

Try playing with Pywikibot. Even if you don't want to run Python scripts, you can do a lot from the command line. For example using mw:Manual:Pywikibot/ you can read in a text file of all the renames. As for 8 files per minute, it's a good throttle limit for something like mass moves, as if something starts going wrong, mass moves have the potential to cause disruption on many other projects. -- (talk) 16:15, 9 March 2017 (UTC)
(Edit conflict) Mass renames can be done after a BRFA, eg. 19 23. The main technical issue is making sure the files gets global replaced ASAP. Unfortunately I don't have much time right now so if anyone else wish to do this, feel free to fork my scripts. --Zhuyifei1999 (talk) 16:31, 9 March 2017 (UTC)
@Jc86035: you can try also this script. It is also affected by the '8 moves limit', but after it reaches it and stops, you can remove proccessed files from lists and restart it without a page reloading:)
Another JS scripts are here> User:Perhelion/massrename.js / User:Legoktm/massrename.js — these works only on files contained in a category, AFAIK. --XXN, 17:28, 9 March 2017 (UTC)
@, Zhuyifei1999, XXN: Thanks for the help. I don't think I'll use pywikibot yet, although I might figure it out sometime later. Jc86035 (talk) Use {{re|Jc86035}}
to reply to me
15:00, 10 March 2017 (UTC)


{{PeopleByName}} was created after merging of two templates, {{MenByName}} and {{WomenByName}}. As a result, the categories using old templates ({{MenByName}}, {{Mbyname}} and {{WomenByName}}, {{Wbyname}}, {{Fbyname}}) have lost Category:Men by name and Category:Women by name. To fix this problem, someone with a bot should replace old templates in the above-mentioned categories:

{{MenByName|xxx|yyy}}, {{Mbyname|xxx|yyy}} by {{PeopleByName|xxx|yyy|M}}

{{WomenByName|xxx|yyy}}, {{Wbyname|xxx|yyy}}, {{Fbyname|xxx|yyy}} by {{PeopleByName|xxx|yyy|F}}

--Russian Rocky (talk) 23:34, 11 March 2017 (UTC)

@Russian Rocky: See Commons:Bots/Requests/JJMC89 bot 2. — JJMC89(T·C) 19:31, 18 March 2017 (UTC)

Can a bot leave a list of 100 pages with malformed descriptions at User:PokestarFan/Bot/Malformed?Edit

I am going to fix those malformed descriptions. And can this be done once a day? PokestarFan (talk) 13:41, 18 March 2017 (UTC)

@PokestarFan: Does Category:Media missing infobox template help? --Hedwig in Washington (mail?) 23:56, 18 March 2017 (UTC)
@Hedwig:Yep it works. PokestarFan (talk) 02:37, 19 March 2017 (UTC)