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.

Imgur filesEdit

Maybe somebody would like to automate Commons:Village pump/Copyright/Archive/2017/01#Imgur filenames? Dispenser (talk) 23:21, 20 January 2017 (UTC)

Withdrawing The hacky JavaScript is automated enough, just need to get somebody to remember to look at the results every few months. —Dispenser (talk) 23:33, 13 February 2017 (UTC)

Mass move .ogg to .ogvEdit

SELECT COUNT(*) FROM image WHERE img_media_type="VIDEO" 
AND img_major_mime="application" AND img_minor_mime="ogg" 
AND UPPER(CONVERT(img_name USING latin1)) LIKE "%.OGG";

Most users like separate programs to open audio and video files. Since the major file managers (Windows Explorer, OS X Finder, Ubuntu/Nautilus) use the extension to determine this, I would like the 7,157 files to be renamed from .ogg to .ogv extension. This is already the predominate method for the remaining 54,053 Ogg video files. —Dispenser (talk) 20:48, 24 January 2017 (UTC)

I see no need, and this likely will cause a lot of drama. Some user want ogg other want ogv. --Steinsplitter (talk) 12:16, 27 January 2017 (UTC)
The majority of Theora videos use .ogv (88%). Since we're forcing extensions may as well have it meaningful and it signal to editors/users it's a video file. —Dispenser (talk) 05:42, 30 January 2017 (UTC)
  Doing… per, phab:T151352, phab:T65584, etc. MediaWiki:Gadget-AjaxQuickDelete.js is doing that fix as well since years. I also found a old request from 2009. Talked with other users, seems to be uncontroversial and needed. --Steinsplitter (talk) 14:42, 31 January 2017 (UTC)
  Done A few files with conflicts not moved. --Steinsplitter (talk) 13:03, 1 February 2017 (UTC)
Thank you, I'll remove VIDEO:.ogg from User:Dispenser/Wrong Extension so we can track new files. —Dispenser (talk) 14:08, 1 February 2017 (UTC)

I really wished you hadn't done that. A lot of those OGG files you moved where audio only and should have been moved to OGA not OGV. Reguyla (talk) 15:36, 1 February 2017 (UTC)

@Reguyla: Hi, Do you have a example? --Steinsplitter (talk) 15:40, 1 February 2017 (UTC)
I only found File:Lillers - Grand Prix de Lillers-Souvenir Bruno Comini, 6 mars 2016 (D12A).ogv - Broken in Firefox. 19 others that MediaWiki has trouble decoding. —Dispenser (talk) 17:15, 1 February 2017 (UTC)
Ok well when I did a search recently for OGG/OGV files with a Video display resolution = 0 x 0 I found thousands of non video audio files. If you look in Quarry under my name you'll see the code. It just needs to be updated a little to show 0 x 0. Reguyla (talk) 17:27, 1 February 2017 (UTC)
I am away from my computer at the moment though but if you still need examples when I get back to it tonight I can certainly provide some. Reguyla (talk) 17:30, 1 February 2017 (UTC)
You're newest query at Quarry is 3 days old. And Wrong Extension checks that .ogg/AUDIO/application/ogg has zero pixel and .ogg/VIDEO/application/ogg does not. I tried replicating the query without success, but I think your mistaken. —Dispenser (talk) 19:32, 1 February 2017 (UTC)
It's possible I pulled something up wrong and got a false report. I'll double check later tonight and let you know. Reguyla (talk) 20:30, 1 February 2017 (UTC)
Well I found out tonight that due to being blocked on Meta I can no longer access Quarry so I have no way to validate if I am right or wrong. So nevermind what I said above, if I find anything I'll let you know. Cheers! Reguyla (talk) 03:18, 2 February 2017 (UTC)
File:Lillers - Grand Prix de Lillers-Souvenir Bruno Comini, 6 mars 2016 (D12A).ogv is a 1080p 25fps Theora, 48000 Hz stereo 112 kb/s Vorbis file, so it is indeed a video. Playing it with ffplay shows tons of errors, but in one of the few rendered frames I saw a motorcycle. --Zhuyifei1999 (talk) 03:16, 2 February 2017 (UTC)

Upload of Ipernity filesEdit

Perhaps you know the photo sharing website Ipernity. More than 1,000 photos published on Ipernity under a free license have subsequently been uploaded to Commons. The number of free photos available at Ipernity is, of course, much larger (see here).

In December, unfortunately, the team of Ipernity announced that they will close down the site on January 31, 2017 (see here). The close-down date has since been changed to "late February" (see here). There are efforts going on to save the site, but I think it would be a good idea to copy public domain and Creative Commons content to Wikimedia Commons.

Unfortunately, I am not technically skilled to do something like that. I could only download photos from Ipernity and upload them to Commons on a one-by-one basis. I know it'll be a lot of work to get a bot moving (and to keep an eye on its movements), but can somebody here help? -- Robert Weemeyer (talk) 20:38, 27 January 2017 (UTC)

@Robert Weemeyer: I did have a brief look through the API ( and the image collection in general. Though a mass import may be possible, I do not think this is an easy import for Commons as many images would fail to meet Scope for various reasons, and some may be copyright problems just as we see with Flickr. I suggest that on Ipernity discussion pages you push to have someone release version(s) on Flickr with matching licenses, or create an archive dump, or a passive mirror using something like wget, that others can take advantage of in the future. I have not tested overall size, but as you can push 1TB on to just one Flickr account, it would be reasonable to expect that all photos filtered by free reuse licenses could be released on one Flickr account.
Though I've done similar things in the past, I'm over-committed to take this on at the moment. Thanks -- (talk) 11:45, 12 February 2017 (UTC)

Tasnimnews review neededEdit

Per this discussion. Tasnim news photo's uploaders should use this template! But we have lots of photos from this website without image reviewer tag! Please run Bot in this category and make a list of tasnimnews photos without review tag. thanks--MehdiTalk 09:06, 28 January 2017 (UTC)

The bot should place such images into the subcategory Category:Tasnimnews review needed. De728631 (talk) 13:33, 29 January 2017 (UTC)
Thats good! I'm waiting for result.--MehdiTalk 16:42, 29 January 2017 (UTC)
@Ebraminio: If its possible, please done.--Mehdi (talk) 16:45, 29 January 2017 (UTC)
@Ladsgroup, Yamaha5:--Mehdi (talk) 16:53, 1 February 2017 (UTC)
Hello @Mehdi: , was a solution found? If not, I am willing to help. Just to make sure I fully understand your request, you need the bot to browse the Category [[Category:Photos from]] and search for photos that do not use the {{subst:Tasnim/subst}} template. Then these photos will be placed under the [[Category:Tasnimnews review needed]]. Is is what you need?--African Hope (talk) 13:07, 16 February 2017 (UTC)
@African Hope:Exactly! Thank you for your help.--Mehdi (talk) 14:04, 16 February 2017 (UTC)
@Mehdi: I ran two test here and here. Check if this is what you meant. I have a concern however, inserting the {{subst:Tasnim/subst}} template automatically prints "Tasnim", "License review" templates and the "Tasnimnews review needed" category. In any case it does not print the {{subst:Tasnim/subst}} template itslef. As a matter of fact, when I searched for photos with {{subst:Tasnim/subst}} template I found none. My question is the following: what is the criteria the bot should really search for?--African Hope (talk) 16:49, 16 February 2017 (UTC)
@African Hope:Thanks dude. I think you can use [[:Category:Files from external sources with reviewed licenses|this category]] for best result! Bot should check photos in [[:Category:Photos from]] that doesn't exist in Category:Files from external sources with reviewed licenses! --Mehdi (talk) 19:20, 16 February 2017 (UTC)
Ok @Mehdi:. Actually the [[:Category:Files from external sources with reviewed licenses]] is added to photos via {{LicenseReview}} template which itself is generated by the {{subst:Tasnim/subst}} template. So I will search for photos in [[:Category:Photos from]] that do not have the {{LicenseReview}} template and add the {{subst:Tasnim/subst}} template. By the way I have run two additional tests here and here--African Hope (talk) 20:23, 16 February 2017 (UTC)
@African Hope:Thanks alot @};- --Mehdi (talk) 20:58, 16 February 2017 (UTC)
You're welcome @Mehdi:. Since there are roughly 2500 photos, I will run few additional tests for now. If things do not break I will start the heavy work after.I will keep you informed.--African Hope (talk) 21:08, 16 February 2017 (UTC)
@Mehdi:   Done-- African Hope (talk) 15:34, 23 February 2017 (UTC)

Wiki Loves Africa 2016Edit


We have 480 files which have been uploaded as part of WLA, but do not include the overarching template because uploaders did not go through the dedicated upload system, but simply taggued their images as Category:Images from Wiki Loves Africa 2016 in CountryX (eg Category:Images from Wiki Loves Africa 2016 in Algeria). Our template is {{Wiki Loves Africa 2016}}. This template in particular include the category Category:Images from Wiki Loves Africa 2016. Since many uploaders did not use the template, the images are now not taggued with the general category.

For communication and for jury tool needs, we would like that all pictures be taggued, ideally with {{wiki Loves Africa 2016}} or if difficult to do, with Category:Images from Wiki Loves Africa 2016

We have established the list of images concerned by this problem : The download link provides a raw list (

Is there anyone (a bot) who could help us tag all those pictures ? Ideally with the template. At worse, with the category ? If not, any suggestion of how we could do ?

Thanks in advance

Anthere (talk)

Hello @Anthere:, I made a permission request for my bot here. If it is granted quickly I will handle your task.African Hope (talk) 01:29, 8 February 2017 (UTC)
That would be awesome @African Hope: ! Anthere (talk)
@Anthere: its is   Done --African Hope (talk) 15:55, 9 February 2017 (UTC)
@African Hope: Yipppeee. Ok, so we are ready to import images in the voting tool :) Anthere (talk)

Category:Crop for Wikidata needs cleanupEdit

There are a lot of images in Category:Crop for Wikidata that have already been cropped, and feature {{Extracted from}}, but are still tagged with {{Crop for Wikidata}}. Can someone remove the latter, from the new and old file, please? Andy Mabbett (talk) 21:46, 8 February 2017 (UTC)

Hello @Pigsonthewing:   Doing… -- African Hope (talk) 16:08, 23 February 2017 (UTC)

@Pigsonthewing:   Done--African Hope (talk) 22:53, 24 February 2017 (UTC)

@African Hope: Much better! Thank you. Andy Mabbett (talk) 22:59, 24 February 2017 (UTC)
You're welcome --African Hope (talk) 23:35, 24 February 2017 (UTC)

Nonsense coordinates added by videoconvertEdit

There are 265 webm files here which contain nonsense coordinates {{Location dec|12.345|23.456|}}. Seems to be a succesive sequence of digits only. Please remove them. The problem seems to be caused by --ŠJů (talk) 01:57, 10 February 2017 (UTC)

@ŠJů: Is there a list or category of these webm files? sısɐuuǝɔıʌ∀ (diskuto) 11:57, 11 February 2017 (UTC)
re You can insert insource:{{Location dec|12.345|23.456|}} into the search field and search it. However, it seeems that somebody corrected it already, I found none such file now. --ŠJů (talk) 17:00, 11 February 2017 (UTC)
(Edit conflict)Fixed MediaWiki_talk:VisualFileChange.js#Make_VFC_work_on_special_pages and done this with the search query insource:"{{Location dec|12.345|23.456|}}". The rest will need to be fixed manually --Zhuyifei1999 (talk) 18:28, 11 February 2017 (UTC)

Replace {{De-at}} by {{de}}Edit

Per Commons:Deletion requests/Template:De-at (and Commons:Forum#Commons:Deletion requests.2FTemplate:De-at). Sebari – aka Srittau (talk) 19:47, 13 February 2017 (UTC)

@Sebari:   Done --Steinsplitter (talk) 14:05, 16 February 2017 (UTC)

Information neededEdit

Does Commons have any bot which will scan for untagged(unlicensed) images/media and segregate it. As on marathi Wikipedia we have a lot of such images so needed assistance in this case --Tiven2240 (talk) 07:20, 15 February 2017 (UTC)

Move all pictures from Category:Logos to Category:Unidentified logosEdit

Hello, maybe a bot can move all the logos from Category:Logos (Total: 19 Files) to Category:Unidentified logos, since this category should not be used normally. New uploads are often tagged directly with Category:Logos, so it would be also nice, if the bot could work continuously. --Der Buckesfelder  Talk  Evaluation  E-Mail  commons 11:59, 16 February 2017 (UTC)

  This section is resolved and can be archived. If you disagree, replace this template with your comment. Der Buckesfelder  Talk  Evaluation  E-Mail  commons 20:07, 24 February 2017 (UTC): Done by myself

Creating subcategories per CountryEdit

Is it possible, that a bot could create subcategories below Category:Unidentified logos for all the countries of the world? The scheme should be like Category:Unidentified logos of Germany. Afterwards the logos can be shifted from Unidentified logos to the page cats and users from the country can categories it correctly. --Der Buckesfelder  Talk  Evaluation  E-Mail  commons 12:02, 16 February 2017 (UTC)

  This section is resolved and can be archived. If you disagree, replace this template with your comment. Der Buckesfelder  Talk  Evaluation  E-Mail  commons 20:07, 24 February 2017 (UTC): Done by myself

PD-USGov Diffusion BotEdit

I'd like to request a bot to go through Category:PD US Government, and change the licenses on files to the more specific license tags when it can be easily determined. I'm talking about it changing the licenses on the files that have a source from one of over the 27 US Government Flickr stream (see Category:Government organisations on Flickr for lists), or images from an easy Federal Government source (,,, etc). I'd also like it if the Flickr stream ones placed the images in the correct categories for the Flickr stream. Preferably, this bot would run once a month to make sure to clean out Category:PD US Government. Elisfkc (talk) 19:52, 17 February 2017 (UTC)

@Elisfkc: I've put this on my backlog. There's not much more to doing this that deciding which searches to apply, but as I had to think about US-Gov licenses when I created COM:VIRIN, I probably have the right experience. As this would have to be cautiously done, there may be a large residue which are not all that simple to make sub-licensing decisions about.
I do not get your Flickrstream comment, I would hesitate to make assumptions about the source unless this was already explicit.
I have started with a couple of initial wildcard searches, feel free to add and comment at User_talk:Fæ#Faebot_diffusion_of_PD-USGov. -- (talk) 12:47, 25 February 2017 (UTC)

Mass uploadsEdit

Hi, Could someone with a bot upload

  1. images from the California Department of Water Resources website (CDWR). {{PD-CAGov}} should be used.
  2. images from IAEA Flickr stream? Files should be added to Category:Files from IAEA Flickr stream. Additionally, could you please add files already uploaded from there into this category?

Thanks a lot in advance, Yann (talk) 22:55, 18 February 2017 (UTC)

FYI, for the CDWR pictures, you need to create an account, and then wait that the account is validated. I uploaded a few manually: Category:Files from the California Department of Water Resources. Regards, Yann (talk) 21:00, 24 February 2017 (UTC)

Fix Exif timeEdit

Is there somebody who is able to correct the Exif time of 531 files from Category:Exif time is 1 hour higher? I forgot my camera set to summer time up to 2016-11-09, the time should be one hour lower than the Exif states. --ŠJů (talk) 04:59, 19 February 2017 (UTC)


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)