Wikipedia:Bot requests/Archive 46

From Wikipedia, the free encyclopedia
Archive 40 Archive 44 Archive 45 Archive 46 Archive 47 Archive 48 Archive 50

Ridiculously over-exact coordinates detector

Many articles on geographic locations have coordinates that are given with far too many digits of "precision". In some cases, these coordinates are not even pointing to the correct location, and others (especially towns) point to some user's house or some other such shenanigans. (0.0001° is <11 m, 1″ is <31 m) Is it possible to built a bot that would list (not change) all articles with coordinates that are, say, 10 digits long or longer after a decimal point? Then once I deal with those, 9 digits and so forth? For a fuller discussion of the inanity of lengthy decimal coordinates see WP:Coordinates. Abductive (reasoning) 15:50, 26 February 2012 (UTC)

Running now for usage over 11 decimals. Results will save here when the report finishes. Remember to set your browser's encoding to UTF8. The query I used is below. Tim1357 talk 22:21, 26 February 2012 (UTC)
Query
SELECT page_title, 
       el_to 
FROM   page 
       JOIN externallinks 
         ON el_from = page_id 
WHERE  el_to LIKE 'http://toolserver.org/~geohack/geohack.php?%' 
       AND el_to REGEXP 'params\=[0-9]+\.[0-9]{12}' 
       AND page_namespace = 0;

The preponderance of recurring digits suggests rounding errors by a script; it would be good to deal with that at source. I've added a pointer to this discussion from WT:COORD and notified User:The_Anome, whose bot already deals with a number of coordinate-related tasks. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 01:04, 27 February 2012 (UTC)

Here is a formatted version of the results. Tim1357 talk 02:52, 27 February 2012 (UTC)
I'd go beyond that, and regard anything with 8 or more decimal places as being physically meaningless as absolute coordinates for a fixed location: 10-8 degree of arc at the equator is roughly 1 millimetre -- the Earth's surface shifts more than that from day to day with natural processes such as rainfall expansion of soil and Earth tides, and continental drift motions run at about 10-160mm/year. I think most of them are either points picked off a mapping tool by hand, or dms coordinates converted to decimal. The latter are easy to spot: there are only 3600 possible values for the fractional degree part. In the first case, we should round to six decimal places, in the second, to degrees/minutes or degrees/minutes/seconds, depending on the relevant level of precision. This should be accurate enough for all practical purposes: in the first case, 10-6 degree of arc at the equator is about 0.1m, and in the second, one second of arc is about 30 metres. -- The Anome (talk) 09:58, 27 February 2012 (UTC)
I'd prefer the DMS seconds to have a single decimal place. 30 metres is quite large when pointing to a house or a road or river estuary (think width), for instance. It'd be a bit vexing to see on target coords just miss, after the correction. --Tagishsimon (talk) 00:06, 28 February 2012 (UTC)
The precision should be appropriate to the object. Lower precision is appropriate for a dessert than for a National Geodetic Survey station or the Airy transit circle at Royal Observatory, Greenwich. Jc3s5h (talk) 00:23, 28 February 2012 (UTC)
It's not possible to evaluate the appropriate precision for an object using an automated method (i.e. a bot). I think what everyone is trying to do here is to simply figure out what is the smallest reasonable precision for any object. Certainly, I can think of no unique object covered by a Wikipedia article which requires sub-millimeter precision in its location. If we can all agree that locations don't need to be any more precise than within (for example) 1 meter, then we can find all of the articles that are specifying locations with nanometer precision and round them up. —SW— converse 02:26, 28 February 2012 (UTC)
{{Coord}}'s |type= parameter, where present, gives us an indicator for calculating the the required precision; for example, |type=city requires less precision than |type=landmark. that said, six decimal places should always be sufficient. I seem to remember being taught that one should truncate, not round, coordinates (where one is not referring back to a map for a more exact point); is that so, or is my memory playing tricks Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 10:20, 28 February 2012 (UTC)
From my numerical methods course several decades ago, I recall that rounding is generally more appropriate than truncating, unless one is more concerned with not exceeding a minimum or maximum than with obtaining the closest practical value. If coordinates are expressed in decimal degrees, one might want to change a rounded result of 360 to 0. Similarly, a rounded result of 55°60' should change to 56°00'. Jc3s5h (talk) 15:48, 28 February 2012 (UTC)

Fixing incorrect names linked to the redirects marked with the R from incorrect name template

My request is trigged by the recent deletion discussion of the redirect:Talinn. Talinn is an implausible typo of Tallinn and, as such, useful redirect. At the same time, there was a number of links linking to this incorrect name without being fixed for years as they had perfectly normal blue links and they are quite hard to notice. Therefore I propose that if the redirect is marked with {{R from incorrect name|Correct name}} template, the bot should automatically fix incoming links (from articles only, excluding talk pages, user pages and project pages) replacing them with the correct spelling. In case of the above example (Talinn) that means that bot will replace all links linked to 'Talinn' with links to correct spelling 'Tallinn'.

Currently there are 65 pages marked with this template, which is not a large number. However, as a rule they are not regularly checked by editors and therefore these misspellings which could be easily fixed by bot may stay unfixed for the long time. Beagel (talk) 19:20, 28 February 2012 (UTC)

Nope. See WP:NOTBROKEN. —SW— yak 21:14, 28 February 2012 (UTC)
I really don't believe that WP:NOTBROKEN applies here. WP:NOTBROKEN states clearly that "This rule does not apply to cases where there are other reasons to make the change, such as linking to an unprintworthy redirect." The request concerns only unprintworthy redirects marked with the {{R from incorrect name}} template and not any other type of redirects. Beagel (talk) 21:42, 28 February 2012 (UTC)
If the redirect is an implausible typo, then it should be taken to RfD and deleted per WP:RFD#DELETE (criteria #8) or speedy deleted per WP:CSD#R3 (if it was recently created). Otherwise, if the typo is plausible, then the redirect should stay, and you can fix them manually if you want (although nothing technically needs to be fixed because when you click on the link, you end up at the right page, regardless of what's going on behind the scenes). It's very unlikely that you'll find consensus for a bot to perform this task, as many will likely judge it to fall under WP:COSMETICBOT. —SW— verbalize 21:55, 28 February 2012 (UTC)
WP:NOTBROKEN or WP:COSMETICBOT do not apply here. If the name is incorrect, then it is broken. However, the list should be reviewed by humans to make sure those redirects are indeed due to incorrect names, and not simple mistaggings. It could be done via AWB without any BRFA though, so if the task is small, you might want to do that instead of going through bot trials etc. But if someone prefers to do it via bots, I'm fine with it too.Headbomb {talk / contribs / physics / books} 21:57, 28 February 2012 (UTC)

The main issue is not if you end up the right place by clicking on the link, but that the article containing the link contains also a misspelling/typo, which is hard to notice and therefore it may stay not corrected for quite a long time. To make more clear what I meant, just some examples I proposed to be changed by bot:

At the same time, it should not included redirects if there is no consensus what is the the common name in English or if different forms are accepted. E.g. Kyiv should be not automatically replaced with Kiev. It should also not replace diacritics. In this context, the proposal that there should be approved list makes a sense. Beagel (talk) 22:30, 28 February 2012 (UTC)

A couple of Ideas

I have a couple of ideas for bots and I am a programmer so I wouldn't mind making these myself (I think I might even enjoy it). I just wanted to check here to see if there are already bots doing these or if these are stupid ideas (feel free to say so) or something else.

My first idea is for an antivandalism bot. I have noticed that some vandalism is does not make actual words. My idea is the bot that follows the recent changes and if an edit is mostly words it does not find in a dictionary it would either just revert it or alert someone or something.

My other idea is for an "as of" bot. It would wander wikipedia and if it finds any phrases that say "as of" and then a date older than, say five years, it would leave a nice note on the article talk page (or maybe on an associated project page or something).

Those are my ideas, let me know what you think. Eomund (talk) 03:36, 29 February 2012 (UTC)

Another option for an "as of" bot is to change the article itself to use {{As of}}. GoingBatty (talk) 03:55, 29 February 2012 (UTC)
For the anti-vandal bot, I think listing a report would be ok, but not automatically reverting it. For instance, some gibberish-like text is actually legitimate, like this: <math>x={-b\pm\sqrt{b^2-4ac} \over 2a}</math> —SW— confer 15:43, 29 February 2012 (UTC)

Chemistry compounds templates

Please make a bot to order the templates in Category:Chemistry compounds templates by period number.--Kc kennylau (talk) 10:04, 29 February 2012 (UTC)

84 pages of adding {{DEFAULTSORT}} is the kind of thing one does by hand. Now, it seems to me that finding the Chemistry compounds templates will become quite hard if they're ordered by period number. Can you point to a discussion when a consensus opinion was formed that this was a Good Thing to do? Josh Parris 10:59, 29 February 2012 (UTC)
Done by hand.--Kc kennylau (talk) 05:30, 2 March 2012 (UTC)

List of articles using a particular field

Hello, would it be possible to generate a list of all articles that use the "distributor" field in {{Infobox video game}}? I suspect that it is only being used for online services such as Steam, and not for physical distributors as intended, and as such should be re-purposed to make that clearer for editors and readers. ▫ JohnnyMrNinja 16:08, 3 March 2012 (UTC)

I'll make the list. —  HELLKNOWZ  ▎TALK 16:28, 3 March 2012 (UTC)
Oh wow, cool thanks. ▫ JohnnyMrNinja 16:40, 3 March 2012 (UTC)
|distributor=
count value
91 [[Nintendo]]
42 Sega
40 Nintendo
37 [[Apple Inc.|Apple]]
23 [[Sega]]
21 [[Electronic Arts|EA Distribution]]
17 KCET
16 Various
15 [[Konami Computer Entertainment Tokyo]]
14 [[Electronic Arts]]
13 [[Take-Two Interactive]]
12 [[Atari|Atari Inc.]]
12 [[Steam (software)|Steam]]
12 Sony Computer Entertainment
10 [[Apple Inc.]]
10 [[Atari]]
9 [[Ubisoft]]
8 [[Bandai Namco Games]]
8 [[Valve Corporation]]
8 KDE GmbH
7 Atari
6 [[Activision]]
6 [[Microsoft]]
6 [[Sony Computer Entertainment]]
5 [[App Store (iOS)|App Store]]
5 [[Disney Interactive Studios]]
5 [[Electro Source]]
5 [[Square Enix]]
5 [[Steam (software)|Steam]]<br>[[Desura]]
5 Konami Computer Entertainment Tokyo
4 [[2K Games]]
4 [[Activision Blizzard]]
4 [[Big Fish Games]]
4 [[Desura]]
4 [[Eidos Interactive]]
4 [[Electronic Arts]] <small>(retail)</small><br />[[Steam (software)|Steam]] <small>(online)</small>
4 [[Konami Digital Entertainment GmbH]]
4 [[Konami of America]]
4 [[Psygnosis]]
4 [[Steam (software)|Steam]] <small>(online)</small>
4 [[Time Warner]]
4 [[Valve Corporation]] ([[Steam (software)|Steam]])
4 [[Vivendi Games|Universal Interactive Studios]]
4 [[Warner Bros. Interactive Entertainment]] <br> [[Time Warner]]
4 Electronic Arts
4 Ingram Entertainment
4 Konami
4 Konami Digital Entertainment
4 Mattel
4 Namco
3 [[20th Century Fox]]
3 [[EA Games|EA Distribution]] <br> [[Nintendo]]
3 [[EA Sports]]
3 [[FormGen]]
3 [[Infogrames]]
3 [[Microsoft Game Studios]]
3 [[Rock-Ola]]
3 [[The Learning Company]]
3 [[THQ]]
3 [[Universal Interactive Studios]]
3 [[Warner Bros. Interactive Entertainment]]
3 [[Warner Bros. Interactive]]
3 {{vgrelease|EU=[[Nintendo]]}}
3 {{vgrelease|EU=[[Ubisoft]]}}
3 {{vgrelease|JP=[[Sega]]}}
3 Activision <small>(retail)</small><br />[[Steam (software)|Steam]] <small>(online)</small>
3 Atari?
3 Capcom
3 City Interactive
3 Microsoft
3 Tectoy
2 [[Ambrosia Software]]
2 [[Apple Inc.|Apple]] (iOS)
2 [[Banpresto]]
2 [[Deep Silver]]
2 [[EA Games|EA Distribution]]
2 [[Electronic Arts|EA Distribution]] <br> [[Nintendo]]
2 [[Epic MegaGames]]
2 [[Gameloft]]
2 [[Good Old Games]]<br />[[Gamersgate]]<br />[[Direct2Drive]]<br />[[Desura]]
2 [[Ignition Entertainment]]
2 [[Ingram Entertainment]]
2 [[JoWood Productions]]
2 [[Konami Computer Entertainment Japan]]
2 [[Konami Digital Entertainment]]
2 [[Konami]]
2 [[Mattel]]
2 [[MicroProse]]
2 [[Mindscape]]
2 [[Steam (software)|Steam]] (PC)
2 [[Team Soho]]
2 [[Tecmo]]
2 [[The Walt Disney Company]]
2 [[Ubisoft]] <br /> [[Nintendo]] <br /> [[Eidos Interactive]] <br /> [[Winning Moves]]
2 [[Valve Software]]<br />[[Gametap]]<br />[[Desura]]
2 [[Vectorbeam]]
2 [[Vivendi Universal Games]]
2 [[Zoo Digital Publishing]] (PAL)
2 {{vgrelease|EU=[[505 Games]]}}
2 {{Vgrelease|EU=[[Metro 3D]]}}
2 <!-- Don't add anything here, because EA distributed all the Sims games -->
2 Artix Entertainment, LLC
2 Atari Games
2 Atari Inc.
2 Braintonik Games
2 Camerica
2 Gamers Gate, Manifesto Games & Macgamestore
2 Jaleco
2 Konami Computer Entertainment Japan
2 MicroProse<br>[[Hasbro Interactive]]<br>[[2K Games]]
2 Nintendo?
2 Parker Brothers
2 Sierra Studios <small>(retail)</small><br />[[Steam (software)|Steam]] <small>(online)</small>
2 Steam
2 ValuSoft
2 WildTangent
1 (Various)
1 [[1C Company]]/[[MTV Games]] (USA)
1 [[1C Games]], [[Amazon.com|Amazon]], [[Steam (software)|Steam]], [[Impulse (content delivery)|Impulse]], [[GamersGate]], [[Gamesload]], [[Xfire]], etc.<ref name="Distributors">{{cite web|url=http://www.rignroll.com|title=Official release of Rig'n'R
1 [[2K Sports]]
1 [[505 Games]] (PAL)
1 [[505 Games]] [[Aspyr Media]] [[Steam (software)|Steam]]<ref name="steam">↵{{cite web | title=Death Track: Resurrection on Steam | publisher=[[Steam (software)|Steam]] | url=http://store.steampowered.com/app/7840/ | date=2009-05-06 | accessdate=200
1 [[ABC Studios]]
1 [[Acclaim Entertainment]]
1 [[Activision Blizzard]] <small>(Some copies were sold as the "[[Activision]]" brand)</small>
1 [[Activision]]<br />[[Aspyr Media]]<br />[[1C Company]]<br />[[Valve Corporation]]
1 [[Activision]]<br/>[[ABC Studios]]
1 [[Activision|Activision Value]]
1 [[Akella]] (Russia)<br />[[Microsoft]]/[[Shogakukan]] (Japan)<br />[[Moving Editora]] ([[Brazil]])<br />[[CD Projekt]] (Poland)<br />[[Seven M]] (Hungary)
1 [[Akella]]<br />[[Iceberg Interactive]]<br />[[Wendros]]
1 [[Alliance Distributors]]
1 [[AllM]], Chinese Gamer, [[NEXON Corporation|Nexon]] , [[ijji]] , [[Level Up! Games]] , [[NEXON Corporation|Nexon Europe]]
1 [[Amanita Design]],<ref>[https://sites.fastspring.com/amanitadesign/instant/machinarium Amanita Design Store - Fastspring]</ref> [[Valve Corporation]],<ref name="Steam">[http://web.archive.org/web/20100213083756/http://store.steampowered.com/app/40
1 [[American Girl]]
1 [[American Laser Games]]
1 [[AND1]]
1 [[Andamiro]]
1 [[Apex Computer Productions]]
1 [[App Store (iOS)|App Store]], [[Android Market]]
1 [[App Store (iOS)|App Store]], [[Zune Marketplace]]
1 [[App Store (iOS)|App Store]]/[[Android Market]]
1 [[Apple Core]]
1 [[Apple Inc.]] (iPhone OS)
1 [[Apple Inc.]], [[Google Inc.]]
1 [[Apple Inc.|Apple]], [[Google]]
1 [[Apple Inc.|Apple]], [[Google]], [[Sony]]
1 [[Apple Inc.|Apple]], [[Microsoft]]
1 [[Apple Inc.|Apple]], [[Tectoy]]
1 [[Apple Inc|Apple]]
1 [[Apple]] (iOS)<br />[[Google]] (Android)
1 [[Ascaron]] (UK & Ireland)<br>[[Atari]] (Germany)<br>[[SimBin]] (Scandinavia & Finland)<br>[[Akella]] (Russia)<br>[[Ecofilmes]] (Portugal)<br>[[Planeta DeAgostini]] (Spain)
1 [[ASCII (company)|ASCII]] (X1, MSX, FM-7, PC) <br> [[Nintendo]] (Famicom, VC)
1 [[Aspyr Media]] (Mac OS X)
1 [[Aspyr Media]] (Retail) [[GamersGate]] (Online) [[GamesPlanet]] (Online)
1 [[Aspyr Media]] (Retail) ↵↵[[Direct2Drive]] <small>(Online)</small> ↵↵[[Steam (software)|Steam]] <small>(online)</small>
1 [[Atari, Inc.]]
1 [[Atari, Inc]]
1 [[Atari]] <small>(outside [[Germany]])</small>
1 [[Atari]], [[Namco]], [[Ubisoft]]<br>Creative Distribution (Wii)
1 [[Atari]],<ref name="infogrames1" /><small>(retail)</small><br />[[Steam (software)|Steam]]<ref>{{cite web|url=http://store.steampowered.com/app/9870|title=Ghostbusters: The Video Game|publisher=Steam|accessdate=2009-08-26}}</ref><small>(online)</
1 [[Atari]]<br />[[Valve Corporation]]<br />Mobius Games
1 [[Atari]]<br/>[[Auran]]<br/>[[Focus Home Interactive]]<br/>Koch Media
1 [[Atari]]<ref name=distributor/>
1 [[Atari|Atari Inc.]]/Horror Games
1 [[Bandai Namco Games]] (rerelease)
1 [[Bandai]]
1 [[Bandai]] <small>(European NES version)</small> <br/> [[Metro (game company)|Metro]] <small>(Australian NES version)</small>
1 [[BBC Multimedia]]
1 [[BBC Online]]
1 [[Behaviour Interactive]]
1 [[Bigfishgames|Big Fish Games]] (USA)<br>[[Meridian4]] (North America)<br>[[PROEIN]] (Spain)<br>[[ATARI]] (Italy)<br>[[NoviyDisk]] (Russia)
1 [[Bigfishgames|Big Fish Games]] (USA)<br>[[UbiSoft]] (Scandinavia & Finland)<br>[[NoviyDisk]] (Russia)<br>[[EMME]] (Germany)<br>[[Nobilis]] (France)<br> [[GSP]] (UK & Ireland<br>[[PROEIN]] (Spain)
1 [[BioWare]]
1 [[Blue Ribbon (software house)|Blue Ribbon]]
1 [[Buena Vista (Walt Disney Company)|Buena Vista]]
1 [[Capcom]]
1 [[Capcom]] (Arcade version)
1 [[Capcom]] (Japanese version)<br>[[Village Roadshow Limited|Roadshow Interactive]] (Australia and New Zealand)
1 [[Capcom]] <small>(Japan)</small>
1 [[Cartoon Network Interactive]]
1 [[Cartoon Network|Cartoon Network Interactive]]
1 [[CBBC]] and [[Ketnet]]
1 [[Centuri]]
1 [[CipSoft]]
1 [[Codemasters]]
1 [[Commodore International|Commodore]]
1 [[Contrail (company)|Contrail]]
1 [[Cornelsen]]
1 [[Crotch Zombie Productions]]
1 [[D3 Publisher]]
1 [[Data East]]
1 [[Deep Silver]]<br/> [[Strategy First]]
1 [[DeNA]]
1 [[Destination Software]] <small>(GBA)</small>
1 [[Destination Software]]/[[Hip Games]]/[[Namco]]
1 [[Direct2Drive]]<br />[[GamersGate]]<br />[[Metaboli]]<br />[[Steam (software)|Steam]]<br />GameTree (Mac OS X)<ref name=Mac />
1 [[Disney Interactive Media Group]]
1 [[Disney Interactive Studios|[Disney Interactive]]
1 [[Disney Interactive Studios|Touchstone Games]]
1 [[Disney Interactive]] <br/> [[Cartoon Pizza|Jumbo Pictures]]
1 [[Disney Interactive]]<br>[[Valve Corporation]] (Steam release)
1 [[Dreamcatcher Interactive]] [[GamersGate]] (Online)
1 [[Dreamcatcher Interactive]] [[GamesPlanet]] (Online)
1 [[Dreamline]]
1 [[DSI Games]]
1 [[DSI Games]] <small>(NDS/GBA)</small>
1 [[Duke University Medical Center#Duke University Hospital|Duke University Medical Center]] and [[Virtual Heroes, Inc.]]
1 [[EA Distribution]]
1 [[Egmont (media group)|Egmont Interactive]]<br />[[Xicat Interactive, Inc.]]
1 [[Eidos Interactive|Eidos]]
1 [[Electronic Arts]] (PSX)<br />[[Zoo Digital Publishing]] (GBA)
1 [[Electronic Arts]] (retail)<br />[[Apple Inc.|Apple]] (iPhone OS)
1 [[Electronic Arts]] (South America)
1 [[Electronic Arts]] {{small|(retail)}}<br />[[Steam (software)|Steam]] {{small|(online)}}
1 [[Electronic Arts]] <small>(retail)</small><br />[[Steam (software)|Steam]] <small>(online)</small><br /><!-- Sierra/Activision/Blizzard/Vivendi had nothing to do with this game -->
1 [[Electronic Arts]] <small>(retail)</small><br/>[[Steam (software)|Steam]] <small>(online)
1 [[Electronic Arts]], [[Mad Catz]]
1 [[Electronic Arts]], [[Valve Corporation]]
1 [[Electronic Arts]]<br />[[K2 Network]] (acquisition)
1 [[Electronic Arts]]<ref name="Dragon143">{{cite journal↵ | title=The Role of Computers↵ | author=Hartley, Patricia, and Kirk Lesser↵ | journal=Dragon↵ | issue=143↵ | date=March 1989↵ | pages=76–78}}</ref>
1 [[Electronic Arts]]<ref>{{cite journal↵ | last = Mclean↵ | first = Mickey↵ | year = 1989↵ | month = December↵ | title = News & Products: Defend Aladda↵ | journal = [[Compute!]]↵ | volume = 11↵ | issue = 115↵ | pages = p. 157↵ | location = North Car
1 [[Electronic Arts|EA Distribution]] <br /> [[Nintendo]]
1 [[Electronic Arts|EA Distribution]] <br> [[Time Warner]] [SCEA]
1 [[Electronic Arts|EA Distribution]], Avenquest Software
1 [[Electronic Arts|EA Games]]
1 [[Electronic Zoo]]
1 [[Epoch Co.]]
1 [[Espaço Informática]]
1 [[Excite]]
1 [[Expansive Worlds]] <small>(online)</small>
1 [[Far East Video]]
1 [[Far East Video]] (EU)
1 [[Final Judgment Games Inc.]]
1 [[Focus Features|Focus Home Interactive]], [[Laika (company)|Laika]]
1 [[Focus Home Interactive]]
1 [[Focus Home Interactive]], [[Digital Bros]], [[1C Company]], [[Dreamcatcher Interactive]], [[Valve Corporation]]
1 [[Fox Interactive]]<br>[[Activision Blizzard]]
1 [[French-Bread]]<br />[[Gravity (company)|GRAVITY Co., Ltd.]]<br />[[Level Up! Games]]<br />[[Game Flier]] <br/>[[Atari]]
1 [[From Software]]<br/>[[ASCII Entertainment]]
1 [[Game A Tron]]
1 [[Gameloft]], phone service providers
1 [[GamesPlanet]] (Online)
1 [[GameStop]] (online)<br/>[[Gamestation]] (online)
1 [[GameStorm]] <br> [[AOL]] <br> [[Electronic Arts]]
1 [[GarageGames]], [[Trymedia]]
1 [[G-Collections]]
1 [[Genki (company)|Genki]]
1 [[Global Star Software]]
1 [[Got Game Entertainment]] (Orc Lords)
1 [[Grandslam Entertainment]]
1 [[Gremlin Graphics]]
1 [[Griptonite Games]] (Game Boy Advance), [[Amaze Entertainment]] (Consoles)
1 [[GT Interactive Software|GT Interactive]]
1 [[GT Interactive]]
1 [[GT Interactive]], [[Valve Corporation]] (Steam), [[Virgin Interactive|Virgin Interactive Entertainment Ltd.]] (Europe)
1 [[GT Interactive|GTI]] <br> [[Electro Source]]
1 [[Hangame]]
1 [[Hasbro Interactive]]
1 [[Hasbro]]<br>[[Panini Comics]]
1 [[HD Interactive]]<br/> [[Novalogic]]
1 [[HiTech Creations]]
1 [[HOT・B]] <small>(''North America'')</small>
1 [[Hudson Soft]]<ref name="tgbus"/>
1 [[IGN Entertainment|Direct2Drive]]
1 [[ImaginEngine|ImaginEngine Entertainment]]
1 [[Impulse (content delivery)|Impulse]]</br>[[Steam (software)|Steam]]</br>[[GamersGate#GamersGate|GamersGate]]</br>Arcen Games
1 [[Impulse]], [http://www.impulsedriven.com/ Impulsedriven.com]
1 [[IndiaGames]] <small>(GoD)</small><br />
1 [[Ingram Entertainment Holdings Inc.|Ingram Entertainment]]
1 [[Interactive Magic]]
1 [[Internet Gaming Gate]], [[Garena]](closed)
1 [[iTunes]]
1 [[iTunes]], [[Android Market]], [[Zune Software]], [[Ovi Store]], [[Samsung Apps]]
1 [[Jaleco]]
1 [[JAST USA]]
1 [[Jim Henson Interactive|Jim Henson Home Interactive]]
1 [[JoWood Productions]]<br />[[Atari]]
1 [[JoWood]],<br>[[Aspyr Media|Aspyr]]
1 [[Kaga Create]] (PS2)
1 [[Kalypso Media]] (Retail)<br />[[GamesPlanet]] (Online)<br />[[Direct2Drive]] (Online)<br />[[Steam (software)|Steam]] (Online)<br />[[Impulse (content delivery)|Impulse]] (Online)<br />[[OnLive]]
1 [[Kaneko]]<br>↵{{vgrelease|JP=[[Taito Corporation]]}}
1 [[Kirin Entertainment]]
1 [[Koch Media]] <small> (UK)</small>
1 [[Koch Media]], [[SouthPeak Games]]{{Citation needed|date=April 2010}}
1 [[Konami Digital Entertainment Co., Ltd.]]
1 [[Konami]], [[Ocean Software]]
1 [[Konami|Konami of Europe]]
1 [[Kongregate]], [[The Casual Collective]]
1 [[Kongregate]], [http://www.handdrawngames.com/ Handdrawngames.com], [http://old.casualcollective.com/ Casualcollective.com]
1 [[KSS (company)|KSS]]
1 [[Legacy Interactive]]<br />[[Valve Corporation]]
1 [[Lego Group]]
1 [[Lighthouse Interactive]]
1 [[Loriciel]]
1 [[LucasArts]] <br/> [[Victor Entertainment]] (Japanese release)
1 [[LucasArts]] <small>(Worldwide)</small>
1 [[LucasArts]]/[[Sega]]
1 [[Ludum Dare]]
1 [[MacPlay]] (Mac version)
1 [[Mad Catz]] (North American Xbox 360 version)
1 [[Madman Entertainment]]<ref>{{cite press | date=July 16, 2009 | title=Aussie Distributor Goes Mad | url=http://games.ign.com/articles/100/1004739p1.html | publisher=[[Madman Entertainment]] | accessdate=2011-04-17}}</ref>
1 [[Major League Baseball]]<br>[[Nickelodeon]]
1 [[Makena Technologies]]
1 [[Masque Publishing]] (Retail) [[Impulse (content delivery)|Impulse]] (Online)↵[[GamersGate]] (Online)
1 [[Mastertronic|Virgin Mastertronic]]<br/>[[Virgin Games]] <small>(NES)</small>
1 [[Mattel Interactive|Mattel Media]]
1 [[Mattel|Mattel Games]] <br> [[Activision Blizzard]]
1 [[Metaversum GmbH]]
1 [[Microsoft Game Studios]] (Japanese Xbox version)<br>[[Mediaquest]] (Japanese Windows version)<br>[[Sega]] (Japanese PS2 version)
1 [[Microsoft Kids]]
1 [[Microsoft Studios (game studio)|Microsoft Game Studios]]
1 [[Microsoft Studios (game studio)|Microsoft Studios]]
1 [[Microsoft Studios (game studio)|Microsoft Studios]]<ref name="Tsukayama0606" />
1 [[Microsoft]]<br />[[Riverhillsoft]] <small>(Japan)</small>
1 [[Midway Games]]
1 [[Midway Games|Bally Midway]]<br/>[[ENCOM International]]
1 [[Midway Games|Midway]]
1 [[Milton Bradley Company|Milton Bradley]]
1 [[Mindscape]] (US)
1 [[Mod DB]]
1 [[Mountain King Studios]]
1 [[Mythic Entertainment]] <small>(North America)</small>
1 [[Namco Bandai Games]]
1 [[Namco Bandai Games|Namco Bandai]]
1 [[Namco Bandai Partners]] ([[Europe]], [[Australia]])<br />[[Microsoft]] ([[Asia]] Except [[Japan]])
1 [[Namco Bandai]] (JP, EU, USA)
1 [[Namco Bandai]]<ref name="123kinect">{{cite web |url=http://123kinect.com/yoostar-2-kinect-game-next/ |title=Yoostar 2 is ‘the next Guitar Hero’ |date=2011-01-08 |accessdate=2011-03-04}}</ref>
1 [[Namco]]
1 [[Navarre Corporation]]
1 [[Nelvana]] <br> [[Disney-ABC Domestic Television]]
1 [[Neowiz Games]]
1 [[Neowiz Games|Pmang]], [[Good Game]], [[The9]], GameOn, IAHGames
1 [[Neowiz]]<br/>[[NHN USA]]<br/>[[Tencent]]<br/>WarTown<br/>[[Asiasoft]]
1 [[New Line Cinema|New Line Games]]<br>[[Warner Bros. Games]]
1 [[Nickelodeon (TV channel)|Nick Games]]
1 [[Nickelodeon (TV channel)|Nickelodeon]]
1 [[Nickelodeon (TV channel)|Nickelodeon]], [[Nick Jr.]]
1 [[Nickolas Marentes]]
1 [[Nintendo]] (Virtual Console)
1 [[Nintendo]] <br> [[Sega]]
1 [[Ocean Software]]
1 [[Paramount Pictures]]
1 [[Paramount Pictures|Paramount]]
1 [[PC Gamer]] magazine
1 [[Pearson Education]]
1 [[Philips|Philips Interactive Media]]
1 [[Pinnacle Software]] (Windows)<br />[[Valve Corporation]] (Steam)<br />DesuraNET (Desura)
1 [[Pinnacle Software]] [http://www.pinnacle-software.co.uk/] (Windows)<br>[[Valve Corporation|Valve]] (Steam)<br>DesuraNET (Desura)
1 [[PlayStation Network]], [[Mac App Store]]
1 [[PlayStation Network]], [[Xbox Live Arcade]], [[Steam (software)|Steam]]
1 [[PocketGear]], [[Handango]], other online retailers
1 [[Q Entertainment]]
1 [[Radio Shack]]
1 [[Ralston Purina]]
1 [[Red Ant Enterprises]]<br/>[[Trymedia]]
1 [[RedSpotGames]] (Dreamcast)
1 [[Riverdeep]] (Mac/Windows, via [[GameTap]])
1 [[Romstar]]
1 [[Sega of America]]
1 [[Sega]] (Japan)
1 [[Sega]] (Japanese PC Version)
1 [[Sega]] (Japanese version)
1 [[Sega]] (Worldwide) <br> [[Tec Toy]] (Brazil) <br> [[Vivendi Universal Games]] ([[Steam (software)|Steam]])
1 [[Sega]] (Worldwide)<br />[[Tec Toy]] ([[Brazil]])<br />[[Valve Corporation]] ([[Steam (software)|Steam]])<br />[[Ce-Asia]] ([[China]])
1 [[Sega]] <br> [[Nintendo]]
1 [[Sega]] <small>(retail)</small><br />[[Steam (software)|Steam]] <small>(online)</small>
1 [[Sega]] <small>(retail)</small><br>[[Steam (software)|Steam]] <small>(online)</small>
1 [[Sega]] <small>(Virtual Console)</small>
1 [[Sega]], [[Valve Corporation]]
1 [[SEGA]]<br>Zone X<br>Quantum Amusement Corp.<br>Hit-Style<br>Sega Taiwan<br>RGB<br>Sega Korea
1 [[Simon & Schuster]]
1 [[Sinclair Research]]
1 [[SkyBox International]], Inc.
1 [[SNK Playmore]]
1 ''[[Softdisk (disk magazine)|Softdisk]]'' (Apple II), ''[[Big Blue Disk]]'' (DOS)
1 [[SoftSide]] Magazine
1 [[Sold Out]], Red Ant Entertainment, PAN Vision
1 [[Sony Computer Entertainment America]]
1 [[Sony Computer Entertainment Japan]]
1 [[Sony Computer Entertainment]] (PSN)<br/> [[Microsoft Studios (game studio)|Microsoft Studios]] (XBLA)<ref name="EGSE">{{cite web |url= http://www.eurogamer.net/articles/2011-11-03-joe-danger-special-edition-for-xbox-live-arcade-announced |title=J
1 [[Sony Computer Entertainment|Sony Computer Entertainment Inc.]]
1 [[Sony Online Entertainment]]
1 [[SouthPeak Games]] (US & UK),<ref>{{cite web↵|url=http://godsandheroes.com/southpeak-to-distribute-gods-heroes-for-retail/↵|title=SouthPeak to Distribute Gods & Heroes for Retail↵|publisher=Heatwave Interactive↵|date=May 12,
1 [[Square Enix]] <br> [[Valve Corporation]]
1 [[St.GIGA]]
1 [[Steam (software)#Steamworks|Steam]] (online)
1 ''[[Steam (software)|Steam]]''
1 [[Steam (software)|Steam]] (online)
1 [[Steam (software)|Steam]] (online)<br />[[Tripwire Interactive]] ([[North America|NA]])<br />[[Iceberg Interactive]] ([[Europe|EU]])
1 [[Steam (software)|Steam]] (Windows)
1 [[Steam (software)|Steam]] {{small|(online)}}
1 [[Steam (software)|Steam]] <small>(online)</small><br />[[Electronic Arts]] <small>(retail)</small>
1 [[Steam (software)|Steam]] <small>(online)</small><br>[[Sega]] <small>(retail)</small>
1 [[Steam (software)|Steam]] <small>(online)</small><ref name='Steam App 12900'> {{cite web | url = http://store.steampowered.com/app/12900/ | title = AudioSurf | accessdate = 2010-06-23 | work = [[Steam (software)|Steam]] | publisher = [[Valve Corpo
1 [[Steam (software)|Steam]], [[Desura]]
1 [[Steam (software)|Steam]], [[Direct2Drive]], [[Xbox Live]]
1 [[Steam (software)|Steam]], [[Impulse (content delivery)|Impulse]], [[OnLive]]
1 [[Steam (software)|Steam]]<!-- there is more than just steam, but this is the only confirmed distributor confirmed as yet -->
1 [[Steam (software)|Steam]]<br />Telltale Games<br />[[Xbox Live Arcade]]
1 [[Steam (software)|Steam]]<br/>{{small|(online)}}<br/>[[Desura]]<br/>{{small|(online)}}<br/>[[Ubuntu Software Center]]<br/>{{small|(online)}}
1 [[Steam (software)|Steam]]<br/>{{small|(online)}}<br/>[[GamersGate]]<br/>{{small|(online)}}
1 [[Steam (software)|Steam]]<ref>[http://store.steampowered.com/app/32410/ Steam - Lucidity]</ref><br />[[Xbox Live Arcade]]
1 [[Steam]], [[Direct2Drive]], [[Gamers Gate]], [[Impulse]], [[Desura]], [[Mac App Store]], [[OnLive]]
1 [[Stern (game company)|Stern Electronics]] (U.S)
1 [[Strategy First]]
1 [[Sunsoft]]
1 [[Taito Corporation|Taito]], [[Romstar]]
1 [[Taito]]
1 [[Takara]]
1 [[Take 2]]
1 [[Take-Two Interactive]] <br />[[Capcom]] (Japan)<br />[[Valve Corporation]]/[[Microsoft]] (download)
1 [[Take-Two Interactive]] <br> [[Cat Daddy Games]]
1 [[Take-Two Interactive]] <ref>http://www.newegg.com/Product/Product.aspx?Item=N82E16874166012&cm_re=tropico_3-_-74-166-012-_-Product</ref>
1 [[Tecmo Koei]]
1 [[Tecmo Koei]], [[Aeria Games and Entertainment|Aeria Games]]
1 [[The Software Toolworks]]
1 [[THQ]], [[Russobit-M]]
1 [[Time Warner]] <br /> [[Nintendo]]
1 [[Time Warner]] <br> [[Nintendo]] <br> [[Lego Group]]
1 [[Time Warner]]<br />[[Nintendo]]<br />[[Lego Group]]
1 [[Time Warner]]<br />[[Square Enix]]
1 [[Toho]]
1 [[Tommo, Inc.]]
1 [[Tonka|Tonka Corp.]]
1 [[Trend Redaktions]]
1 [[TriStar Pictures]]
1 [[Trymedia]]
1 [[Twilight Frontier]]<br>[[07th Expansion]]<br>[[Kaga Create]] (PSP)
1 [[Ubi Soft Entertainment]]
1 [[Ubuntu Software Centre]]<br>[[Desura]]<br>[[Steam]]
1 [[Unico]]
1 [[Universal Studios|Universal Interactive]]
1 [[Unknown Worlds Entertainment]]
1 [[ValuSoft]] (Retail) [[GamersGate]] (Online) [[GamesPlanet]] (Online) [[Steam]] (Online) [[YuPlay]] (Online)
1 [[Valve Corporation]] ([[Steam (software)|Steam]]), [[Good Old Games]]
1 [[Valve Corporation]] ([[Steam (software)|Steam]])<br>Noviy disk ([[Russia|RU]])<br>Virtual Programming, Ltd. ([[Mac App Store|App Store]])
1 [[Valve Corporation]] ([[Steam (software)|Steam]])<ref name="Steam">[http://store.steampowered.com/app/41210/ Steam - Eufloria]</ref>
1 [[Valve Corporation]] ([[Steam (software)|Steam]])<ref name="Steam">[http://www.steamgames.com/v/index.php?area=game&AppId=12900 Steam - AudioSurf<!-- Bot generated title -->]</ref>
1 [[Valve Corporation]] (Steam)<br />[[Microsoft Corporation]] (Xbox Live)
1 [[Valve Corporation]] (Steam)<br />[[Mindscape (software publisher)|Mindscape Group]] (Europe)<br />[[1С]] (Russia)<br />[[Merscom]] (North America)
1 [[Valve Corporation]] (Windows)
1 [[Valve Corporation]] <small>([[Steam (software)|Steam]])</small>
1 [[Valve Corporation]] <small>(Microsoft Windows)</small>, [[OnLive]] <small>(Windows, Mac, Micro-Console)</small>
1 [[Valve Corporation]] <small>(Steam)</small>
1 [[Valve Corporation]] <small>(Windows)</small>
1 [[Valve Corporation]] <small>(Windows)</small>, [[OnLive]] <small>(Windows, Mac, Micro-Console)</small>
1 [[Valve Corporation]], [[Direct2Drive]], [[GameStop]]
1 [[Valve Corporation]], [[Square Enix]] (for North America)
1 [[Valve Corporation]], [[Stardock]], [[Paradox Interactive]]
1 [[Valve Corporation]]<br />[[Koch Media]]
1 [[Valve Corporation]]<br />[[Vivendi Universal Games]] (former distributor)<br />[[Electronic Arts]] (2005-present)
1 [[Valve Corporation]]<br/>[[Sega]]
1 [[Valve Corporation]]<br>[[Microsoft]]
1 [[Valve Corporation|Valve Corp.]] <small>(Steam)</small>
1 [[Valve Corporation|Valve]]
1 [[Valve Software]]
1 [[Verizon Wireless]]
1 [[Virgin Games]]
1 [[Virgin Interactive]]<ref name=tnmanual />
1 [[Visco Corporation|Visco]]
1 [[Vision Park]]
1 [[Vivendi Games]]
1 [[Vivendi Games]]<br />[[Valve Corporation]]
1 [[Vivendi Games|Universal Interactive]] <br> [[Bandai Namco Games]]
1 [[Vivendi Games|Vivendi Universal Games]]<br>[[Sierra Entertainment]]
1 [[Vivendi Universal Games]]<br />[[Virtual Programming]] (Mac)
1 [[Vivendi Universal]]
1 [[Vivendi|Vivendi Universal]] {{small|(retail)}}<br />[[Steam (software)|Steam]] {{small|(online)}}
1 [[Walt Disney Animation Studios]]
1 [[Walt Disney Home Video]]
1 [[Walt Disney Pictures]]
1 [[Walt Disney Pictures]]<br />[[Walt Disney Studios Motion Pictures|Buena Vista Distribution]]
1 [[Walt Disney Pictures]]<br>[[DisneyToon Studios]]
1 [[Walt Disney Studios Home Entertainment]]
1 [[Warner Bros. Interactive Entertainment]] (Uncredited)
1 [[Warner Bros. Interactive Entertainment]]<br />[[Sony Computer Entertainment]]
1 [[WHA 2 Entertainment]], [[Lace Mamba Global]] (United States)<br>
1 [[WildTangent]]
1 [[Williams (gaming company)|Williams Electronics]]
1 [[Williams Street]]
1 [[Xbox Family Games]]
1 [[XPEC Entertainment]]
1 [[YNK Interactive]]
1 [[YNK Korea]], [[YNK Japan]], [[YNK Interactive]], [[Level Up! Games Philippines]], [[Aeria Games and Entertainment]]
1 [[Zoo Digital Publishing]]
1 [[Zoo Entertainment (video game company)|Zoo Entertainment]]
1 [http://web.archive.org/web/20100413231156/http://novelconcepts.co.uk/ NovelConcepts.co.uk], [http://www.casualcollective.com/ Casualcollective.com]
1 [http://www.bluegiantinteractive.com BlueGiant Interactive], [[Steam (software)|Steam]]
1 [http://www.contactmusic.com/ ContactMusic.com]
1 [http://www.gauntnet.com/ GauntNet.com]
1 [http://www.teamgigadrill.com/Blog.aspx Bad Sheep Gaming LLC]
1 [http://www.x-legend.com.tw/ X-Legend]([[Republic of China|Taiwan]])<br>[http://www.altamm.com.hk/ Alta Multimedia]([[Hong Kong]])<br>[http://www.gamania.co.jp/ Gamania]([[Japan]])<br>[http://www.cyberstep.com/ CyberStep]([[USA]])<br>[[NHN]] [[ijji
1 {{Collapsible list|[[Steam (software)|Steam]]<br/>Greenhouse<br/>[[GamersGate]]<br/>Impulse<br/>Deliver2Mac<br/>[[Direct2Drive]]<br/>Mac Game Store}}
1 {{flagicon|China}} [[Perfect World (company)|Perfect World]]<br/>{{flagicon|Taiwan}}{{flagicon|Hong Kong}}{{flagicon|Macau}} [[:zh:東遊玩子|Gameastor]]
1 {{flagicon|EGY}} [[Telecom Egypt]]<br>{{flagicon|KSA}} [[Saudi Telecom Company]]
1 {{plainlist|↵*[[3D Realms|Apogee Software]] (USA) (1992)↵*[[Manaccom]] (Australia)↵*[[GT Interactive]] (USA) (1993)↵*[[Activision]] (USA) (reissues)↵*[[Valve Corporation]] ([[Steam (software)|Steam]])↵}}
1 {{vgrelease new|NA|[[Warner Bros. Interactive Entertainment|Warner Bros.]]}}<ref>{{cite news|url=http://www.next-gen.biz/news/warner-bros-strengthens-partnership-sci|title=Warner Bros. Strengthens Partnership with SCi|work=[[Edge (magazine)|Edge]]|
1 {{vgrelease new|UK|[[G2 Games]]|ITA|[[Blue Label Entertainment]]|INT|[[GamersGate]]}}
1 {{vgrelease|[[United Kingdom|UK]]|[[Atari]]}}
1 {{vgrelease|[[United Kingdom|UK]]|[[Bandai]]}}
1 {{vgrelease|[[United Kingdom|UK]]|ASCARON Entertainment}}
1 {{vgrelease|AUS=[[Activision]]<ref>{{cite web | author=Kolan, Patrick | date=12 November 2006 | title=Capcom Splits From THQ in Australia | url=http://ps2.ign.com/articles/745/745473p1.html | publisher=IGN | accessdate=21 February 2010}}</ref>
1 {{vgrelease|AUS=[[Activision]]<ref>{{cite web | author=Kolan, Patrick | date=November 12, 2006 | title=Capcom Splits From THQ in Australia | url=http://ps2.ign.com/articles/745/745473p1.html | publisher=[[IGN]] | accessdate=2010-02-21}}</ref>
1 {{vgrelease|AUS=[[Nintendo Australia]]}}
1 {{vgrelease|AUS=[[Red Ant Enterprises]]}}
1 {{vgrelease|AUS=[[Ubisoft]]}}
1 {{vgrelease|AUS=Nintendo Australia}}
1 {{vgrelease|EU= Koch Media <ref>http://www.kochmedia.de/haendler/shop/public/ECD008149M.jsf</ref> <ref>http://www.kochmedia.co.uk/?rid=2633397091386737039029368</ref>}}{{vgrelease|NA=[[Navarre Corporation]] <ref>http://www.navarre.com/prodhome.aspx
1 {{vgrelease|EU=[[Codemasters]]}}
1 {{vgrelease|EU=[[Digital Bros]] (PS2)}}
1 {{vgrelease|EU=[[Eidos Interactive]]}}<br />[[Valve Corporation]] ([[Steam (software)|Steam]])
1 {{vgrelease|EU=[[Gameforge|Gameforge]]}} PlayNC under NCsoft and Shanda (China)
1 {{vgrelease|EU=[[Infogrames Entertainment, SA|Infogrames]]}}
1 {{vgrelease|EU=[[Ingram Entertainment Holdings Inc.|Ingram Entertainment]]}}
1 {{vgrelease|EU=[[Konami]]}}
1 {{vgrelease|EU=[[Nintendo]]<ref>{{cite web | author=Carless, Simon | date=November 3, 2005 | title=Nintendo Signs Up Capcom, Reveals Q1 Plans For Europe | url=http://www.gamasutra.com/view/news/7057/Nintendo_Signs_Up_Capcom_Reveals_Q1_Plans_For_Eur
1 {{vgrelease|EU=[[Ubisoft|Ubisoft Entertainment]]}}
1 {{vgrelease|EU=[[Virgin Interactive]]}}
1 {{vgrelease|JP=[[Square Enix]]|NA=Square Enix|EU=Square Enix|AUS=[[Ubisoft|Ubisoft Entertainment]]}}
1 {{vgrelease|JP=Arario}}{{vgrelease|Germany|DEU|[[Bigpoint Games|BigPoint]]}}{{vgrelease|NA=GameCampus}}{{vgrelease|South Korea|KOR|[[Hangame]]}}{{vgrelease|Indonesia|IND|PlayCircle}}{{vgrelease|EU=SevenGames}}{{vgrelease|Taiwan|TWN|[[:zh:松崗科技|Unali
1 {{Vgrelease|NA= [[Koei]]<ref name="Distributed exclusively by KOEI Corporation">{{cite web|url= http://www.nisamerica.com/games/crossedge/|title= Distributed exclusively by KOEI Corporation|publisher=[[NISA]]|accessdate=2009-06-24}}</ref>
1 {{vgrelease|NA= [[Tommo Inc.]]}}
1 {{vgrelease|NA=[[Koei]]|EU=[[Tecmo Koei]]|AUS=AFA Interactive}}
1 {{vgrelease|NA=[[Take-Two Interactive]]}}
1 {{vgrelease|NA=[[Take-Two Interactive]]}}↵{{vgrelease|EU=[[Atari]]}}
1 {{vgrelease|NA=[[THQ]]}}
1 {{vgrelease|NA=[[Viva Media]]}} [[Valve Corporation|Valve]] ([[Steam (software)|Steam]])
1 {{vgrelease|NA=[[Vivendi Universal]]}}
1 {{vgrelease|NA=Betson Enterprises}}
1 {{vgrelease|NA=G-Collections, JList}}
1 {{vgrelease|NA=JAST USA}}
1 {{vgrelease|NA=Tommo, Inc.}}
1 {{vgrelease|PAL=[[Mindscape]]}}
1 {{vgrelease|PAL=[[Nintendo of Europe]]<ref>{{cite web |date=August 21, 2007 |title=New Gem Added to Wii's Christmas Treasure Chest |url=http://www.gamespot.com/wii/adventure/projecttreasureislandz/news.html?sid=6177019&mode=all | publisher=[[GameSp
1 {{vgrelease|PAL=[[Nintendo]]<ref>{{cite web | author=Sinclair, Brendan | date=November 3, 2005 | title=Nintendo Europe picks up four from Capcom - DS News at GameSpot | url=http://www.gamespot.com/ds/action/viewtifuljoe/news.html?sid=6137173 | publ
1 {{vgrelease|World|WW|Com2uS}}<br>{{vgrelease|Brazil|BR|[[Tectoy|Tectoy Mobile]]}}
1 <!-- [[Steam (content delivery)|Steam]] (online) -->
1 <!-- Don't add anything here, because EA published all Sims games -->
1 <!-- only add if distributor is different from publisher -->
1 <!-- This field should be used for digital distribution -->[[GameTap]]<br />Telltale Games<br />[[Steam (software)|Steam]]<br />[[Xbox Live Arcade]]
1 <sup>[[Steam (software)|Steam]]</sup>[[Valve Corporation]]
1 <sup>[[United Kingdom|UK]]</sup> Marubeni<ref name="sprev">{{cite journal| author=Mott, Tony | title=UK Review: ''Mega Man 7''| journal=[[Super Play]]| issue=38 | publisher=[[Future Publishing]] | date=December 1995 | page=p. 42 | issn=0966-6199}}
1 4Kids Entertainment, TC Digital Games
1 Absolute Entertainment
1 Access Software
1 Acclaim Distribution
1 Acclaim Entertainment
1 Active Enterprises
1 Activision Blizzard
1 Activision Value <small>(2003)</small><br />GameMill Publishing <small>(2004)</small>
1 Activision<br />{{small|(retail)}}<br />[[Steam (software)|Steam]]<br />{{small|(online)<ref>{{cite web|url=http://www.steampowered.com/v/index.php?area=app&AppId=9050&cc=GB|title=''Doom 3'' on Steam|work=[[Steam (software)|Steam]]|publisher=[[Valv
1 American Sammy
1 Atari, Inc.
1 Australia and New Zealand distributed by Mindscape Asia Pty Ltd
1 Bandai
1 Bandai Korea, Bandai US, CDC Games, WeMade Entertainment
1 Bethesda Softworks (retail)<br />[[Steam (software)|Steam]] (online)
1 Bohemia Interactive Studio and several local publishers.
1 Brøderbund
1 Brøderbund Software
1 Bunch Games
1 Bungie Software
1 Casady & Greene
1 Cauldron Games
1 Chart Top Design
1 Chasseur de Bots
1 Cie Studios
1 City Interactive, [[Steam (software)|Steam <small>(online)<small>]]<ref>[http://store.steampowered.com/app/34800/ Chronicles of Mystery: The Scorpio Ritual on Steam]</ref>
1 Codemasters
1 Core Design
1 Cyber Sports
1 Data Age
1 Domark
1 Dragonfly (Korea), Ijji (former, US/EU), Joymax (current, Globally)
1 EA
1 EA Games
1 Eidos Interactive
1 Eidos Interactive, [[Valve Corporation]], [[GameTap]]
1 Electro Source
1 Electronic Arts (retail)<br />[[Steam (software)|Steam]] (online)
1 Electronic Arts <small>(retail)</small><br />[[Steam (software)|Steam]] <small>(online)</small>
1 Empire of Sports
1 Encore
1 Europe: [[Kalypso Media]]<ref name="Euro release">{{cite web|url=http://www.computerandvideogames.com/article.php?id=187268|title=Sins of a Solar Empire hitting UK retail|last=Bishop|first=Stuart |date=April 21, 2008|publisher=Computer and Video Ga
1 FamilySoft
1 Firesky<ref name="Firesky">{{cite web|url=http://www.stargateresistance.com/store.html |title=Firesky Store}}</ref><br>[[Direct2Drive]]<ref name="Direct2Drive">{{cite web|url=http://www.direct2drive.com/2/9057/product/Buy-Stargate:-Resistance-Downl
1 Flying Edge
1 Fox Video Games
1 Gamers Gate, Iceberg Interactive
1 GamersGate, [[Paradox Interactive]], [[Atari]]
1 Genki
1 Grinding Gear Games
1 Hasbro Interactive
1 Hudson Soft
1 Incentive Software
1 Infogrames
1 Ingram Entertainment, GTI, SVG, Electro Source, AEC
1 Ingram Entertainment, SVG, Electro Source
1 Interplay
1 Jaleco Entertainment
1 KCEJ
1 KCET, KDE & [[Betson Enterprises]] (North America)
1 KCET, KDE, KDE GmbH
1 KCET, KoA & KDE GmbH
1 KDE
1 Kemco
1 Koei
1 Konami Computer Entertainment Tokyo, Konami of America, Konami of Europe GmbH
1 Konami of America
1 Max Design
1 Mgame
1 Microsoft Game Studios
1 Microsoft Game Studios (retail) <br> Microsoft Game Studios/[[Valve Corporation]] (Steam)
1 Microsoft Game Studios,<br />Sony Computer Entertainment,<br />Nintendo
1 MTV Games <br/> [[Time Warner]]
1 Multiple Digital Distributors
1 NASA
1 Natsume
1 Neowiz Internet
1 Nintendo <br> Ajinomoto
1 Nintendo/Sega
1 None
1 '''Nothing Ltd.'''
1 Pangea Software <small>(''Nanosaur'')</small><br />Ideas From the Deep <small>(''Nanosaur Extreme'')</small>
1 Panyu Gaming Electronic Co. Ltd.
1 PC Retail - [[Aspyr Media]]<ref name="retail-ign">{{cite web|url=http://pc.ign.com/articles/976/976764p1.html|title=Defense Grid Coming to Retail|last=Ocampo|first=Jason |date=April 27, 2009|publisher=IGN|accessdate=2009-04-28}}</ref>
1 PopCap Games, [[Valve Corporation|Valve]] (via [[Steam (software)|Steam]])
1 Positive Gaming
1 '''PS2:''' Konami Computer Entertainment Japan, Konami Digital Entertainment & Konami Digital Entertainment GmbH↵'''Arcade:''' Konami Computer Entertainment Japan & Betson Enterprises
1 Reality Gap, IT Territory
1 Renovation Products
1 Rhys Andrews
1 Right Stuff
1 Roadshow Interactive (Australia and New Zealand)<br>[[Sony Computer Entertainment]] (PlayStation) (Europe, Australia)
1 Roblox Corporation
1 Roxor Games
1 Runic Games
1 Runic Games<br>[[Steam (software)|Steam]]
1 SCEA
1 SCEE
1 SCEJ
1 SCS Software
1 Sega <small>(retail)</small><br />[[Steam (software)|Steam]] <small>(online)</small>
1 Sega <small>(retail)</small><br>[[Steam (software)|Steam]]<ref>{{cite web|url=http://store.steampowered.com/app/34220/|title=Steam}} - ''Football Manager 2011''</ref> and [[Windows Games on Demand|Games for Windows Marketplace]]
1 Sega Amusements
1 Sega of America
1 Sega of America Inc.
1 Sega, Nintendo
1 Sierra Entertainment {{small|(retail)}}<br />[[Steam (software)|Steam]] {{small|(online)}}
1 Sierra Studios {{small|(retail)}}<br />[[Steam (software)|Steam]] {{small|(online)}}
1 SimSquared Ltd.
1 Square Enix
1 SSI
1 StarWraith 3D Games
1 StarWraith 3D Games LLC
1 Station Pass
1 Steam, GamersGate and Akella
1 Sunlight
1 Sunspire Studios
1 Taito
1 Taito Corporation
1 Takashi Kojima (Mackoy)
1 Tapulous
1 TBA
1 Tecmo
1 Telltale Games<br />[[Playstation Store]]<br />[[Steam (software)|Steam]]
1 Telltale Games<br />[[WiiWare]]<br />[[Steam (software)|Steam]]<br />[[Amazon.com]]<br />[[PlayStation Network]]<br />[[App Store (iOS)|App Store]]
1 Telstar Electronic Studios (Europe)
1 Thalamus <br> [[Electronic Arts]]
1 The Walt Disney Company
1 THQ<br />[[1C Company|1C]] (Russia)<br />[[Valve Corporation]]
1 Thunder Mountain
1 Titus Software
1 Toho <br> [[Nintendo]]
1 Tokyopop
1 Tuning ([[Europe]])<br>Fabtek ([[USA]])<br>Metrotainment ([[Hong Kong]])
1 Ubisoft
1 Unknown
1 '''''USA/Canada:'''''<br/>[[Betson]]<br/>'''''Europe:'''''<br/>[[Namco]]
1 Valve Corporation <small>(online)</small><br />[[Electronic Arts]] <small>(retail)</small>
1 Valve Corporation<br/>[[Electronic Arts|EA Distribution]]
1 Valve Software (Steam), Introversion Software, Ambrosia Software, Pinnacle Software UK, Encore, DesuraNET (Desura)
1 various online gaming sites
1 Viacom New Media
1 Vic Tokai
1 Visco Corporation
1 Viva Media
1 Wetware
1 Wisdom Tree
1 Yano Electric, Dynaware USA

Raw: distributor distribution media1 media2 (size limit) —  HELLKNOWZ  ▎TALK 19:37, 3 March 2012 (UTC)

Quis custodiet ipsos custodes?

I'm concerned that after approval, there is no oversight of bot operations; it is assumed that an approved bot will only perform the tasks to which it is approved. Bot edits are flagged and generally ignored, so there's a reasonable scope for a bot account to go off reservation without anyone noticing, at least for a while. There have also been incidents lately of this occurring and causing a ruckus.

I'd like a dev to propose a minimally intrusive bot to monitor all bot accounts on Wikipedia. I imagine that over time it will grow more sophisticated, but for a first iteration I'd like to see at least monitoring of the namespaces edited and use of edit summaries. There ought to be some thought given to security/monitoring/auditing/generation of the data that configures the monitor's operation.

A retrospective report of all bot accounts that have operated outside approved tasks would be of interest. It would not be able to be generated until appropriate configuration data had been assembled.

Others might suggest other necessary, basic functionality. Josh Parris 03:06, 4 March 2012 (UTC)

Lists in infoboxes

The use of list templates ({{Plainlist}}; {{Flatlist}}; example edit) in infoboxes has proved uncontroversial; it improves their accessibility and web standards compliance, makes the content easier to edit (especially for longer lists), and makes the data more easily parsable. I'd like to work with a bot owner to look for cases where the conversion could be automated. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 12:49, 25 February 2012 (UTC)

I've had a little poke around this problem, and it sure seems messy. I selected one other writer's bio, Ayn Rand. The field spouse, in this case, is not delimited the same way as it was in the above diff - there's a BR tag, but that's to separate the spouse's name from the period of marriage. That's what happens when humans get at stuff, and makes for a parsing nightmare. And this problem was found in just the first (and last) article I fiddled with. So that's a problem at the lowest level. Then you've got the additional problem of "infoboxes exist on most pages on the wiki", which means at least a full scan is necessary, although I have no feeling for how many infoboxes have fields that could reasonably be expected to have multiple entries for that field, nor how many have infoboxes with these fields that actually have multiple entries. Infoboxes get changed, created and retired, so whatever solution there is will need to monitor for these occurrences during its life given the shear number of them it will have to work on.
For the interested, I used this regex to extract out {{Infobox writer}} params that could be expected to have a BR in them, and indeed do (based on only two articles):
([\|]\s*)(occupation|spouse|notableworks)(\s*=\s*)([^\|\}]+<[Bb][Rr]\s?/?>.*)(?=\s*(\||}}))
$4 is the value passed to the template; the other matches are to maintain existing formatting
A variation is required for lists expected to be separated by commas
I think a good starting point is to get someone to generate a list of possible matches for using ({{Plainlist}}, and use that to identify the various formats humans have used thus far. That can act as a basis for a parser to strip lists apart for reconstruction. And once that's sorted, drop it into a tool like AWB that gets used all over the place - you're going to be up for hundreds of thousands of edits. Josh Parris 00:00, 28 February 2012 (UTC)

How do you eat an elephant? One bite at a time ;-)

Thank you for the time you spent on this. You have identified some issues I anticipated. I would start by, say, doing all the "occupation" fields in {{Infobox person}}, rather than trying to do all infoboxes at once. Unfortunately, AWB wont run properly on netbooks, which is what I'm using. — Preceding unsigned comment added by Pigsonthewing‎ (talkcontribs)

So, can anyone help, please? Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 20:37, 4 March 2012 (UTC)

Old prod full template applier

In the past I have requested that a bot be designed to apply the {{Old prod full}} template to talk pages of articles that have been prod-tagged and then deprodded. This bot has never been built, although a couple programmers have said they would like to. Perhaps the technical difficulties could be overcome this year? Here are some of the technical problems that I have thought of or that have been mentioned before: 1) The detection of Prod and Prod-nn tags is difficult, because they are assigned to a category with a date that, perforce, always changes. 2) If an article is prodded and rapidly deprodded, is it hard to detect. 3) If an article was prodded, deleted and recreated, it requires a different sort of detection. Anyway, any takers? Abductive (reasoning) 15:43, 26 February 2012 (UTC)

I have a few other tasks in line before this, but I've added it to my to-do list. Tim1357 talk 22:02, 26 February 2012 (UTC)
An update: I started scanning through all of the revisions of articles using a database dump, looking for edits adding/removing/endorsing PRODs. Hopefully that can help me retroactively add {{oldprodfull}} to the appropriate talk pages. It should be done scanning in a few days (I'm too lazy to learn a faster method). Tim1357 talk 16:11, 4 March 2012 (UTC)

Citation Bot cleanup

Citation bot (talk · contribs) has a tendency to upload things at the wrong place following bad template usage from humans. So there's some cleanup to be had.

First, the following

should be moved from Template:Cite doi/:10.Foobar to Template:Cite doi/10.Foobar.

The following

should be moved from Template:Cite doi/doi: 10.Foobar to Template:Cite doi/10.Foobar.

The following

should be moved from Template:Cite doi/doi:10.Foobar to Template:Cite doi/10.Foobar.

And lastly the following

should be moved from Template:Cite doi/http:.2F.2Fdx.doi.org.2F10.Foobar to Template:Cite doi/10.Foobar.

Additionally,

  • All articles that invode these templates should be updated to use the correct {{cite doi|10.Foobar}} arguments
  • Leftover redirects can be tagged with {{db-r3}} (or just move without redirects, if possible)
  • Moves that cannot be performed due to the location already being occupied by a template can be tagged with {{db-t3|~~~~~|10.Foobar of the correct tempalte}}


I've left a message to User:Smith609, but he's on a wikibreak so anyone that wants to clean this stuff up is more than welcomed to. Headbomb {talk / contribs / physics / books} 06:18, 4 March 2012 (UTC)

On a side note to the cleanup, the bot should probably upload the citation in the correct place and edit the article to use the correct location as well. Going through the last set by hand. --Izno (talk) 17:03, 4 March 2012 (UTC)
Now doing the second batch. G6ing them via TW, which is faster than T3 (and probably r3? I'll check). --Izno (talk) 17:35, 4 March 2012 (UTC)
Unable to move Template:Cite doi/DOI: 10.1002.2F.28SICI.291098-111X.28200001.2915:1.3C61::AID-INT4.3E3.0.CO.3B2-O as it was triggering the blacklist. Probably too many random characters or too long. Probably an admin can see to that? Also have used prefixindex (below) to list the ones I didn't get to.
Also, done with "DOI: " and "doi: " other than the above blacklisted title. --Izno (talk) 17:54, 4 March 2012 (UTC)
FYI, it matches .*\p{Lu}(\P{L}*\p{Lu}){9}.* <casesensitive | moveonly>, which is intended to prevent moves to titles with more than nine consecutive capital letters (after ignoring non-letter characters). Looks like Headbomb used his accountcreator flag to move it already. Anomie 18:19, 4 March 2012 (UTC)
Yeah, I figured it would be something like that.
Finished the rest, from the below set. If there's any remaining there after all the deletions go through, someone else can do 'em. :^) --Izno (talk) 19:11, 4 March 2012 (UTC)

Prefixindex version



Repopulating 'New unreviewed articles' category

Would a bot operator willing to spend a bit of time looking into a series of discussions be able to look at the request here that was not done at the time (for the reasons given there) and see if anything can be done about it? The links are provided from that page. Essentially, the task would involve re-tagging for review the articles listed at User:Δ/Sandbox 4 (this list was generated on request back in November 2011). If it would be better to generate a new list, please say so. What was suggested, given the problems found with some of the reviews, was to re-tag all the articles to be re-reviewed (an example of the tag to be replaced is here). If a new consensus is needed to run such a re-tagging request, please say so and I'll raise that in the appropriate location. Carcharoth (talk) 18:40, 4 March 2012 (UTC)

Dealing with misplaced user subpages

I have encountered several users, both new and experienced, who by accident made a mainspace page when tried to make a user subpage by forgetting the user: prefix. (i.e. Yoenit/Sandbox instead of user:Yoenit/Sandbox).

Could somebody make a bot which automatically moves pages to userspace without redirect if the page name starts with username of creator followed by "/". I think this would result in very few false positives as "/" is not commonly used in article titles. The bot should also leave a message at the creators talkpage with information what went wrong and how to prevent it in the future. Yoenit (talk) 11:19, 29 February 2012 (UTC)

Assuming the bot would check that the page was created by the same user, it should have virtually no false positives. —  HELLKNOWZ  ▎TALK 11:21, 29 February 2012 (UTC)
This seems like a good idea. Who ought to get the message? Are there any devs interested in taking this up? Josh Parris 02:31, 1 March 2012 (UTC)
It should be easy to code, but my only question is how do you plan on finding the incorrect edits? Do you just want to watch the New Articles feed for any edits which follow the above logic? LegoKontribsTalkM 21:51, 1 March 2012 (UTC)
All coded up using Special:NewPages, except for the user's talk page message. If someone wants to create a template for it, it would be trivial for me to add it in. LegoKontribsTalkM 05:31, 2 March 2012 (UTC)
See User:Legobot/userfy move for a first draft of a subst'able template for the talk page. Josh Parris 03:40, 3 March 2012 (UTC)
Wow looks good, the only thing I noticed that it may not be possible for them to move it back right away. Since the bot moves it, I added a line in the code that would mark the newly created redirect for {{db-r2}}. If the redirect isn't deleted by that time, the user (unless theyre an admin) shouldn't be able to move the page back until the redirect is deleted. Not sure how you explain that to a inexperienced editor without confusing them further though. LegoKontribsTalkM 08:58, 3 March 2012 (UTC)
Bots can move without creating a redirect. Josh Parris 09:47, 3 March 2012 (UTC)

<--Oh did not know that. BRFA filed here LegoKontribsTalkM 04:47, 5 March 2012 (UTC)

Removal of redundant date templates

Can we get a bot to remove expired {{show by date}} and {{update after}} templates if it is not already done? It is only a minor issue but removing redundant wikitext is a nice thing to do to help any editors who subsequently edit the page. -- Alan Liefting (talk - contribs) 21:25, 4 March 2012 (UTC)

Surprisingly, it looks like there isn't a bot to do this (or if there is, it managed to get approved without linking to Template:show by date or Template:update after from its BRFA). I'll look at having AnomieBOT take this on. Anomie 02:18, 5 March 2012 (UTC)
How do you propose that the bot ensures that the article has been adequately updated before removing {{update after}}? For example, the template should not be removed from Advanced Micro Devices, which says "The Magny Cours and Lisbon server parts will be released in 2010.{{update after|2010|12|31}}" -GoingBatty (talk) 02:24, 5 March 2012 (UTC)
I was thinking of creating a template that displays unconditionally what {{update after}} currently does once its timer expires. But looking at it a bit closer, I'm not entirely sure that {{update after|2012|March|1}} is all that much worse than something like {{update-inline|date=March 2012}}. Anomie 02:29, 5 March 2012 (UTC)
Note that {{update-inline}} redirects to {{update after}}. GoingBatty (talk) 02:35, 5 March 2012 (UTC)
Yes, I know. The point is the difference in syntax, not the specific template name. Anomie 03:08, 5 March 2012 (UTC)
I was a little to broad in my initial brief. {{update after}} should be done by actual humans. -- Alan Liefting (talk - contribs) 03:57, 5 March 2012 (UTC)

The Ukraine -> Ukraine

Hello,

Often English speakers, used to talking about "The UK" and "The USA" make the mistake of writing "The Ukraine", which is incorrect (the country is simply Ukraine). Currently a search for "The Ukraine" -Ukrainian returns 2,719 results, about half of which I guess are incorrect instances of the country's name. I had a go at correcting the first dozen or so instances in the search (hence you may find the first few pages to be all false positives), but I quickly realised this could do with some semi-automation.

What I propose is a semi-automated bot/editing tool that allows this to be done as efficiently as possible, with a user reviewing every edit before it's implemented of course. I'd be happy to be one of those users.

Cheers -- LukeSurl t c 17:27, 6 March 2012 (UTC)

Try WP:AWB. Headbomb {talk / contribs / physics / books} 17:34, 6 March 2012 (UTC)
The Ukraine is correct English and was the standard. Secretlondon (talk) 23:26, 6 March 2012 (UTC)
Actually it's not [1] (among many other possible sources).VolunteerMarek 23:43, 6 March 2012 (UTC)
The country also wished us to change the spelling of Kiev. We don't do that either. Not suitable for a bot edit as it's contentious. Secretlondon (talk) 23:50, 6 March 2012 (UTC)
"The country"? I was not aware that any country tried to make Wikipedia do anything. Did they propose a UN resolution saying that "Wikipedia shall change the spelling of Kiev" or something? Threaten to invade Jimbo's home?
Also, I don't think a guy named Paul Brians, who wrote a book called "Common Errors in English Usage", and who is a professor at the non-Ukrainian Washington State University, which happens to be located in The Washington rather than The Ukraine, qualifies as "The country of the Ukraine".
What are you talking about?VolunteerMarek 00:30, 7 March 2012 (UTC)
This isn't the place to discuss which version of the country name is correct. I think it has been shown that it is not an uncontroversial change, and therefore it is inappropriate as a bot task. If you can point to a recent discussion showing consensus for one version or another, then come back here and let us know. This is not the appropriate place to form that consensus. —SW— speak 20:02, 7 March 2012 (UTC)
Plus, does anyone consider where the idiom, correct or not, occurs in direct quotes from the correct or not sources? Reason enough not to automate. Dahn (talk) 20:06, 7 March 2012 (UTC)
Thanks. It looks like WP:AWB would be the tool to use. I've posted a notice on the policy board of the village pump to see if consensus can be reached on standardising the naming of the country before implementing any semi-automatic changes. LukeSurl t c 21:40, 7 March 2012 (UTC)

Bot needed to get ISBNs

{{cite doi}}, {{cite pmid}} etc are nice ways of adding references and I see the need for a {{cite ISBN}}/{{cite isbn}}. Books are frequently cited in articles and most new books and most books published in the past 20-30 years have an ISBN. Adding book citations by hand is tedious and some of the citation tools are sporadic in operation or are a little "fiddly". I would like to have a {{cite ISBN}} template created and then a bot goes off to find the biblio data to build a reference along the same lines as what happens with {{cite doi}}. There are concerns about availability of ISBN data in the quantities that would be used by WP, however WorldCat allows up to 1000 ISBN queries per day with other options available. That may be sufficient for WP needs. The citation templates would then be placed in a Category:Cite ISBN templates similar to Category:Cite doi templates, Category:Cite pmid templates etc. This is surely a simple task for the experts who lurk here? -- Alan Liefting (talk - contribs) 01:36, 8 March 2012 (UTC)

That should be discussed at User talk:Citation bot, as it's that bot (and User:Smith609) that takes care of that stuff. Headbomb {talk / contribs / physics / books} 03:53, 8 March 2012 (UTC)
Ok. I will pop on over there. -- Alan Liefting (talk - contribs) 04:31, 8 March 2012 (UTC)
Cite book has 378832 transclusions. It may be worthwhile checking for uses of the template with an ISBN but missing other common data, such as title, author, publisher, etc. Without a local copy of the wiki I can't provide an estimate but I'd guess it would be very low. I suspect the template could be modified to detect that kind of situation to make it very easy to find incomplete calls to the template, which a bot could fill in. Josh Parris 04:35, 8 March 2012 (UTC)

I have gone off this idea completely. -- Alan Liefting (talk - contribs) 19:46, 9 March 2012 (UTC)

Checking WP ref fields with external databases

I am looking into ensuring rigour in WP referencing. I would like a bot to do a sample run on references to see how they compare with external sources. It should not be too hard for a bot to pull ISBN, doi, pmid numbers out of {{cite}} templates in an article, get the bibliographic metadata from an external database, and then compare it to what has been put in the {{cite}} template fields. Initially I am interested in the percentage of perfect matches and getting a spreadsheet of how the rest mismatch. Anyone interested in doing a sample of 1000 refs? -- Alan Liefting (talk - contribs) 20:03, 9 March 2012 (UTC)

I've got a mysql table of the ~700k scientific journal references on en-wiki and ~25k pubmed records. There doesn't seem to be a pubmed bulk API though. Rjwilmsi 00:56, 10 March 2012 (UTC)
So getting those records out of the WP database is easy? -- Alan Liefting (talk - contribs) 02:13, 10 March 2012 (UTC)
I use the enwiki-latest-pages-articles.xml database dump, have written a custom database scanner function in AWB that parses citation templates to pull out the common parameters and produces a flat tab-separated file, ~120 MB. I set up a mysql table to match, then load this into mysql using "LOAD DATA INFILE". I collect pubmed data via web calls to the Diberri tool from an AWB custom module. I've now got various sets of SQL queries to identify data problems and inconsistencies. Rjwilmsi 08:10, 10 March 2012 (UTC)
Whew! Hang on a sec while my head stops spinning after reading all those techie terms. Ok. So can you make that available to other editors? It is a big file so maybe it can be split into ISBN, doi, pmid sections for ease of downloading and use. -- Alan Liefting (talk - contribs) 18:02, 10 March 2012 (UTC)

Message to take part in Assessment Drive

WP: India has a massive backlog of over 18,000 unassessed articles. To help significantly bring down the backlog, an Assessment Drive has been planned. Could a bot please message users who are reviewers as well as members of WP:India to request them to volunteer to help clear the backlog? Thanks, Around The Globeसत्यमेव जयते 06:20, 29 February 2012 (UTC)

It may be better to announce this in the next edition of Wikipedia Signpost. – Allen4names 07:17, 29 February 2012 (UTC)
If a message delivery bot were to do this, they'd want the text of the message; have you written one up? Josh Parris 07:41, 29 February 2012 (UTC)
Spamming "reviewers" is probably not the best idea. Just because someone was trusted with the ability to review pending changes doesn't mean they want to copyedit or assess articles for some random WikiProject. I'd recommend limiting the message to members of the project. Anomie 13:16, 29 February 2012 (UTC)
I agree, please limit the message to Members of Wikipedia:WikiProject India. Message given below:
Tag & Assess 2012

Each Wikiproject in Wikipedia has many article under its stewardship. Assessment means the addition of a WikiProject template to the talk page of an article, assessing it for quality and importance and adding a few extra parameters to it.

In WikiProject India we have 93,867 articles under it as of date. Of these a stupendous, 18235 17511 articles are completely unassessed, both for class and importance. In addition, another 42,772 articles are unassessed for importance. Accordingly, a Tag & Assess 2012 contest has been proposed to run from 01 March 2012 to 31 May 2012.

You can sign up on the Tag & Assess page itself. There are many awards to be given and scope for everyone to win huge awards. Come & join us in this exciting new venture. You'll learn more about India this way.

ssriram_mt (talk) & AshLin (talk) (Drive coordinators)

Is there any thing else that needs doing? AshLin (talk) 20:05, 29 February 2012 (UTC)
If no one else can do it, I can have Legobot do it, but it would have to go through BRFA for it. You may be faster off contacting an operator of any of these bots: Category:Newsletter delivery bots. LegoKontribsTalkM 22:49, 1 March 2012 (UTC)
Thanks for offering! I didn't understand the term BRFA. What do I need to do? AshLin (talk) 17:49, 2 March 2012 (UTC)
Thehelpfulbot's 8th BRFA (Bot Request for approval) might cover this - This bot will tag pages as directed by projects from lists that they give me. This will include adding and substituting templates and adding notices to pages (including talk page messages). - WikiProject India would be an appropriate project requesting this. The Helpful One 20:03, 3 March 2012 (UTC)
A member of the BAG has confirmed that my bot is able to run the task and I have copy edited the message slightly:
WikiProject India Tag & Assess 2012 Contest

Hello friends, we are a number of editors from WikiProject India have got together to assess the many thousands of articles under the stewardship of the project, and we'd love to have you, a fellow member, join us. These articles require assessment, that is, the addition of a WikiProject template to the talk page of an article, assessing it for quality and importance and adding a few extra parameters to it.

As of March 11, 2012, 07:00 UTC, WikiProject India has 95,998 articles under its stewardship. Of these 13,980 articles are completely unassessed (both for class and importance) and another 42,415 articles are unassessed for importance only. Accordingly, a Tag & Assess 2012 drive-cum-contest has begun from March 01, 2012 to last till May 31, 2012.

If you are new to assessment, you can learn the minimum about how to evaluate from Part One of the Assessment Guide. Part Two of the Guide will help you learn to employ the full functionality of the talk page template, should you choose to do so.

You can sign up on the Tag & Assess page. There are a number of awards to be given in recognition of your efforts. Come & join us to take part in this exciting new venture. You'll learn more about India in this way.

ssriram_mt (talk) & AshLin (talk) (Drive coordinators)

If you could confirm that the date (February 29, 2012) is correct and the number of articles is also correct, I will be able to run the task. The Helpful One 21:20, 3 March 2012 (UTC)
Could you also add an introduction so that the message is more welcoming? Perhaps something like "Hi, we are a couple of editors from WikiProject India and would like to recruit you, a fellow member, to help out with a new initiative that we are starting." would be sufficient? The Helpful One 21:32, 3 March 2012 (UTC)
Thanks, User:Thehelpfulone, those were great suggestions, I have done the needful as requested by you. Anything I need to do, please let me know. AshLin (talk) 06:49, 11 March 2012 (UTC)
Nope, I made a couple more fixes but otherwise all done and messages delivered. The Helpful One 01:49, 12 March 2012 (UTC)

Thank You! From a satisfied customer. AshLin (talk) 14:04, 12 March 2012 (UTC)

merging two templates

A few minutes ago I was merging and checking all parameters of {{Infobox AFL player}} and merged the last four missing parameters to {{Infobox AFL biography}} as noted at Wikipedia:Templates_for_discussion/Holding_cell per the outcome at Wikipedia:Templates for discussion/Log/2011 April 5. The "only" problem now is to determine the two nonstandardized parameters {{{coachingteams}}} and {{{playingteams}}}.
The two parameters should be divided to

  • {{{years}}}
  • {{{clubs}}}
  • {{{games(goals)}}}

and (for the coaching related)

  • {{{coachyears}}}
  • {{{coachclubs}}}
  • {{{coachgames(wins)}}}.

That is (I believe) not an easy task, but this template is simply too often transcluded (~1900) to do this by hand. mabdul 20:41, 12 March 2012 (UTC)

Hatnote renaming

Pursuant to Template talk:Further#Requested move and Template talk:Further#Move process, looking for a bot to replace all invocations of {{further}} with {{further2}} (exact same template, it's just being renamed). Any takers? --Cybercobra (talk) 05:27, 8 March 2012 (UTC)

Further seems to be better name than Further 2. Why don't go the other way? -- Magioladitis (talk) 10:31, 8 March 2012 (UTC)
Additionally WP:NOTBROKEN. Headbomb {talk / contribs / physics / books} 14:08, 8 March 2012 (UTC)
Additionally WP:COSMETICBOT. Basically, Cybercobra, the point is MediaWiki is built to handle template redirects perfectly well so there's no need to have a bot do this. Redundant. Cheers! — madman 14:48, 8 March 2012 (UTC)
(ec) Per further discussion at Template_talk:Further2#Move_process this will probably have to happen for what people want to be done ·Add§hore· Talk To Me! 14:50, 8 March 2012 (UTC)
Sure mediawiki can handle redirect perfectly, but if the move from the template see to further is to happen without the changing of all instaces of the current further template to further2 template something would defiantly be broken. ·Add§hore· Talk To Me! 14:52, 8 March 2012 (UTC)
This doesn't seem to quite be a WP:NOTBROKEN situation. I've read through the confusing situation a few times, and I think I see what's going on. Right now, {{see}} and {{further}} are very similar, they both produce a hatnote in the form of Further information: Stuff. The only difference between them is that {{see}} automatically wikilinks whatever you put in it, whereas {{further}} doesn't.
So, these template folk are working to standardize the hatnote templates and they'd like to get rid of {{see}} altogether, and I agree it's a bit silly to have a template named "see" which produces the text "further information". Also, the rest of the standard hatnote templates automatically link their parameters, like {{see}} currently does. So, the plan is to move {{see}} to {{further}} (i.e. make {{further}} the auto-linking template). This, of course, would break all of the current transclusions of {{further}}, so their plan is to use a bot to change all of them to {{further2}} (i.e. make {{further2}} the non-auto-linking template). Make sense now?  ;)
So, I think this is an appropriate bot task. I could run this task if you like, or if someone else would rather do it that's fine too. —SW— confer 16:36, 8 March 2012 (UTC)
Well they seem to have made up their mind in regards to what they want so one of us may as well put in a brfa for a bit more discussion :) ·Add§hore· Talk To Me! 16:45, 8 March 2012 (UTC)
re Add§hore: Aren't you a bit too cynical, given that the Move request already was clear about this, and the only problem left is: explain this to bot people? With you, that problem still exists. And if you react: please note that I happen to pass by here by coincidence, since I did not expect bot handlers to start a redo of a finished template discussion. -DePiep (talk) 21:13, 11 March 2012 (UTC)
Can't we just use a parameter like |text= for custom output and links like the one currently used at {{further}}? Why do we even need 2 templates? —  HELLKNOWZ  ▎TALK 16:49, 8 March 2012 (UTC)
That seems like a logical suggestion to me, although I'm concerned that we'd just be introducing more non-standard idiosyncrasies into the hatnote templates. Are there any other hatnote templates that use the |text= parameter (or something similar)? —SW— yak 18:12, 8 March 2012 (UTC)
Probably not, since I made that up. Looking at existing list, there are a few that use 2 or 3 at the end for arbitrary text as parameters, like {{for2}}, {{see also2}}, {{details3}}. Not exactly an intuitive method and I suppose I would propose merging them all into their central template. —  HELLKNOWZ  ▎TALK 18:19, 8 March 2012 (UTC)
Since this will result in fewer hatnotes, I agree. I can rename further -> further2 with Yobot (8,000 edits). -- Magioladitis (talk) 18:21, 8 March 2012 (UTC)
I support what has been done so far with hatnotes. It really helped in standardiation. -- Magioladitis (talk) 18:27, 8 March 2012 (UTC)
Great; thanks Magioladitis! --Cybercobra (talk) 21:35, 8 March 2012 (UTC)
I am almost done. I am leaving this message to avoid archiving. -- Magioladitis (talk) 16:16, 13 March 2012 (UTC)

 Done Magioladitis (talk) 21:32, 13 March 2012 (UTC)

Automatic addition of {{reflist}}

When a user creates an article with <ref> tags, but doesn't understand that they need to put {{reflist}} in the article, a glaring red message appears on the page directing them to the help page. They probably will figure it out on their own eventually in most cases, but it seems to be a fairly common point of confusion for newbies. It seems like it would make things a whole lot simpler if a bot were simply to add the template where it's needed. Is this plausible? Swarm X 16:51, 12 March 2012 (UTC)

Something like scanning through the last 50 (?) newly created articles, searching for articles for where there are <ref> tags but no {{reflist}}? SD5 18:08, 12 March 2012 (UTC)
There's already a couple bots that add missing reflists. —  HELLKNOWZ  ▎TALK 18:09, 12 March 2012 (UTC)
Really? I wasn't aware. Swarm X 18:24, 12 March 2012 (UTC)
User:Thehelpfulbot has been running this task for a while, but on-and-off. Now that I've got a Wikimedia Labs account, it runs hourly on a crontab as you can see at Special:Contributions/Thehelpfulbot. It's using the noreferences.py Pywikipedia python script. The Helpful One 00:34, 14 March 2012 (UTC)
If the frequency needs to be increased then I can increase it, but if you look at Special:DeletedContributions/Thehelpfulbot, you can see that it's making edits on pages that are soon deleted, although I don't see this as much of a problem. The Helpful One 00:37, 14 March 2012 (UTC)

au.geocities.com dead links

au.geocities is a dead duck, and it would be great if someone could get a bot to go through and appropriately dead link this domain. — billinghurst sDrewth 03:49, 13 March 2012 (UTC)

AnomieBOT did this already, for all geocities.com subdomains; all the existing mainspace uses should already be marked with {{dead link}} or be used in citation templates along with |archiveurl= pointing to an archive at the Internet Archive or WebCite. Are there any that aren't? Anomie 17:29, 13 March 2012 (UTC)

Orphaned non-free files speedy tagging bot

Hello, everybody, I have come up with a new idea. Why not run a bot which will tag orphaned non-free files? It is really a very hard work to find out orphaned non-free files and delete them (or tag them). Dipankan says.. ("Edit count do not matter") 14:10, 12 March 2012 (UTC)

I'm reasonably sure there's already at least one bot doing so, and I've also seen administrators auto- tagging files with Twinkle. SD5 14:52, 12 March 2012 (UTC)
There is a Python script that does this, checkimages.py, but I don't know if anyone runs it. Rcsprinter (gossip) 17:37, 13 March 2012 (UTC)
Then you should run it, as there is no one who does that, and it is very hard to find those images. Dipankan says.. ("Be bold and edit!") 06:49, 15 March 2012 (UTC)

Dear Bot People,

I recently created Wikipedia:Short popular vital articles to help figure out what to work on next, and my preliminary reviews of the first few dozen articles on that list suggest to me that it is likely a very useful resource. However, if it becomes out of date while articles grow, it will become confusing and possibly lose its appeal.

It took more than twelve hours to query the 60-day JSON data from http://stats.grok.se for all of the ~10,000 level 4 Wikipedia:Vital articles, so I am considering assuming that article page view popularity will not change much. I think it is also safe to assume that articles will not shrink, or if they do, there is really no pressing need to move them on to the table from the larger list of level 4 vital articles.

However, it would be a great help if a bot could update the table -- perhaps weekly? -- with correct article sizes from the API. If you can help with this, let me remember to say, use the &redirects& API option when querying article size because many of those links are redirects to other spellings and character sets.

Is there anyone willing to take on this low priority maintenance task? If you reply here, please ping me on my talk page so I don't miss replies in my (now 1,068 page larger) watchlist. Thank you very much for any and all your help. Npmay (talk) 23:07, 12 March 2012 (UTC)

The number of "What links here" incoming backlinks an article has is a useful proxy for how many pageviews it gets, which currently takes far too long to query. There are now clickable category counts on WP:BACKLOG and its {{Backlog status}} thanks to User:Dispenser's awesome new toolserver script which lists the articles in each category sorted by most backlinks. Npmay (talk) 08:44, 15 March 2012 (UTC)
I am planning on implementing a system of organizing articles in backlog categories by page view (see User:Scottywong/Backlog prioritization), but I'm waiting for a more efficient way of querying large numbers of page views. Gigantic page view database files are available here for download, but they are about 75-100MB for an hour's worth of data (that's 2-3GB per day). User:Erik Zachte is apparently working on a system which will boil down the hourly stats into a monthly file. Once he gets that done, I'll continue the work I've been doing, and would be glad to help you with your project as well, which seems like another good use for this type of data. —SW— converse 23:15, 12 March 2012 (UTC)
Great! Thank you. Let me know if I need to do anything to help. I have the raw list of 1,068 short popular vital articles, but you can get it from between the [[ and ]] on the table too. I also have a raw list of the nearly 10,000 level 4 vital articles, but it's dynamic so it would probably be best if a bot were to scrape it weekly or bi-monthly, whatever you decide. Thanks again! Npmay (talk) 23:34, 12 March 2012 (UTC)
Rather than querying http://stats.grok.se for all of the ~10,000 level 4 Wikipedia:Vital articles, you could query just those that are short, cutting query time down to one hour. Josh Parris 05:09, 13 March 2012 (UTC)
Quite true, but I wanted to get a log-log scatter plot and regression before I decided where to draw the line on how small is small. I also used the API to query talk page wikiproject | *class *= *[bBaAgGfF] regexp matches to measure the sizes of B-class and better articles and exclude them from the list. Npmay (talk) 06:47, 13 March 2012 (UTC)

WikiProject Teahouse bot, help wanted

Hi, I'm a host with WikiProject Teahouse, which is a supportive social and help space for new editors. The Teahouse is in pilot phase, and one of the main tasks of this period is reaching new editors to come and use the project. A helpful database report is available which creates a daily list of new but active editors (1 day, >10 edits; 4 days>20 edits). These lists are used for hosts to leave welcome and invitation messages on user talk pages.

The problem is that checking each page to see if there's been an invite previously made significantly slows down efficiency, and with 25 hosts aiming for a minimum of 500 invites per weak, that adds up in time costs. What would be amazing-great-phenomenal, is if someone with bot coding experience could whip up a simple machine to check the talk pages of the users on the database report, search for the word Teahouse, and then update an 'invited' column in the database report at regular intervals. I don't know how much time it would take, but it seems to be on the less complex end of things. Any help would be greatly appreciated by me, as well as the other Teahouse hosts. Or tips on who might be able to make such a thing. Thanks so much for your help and suggestions! Cheers, Ocaasi t | c 13:19, 13 March 2012 (UTC)

I pinged the report generator (I think) with some ideas and an offer to help if they can't do this. Npmay (talk) 00:28, 15 March 2012 (UTC)

Department of Redundancies Department

I'm hoping this is the right forum for this request, but is there any way to get a bot to fix instances where the word "fellow" is redundant? I notice quite a bit of "fellow teammate" and "fellow bandmate" and this seems to be a fairly pervasive error, and searching for common terms showing fellow-ness reveals as much:

These don't account for cases where "fellow" and "co-" or "-mate" are separated, and obviously, the last search yields uses of "fellow" that aren't redundant. But in the very obvious cases, simply deleting the word "fellow" would remove the redundancy. Is it possible to get a bot to do that? --Mosmof (talk) 14:33, 15 March 2012 (UTC)

I've made an addition to WP:AWB/Typos so humans using AWB can clean these up. GoingBatty (talk) 01:50, 16 March 2012 (UTC)

{{portal}} linking

I would like a bot to add {{portal|conservatism}} templates to the See also sections of all articles which have {{WikiProject Conservatism}} banners where importance=top or importance=high or importance=mid . Thanks, – Lionel (talk) 10:20, 10 February 2012 (UTC)

No bot is needed, I can do that easily with AWB. I will have to wait until tomorrow to start, but do you have any idea of the scale of how many pages I might need to do? Thanks, Rcsprinter (articulate) 22:10, 12 February 2012 (UTC)
That's great! And thanks! Let me get the count and I'll contact you on your talk. I'll also double-check the proposed articles. Give me a day or so. – Lionel (talk) 23:05, 12 February 2012 (UTC)
 Doing... Any updates? Rcsprinter (warn) 11:27, 17 February 2012 (UTC)
And  done. Rcsprinter (Gimme a message) 16:35, 17 February 2012 (UTC)

Container categories

Would it be possible for someone to create a bot that periodically goes through the sub-categories Category:Container categories, and tags categories, that doesn't only contain categories, with {{Category diffuse}}? Armbrust, B.Ed. Let's talkabout my edits? 02:48, 17 March 2012 (UTC)

I am not too keen on that idea. {{Category diffuse}} is an ugly, distracting, intrusive template, but more importantly not all of the sub-cats in Category:Container categories are labelled correctly. -- Alan Liefting (talk - contribs) 08:03, 17 March 2012 (UTC)
Than, what about listing such categories and someone can through them manually, and decide whether to mark them with {{Category diffuse}} or remove {{Container category}}. Armbrust, B.Ed. Let's talkabout my edits? 11:05, 17 March 2012 (UTC)
There is 2,698 in the category. I am crazy enough with having to check all those manually!! -- Alan Liefting (talk - contribs) 05:33, 18 March 2012 (UTC)

Bot needed to make a list

 Done

Needed: A bot to make a list of articles on Category:Minor Planets that look like this one, 25001 Pacheco, in the following ways. Here, “exactly like 25001 Pacheco” means that articles consist of:

  1. No more than the following text: "(Article title) is a main belt asteroid discovered on (date) by (name(s)) at (place)." No more text than that. It might have less. For example, it might not include the date, name, or place, but it no more.
  2. The only section break will be “External links”.
  3. The only external link is “*http://ssd.jpl.nasa.gov.....JPL Small-Body Database…...”
  4. It will also include this Template:Infobox planet, a planet infobox template.
  5. Next, it will have an empty reflist.
  6. There will probably be more, but nothing that would establish notablity and therefore matters. There may be a minor planets navigator and a minor planets footer; a “DEFAULTSORT”; several categories such as "Main Belt astroids", "Discoveries by (name)", and “Astronomical objects discovered in (Year); a "beltasteroid-stub" designation; and maybe a number of links to other language wikipedia articles, the same name in different alphabets. None of this matters, again, as these things to not establish notablity.

Basically, we need a bot to make a list of all these articles that are just like this example: 25001 Pacheco. We need this list in order to move on to the next step very carefully. Later, more bots may be needed, but we're taking this one careful doable step at a time. Chrisrus (talk) 06:07, 4 February 2012 (UTC)

Looking at this. Anomie 19:16, 4 February 2012 (UTC)
Ok. I expanded the request slightly to include pages with "an inner-belt asteroid", "an outer-belt asteroid", "a main-belt asteroid", "a Jupiter Trojan", and so on, to include "Its provisional designation was whatever.", and also considered any other empty sections to be unindicative of notability. The final list is at User:Anomie/Asteroid list.
Many of the remaining articles just contain an additional sentence along the lines of "It was named after Joe Bloggs", which may or may not barely scrape the bottom of the "notability" barrel for some few of them. Or further variations of the text, e.g. "(Article title) is an asteroid. It was discovered on (date). It was discovered by (name) at (place).". I've placed a second list at User:Anomie/Asteroid list 2 of all the number-named asteroids sorted by the size of the wikitext after the templates and some of the other junk are removed. Anomie 00:18, 5 February 2012 (UTC)
Excellent. I hope that didn't take too much time out of your day. I'll start a new section to discuss the next step, but first: thank you for all your efforts thus far. I will now start a new section about the following step, below. 03:59, 5 February 2012 (UTC)
Do you have a datasource to pull the information about minor planets? Ganeshk (talk) 19:26, 4 February 2012 (UTC)
Right now, we're not looking for information about the minor planets from off Wikipedia. We are just looking for a reliable list of articles that for sure don't have enough information to establish notablity within them as they stand, and therefore cannot meet WP:NASTRO. Chrisrus (talk) 20:01, 4 February 2012 (UTC)
Got it. Ganeshk (talk) 20:05, 4 February 2012 (UTC)

Bot needed to tag the list

Needed: A bot to tag each article on User:Anomie/Asteroid list thusly"{{Notability|Astro}}". Chrisrus (talk) 03:59, 5 February 2012 (UTC)

I was going to file a BRFA for this, but it looks like User:Avicennasis has already started this. Since this is a dated template, it would be better to add {{Notability|Astro|date=February 2012}}. GoingBatty (talk) 21:50, 5 February 2012 (UTC)
Thought I had replied here, but I guess I just previewed and never saved.  Doing... Avicennasis @ 02:22, 13 Shevat 5772 / 02:22, 6 February 2012 (UTC)
 Done Avicennasis @ 03:56, 15 Shevat 5772 / 03:56, 8 February 2012 (UTC)
You guys are awesome! My sincerest gratitude, and, if I may, please accept from me sincere gratitude on behalf of the Wikipedian standard of Notablity. Chrisrus (talk) 01:46, 13 February 2012 (UTC)

Bot needed to perform "good faith effort to establish notablity"

Needed: A bot to automate the "good faith effort to establish notablity" referred to in WP:NASTRO. For example, if I copy and paste into the Google Scholar search box, in quotes, the name of the first article on User:Anomie/Asteroid list, (196297) 2003 FA, it returns "no hits" from any of the WP:RSes that it searches. Not one. It is my hope that this will fulfill NASTRO's "good faith effort", but we may need to find the proper database that Ganeshk seemed to be referring to above. If not, it's at least a good start. At this point, however, my question to you is this: Is it possible, practicable, very difficult, or problematic to create a bot that will find out which if any of these do not return exactly zero results on a Google Scholar search? Chrisrus (talk) 03:59, 5 February 2012 (UTC)

Looking into this. Tim1357 talk 02:08, 13 February 2012 (UTC)
Hmm. At this point google scholar does not have an API (that I can find). Using screen scraping would probably be a violation of their TOS. Tim1357 talk 02:18, 13 February 2012 (UTC)
Google also autodetects bots and offers them a simple turing test. I get this occassionally even when doing things manually. Stuartyeates (talk) 02:59, 13 February 2012 (UTC)
I'm sorry. Instead of Google Scholar, I noticed that Wikipedia:NASTRO#Insufficient_sources recommends the SAO/Harvard abstract service of the Astrophysics Data System and the SIMBAD database's "display -> reference summary" in the "reference" section. Hopefully, that will be easier than Google Scholar. Actually, please have a look at that section of WP:NASTRO, which is a new document and so untried in the case of so many articles, so it may turn out that they while a good idea you may find don't turn out to be reasonable or doable or some such and still could be tweeked or an exemption could be requested. It depend on what happens when you go to implement them for this a list of more than six thousand articles to be checked and redirected to the List of minor planets chart, so please let us know if it's just not doable or reasonable or whatever the case may be. Chrisrus (talk) 03:26, 13 February 2012 (UTC)

Don't be sorry :), I like doing this stuff. The Harvard and Simbad databases look good. What do you want me to do when the queries return data? For example: 1173 Anchises returns 5 results with the Harvard database [2]. What should the bot do with this data? Just plop it in the Source section? Tim1357 talk 02:29, 14 February 2012 (UTC)

That's a good idea, but to answer your question, it should remove them from the list most importantly. Because in the end, what we want is a list of these articles which not only contain no sign of notablity but also which we tried but could not find any sign of notablity to put in them. In the end, we'll have a list of articles to convert into redirects to the chart called List of minor planets. Ones like 1173 Anchises you discover have some chance of notablity, so putting the hits you find into such articles or their discussion pages or something would help a person who wants to bring them up to WP:NASTRO, so it's nice as a secondary goal. We could call them "possibly notable" asteroids or some such, and set them aside to work on later. We could give that list to the astronomy project or some place later for them to work on. But the important thing at this point is to separate out the ones that have some sign of notablity from the list of ones with no sign at all. Chrisrus (talk) 22:28, 14 February 2012 (UTC)
Well if that's all you want, I could bang out a script in 30 minutes. I'll post back. Tim1357 talk 02:16, 16 February 2012 (UTC)
Ok, its all written. I'm going to have it spit out a sortable wiki table of how many results the Harvard Database has for each asteroid. It should take about 5 hours, so I'll let it run while I'm sleeping. Tim1357 talk 03:17, 16 February 2012 (UTC)
On second thought, I'll wait for you to reply. Below is a sample of what I was planning for the output. Do you want anything tweaked or added before I run it? By the way, I couldn't figure out how to use the Sinbad database, so as of now, the script does not check it. If you can give me some instruction on how to use it, I'd gladly include it in the script. Tim1357 talk 04:39, 16 February 2012 (UTC)

Hey, that's fantastic. Will will be able to separate out make a list of "zero"s? The ones with zero results are the easiest ones to move ahead, to the "convert to List of minor planets chart redirects" step. I guess that won't be necessary if the bot only moves the zeros, but I had been looking forward to getting my hands on the list of zeros.

About the other website, there are some tips and places to go for questions discussed here at WP:NASTRO, but no I'm sorry I don't know how to use it. Chrisrus (talk) 05:07, 16 February 2012 (UTC)

OpenOffice.org Calc to MediaWiki

How can I import an OpenOffice.org Calc spreadsheet to use in a Wikipedia table? Is there a bot? Allen (talk) 02:19, 16 March 2012 (UTC)

No, there's no bot; it should be uploaded by you as you're the contributor and the table should be attributed to you. Apparently in OpenOffice you can export to wikitext by selecting File | Export, selecting MediaWiki (.txt) as the File type, and clicking Save. Does this work? (I don't have an installation of OpenOffice at hand.) — madman 15:24, 16 March 2012 (UTC)
I tried it, but the only file format was .pdf. There weren't any other options. Do you know what else I can do? I want to keep as much formatting as possible. Allen (talk) 20:10, 16 March 2012 (UTC)
In fact User:DrTrigonBot should be able to process 'ods' file format... anyway you will not be able to preserve formatting - you just get the cell data/content... --DrTrigon (talk) 14:38, 18 March 2012 (UTC)

Migrate articles from {{Infobox Indian jurisdiction}} to {{Infobox settlement}}

Would be grateful if a bot could replace all calls to {{Infobox Indian jurisdiction}} with ones to {{Infobox settlement}}, as the former was deleted at TFD and is deprecated and outdated. Saravask 22:20, 11 March 2012 (UTC)

There are [17779 transclusions] {{Infobox Indian jurisdiction}}
Wikipedia:Templates for discussion/Log/2011 June 6#Template:Infobox Indian jurisdiction is the pertinent discussion; there may be some complexity associated with conversion. Implementer is encouraged to research. Josh Parris 12:38, 12 March 2012 (UTC)
Best to make the deprecated template a wrapper for the other; check for issues, and once all is OK, run a bot to subst the former. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 18:30, 19 March 2012 (UTC)

Deleted image link removal

I recall a bot removing links to dead images. Is it still around or has it rusted up? Category:Pages with missing files has got a backlog of 30,000 odd pages. -- Alan Liefting (talk - contribs) 05:37, 18 March 2012 (UTC)

Pywikipedia ships with a script called "delinker.py" that does just that. Tim1357 talk 21:20, 18 March 2012 (UTC)
So does that mean any of the bots clattering round here can be sent of to tidy up the contents of Category:Pages with missing files? -- Alan Liefting (talk - contribs) 00:07, 19 March 2012 (UTC)
Well, Category:Articles with missing files would be better but yes it does. I volunteer. Rcsprinter (Gimme a message) 18:45, 19 March 2012 (UTC)

Notification of deletion discussions on commons, for images originally uploaded on en.wiki

(Reviving an old request that was never coded...) When uploaders' images are moved to the commons, they likely won't be aware of deletion discussions so they can address fixable issues like lack of sourcing. Sometimes deletion nominators on commons make notifications to uploaders on en.wiki, but this is generally rare. (There are bots that leave messages at article talk pages for in-use images, but this doesn't necessarily accomplish the same thing. For example, the original uploader might know the source of an image that is difficult to determine by later passers-by.) A bot should be able to detect the original uploaders at least for images moved to commons using the standard CommonsHelper format. Notifications of the uploaders on en.wiki would be very useful to avoid unnecessary image deletions at commons. Calliopejen1 (talk) 20:44, 19 March 2012 (UTC)

Remove article categories from User pages

Would it be possible for someone to create a bot that would replace article categories from user pages with links to the categories per WP:USERNOCAT? (e.g. this edit, which just added colons) Thanks! GoingBatty (talk) 15:47, 16 March 2012 (UTC)

That seems like it can be done pretty easily with AWB. I'll have a go with my main account then see if we need a bot. Good idea, though. Rcsprinter (state) 16:53, 16 March 2012 (UTC)
I agree that the removal is easy - it's the identifying which user pages have category links that should be removed is what's stumping me. GoingBatty (talk) 17:05, 16 March 2012 (UTC)
It was actually quite easy. Here's a selection. Rcsprinter (talk to me) 17:43, 16 March 2012 (UTC)
I Just did 75 using AWB quite quickly (see on link above). I think a bot seems feasible. Rcsprinter (chatter) 18:26, 16 March 2012 (UTC)
Looks great! Care to share how you identified the user pages? GoingBatty (talk) 22:04, 16 March 2012 (UTC)

I wish it was some code I'd written, so then I could argue it doesn't have to be open-source, but seeing as it's AWB I'll tell you. It seems rather obvious really; get a category in the make list box, like Category:Living people, filter it to userpages and then set off with the find and replace. I did that and then went through things like births and deaths through year categories, and racked up nearly 200 edits just with this trial. No, it's easy and would be much quicker with a bot too. You want to file the BRFA or shall I? Rcsprinter (shout) 22:11, 16 March 2012 (UTC)

That way is OK, and I'll file the BRFA. I was trying to think of a way to search all user pages for "[[Category:", but somehow make sure not to change subcategories of Category:Wikipedians, Category:Wikipedia bots, etc. Thanks! GoingBatty (talk) 22:54, 16 March 2012 (UTC)
BRFA filed GoingBatty (talk) 23:07, 16 March 2012 (UTC)
Wikipedia:Database reports/Polluted categories looks relevant. It's made by BernsteinBot and currently limited to 250 pages. PrimeHunter (talk) 00:02, 17 March 2012 (UTC)
That's great - thanks! GoingBatty (talk) 01:15, 17 March 2012 (UTC)
Yeah, that's great. I am going batty going crazy removing user namespace pages out of article pages. I has been a longstanding problem that I tried to get sorted some time ago. -- Alan Liefting (talk - contribs) 07:56, 17 March 2012 (UTC)

Looks nice. Bot trial has gone well and I think I'll take the task too. We'll share the responsibility between two bots. Rcsprinter (gas) 15:10, 19 March 2012 (UTC)

Doing... - Sounds good to me. I'll finish off Category:Living people and then work through the rest of the polluted categories that are not created by a template until I hear from you. GoingBatty (talk) 03:32, 20 March 2012 (UTC)
Y Done for now with all the polluted categories not created by a template. GoingBatty (talk) 04:28, 21 March 2012 (UTC)

Bots needed on the commons

Seems to me the Commons is in need of bots to do batch uploads of images. There's quite a backlog, should anyone here care to get involved. See also Commons:Bots. --Tagishsimon (talk) 23:59, 20 March 2012 (UTC)

Dead link dansdata.com

It would be worthwhile someone deadlinking Special:LinkSearch/*.dansdata.com. It seems to be gone, though someone may want to leave it a few extra days before initiating. — billinghurst sDrewth 04:24, 21 March 2012 (UTC)

Works for me. I'd be shocked if Dan allowed that url to die. Josh Parris 12:49, 21 March 2012 (UTC)