Wikipedia:Bots/Requests for approval/BotMultichill 3

The following discussion is an archived debate. Please do not modify it. Subsequent comments should be made in a new section. The result of the discussion was

Approved.

BotMultichill

Operator: multichill (talk)

Automatic or Manually Assisted: Automatic (supervised)

Programming Language(s): python

Function Summary: Add commonscat to categories.

Edit period(s) (e.g. Continuous, daily, one time run): First a couple of long runs to add the template, after that every once in a while

Edit rate requested: about 6 edits per minute

Already has a bot flag (Y/N): Y

Function Details: Commonscat (Template:Commonscat (edit | talk | history | links | watch | logs)) is a template to navigate from a wikipedia category/article to a related category at commons. I would like to add this template to a lot of categories. This has two advantages.

It's easier for users to navigate from a wikipedia category to commons
Commonssense makes more sense (it gives better suggestions)

It's like an interwiki. But not between two languages, but to get from wikipedia to commons. I'm planning to do it the same way as i've done it at the nl wikipedia. I will cycle through these steps

First i'm going to add categories based on the name (see here for a list). For this i use add_text.py. (sample edit)
For the categories which dont have the same name i wrote a program which uses the interwiki's to find a link to commons. (sample edit)
Do cleanup, sometimes categories at commons get renamed or deleted. We shouldnt link to those categories.

-multichill (talk) 14:13, 10 April 2008 (UTC)[reply]

Discussion

Presuming that that task is okay by the community, I don't see any issues. — Werdna talk 01:22, 13 April 2008 (UTC)[reply]

Yes, looks good. Will you publish the source code? Monobi (talk) 02:54, 13 April 2008 (UTC)[reply]

I will commit the code to pywikipedia so other people can use it too. multichill (talk) 20:04, 14 April 2008 (UTC)[reply]

Other templates exist for the same linking. Do you have a list to avoid duplication? If you have that in place, I would be OK with a 50-edit trial in category space. In article space, where will you put the commonscat template? What if there is no external links section? Can you point to anything showing this is desired in article space by at least one project? Gimmetrow 20:54, 14 April 2008 (UTC)[reply]

Categories, Gimmetrow, not articles. — Werdna talk 02:56, 15 April 2008 (UTC)[reply]

OK, but commonscat was defined as "a template to navigate from a wikipedia category/article to a related category at commons." Even in categories, what checks are made for templates with similar function? Gimmetrow 17:51, 15 April 2008 (UTC)[reply]

You can find the source here. I couldnt find much duplicate templates in the category namespace. The ones i could find:

Template:Commons - I will probably do a replace {{commons|Category: with {{commons_cat| to avoid dupes
Template:Sisterlinks - Links to search pages
Template:Commonscat1A, Template:Commoncats, Template:Commonscat4Ra, Template:Commonscat1, Template:Sistercommons & Template:Commonscat-inline - Could add thes e templates as a possibilities, but it looks somewhat redundant/unused.

I couldnt find a template which was present at a lot of categories in Category:Interwiki link templates, but maybe i missed something. By the way, someone just renamed the template so it's now Template:Commons_cat. multichill (talk) 19:43, 15 April 2008 (UTC)[reply]

I've seen {{Sisterlinkswp}} used for this purpose too. Gimmetrow 22:45, 15 April 2008 (UTC)[reply]

Ah, i knew i missed something. I could make an exception, but i dont really see the point in having two exactly the same templates. What's your opinion on that Gimmetrow? multichill (talk) 17:26, 16 April 2008 (UTC)[reply]

I don't know. I was thinking for now you would want to just skip categories that had another equivalent template. Since parameters to sisterlinkswp would include "Category:" these would need some manipulation if converted to commons cat. Gimmetrow 03:43, 17 April 2008 (UTC)[reply]

Ok for the time being i filtered out these templates. The query i use to find the pages:

SELECT DISTINCT langpage.page_title AS langcat FROM page AS langpage JOIN commonswiki_p.page AS cpage ON langpage.page_title=cpage.page_title WHERE langpage.page_namespace=14 AND langpage.page_is_redirect=0 AND NOT EXISTS (SELECT * FROM templatelinks WHERE tl_from=langpage.page_id AND (tl_title='Commons_cat' OR tl_title='Commonscat' OR tl_title='Commons' OR tl_title='Sisterlinks' OR tl_title='Commonscat1A' OR tl_title='Commoncats' OR tl_title='Commonscat4Ra' OR tl_title='Commonscat1' OR tl_title='Sistercommons' OR tl_title='Commonscat-inline' OR tl_title='Sisterlinkswp')) AND NOT EXISTS (SELECT * FROM commonswiki_p.page AS cpage2 JOIN commonswiki_p.categorylinks ON cpage2.page_id=commonswiki_p.categorylinks.cl_from WHERE cpage.page_id=cpage2.page_id AND commonswiki_p.categorylinks.cl_to='Category_redirects') AND cpage.page_namespace=14 AND cpage.page_is_redirect=0

Can i go ahead and do some test edits? multichill (talk) 11:58, 17 April 2008 (UTC)[reply]

Sure. Do up to 50 edits and we'll take a look at them. Gimmetrow 22:17, 17 April 2008 (UTC)[reply]

I'm sure ya meant

Approved for trial. Please provide a link to the relevant contributions and/or diffs when the trial is complete. :) SQL ^{Query me!} 22:34, 17 April 2008 (UTC)[reply]

Done. Took the first 50 of my list. Any questions? multichill (talk) 23:15, 17 April 2008 (UTC)[reply]

How do you determine where to put the template? Last before any categories? [1] Gimmetrow 23:42, 17 April 2008 (UTC)[reply]
- Yes, that's the location i'm using. multichill (talk) 06:23, 18 April 2008 (UTC)[reply]
  - Ping!!!! BAGgers, look alive. Would be nice to have some sort of response. multichill (talk) 23:24, 19 April 2008 (UTC)[reply]
    - There is some magic template to get BAG attention. Well, this seemed pretty straightforward after all. Consider task 1 (identical category names) approved. As for task 2 (not identical category names), could you briefly describe how you match categories that don't have the same name? Gimmetrow 04:41, 21 April 2008 (UTC)[reply]
  - Ok. I'll fire up my bot for the first part. As for the second part. The bot gets a page (Category:Maltese people), follows all the interwiki links looking for the commonscat template (nl:Categorie:Maltees persoon), does some error checking (does it exist? is it a redirect?) and finaly adds the template to the category ([2]). I expect to find a lot of hits in the subcategories of Category:People by nationality because of the different naming convention at commons. multichill (talk) 20:23, 21 April 2008 (UTC)[reply]
    - OK, that's rather what I thought. I expect there will be more issues when the naming conventions don't match. Whenever you get a chance, could you run a set of 50 edits with non-matching category names to see what the issues are? Gimmetrow 00:51, 22 April 2008 (UTC)[reply]
      - Both jobs are running, but the second one is much slower, so might have a hard time finding these edits in my contributions. multichill (talk) 19:27, 22 April 2008 (UTC)[reply]
        I was hoping you would make a continuous run of the second type so we could fine them ;) Gimmetrow 05:32, 23 April 2008 (UTC)[reply]
      - Look for Dutch in the contributions. multichill (talk) 10:49, 23 April 2008 (UTC)[reply]

Shouldn't be adding this to redirected categories. Look for {{categoryredirect}}, and maybe check for an actual category redirect (if those exist). Gimmetrow 08:08, 24 April 2008 (UTC)[reply]
- Ok, template is now on the ignore list. multichill (talk) 17:00, 24 April 2008 (UTC)[reply]
  - And all the redirects? Gimmetrow 01:02, 27 April 2008 (UTC)[reply]
    - Already cleanup up most of it. multichill (talk) 09:38, 27 April 2008 (UTC)[reply]
      - Editing seems to have stopped at Category:W*. Was there a problem? Gimmetrow 04:36, 3 May 2008 (UTC)[reply]
        No problems. Already did the whole alfabet and started over again. multichill (talk) 11:43, 3 May 2008 (UTC)[reply]

Can we get a set of 50 edits together where the commons category doesn't have the same name? I would like to look those over before stamping approved on the whole request. Gimmetrow 21:00, 4 May 2008 (UTC)[reply]
- Take a look at Category:Sportspeople by nationality. My bot is doing a run of this category. multichill (talk) 22:20, 10 May 2008 (UTC)[reply]
  - I committed the skip list and am now doing another test run. multichill (talk) 11:37, 14 May 2008 (UTC)[reply]

Approved. Gimmetrow 18:47, 14 May 2008 (UTC)[reply]

The above discussion is preserved as an archive of the debate. Please do not modify it. Subsequent comments should be made in a new section.