Commons:Bots/Work requests

Shortcuts: COM:BR • COM:BWR

Bot help and list Requests to operate a bot Requests for work to be done by a bot Requests for batch uploads

	SpBot archives all sections tagged with {{Section resolved|1=~~~~}} after 7 days.

Archives 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 11, 12, 13, 14, 15, 16, 17, 18

#	Bot request	Status	💬	👥	🙋 Last editor	🕒 (UTC)	🤖 Last botop editor	🕒 (UTC)
1	Remove extraneous "I, " in author param of PD-self		15	5	CalendulaAsteraceae	2024-11-16 07:03	DaxServer	2024-11-11 20:56
2	Add OCR output to jpg		10	2	Prototyperspective	2024-11-16 11:37
3	Move "Historical images of" to "History of"		14	6	Wikiwerner	2024-11-21 19:59	Jeff G.	2024-08-04 10:20
4	Media missing infobox template		26	5	Enhancing999	2024-11-16 08:57	Fl.schmitt	2024-09-04 18:31
5	Auto-addition of inferrable categories		5	2	Prototyperspective	2024-10-09 17:34
6	Generate a daily database report equivalent of Special:UncategorizedCategories		10	3	Wikiwerner	2024-12-08 11:21
7	Report update request (#2)		1	1	Prototyperspective	2024-10-07 16:45
8	file description cleanup: "Uploaded with Reworkhelper"		2	2	Ammarpad	2024-09-09 18:29
9	Add P1651 YouTube video ID structured data from "source" attribute of Filedesc template		17	6	Prototyperspective	2024-10-04 18:01	DaxServer	2024-09-19 07:44
10	Add missing Template:Location		14	3	Enhancing999	2024-09-21 12:37	Fl.schmitt	2024-09-20 19:57
11	Monuments database in Russia		1	1	Pigsonthewing	2024-09-24 11:14
12	Redirect Galleries per Concensus		1	1	Sadads	2024-09-30 12:26
13	Sanborn maps		5	1	Enhancing999	2024-10-30 08:16
14	Adding inferrable video of taxon categories		1	1	Prototyperspective	2024-10-17 12:35
15	Sending automated messages to users who upload suspicious SVG files claiming to be their authors		2	2	SpinnerLaserzthe2nd	2024-11-28 02:30
16	Adding cat "Animated GIF files" to all instances of such		4	2	Prototyperspective	2024-12-12 15:55	Schlurcher	2024-12-12 14:36
17	Change attribution		7	2	Yerpo	2024-12-07 10:09	Jeff G.	2024-12-07 10:01
18	Mass changing WD statements about files		7	4	Schlurcher	2024-12-13 06:50	Schlurcher	2024-12-13 06:50

Legend
In the last hour
In the last day
In the last week
In the last month
More than one month
Manual settings
When exceptions occur, please check the setting first.

@Pelikana noticed that there are a lot of erroneous uses of {{PD-self}} which insert "I, " before the author. Could someone please replace {{PD-self|author=I, with {{PD-self|author= in the following pages? —CalendulaAsteraceae (talk • contribs) 06:52, 24 July 2024 (UTC)[reply]

I can do that -- DaxServer (talk) 09:46, 24 July 2024 (UTC)[reply]

@DaxServer: I think we've resolved the issues with this request. Are you still up for doing the replacement? —CalendulaAsteraceae (talk • contribs) 20:06, 15 October 2024 (UTC)[reply]

@CalendulaAsteraceae Yes, let me know the final replacements to be done -- DaxServer (talk) 19:27, 10 November 2024 (UTC)[reply]

@DaxServer, please replace {{PD-self|author=I, with {{PD-self|author= in these pages. —CalendulaAsteraceae (talk • contribs) 15:34, 11 November 2024 (UTC)[reply]

@CalendulaAsteraceae and @Pelikana: "I, " is there to make the assertion first person.   — 🇺🇦Jeff G. ツ please ping or talk to me🇺🇦 10:21, 24 July 2024 (UTC)[reply]

Hi @Jeff Yes, it obviously used to be there to make the assertion first person. But I think at some point the textlines were changed and now IMHO it is a displaced element, plus very odd that it is the only not translated text element in the template, at least in these use cases. Do you mean to say the results are completely correct this way and need no change? Both lines seem grammatically faulty to me "... door de auteur, I, JohnDoe" (".. by the author, I, JohnDoe") and "I, JohnDoe allows ...". Last one should read (in Dutch) "Ik, JohnDoe sta ...." It should not read "I, JohnDoe staat ... " because this line starts in first person and ends in 3rd person. In later days (past 2007-2008) the "I, " "I, " is not in the templates anymore it seems. Peli (talk) 10:52, 24 July 2024 (UTC)[reply]

Indeed. The template uses {{int:Wm-license-pd-author-with-author-text}}, which produces the text "This work has been released into the public domain by its author, $1. This applies worldwide." The appropriate way to make this first person would to edit the page on TranslateWiki (well, the English one needs to be changed in MW code, but for other languages this is where you'd edit it), not to manually put "I, " in the author parameter. —CalendulaAsteraceae (talk • contribs) 20:50, 24 July 2024 (UTC)[reply]

I think it is a good idea to add "I, " as a suffix if the uploader is also the work's creator. Please don't replace that. For example, it may not be clear to many or people only or first check the author field where this is useful metadata, especially if the author name is different from the username in which case they would also need to check the license template. Prototyperspective (talk) 12:04, 25 July 2024 (UTC)[reply]

This is a good thing to handle in {{PD-self}} (which is a template only intended to be used by the uploader). Adding it manually means it's a huge pain to update if the wording of the template changes, and also doesn't work with internationalization. Right now

{{int:Wm-license-pd-author-with-author-text|I, Calendula}}

produces

This work has been released into the public domain by its author, I, Calendula. This applies worldwide.

in English, which is ungrammatical and frankly silly. If I switch my display language to Spanish, it instead produces

Este trabajo ha sido liberado al dominio público por su autor, I, Calendula. Esto aplica para todo el mundo.

which is even worse. If you want to change the wording of {{PD-self}}, probably the way to go is switching in the template from int:Wm-license-pd-author-with-author-text to something like int:Wm-license-pd-author-self-text that incorporates the author's name. —CalendulaAsteraceae (talk • contribs) 19:28, 25 July 2024 (UTC)[reply]

I couldn't find an existing piece of text, so I submitted a feature request at phabricator:T371057. I think that further discussion of updates to the text of {{PD-self}} should go to the template talk page, and also that this bot request should go ahead because manually adding "I, " before the author's name is a terrible way to make the template first-person. —CalendulaAsteraceae (talk • contribs) 20:28, 25 July 2024 (UTC)[reply]

You're absolutely right. Sorry, I misunderstood. It's not really clear in your initial post that this would be added to the template instead. Prototyperspective (talk) 21:02, 25 July 2024 (UTC)[reply]

I agree that this is just about cleaning up a tiny bit of lost and redundant text on a limited number of pages and would be glad if @-- DaxServer would get the green light to fix this series of typo's, on these old pages by deleting "I, ". ThanksPeli (talk) 21:44, 4 August 2024 (UTC)[reply]

• Bot request filed - Commons:Bots/Requests/DaxBot (7) -- DaxServer (talk) 20:56, 11 November 2024 (UTC)[reply]

  Thank you! —CalendulaAsteraceae (talk • contribs) 07:03, 16 November 2024 (UTC)[reply]

From the discussion at VP/T, I found a solution to a problem identified earlier: frequently we have images of streets and other with some text in it. Sometimes this is of interest, but it's not necessarily included in filename or description.

https://ocr.wmcloud.org/ would allow to extract such text and make it editable on Commons.

Ideally a bot would go through new uploads (and also some maintenance category for older files) and run https://ocr.wmcloud.org/ on it. The output (if any) could be added to the file description page, either with a template or as structured data.

Sample file:

File:Plaque Rue Lauriers - Gournay-sur-Marne (FR93) - 2021-10-04 - 1.jpg

Input:

https://ocr.wmcloud.org/?image=https%3A%2F%2Fupload.wikimedia.org%2Fwikipedia%2Fcommons%2F3%2F36%2FPlaque_Rue_Lauriers_-_Gournay-sur-Marne_%2528FR93%2529_-_2021-10-04_-_1.jpg&engine=google&psm=3&line_id=null

Output:

"PER PONTEM AD FORTUNAM GOURNAY-SUR-MARNE RUE DES LAURIERS"

Enhancing999 (talk) 15:16, 2 August 2024 (UTC)[reply]

Also please see the discussion at VP/T linked above. Just briefly adding support to this wish and two notes:
it would likely be a problem to scan all files on WMC and/or all new uploads, instead one could let the bot run only categories where this may be useful. Secondly, rather than writing a new bot it would probably be better to add this functionality to some bot that already writes e.g. structured data to lots of files (however SD can't be searched on WMC can it?) like SchlurcherBot. Prototyperspective (talk) 10:50, 4 August 2024 (UTC)[reply]

I think there are already some bots who scan all uploads .. it could obviously be added to those. If SD is used, we should make sure it's searchable. Enhancing999 (talk) 13:47, 4 August 2024 (UTC)[reply]

I think the place to put OCR results would be a new field for the file summary box that is collapsed by default. This way all users can easily find and see this info and it can be searched. The mentioned VP/T thread is now archived to here. I think adding a way to categorize based on OCR results would be quite useful. However, not extremely useful so I don't know if it's necessarily worth the effort to develop a categorization-based-on-OCR tool or extension for the ocr-tool. This is why after briefly asking about it here I only listed the task I meant to use this for at the new page Commons:Categorization requests. Prototyperspective (talk) 11:45, 21 September 2024 (UTC)[reply]

I don't think "collapsed by default" allows users to " easily [..] see this info".
 ∞∞ Enhancing999 (talk) 08:36, 16 November 2024 (UTC)[reply]

Disagree, it's just a button to click; also the search would index the content in just the normal way (optimally with some ocr:"text" search operator). For example, what about image that contain very much text? It makes the information-box very large and pushes the other content down usually without being useful. Prototyperspective (talk) 10:53, 16 November 2024 (UTC)[reply]

I'm not saying you should place it on top. It's always confusing when text one is searching for isn't visible in Wikipedia articles, because someone somewhere hid it. Some Wikipedia's have explicit rules against such hiding, but they aren't always applied.
 ∞∞ Enhancing999 (talk) 10:55, 16 November 2024 (UTC)[reply]

Well one can simply click the well-visible Expand button. If these are put into a template that is consistently at the bottom / somewhere beneath the licensing template then that may be as good, it would be worth discussing this but none of OCR is currently added anyway. Prototyperspective (talk) 11:12, 16 November 2024 (UTC)[reply]

How do you know where the "well visible expand button" is and where it's placed? If you just search for the text on the open Wikipedia article, you will never find it.
 ∞∞ Enhancing999 (talk) 11:20, 16 November 2024 (UTC)[reply]

It's in the quite small/short {{Information}} template. A Wikipedia article is long; also highlighting the element underneath text searched for is hidden would be very useful. Prototyperspective (talk) 11:37, 16 November 2024 (UTC)[reply]

Per note at Category:Historical images by country (as conclusion from Commons:Categories for discussion/2019/09/Category:Historical images), the content of the categories at Special:PrefixIndex/Category:Historical images of should be moved to "History of". This seems to involve more than 10'000 categories, see PetScan:29034509. I think the resulting redirect could afterwards be tagged for speedy deletion. Enhancing999 (talk) 18:59, 2 August 2024 (UTC)[reply]

i dont think it's a good idea to handle this problem without human supervision.

i would rather do these instead:

1. prohibit new categories with the word from being created.
2. let users slowly move the files to the appropriate categories (by time).

RZuo (talk) 20:42, 2 August 2024 (UTC)[reply]

"history of ..." is not any better. everything is history. RZuo (talk) 20:43, 2 August 2024 (UTC)[reply]

Right, any cutoff for "history" will change every second/minute/hour/week/month/year/century/millennium. See also Commons:Categories for discussion/2024/08/Category:History by country.   — 🇺🇦Jeff G. ツ please ping or talk to me🇺🇦 10:20, 4 August 2024 (UTC)[reply]

there's specific interest related to "history" of something.

for example, historians of asian history should go under "history of asia".

but to dump files into "history of xx" is no more better than dumping them in "xx" or "historical images of xx". all files of xx can perfectly fit into all those three variations.

most of these "historical images of xx" basically contain all photographs before the advent of digital photography, especially black and white photographs.

so i'd rather users move these cats to or create for example "xx in the 19th/20th century". RZuo (talk) 12:49, 4 August 2024 (UTC)[reply]

i have an idea of a bot moving files according to the time/date, but i need probably 1 or 2 years to code something like that up. RZuo (talk) 12:53, 4 August 2024 (UTC)[reply]

I don't think this is the place to re-discuss the CfD. If you think the closure is problematic, ask an admin to re-open it. Enhancing999 (talk) 12:57, 4 August 2024 (UTC)[reply]

There is just no way this can be done manually. If there are cases you think would be problematic, please state them here. Enhancing999 (talk) 20:56, 2 August 2024 (UTC)[reply]

•  Support Per Enhancing999. There's currently 33732 categories for "historical images", which is way to many for anyone to deal with manually. This also isn't the place to relitigate the CfD. Nor do I think doing so would go anywhere anyways since it was open for 4 years and has been closed since last year. So there has been plenty of time for people to raise concerns about it. Most of these categories only contain a couple of images to begin with and they aren't "historical" either. The idea that we should let users slowly move the files to the appropriate categories when it's only a couple of images per category to begin with is totally ridiculous and would just waste everyone's time. There's no reason people can't better categorize the images once they are moved to "history of xx" categories. That's where most of the images were in the first place. Regardless, this should totally be done by a bot instead of forcing users to waste time doing it manually. --Adamant1 (talk) 07:27, 10 August 2024 (UTC)[reply]

Instead of tagging the redirects for speedy deletion, a bot may rename the categories without leaving a redirect if the corresponding category 'history of...' does not yet exist. Wikiwerner (talk) 12:12, 17 November 2024 (UTC)[reply]

If a cat "historical images of xx" has < 5 (or a similarly small number) files, all files should be moved to "xx". it's not necessary to make a separate subcat for just a handful of files. RoyZuo (talk) 14:14, 17 November 2024 (UTC)[reply]

e.g. Category:Historical images of Sababurg which has 6 files, while Category:Sababurg has only ~50 files. RoyZuo (talk) 14:40, 17 November 2024 (UTC)[reply]

But how do decide by bot when a category is desired to keep? Wikiwerner (talk) 17:09, 18 November 2024 (UTC)[reply]

This request requires probably hundreds of thousands of edits. Is "History of ..." a better categorization? The category:History is subject of a CfD too: see Commons:Categories for discussion/2024/06/Category:History. We better wait for a verdict there. Otherwise perhaps another hundreds of thousands of edits are necessary after the latter verdict. Wikiwerner (talk) 19:59, 21 November 2024 (UTC)[reply]

There are about 339,000 files in the category Media missing infobox template. Even using add_information.php (or the gadget), the task is too huge to be done manually. I assume that would be a nice job for a bot. A simple search/replace wouldn't be sufficient, since some file pges contain {{Filedesc}} and {{License-header}} which should be preserved. Additionally, some files have information on sources, e.g. 1884 South Penn RR.jpg. Those should be used for the source parameter of the information template. Fl.schmitt (talk) 19:22, 10 August 2024 (UTC)[reply]

Maybe a list could be generate from the category about the most used files and these be done manually? Also, please keep in mind COM:GOF. Enhancing999 (talk) 07:09, 12 August 2024 (UTC)[reply]

Good idea - restricting on the most used files is reasonable. Additionally, i thought about grouping by uploader / author which would facilitate automatic editing. Fl.schmitt (talk) 07:25, 12 August 2024 (UTC)[reply]

I tried Special:Search/switzerland incategory:"Media_missing_infobox_template" and then used Petscan:29082230 to find the uploaders.

This found images like File:Runs_Kapelle.jpeg by "Ikiwaner" who uploaded plenty of own pictures which is clearly indicated, but even add-information can't complete it.

One would think that we'd have more pictures of these places almost 20 years later, but sometimes we don't. Enhancing999 (talk) 08:30, 12 August 2024 (UTC)[reply]

Looks very interesting! The problem with add-information.php is that it has to transform arbitrary input, which is IMO almost impossible. With pre-structured data (known author/uploader, known structure of file description), maybe the task can be automated to a certain extend. Limiting the input by location is a good idea! Fl.schmitt (talk) 08:55, 12 August 2024 (UTC)[reply]

add-information.php seems relatively good based on the input, but a review seems necessary.

Even when filtering by uploader can give large range of complicated cases (especially old imports from other wikis). Adding a search for "own photograph" (or similar) can simplify things. Enhancing999 (talk) 12:02, 12 August 2024 (UTC)[reply]

Maybe we could list groups of a similar cases somewhere, so someone else can determine if they want to assess them further (or they are all actually similar). Samples:

• Mapmakers
  • Tschubby maps (1100), see Category:Media missing infobox template (maps t1)
  • AHoerstemeier map (275)
  • Vardion map (288)
• Photographers/image sources
  • Famfamfam flag icons (250)
  • Peter Berger (50)
  • Picswiss (294)
  • NASA (4794)
  • Lienhard Schulz (270)
  • Dake Switzerland (82)
  • Carlo Ponti (31)
  • Giorgio Sommer (75)
  • Arnaud Gaillard (105)
  • Qwertzy2 (81)
  • CdaMVvWgS (65)
  • Marcel.C (7)
  • Flyout (46)
  • Francis Frith (28)
  • Matthäus Merian (160)
  • Marc Mongenet (68)
  • Markus Bernet (40)
  • Julo (524): possibly several
  • Flickr (4483)
  • Crops from Mathematikerkongress, Zürich 1932 (all done)
• Copyright status
  • PD-Old (22630): Category:PD Old
  • PD Official documents (115)
• Added complexity
  • original upload log-header (10450): Template:original upload log (initial upload at Wikipedia)
  • transferred from (458): Template:Transferred from (not included in previous)
  • Files_moved_to_Commons_from_Wikipedia: Category:Files_moved_to_Commons_from_Wikipedia (possibly included in previous, likely not)
  • derived from (91): Template:derived from
  • extracted from (1641): Template:Extracted from
  • Bilderwerkstatt (387) :Template:Bilderwerkstatt
  • images with annotations (1765): Category:Images with annotations (doesn't work well with add_information)
  • Files in need of review (sources) (4705): Category:Files in need of review (sources) (possibly this doesn't go beyond the file not having the information template)
• Personal templates, see Category:Media missing infobox template (personal templates)
  • RHaworth personal template (25): user:RHaworth/mylic
  • IUCN category/Pengo (362): Template:Pengo IUCN
  • Fb78 (122): User:Fb78/Licence
  • Twice25 (270): user:Twice25/Crediti
  • CNG (343): Template:CNG
• Image types
  • coat of arms (16323), some in Category:Media missing infobox template (coats of arms)
  • insignia (11356)
  • flag (13852)
  • currency (423), see Category:Media missing infobox template (currency)
  • logo (7826)
  • Wikipedia brand (957): Category:Trademarks and logos of Wikimedia (also included in previous)
  • kit body (769)
  • ChemDraw (490)

Enhancing999 (talk) 15:01, 12 August 2024 (UTC) updated[reply]

We could do subcategories of Media missing infobox template for maps, logos, coats of arms, insignia, currency, flags and personal templates. There is already one for artwork.

Interesting to compare the early digital photos with others we have: sometimes it still looks the same, others lack any comparable one, sometimes it's clearly aged, sometimes it gives a historic comparison, sometimes in a larger set we lack clearly better ones.

BTW, image notes seem to be handled badly by add-information (they get mixed into the description). Headers handling could be improved too. I don't think I ever had one that didn't need editing (that seems to be the idea anyways).. besides, I try to complete them. Enhancing999 (talk) 13:38, 13 August 2024 (UTC)[reply]

@Enhancing999: Great work, this is very helpful. I've started with the maps provided by Tschubby, because it seems that most of the file description shares the same structure. Please check Revision #909185535 of Karte Gemeinde Troinex.png for a regex-based replacement by pywikibot. IMO, this looks ok. Fl.schmitt (talk) 16:49, 13 August 2024 (UTC)[reply]

The problem with File:Karte Gemeinde Troinex.png is that it wasn't uploaded by Tschubby, so {{Own}} isn't applicable.

Supposedly that file and File:Carte Commune Troinex.png are based on a file that was initially uploaded at de:File:Karte Gemeinde Troinex.png, see https://de.wikipedia.org/w/index.php?title=Spezial:Logbuch&logid=283755 . Normally the file description page would include copy of the upload log from dewiki, but it doesn't. File:Glacier.zermatt.arp.750pix.jpg had some details I added after "own".

BTW, Tschubby is still very active, so he might have a view how he prefers them to be done or do them directly himself. Enhancing999 (talk) 17:03, 13 August 2024 (UTC)[reply]

If it's the same file, initial upload was: [1]. Enhancing999 (talk) 17:09, 13 August 2024 (UTC)[reply]

hmm - ok - yes, seems I was too optimistic... it's clear that getting this done by a bot will never reach the quality of manually checking / editing all the parameters. So we will have to decide which grade of completeness is achievable / required. Searching for other / derived / source versions can only be done manually, I think. So if this is a requirement, there's no way to get this task done by a bot, not even a small part of this task.

What's possible IMO is to group the files by the structure of their description, maybe additionally by uploader and year/month of upload, and do a regex-based replacement. This may lead to incomplete Information/Map/Artwork templates, e.g. if there's no information regarding the source.

Regarding the parameters:

• Setting the source parameter may be possible (1) if the source is stated in the description or (2) if uploader is identical with author. In other cases, the source can't be set automatically.
• Setting the exact upload date will be very difficult if we use pywikibot's replace script. If using the upload's year and month is sufficient, one could group the files accordingly, based on a PetScan search. This depends on the required/acceptable grade of precision.

Fl.schmitt (talk) 18:13, 13 August 2024 (UTC)[reply]

Still trying to get the {{Upload date}} template working... Fl.schmitt (talk) 16:51, 13 August 2024 (UTC)[reply]

I try to avoid upload date. Weirdly, add-information tends to get even the exif date wrong. For Tschubby's municipality maps, it may be sufficient to add the year they are meant to be current (borders don't change that frequently). Enhancing999 (talk) 15:00, 15 August 2024 (UTC)[reply]

when you can identify some common pattern in some file sets, Commons:AWB or jwb might be a good tool. RZuo (talk) 22:04, 14 August 2024 (UTC)[reply]

What would be cool for add-information is if one could use it with some defaults (description language, author, date, {{Taken on}}-location, source, other fields, license, etc) for a given subset.

Also, a few bugs might be worth fixing (licence header formatting, keeping image annotations together, placement of coordinates template, exif dates) if others plan to use it (I'm mostly done with the subset I'm looking into). Enhancing999 (talk) 15:05, 15 August 2024 (UTC)[reply]

Enhancing999, Thank you for tackling this long neglected problem. I like your divide-and-concur approach, and I agree with RZuo that Commons:AWB might be a good tool to use. That is what I used when some years ago I was adding infoboxes. Another possible approach might be to start adding com:SDC data like author, description and date with QuickStatements tool. If you do that than you can just add {{Information}} template with no parameters and it will display SDC data. See File:Indoor_Climbing_Kid.jpg for example. If you have any questions about this approach I can explain with more details. --Jarekt (talk) 04:21, 16 August 2024 (UTC)[reply]

Good idea indeed. This could simplify adding only one aspect at a time (not everything can be determined with the same ease). Once sufficient data for {{Information}} is available, the template could be added. We just need to be careful that basic information available as statements is also otherwise visible.

BTW, one would think that it's an old issue, but sometimes even recent uploads don't have a template (or someone deleted it).

If it's thought helpful for others, I can create subcategories for some or most of the above groups (obviously they should be deleted easily once empty or if a better one can be found).

If it's easy to add by bot, a subcategory for frequently used files could be helpful. (it's doable with PetScan for a relatively small set, but not for all 337000 files in the category). In the subset I checked few had more than 30 main namespace uses (sample, now with template). Enhancing999 (talk) 11:21, 16 August 2024 (UTC)[reply]

Flickr might a good start to add {{Information}} through statements only. We currently have ca. 4500 files mentioning Flickr. Some 2100 have both creator and source. An issue with some of these seems to be that they are blank. I brought this up at Schlurcherbot. Wouldn't the various Flickr templates also include source and creator? Enhancing999 (talk) 15:01, 16 August 2024 (UTC)[reply]

@Enhancing999 thank you for creating the hiddencat - this makes it easier to get a clearly defined set of files as input for bulk modifications! I'm currently working on a bot that should be able to work through the grouped files, preferably writing SDC data wherever possible. But there are some points where I'm not sure about:

• Date: We may simply take the year (as you've proposed earlier), but I found it would be quite easy for a bot (from a technical point of view) to use the oldest upload date. Is there a way to use inception (P571), qualifying the date as {{Upload date}} in SDC?
• Source: We can use either original creation by uploader (Q66458942) (if uploader and creator seem to be identical) or own work by the original uploader (Q87402110) (in other cases). I wonder if there's a way to additionally point to the source wikipedia (e.g. german wikipedia)?

Fl.schmitt (talk) 16:11, 22 August 2024 (UTC)[reply]

Commons_talk:Structured_data might find you help on the question specifically for structured data.

If {{Information}} has no date, the line doesn't even appear as missing. Sample: Special:Diff/914493166.

I noticed some uploaders use {{Own}} and link directly their username at Wikipedia. Not sure how bots handle this.

Reimports from Wikipedia are tricky in general. See also: Commons:Village_pump#c-Jarekt-20240817151300-Asclepias-20240817140600 Enhancing999 (talk) 19:29, 22 August 2024 (UTC)[reply]

@Enhancing999 - it took some time, but my bot solution is almost ready for action. Since handling weak-structured data is tricky, the bot first prepares (and actually prepared) just a "simulation" result, without any "live" modifications of Commons pages. This "simulation" result shows the proposed modifications for a certain set of file pages lacking {{Information}}. The bot tries to add as much information as possible by SDC (esp. Date and Author) and doesn't repeat those values in the generated {{Information}} template, since the template uses those SDC values by default. So, the template may look "incomplete" (for reference, see e.g. File:Karte Bodensee Birnau.png where I added as much as SDC as possible manually, leaving the respecting files in the Information template empty). The simulation result is available on gitlab in two formats: plain txt and SQL (sqlite). Before filing a bot request, I would be glad about any critical feedback regarding the proposed modifications. Fl.schmitt (talk) 18:31, 4 September 2024 (UTC)[reply]

•  Comment Have anyone looked at who the uploader was? Sometimes you can be lucky and find users who uploaded hundreds (or thousands) of files using the same way of adding information. So if user Foo uploaded 1000 photos with "<description>Taken by me.<license>" then it is possible to add an information template and put the <description> in the description field and add "Taken by me" in source field (or add {{Own}} instead) and add User Foo as author. If Foo is still active and did not add a good source/author the files could be added in a category called "Files uploaded by Foo" and then Foo could be asked to check the files and confirm to be the photographer. --MGA73 (talk) 18:49, 1 November 2024 (UTC)[reply]

  Give it a try. Please make sure to skip people who frequently imported from other wikis.
   ∞∞ Enhancing999 (talk) 19:59, 1 November 2024 (UTC)[reply]

If imported with FileImporter it can still work. I fixed thousands of files this way on various wikis before they were imported to Commons but also some after they were imported. --MGA73 (talk) 17:43, 2 November 2024 (UTC)[reply]

Special:Search/"featured picture" incategory:"Media missing infobox template" (118) might be worth doing in priority.
 ∞∞ Enhancing999 (talk) 08:57, 16 November 2024 (UTC)[reply]

Could somebody create a bot to add categories that are inferrable given the structured data (SD) that other bots have added or the combination of the file's existing categories?

I previously asked if this functionality could be added to User:SchlurcherBot here but it seems like it won't be done. Schlurcher (talk · contribs) said there already are some bots adding categories – maybe instead of creating new bot(s) for this it would be best to add this functionality to these (please name these because I don't know what the relevant bots would be).

SchlurcherBot for example already reads and parses the date field, it would be nice if a bot did the same and then added "Category:Videos of 2023" if that's in the field which the bot already writes into the "inception" field. It could also be put in a hidden subcat like "Uncategorized videos of 2023" so people can check these and/or it doesn't clutter the category which could also be specific to videos that show something specific to the year like an event (this doesn't seem to be the case currently).

Likewise, the bot already writes the display resolution to the SD but does not add the respective Category:Videos by display resolution subcat. If not nearly all videos are in there I don't see why this category (its subcats) could be useful. If it was added to videos, then one could use this for statistics, petscans and maybe other things. The same goes for the WebM videos category which is currently up for deletion. Most webm videos are missing there so the category is largely useless. (Note that these two are exceptional cases: most WMC categories are useful.) If files were in there one could for example use this as a workaround to find videos in petscan which currently can't filter for videos except when combining categories with the Category:Videos by file format cat. A bot could also populate the Category:4K videos.

Some further examples of inferrable cats:

• "Videos of 2024 from the United States" (depending on the license tag or other categories of the file or the coordinates)
• Category:Audio files of 1906 (see here)
• when a video file is in a category like "Muscidae" it should be added to Category:Videos of Muscidae
• when a video file is in category "Azeliinae", which is a subfamily of Muscidae, it should also be added to "Videos of Muscidae" because that is the closest category to Muscidae which has a subcategory for videos (it would be best if a bot moved it to the more specific subcat once it is created)
• files in Category:Animals in water should be moved to Category:Elephants in water if it's also in a subcat of elephants
• it could make sure artworks like paintings (e.g. somewhere in a subcat of Visual arts) are in an "in art" subcat so paintings of elephants eating are not directly in the Elephantidae eating category and can e.g. be easily filtered out using the deepcategory search operator (or viewed alongside other such artworks)
• a video in a subcategory of Category:Black and white films should go into Category:Black and white videos
• After some delay to allow removal of metadata, categories like Category:Taken with Canon PowerShot A480 (example) or Category:Photographs by exposure time‎ subcats based on the file exif metadata

More difficult:

• Videos without audio, Black and white videos, Category:Animated GIF files (for gifs that are animated e.g. from -deepcategory:"Animated GIF files" sorted by recency) if it can read the content to some degree like being able to check if the video has audio (the ones below are probably much easier to implement)
• Category:Categories with contradictory categorization & Category:Categories with categorization contradicting their contents – inferrable cats may also be applied to categories and this maintenance cat could be added to cats that have contradictory categorization which can often be solved with a new subcat

More things could be added and refined to such an automatic categorization system(s) over time. There can be rare exceptions but having things auto-categorized with exceptional errors would be better than things missing and requiring lots of manual maintenance/subcategorization and there would be ways to deal with that (for example for video files in Category:Short films it would create a 'suggestion' to add Category:Short films videos) and move things out of ill-inferred categories where usually another cat of the file is false.

Here I suggested that video2commons adds as many of inferrable cats right away when uploading, such as "Videos with English subtitles" if it imports en subtitles.

It would be a big endeavor but addition of categories that are inferrable from other categories of a file would be very useful, very much improve the reliability / completeness / usefulness of categories, and free up categorizers' time for other tasks.

Maybe focusing this discussion on inferrable technical criteria cats for videos would be best for now. Prototyperspective (talk) 23:05, 17 August 2024 (UTC)[reply]

I'll rarely add some more inferrable categories to the list. Added 2 and edited 1 now. --Prototyperspective (talk) 12:50, 30 August 2024 (UTC)[reply]

Videos without audio should actually be fairly straightforward, since it's possible to detect if a video has no audio channel at all.

I think implicit in what you wrote above is that a bot should add subcategories of Category:Vidoes by display resolution, which is what I came here to suggest. —Justin (koavf)❤T☮C☺M☯ 14:03, 9 September 2024 (UTC)[reply]

How is that possible? (Is that possible without having to download the full video from WMC?) Yes, there are lots of inferrable categories like the ones about resolution and rather than handling each individually I think it needs a broader approach where many inferrable cats are added at once. Display resolution is just one and probably not even among the most useful ones (eg not really suitable much for showing results sorted by resolution or specifying min resolution). Since the deepcategory search operator very often doesn't work one can use Category:Videos by file format in PetScan as a workaround to show videos of whatever subject one is interested in but it's missing quite a lot of videos. Prototyperspective (talk) 20:39, 9 September 2024 (UTC)[reply]

A few more examples:

• Adding files to subcats of Category:Media from scholarly journals depending on the link in the source field. For example, files with an URL starting with https://www.nature.com/ or a DOI that resolves to one should be in a respective subcat of Category:Media from Nature Publishing Group journals. I don't think these cats are useful if they do not include most of their files which currently seems to be the case for most or many of these. Instead, these cats are misleading as people think that would be all the media from these sources on WMC when they only contain a small random subset. Metacladistics (talk · contribs) recently added these to a few files manually.
• If in Category:Birds in flight carrying something and e.g. Category:Birds with prey (or subcat thereof) should move the file to the appropriate subcat of the former like Category:Ardea cinerea in flight with prey if it's in the Ardea cinerea cat. Alternatively, suggest the file is moved to a subcat.
• Again: more exif cats like Category:F-number f/9 & Category:ISO speed rating 100 depending on exif data
• If in Category:Videos of 2018 and Category:Videos from Norway then -> move the files to Category:Videos of 2018 from Norway

There are various ways these rules for category inferring could be built – they would be transparent in some page on Commons where people can see which reasonings the bot implements. Note that until there is a better solution, files that are in a category and files in all its subcategory branches can be viewed in the wall of images view (like in the MediaSearch) using the Deepcat Gadget (it only fails sometimes for large categories but that may also get fixed with phab:T376440. Prototyperspective (talk) 17:34, 9 October 2024 (UTC)[reply]

initial request and related discussion

Generate a daily database report equivalent of Special:UncategorizedCategories For each page, output: Page name Date time last edited Creator name User who last edited Wikidata item (if available) Ideally formatted in a template. Enhancing999 (talk) 14:27, 24 August 2024 (UTC)[reply] Is there a way to find categories modified / created in the last 24 hours? Fl.schmitt (talk) 17:53, 24 August 2024 (UTC)[reply] https://commons.wikimedia.org/w/index.php?sort=last_edit_desc&search=contentmodel%3Awikitext&ns14=1 https://commons.wikimedia.org/w/index.php?sort=create_timestamp_desc&search=contentmodel%3Awikitext&ns14=1 . RZuo (talk) 19:34, 24 August 2024 (UTC)[reply] Thanks! But it's difficult to build a stable PagePile from a query... - here's a Quarry #85732 searching for Categories created today and a Petscan (psid: 29146248) based on that quarry (same for yesterday: Quarry #85736 / Petscan (psid: 29146272)). Would be nice if pywikibot could "update" the quarry automatically, since the pagepile is only a "snapshot" of the quarry result at the time the pagepile was created. Or the bot would have to query a replica db itself... Fl.schmitt (talk) 21:27, 24 August 2024 (UTC)[reply] Something like Quarry:history/85731/922919/895636 should work (1187 rows today, ran in 27 minutes). I'm trying to add the Wikidata item. User names seem more difficult, but I guess we can do without. Enhancing999 (talk) 21:34, 24 August 2024 (UTC)[reply] Username did work too Quarry:history/85733/922940/895656 (1167 rows, ran in 60 minutes). Username seems interesting too. Enhancing999 (talk) 21:47, 24 August 2024 (UTC)[reply] with Wikidata item Quarry:history/85731/923002/895717 (1162 rows, ran in 27 minutes; 109 have items). Maybe I can combine the two. Enhancing999 (talk) 21:50, 24 August 2024 (UTC)[reply] An initial output for now at Commons:Report_Special:UncategorizedCategories. Enhancing999 (talk) 22:48, 24 August 2024 (UTC)[reply] @Enhancing999: Excellent work! Is there a way to create such a report automatically based on a Quarry? Fl.schmitt (talk) 10:01, 25 August 2024 (UTC)[reply] That's the point of my bot request: the idea is that the bot runs the report daily and add its result to the page. I'm still working on the optimal format. (BTW, as another bot adds infoboxes to categories with items, there shouldn't be hardly any on the list. I reported this to User talk:Mike Peel.) Enhancing999 (talk) 10:08, 25 August 2024 (UTC)[reply] Here is the combined query: Quarry:history/85733/923138/895851. It seems it runs quicker now that we worked to limit the number of categories on it. Enhancing999 (talk) 13:14, 25 August 2024 (UTC)[reply] @Enhancing999: I've found thatt with Pywikibot, it's quite easy to get the metadata (last time edited, last user editing, wikidata item and so on) for any page or category. Here's a small python script that collects the metadata and creates a CSV file as result. CSV output is only for testing purposes - with some more effort, the script could output a wikitable (or even a static HTML page). The difficult part is getting a PagePile containing the uncategorized categories (doesn't even need to be a PagePile, but working on PagePiles is quite straightforward with Pywikibot). Fl.schmitt (talk) 06:01, 26 August 2024 (UTC)[reply] So it might be quicker to use a basic query and then enriched that afterwards. Enhancing999 (talk) 07:06, 26 August 2024 (UTC)[reply] Yes - while it's important to include the namespace as page_namespace and the category name as page_title (column aliases in SQL) - otherwise PagePile isn't able to create a valid result. Anyway, a bot would still require some time to work, since it needs to request all categories and their metadata. Depending on the server load, it seems that a bot is able to process about 6-7 Categories per Minute. So, processing ca 1,000 categories will still take between 2 and 3 hours (even when preloading the categories in batches). I'll have to check if there's a way to speed up things. Fl.schmitt (talk) 12:36, 26 August 2024 (UTC)[reply] Then it might be easier to do it all in SQL: Quarry:history/85733/923437/896130 took about 15 minutes, but speed on quarry varies much. Enhancing999 (talk) 12:49, 26 August 2024 (UTC)[reply] What a great query! Thanks for building this (also @Tjmj: ). Could you or somebody else fork it once more to also create a report for redcats (cats with only nonexisting categories)? Doesn't this query mean this is nearly solved? One would only need to get its result output and write it to some page on WMC and have a script do that regularly. Quite possibly there already is a tool for each of both. Prototyperspective (talk) 14:16, 26 August 2024 (UTC)[reply]

Updated request (the reports were created a while ago and manually updated)

The following reports should be updated by bot:

1. Commons:Report_Special:UncategorizedCategories (based on Quarry:query/86077, takes >10 minutes to run)
2. Commons:Report_UncategorizedCategories_with_infobox (Quarry:query/85877, takes ∼1 minute to run)

Notes:

• When updating, after running the query, the resulting categories need to be null-edited and then the queries run again. Otherwise we get false positives due to template based categorizations (notably {{Wikidata Infobox}}).
• The count by user is added when it's formatted.
• The lines should be in a template for easier formatting.
• If it's easier to update, I could merge the two reports.
• Ideally, the reports are updated 6AM and 6PM UTC, so Europeans and Americans don't get too many entries that have already been dealt with.

The reports may appear short now, but not too long ago they were at 4000 categories total. I think this was partially due to Special:UncategorizedCategories having ran only once a month.

The reports would be similar to w:Wikipedia:Database_reports/Uncategorized_categories.
 ∞∞ Enhancing999 (talk) 12:08, 29 September 2024 (UTC)[reply]

You can choose to download the results as a wikitable. Does that resemble the desired output? Wikiwerner (talk) 17:46, 20 November 2024 (UTC)[reply]

A bit (compare with the pages). If you can automated that part, it would be a good start.
 ∞∞ Enhancing999 (talk) 19:36, 24 November 2024 (UTC)[reply]

I have given it a try. I let a script request the wikitable download URL and perform two regex replacements. (And now I see that you piped the Wikidata search link, unlike my script. That's fixed easily next time.) Wikiwerner (talk) 20:29, 27 November 2024 (UTC)[reply]

Looks good. Thanks!
 ∞∞ Enhancing999 (talk) 22:41, 27 November 2024 (UTC)[reply]

The next step is running the query again. How do you do that? Wikiwerner (talk) 14:21, 1 December 2024 (UTC)[reply]

If it's your own query, you have to login into quarry and click "submit query". There is a feature that makes forking other people's queries easy.

As for pybot, I asked at mw:Topic:Yd8qqsrjykawj9v9. I couldn't get far with the "superset" solution mentioned there.

In the meantime, I found that loading the most recent run is possible per m:Research:Quarry#Downloading_a_resultset.

If you ask for access to toolserver, you could use m:Research:Quarry#Querying_ToolsDB_public_databases.
 ∞∞ Enhancing999 (talk) 14:35, 1 December 2024 (UTC)[reply]

Thank you very much. Now I can run the same script, with the same HTTP request, after each query run. The only thing we need is a way to trigger a new query run... Wikiwerner (talk) 17:02, 1 December 2024 (UTC)[reply]

I have discovered how to do that. I have run the query and updated the report. Wikiwerner (talk) 11:21, 8 December 2024 (UTC)[reply]

Please also update these new reports with a bot:

1. Commons:Report UncategorizedCategories with redcats (Quarry:query/86864)
2. Commons:Report UncategorizedCategories with only infobox categories (Quarry:query/86867)

I suggest that these are updated twice a month at first. Frequency could be increased as needed.

Here's how I update the reports manually (info how this is done for the two reports above doesn't seem to be included): I go to the query page click Download data and select csv. Then I open the csv in VSCodium (Visual Studio Code) and use this to add [[:Category: to the start and ]], to the end of every line as well as replacing all linebreaks. There also is a page 2 with only the first 500 items. I requested the queries here so thanks to Matěj Suchánek. Changing the output to be ordered alphabetically would improve it. "redcats" refers to nonexisting categories – further explanations are at the top of these reports.

By the way, I think the resulting categories need to be null-edited is too unclear. Prototyperspective (talk) 16:45, 7 October 2024 (UTC)[reply]

At File:Bahnhofshalle_Zuerich-2.jpg, when adding {{Information}}, I noticed:

Uploaded with ''[http://tools.wikimedia.de/~luxo/reworkhelper.html Reworkhelper] {{Wayback|url=http://tools.wikimedia.de/~luxo/reworkhelper.html |date=20080419030339 }}''

in the source. There are other similar: Special:Search/insource:"tools.wikimedia.de/~luxo/reworkhelper.html" (1970)

I'd remove this from the file description pages and replace it with a category, e.g. Category:Uploaded with Reworkhelper, similar to others at Category:Files by upload tool.

@Luxo FYI
 ∞∞ Enhancing999 (talk) 13:46, 27 August 2024 (UTC)[reply]

I have opened a bot approval request to do this. – Ammarpad (talk) 18:29, 9 September 2024 (UTC)[reply]

To assist with de-duplication of Common Criteria YouTube video uploads, a bot could search uses of Template:Filedesc for a "source" attribute that contains YouTube links in the format of "^https:\/\/www\.youtube\.com\/watch\?v=([-_0-9A-Za-z]{11})$". The captured 11 character YouTube video ID can then be added as structured data for the video file using Wikidata's P1651 property. Dhx1 (talk) 01:54, 29 August 2024 (UTC)[reply]

Also see related request (approved) for adding P12120 Flickr photo IDs as structured data at Commons:Bots/Requests/FlickypediaBackfillrBot. Dhx1 (talk) 02:00, 29 August 2024 (UTC)[reply]

I have exactly the same idea and wanted to propose something in a few days.

@Multichill Is your bot capable of adding YouTube data in SDC, and perhaps also additional data related to it? -- DaxServer (talk) 07:22, 29 August 2024 (UTC)[reply]

@DaxServer: Focus is on own work so not really doing much identifier properties at the moment. Did propose one at d:Wikidata:Property proposal/VIRIN. Maybe make it a bit more generic bot to add identifiers based on templates?

For YouTube a bit of cleanup is needed. Probably switch to something like {{From YouTube}}, which can add a tracker category so a robot has a category to work on. Same goes for {{ID-USMil}} and other templates that have an identifier property. Multichill (talk) 10:59, 1 September 2024 (UTC)[reply]

We currently have 166,884 files resulting from this search. That template doesn't mention categorization.   — 🇺🇦Jeff G. ツ please ping or talk to me🇺🇦 15:28, 1 September 2024 (UTC)[reply]

Jeff, the template mentions that it categorizes into Category:Media from YouTube. Are we talking about the same {{From YouTube}}? -- DaxServer (talk) 18:42, 1 September 2024 (UTC)[reply]

@DaxServer: Thanks, I missed it at first.   — 🇺🇦Jeff G. ツ please ping or talk to me🇺🇦 21:58, 4 September 2024 (UTC)[reply]

@Multichill Yes, please make the bot generic so it can be expanded with ease 🙏 -- DaxServer (talk) 20:26, 1 September 2024 (UTC)[reply]

Once files have the ID could this please also be added to Commons:Video2commons so people don't accidentally reupload videos that are already here (under a different title)? I think it could and probably should already check for the YouTube ID via an insource search for that ID doesn't it? Prototyperspective (talk) 22:29, 9 September 2024 (UTC)[reply]

Pinging @Don-vip who maintains the V2C -- DaxServer (talk) 07:48, 10 September 2024 (UTC)[reply]

Created https://github.com/toolforge/video2commons/issues/214. I'm happy to accept pull requests for this. vip (talk) 11:24, 10 September 2024 (UTC)[reply]

Once this is implemented could some tool scan for duplicate uploads using the tool please? I think this may work best if the bot adding it would simply store all IDs that it adds along with the URL (or file title or some file ID) so that after added all the IDs one can simply have it show all duplicate IDs. Prototyperspective (talk) 09:46, 28 September 2024 (UTC)[reply]

Actually the structured data is not needed and as far as I can see adds nothing directly useful. I still think it would be good to add this data. However, much more important would be to have video2commons check whether the same video has already been uploaded which can be done using the insource search operator – issue here: A scan for whether the video has been already been uploaded. Prototyperspective (talk) 18:01, 4 October 2024 (UTC)[reply]

@Dhx1 @Multichill @Jeff G. @Prototyperspective @Don-vip - How does this schema look like? -- DaxServer (talk) 18:00, 12 September 2024 (UTC)[reply]

If this looks okay, we can move forward? -- DaxServer (talk) 13:44, 18 September 2024 (UTC)[reply]

@DaxServer: YouTube handle (P11245) & YouTube channel ID (P2397) give constraint violations. The first looks like a good qualifier so I'll update the constraints, just not sure about YouTube channel ID (P2397). Multichill (talk) 21:26, 18 September 2024 (UTC)[reply]

@Multichill Reading the https://support.google.com/youtube/answer/11585688, it seems the channel IDs are the ones that are persistent while the handles can be changed and can be claimed by others. If we were to add the handle and not channel ID and if the handle is relinquished and claimed by another, we would be directing to the wrong creator. I think channel ID should be added, not sure about the handle -- DaxServer (talk) 07:44, 19 September 2024 (UTC)[reply]

Some images seem to have coordinates in SDC, but not display them on the file description page.

Special:Search/haswbstatement:P1259 -hastemplate:"Module:Coordinates" doesn't find them. Is there way to complete them?
 ∞∞ Enhancing999 (talk) 15:14, 29 August 2024 (UTC)[reply]

@Enhancing999: completing the file description isn't too difficult once the files are found. Fl.schmitt (talk) 17:53, 1 September 2024 (UTC)[reply]

I'm trying to figure out where I saw it. I think it was Flickrbackfillerbot who had added the coordinates. As they weren't visible on the description, I had added some myself and then the template complained about a differences.
 ∞∞ Enhancing999 (talk) 17:55, 1 September 2024 (UTC)[reply]

@Enhancing999: BTW: If there are SDC coordinates, it seems to be sufficient to add empty {{Location}}/{{Object location}} templates - see test at Revision #918241588. Fl.schmitt (talk) 18:35, 1 September 2024 (UTC)[reply]

Yes, the question is to which files.
 ∞∞ Enhancing999 (talk) 18:41, 1 September 2024 (UTC)[reply]

One brute-force solution is to parse the database dumps - both the wikibase entities and wikitext content - and determine the files -- DaxServer (talk) 18:50, 1 September 2024 (UTC)[reply]

Maybe we need to have MediaWiki re-add Category:Pages with coordinates to files.
 ∞∞ Enhancing999 (talk) 18:55, 1 September 2024 (UTC)[reply]

@Enhancing999 / @DaxServer: Missing {{Location}} seems to be quite often the case for imports from Flickr. Analyzing one randomly chosen multistream dump archive, containing 918,128 file pages, there are 5,228 file pages with coordinates of the point of view (P1259) claim missing a {{Location}} template: PetScan #29249152 / Pagepile #60582. Fl.schmitt (talk) 18:50, 9 September 2024 (UTC)[reply]

Thanks. I struggled finding my sample again.

Sample from that list: Boeing 757-200, Diocletians_Palace

It also includes some with really "special" templates: File:Wym-bykaont (wersja Józefa Gary).ogg, File:Davy Mourier - Cartoonist 2013 - P1600722.jpg that do display them.
 ∞∞ Enhancing999 (talk) 19:05, 9 September 2024 (UTC)[reply]

OK :-) then please subtract 3,176 files pages from the "Wymysorys pronunciation" category from my 5,228. Obviously, I've hit a special dump... but why is the location visible in Davy Mourier - Cartoonist 2013 - P1600722.jpg, while it isn't visible in Diocletians Palace? Both are using the {{Information}} template? Fl.schmitt (talk) 19:19, 9 September 2024 (UTC)[reply]

There is: Template:Festival Cartoonist 2013. Go figure. Maybe location should be removed from that template.
 ∞∞ Enhancing999 (talk) 19:22, 9 September 2024 (UTC)[reply]

Ok. As far as I see, the dump doesn't have the templates transcluded. Cases like Template:Festival Cartoonist 2013 can be detected only if those templates containing coords are known beforehand. Thus, scanning the dumps won't yield a complete result set. So I would propose to restrict the task on files with {{Information}} template, SDC coordinates of the point of view (P1259) and missing {{Location}}.

Is there consent to solve the issue in those cases by adding {{Location}}? Does this need additional discussion? Alternatively, since Module:Information already uses location of creation (P1071) and location (P276), would it be realistic to get coordinates of the point of view (P1259) added to Module:Information, too? This would solve the issue without the need of a bot and also for the future. Fl.schmitt (talk) 16:10, 11 September 2024 (UTC)[reply]

@Enhancing999: see Module_talk:Information#Proposal:_Evaluate_SDC_P1259_(coordinates_of_the_point_of_view) - let's wait and see... Fl.schmitt (talk) 19:57, 20 September 2024 (UTC)[reply]

The 1% missing mentioned there seems a lot that we are missing. I still favor adding {{Location}} directly, {{Information}} might take a long time to update or change.

Template:Location from Template:Festival Cartoonist 2013 might be in the template links table if it's correctly refreshed. In rare cases having two location templates shouldn't be the end of the world.

Also, shall we have MediaWiki add Category:Pages with coordinates again?
 ∞∞ Enhancing999 (talk) 12:37, 21 September 2024 (UTC)[reply]

Per discussion at Commons:Village pump#Monuments database in Russia.

There are >25K sub-categories of Category:Galleries of cultural heritage monuments in Russia (and about 275 in its subcategory, Category:Galleries of cultural heritage monuments in Crimea) named in the format (for example) Category:WLM/1010021052. That example duplicates Category:Threshing barn from Berezovaya Selga. The corresponding Wikidata item, Threshing barn from Berezovaya Selga (Q106488771), has a Wiki Loves Monuments ID (P2186) value of RU-1010021052 (note the "RU-" prefix). That Wikidata item is linked to the alphanumerically named, not numbered, category.

For each of those 25K categories, we need a bot to do the following:

1. Find the Wikidata item with the Wiki Loves Monuments ID (P2186) value (e.g. RU-1010021052)
   1. If no Wikidata item is found, write a log entry and skip to the next category
2. Find the Commons category that the Wikidata item is linked to
   1. If no Commons category is found; or if the linked category is of the numeric type, write a log entry and skip to the next category
3. Redirect the numeric category (e.g. Category:WLM/1010021052) to the latter category (e.g. Category:Threshing barn from Berezovaya Selga)
4. Ensure that the latter category transcludes {{Wikidata infobox}}

An alternative at 1.1 would be to create a Wikidata item; populating with data from e.g. https://ru-monuments.toolforge.org/wikivoyage.php?id=1010021052 - but this could be done later. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 11:14, 24 September 2024 (UTC)[reply]

Per the proposal here: Commons:Village_pump/Proposals#Summary_Proposal_by_Alachuckthebuck, we are approaching the point where the task could be automated. It will require a bot to see if the gallery title matches a category name, and can be redirected without effecting the countervandelism and patrolling tools, Sadads (talk) 12:26, 30 September 2024 (UTC)[reply]

We have thousands of fairly local maps in Category:Sanborn maps: Special:Search/File: "Sanborn Fire Insurance Maps" (also Special:Search/File: "Sanborn Insurance Maps" or Special:Search/File: "Sanborn Maps")-

It would be helpful if we had some geocoding for these.. Not entirely sure where to get coordinates from, but it should be doable.
 ∞∞ Enhancing999 (talk) 14:31, 15 October 2024 (UTC)[reply]

Many Sanborn maps from LOC only have a link to the actual source of the map, which doesn't provide much context (Sample).

It would be helpful, if each file also had a link to the LOC description page for the series of map sheets.

Samples:

• this map has it both in file name and on the file description page.
• This table has a table of such links (first column: remove the "manifest.json"-part, individual files are in the last column).

Notes:

• This should concern the following files: Special:Search/File: Sanborn insource:tile.loc.gov/image-service -insource:"loc.gov/item/sanborn"
• Some of these files did include the LOC details in the filename, but were renamed.

 ∞∞ Enhancing999 (talk) 09:54, 19 October 2024 (UTC), updated 10:22, 26 October 2024 (UTC)[reply]

Maps in some categories, e.g. Category:Sanborn Fire Insurance Map from Brooklyn, Kings County, New York, include the LOC detail, but no sheet numbers.

Sample:

• File:Sanborn Fire Insurance Map from Brooklyn, Kings County, New York. LOC sanborn05791 001-10.jpg shows part of sheet #4 (note the large "4" in the top right corner), but this isn't anywhere on the file description page or file name.

Notes:

• Some sheets are uploaded as single files, others are split in left and right side (as the sample) where only the right side show the large sheet number.
• Renames solve this for some files, but omitted to keep the LOC details somewhere in the file description
   ∞∞ Enhancing999 (talk) 10:22, 26 October 2024 (UTC)[reply]

Files like this with a categorized jpg version like that can be moved to Category:LC TIF images with categorized JPGs.
 ∞∞ Enhancing999 (talk) 20:35, 23 October 2024 (UTC)[reply]

Sanborn maps are suitable to be rectified with Wikimaps Warper. To do so, the files need to use {{Map}} instead of {{Information}}. This can be done simply by replacing {{Information with {{Map at the beginning of file description pages.

Sample:

• sheet index map for Barton, Vermont

Notes:

• A few Sanborn pages are not maps and should remain with the information template: e.g. Sanborn maps title pages.
• The change could be included in other updates (see other requests).
• A good series of files to start with could be Sanborn index maps.
   ∞∞ Enhancing999 (talk) 08:16, 30 October 2024 (UTC)[reply]

Example: this video has category Category:Butorides virescens set. The latter has a) an infobox with its Taxonomy (specified in Wikidata) and b) is in the taxonomic category Category:Butorides. Could a bot check videos of organisms' taxonomy upward for a Videos of xyz category and add the video closest to the species? In this example, the bot would simply add Category:Videos of Ardeidae because that is the Videos of category closest to the specific species. Prototyperspective (talk) 12:35, 17 October 2024 (UTC)[reply]

I've noticed there are a *lot* of users who mistakenly think that making a vector version of a file grants them authorship status. I was thinking as a means to reduce how often this happens, it would be helpful to have a bot that would promptly flag likely cases and inform the uploader about relevant Commons policies.

I'd like there to be a bot that monitors new uploads to Commons:

• For each new SVG file that is uploaded:
  • Check the file description to see if ANY of the following are true: Author field is equal to [[User:UPLOADERNAME|UPLOADERNAME]], license tag contains self (e.g. {{PD-self}}, {{self|cc-by-sa-4.0}})
  • If any of those cases are True:
    • Check to see if there is a file already on Commons with the same name but different file extension (e.g. File:MyCityFlag.svg was just uploaded, and File:MyCityFlag.jpg already exists)
      • If there is a filename match, add an appropriate tag on the image's page and leave automated message on user's talkpage about it

There are a couple of possible tags that could be added to the file's page. I'm thinking {{Disputed}} or {{Wrong license}} but there may be something more suitable.

As for the automated message to leave on users' talk pages, I'm thinking something along the lines of:

Dear USERNAME, thank you for your contribution to Commons! I am an automated bot and am responding to your upload of FILENAME. It appears you have listed yourself as the author, or used a license tag that implies you are the copyright holder of this file.

Making a vector version of an existing work of art is, in copyright terms, seen as a derivative work. While creating a vector version requires skill and effort, it is still legally considered derivative.

It appears your upload is a vector version of RASTER-FILENAME. The description of UPLOAD should be updated to ensure the original designer of the work is credited as author, and that the license tag reflects the copyright status held by the original designer.

You can credit yourself as the vectorizer using the Igen template. For example, add: |other fields={{Igen|Inkscape|+|u=[[User:USERNAME|USERNAME]]}} (replace Inkscape with relevant software as needed, information at Template:Image generation).

Please update the description of FILENAME promptly. Your contribution to Commons is appreciated!

I don't have any experience with running bots on wikis so I'm afraid I don't know how technically difficult this will be. The automated message should probably be refined - it's just a first draft. But I'm hoping this sort of thing will help new users figure this out much sooner and reduce how many files with inappropriate authorship/licensing need to be fixed. Intervex (talk) 21:37, 26 November 2024 (UTC)[reply]

I think better yet since *other* users might not know the name of the authors:

Dear USERNAME, thank you for your contribution to Commons! I am an automated bot and am responding to your upload of FILENAME.

It appears you have listed yourself as the author, or used a license tag that implies you are the copyright holder of this file.

Making a vector version of an existing work of art is, in copyright terms, seen as a derivative work.

While creating a vector version requires skill and effort, it is still legally considered derivative. It appears your upload is a vector version of RASTER-FILENAME.

The description of UPLOAD should be updated to ensure the original designer of the work is credited as author, and that the license tag reflects the copyright status held by the original designer.

You can credit yourself as the vectorizer using the Igen template. For example, add: |other fields={{Igen|Inkscape|+|u=[[User:USERNAME|USERNAME]]}} (replace Inkscape with relevant software as needed, information at Template:Image generation).

If you are unable to find the name of the author, feel free add: Template:Unknown author.

Please update the description of FILENAME promptly. Your contribution to Commons is appreciated!

SpinnerLaserzthe2nd (talk) 02:30, 28 November 2024 (UTC)[reply]

Category:Animated GIF files is a fairly flat category containing most or probably more than half and most in-use animated GIF files. However, I noticed it's quite unreliable and does not contain a large fraction of animated GIF files. Could a bot please add this inferrable category to all files with the GIF filetype that are animated?

This can be useful to later have a filter for animated GIF files, to complete Animations of xyz categories, and for deepcategory searches and Petscans for animated GIF files in specific, and for allowing searching of all animated GIF files (e.g. via the category search box at the top of that page).

I don't know how one could check whether a GIF file is animated or not but there probably is a way for that (maybe using machine vision via using some machine vision package but not unlikely also possible in a much easier way). If somebody know how that could be done please add info about that here.

See this search query.
Prototyperspective (talk) 12:10, 2 December 2024 (UTC)[reply]

According to Google it's fairly straightforward in most programming languages to check if a gif file is animated. Is there a way or wiki API call that can tell if a Gif is animated without downloading it first? --Schlurcher (talk) 17:21, 2 December 2024 (UTC)[reply]

I'll probably implement this during the Christmas break. --Schlurcher (talk) 14:36, 12 December 2024 (UTC)[reply]

Sounds great! I don't know if there is an API to check whether or not it's animated but that service may need to download the full thing as well (don't know if it can just selectively download some of its metadata). Prototyperspective (talk) 15:55, 12 December 2024 (UTC)[reply]

A contributor (Ivan Maki Marjanović) has been recently renamed and has expressed a whish, both on his talk page and through VRT, to have attribution updated from his previous username on all his uploads. Which there are a few dozen, so a bit annoying to do it by hand. Can anyone please run this simple bot task? — Yerpo ^Eh? 08:06, 7 December 2024 (UTC)[reply]

@Yerpo and @Ivan Maki Marjanović:  Done in these edits.   — 🇺🇦Jeff G. ツ please ping or talk to me🇺🇦 09:23, 7 December 2024 (UTC)[reply]

@Jeff G.: thank you, but please also change the displayed name. — Yerpo ^Eh? 09:25, 7 December 2024 (UTC)[reply]

@Yerpo: You're welcome. You forgot to ping me.   — 🇺🇦Jeff G. ツ please ping or talk to me🇺🇦 09:26, 7 December 2024 (UTC)[reply]

@Jeff G.: I added the ping afterwards with another request (you probably overlooked it) - to also change the displayed name. — Yerpo ^Eh? 09:45, 7 December 2024 (UTC)[reply]

@Yerpo: Ok, I did it again to take care of the displayed name, thanks for catching it.   — 🇺🇦Jeff G. ツ please ping or talk to me🇺🇦 10:01, 7 December 2024 (UTC)[reply]

@Jeff G.: looking good now, thanks. A handful of uploads had a third version of the name, I'll change those manually. — Yerpo ^Eh? 10:09, 7 December 2024 (UTC)[reply]

I have my own bot, but I need to manage WD statements linked with files, they aren't stored in wikitext, so my bot can't change them. I need, for several categories, to do a job: remove one WD property and add another, with a different value for different categories. Could someone here do that? MBH 08:23, 12 December 2024 (UTC)[reply]

@Schlurcher or Mike Peel: Could you help out with this?   — 🇺🇦Jeff G. ツ please ping or talk to me🇺🇦 09:35, 12 December 2024 (UTC)[reply]

Some more detail would be needed. Also sounds like a job that could be done with AC/DC gadget. --Schlurcher (talk) 14:32, 12 December 2024 (UTC)[reply]

@Schlurcher my case is described on phab:T381945. On categories like Category:Views_from_The_First_Tower_observation_deck it's needed to set P1071 for all files and, if exist, remove P180, because earlier I was uploading such batches setting a name of summit to P180 property instead of P1071. MBH 02:50, 13 December 2024 (UTC)[reply]

@PMG looks like you're doing this automatically, how you did it? MBH 02:54, 13 December 2024 (UTC)[reply]

These edits were done with Help:Gadget-ACDC which was also my first suggestion. --Schlurcher (talk) 06:50, 13 December 2024 (UTC)[reply]

I've not figured out bot editing of SDC yet, I suggest asking @Multichill: . Thanks. Mike Peel (talk) 17:41, 12 December 2024 (UTC)[reply]