User talk:Svick/Archive 3

You legend

Just wanted to drop a note saying how much I appeciate your (and Smallmanq12's) efforts in reviving the cleanup list, and improving it too from the old Wolterbot very infrequent list. This is the sort of maintenance tool that should be run from the foundation level, but as they don't seem interested in any practical, ground level work, it lies in limbo for almost a year until someone like you comes along and puts in the effort. You are a wiklegend. The-Pope (talk) 23:58, 7 November 2010 (UTC)

Thanks. I think the Foundation is quite busy just running the sites and improving MediaWiki itself, considering their limited resources. And it gives people like the opportunity to feel appreciated :-). Svick (talk) 00:18, 8 November 2010 (UTC)

Yes great work. I used the Walterbot cleanup listing for WP:QLD. Now I can try to destroy the category listing for this project one small step at a time. - Shiftchange (talk) 00:55, 8 November 2010 (UTC)

		The da Vinci Barnstar
		WikiProject North America cufflink cufflink Thank you for co-creating such an useful tool for WikiProjects. On behalf of WikiProject East Asia and WikiProject North America, I hereby present you with this banrstar, complete with a set of cufflinks. Sven Manguard Talk 01:22, 8 November 2010 (UTC)

Totally second that. Came here for the same reason: THANK YOU! Renata (talk) 15:15, 8 November 2010 (UTC)

Thanks both to you and Smallmanq12 from all at the Athletics WikiProject! Your free time was not mis-spent. SFB 16:33, 10 November 2010 (UTC)

Re:WikiProject cleanup listing

Great news. Will your tool (bot?) automatically take over WolterBot's functions, or do we need to reregister the projects somewhere? --_{Piotr Konieczny aka Prokonsul Piotrus| talk} 04:02, 8 November 2010 (UTC)

Well it found my two projects, which are new, and never had interaction with Wolterbot. Check your project's talk page, there will be a message if the project is already covered. Sven Manguard _Talk 04:04, 8 November 2010 (UTC)

If your project isn't listed at the index, you have to request adding it, either at the tool's talk page or here. It's not “taking over” WolterBot's function in the sense that the old pages will not get updated. The results are only on the toolserver. Svick (talk) 22:13, 9 November 2010 (UTC)

Problem with the new Tool?

Hello. When I looked through the readout that your excellent tool generated, I noticed that it did not seem to recognize the Bottom importance field. The readout left that field blank. I believe nine or so projects use it, including several big ones, such as astronomy and comics. (See Category:Bottom-importance articles). This could all just be me, but if it isn't, I figure this is worth mentioning. Sven Manguard _Talk 05:50, 8 November 2010 (UTC)

Support for bottom and No importance articles was added yesterday. The cleanup listing for projects such as Astronomy was generated two days ago. Svick simply needs to recreate the cleanup listing to reflect the new settings.Smallman12q (talk) 12:47, 8 November 2010 (UTC)

Thank you !

Thank you for our cleanup page from WikiProject Lepidoptera. AshLin (talk) 09:34, 11 November 2010 (UTC)

Request

Thanks for your efforts. This is a great help to us. We had given up on Walterbot. I wondered, is it possible for you to redirect the output to a wikipage instead of a ? Then we could edit and say  Done for those tasks already carried out. AshLin (talk) 09:39, 11 November 2010 (UTC)

See above.Smallman12q (talk) 23:37, 11 November 2010 (UTC)

Eagerly awaiting the fruits of your labour. AshLin (talk) 01:42, 12 November 2010 (UTC)

Database reports

Hey there.

I saw your new reports. They look really good. :D

A few general comments:

1. Wikipedia:Database reports/WikiProjects by changes/Configuration and Wikipedia:Database reports/WikiProject watchers/Configuration — you probably want to update the headers here; it's not 2009 and you should give yourself some credit ;-)
2. Wikipedia:Database reports/Configuration has my notes about the git repo where I put all of these reports and instructions for adding a report, etc.; if you want access to the GitHub repo, feel free to poke me; I'd be happy to add you
3. If you want to make a multi-maintainer project for database reports, that'd be nice as well; then we could have one crontab and centralized files and all sorts of other goodies; I'm not sure how much you want to be involved, but if you wanted to take over this project, I'd be more than happy to give you the other scripts and passwords

Again, nice work and thanks for helping out. :-) --MZMcBride (talk) 20:13, 13 November 2010 (UTC)

Thanks.

1. I guess.
2. I didn't know about that repo. Yeah, add me there if you want. For now, I have created a fork of it.
3. I'm not sure how much do I want to be involved either. So I guess creating that project is little premature.

Svick (talk) 20:51, 13 November 2010 (UTC)

Thankyou

		The Half Barnstar
		Good work on getting the cleanup listings rolling again. This is a major tool a lot of editors have been using. I'd been talking with one editor, about a month ago, about how we could get this up again. Half a star doesn't really do it justice but you might find another editor that you know, has the other half to make a full star. Tom B (talk) 18:39, 15 November 2010 (UTC)

Bot version for cleanup listing

I'll add my voice to the many thanks to you and Smallmanq12 for the cleanup listing tool, well done! Do you have any plans to run a bot (maybe once a month) to deliver the listing to wikiprojects in much the way that Wolterbot did? This was a good way to prompt editors to look at the back-log when it got delivered and useful for progress statistic collation. Cheers Zangar (talk) 10:28, 9 November 2010 (UTC)

I'll think about the bot. Although for statistic purposes, the history I keep in the database would be probably easier to use than parsing history of a wiki page. Svick (talk) 00:04, 10 November 2010 (UTC)

CleanupListingBot is approved to make such postings. If Svick approves, I'll write up the program (either in C# of PHP) to make the postings based on the csv dumps.Smallman12q (talk) 23:28, 10 November 2010 (UTC)

Sure, I have absolutely no problems with that. Svick (talk) 23:36, 10 November 2010 (UTC)

That sounds a great solution and might solve the request below as well. Zangar (talk) 10:23, 11 November 2010 (UTC)

I'll have it done sometime friday...(@Svick, I'll write in C# w/ dotnetwikibot and post to github.) The bot will also include some statistics, and another category to indicate whether the amount of tags an article has go up, down, whether the article is newly listed, or whether it got de-listed. Cheers!Smallman12q (talk) 23:37, 11 November 2010 (UTC)

Hmm, in that case, it might be useful for you to have access to the historic data too, right? And I was wondering whether CSV was a good choice for an output format (for example, you can't reasonably put generation date there). Maybe XML would be better? Svick (talk) 00:45, 12 November 2010 (UTC)

I was thinking of making serialized objects for the articles from the csv...I think its best if I were to write it so it to work off the db directly. The toolserver supports MONO (C#) so it's pretty much the same code, though how the data is fetched will be with sql queries. (I believe mono supports Mysql). I'll have the code up tonight/tmrw.Smallman12q (talk) 22:20, 12 November 2010 (UTC)

There is a (small) problem with that: since you have the approval to run User:CleanupListingBot, I think I shouldn't run it until someone from BAG says it's okay. Maybe separate BRFA won't be necessary, and even if it is, it will probably just add some delay. (You said you can't/don't want to have an toolserver account, so I assume I would have to run it.)

Now to the technical stuff: Yeah, Mono supports MySQL and toolserver has mono installed (although it is an older version, so you can't use .Net/C# 4.0 features). And of course, accessing the DB directly is always preferable, if it's possible. Svick (talk) 22:48, 12 November 2010 (UTC)

I don't see why you wouldn't be able to get approval...I've asked at Wikipedia:Bot_owners'_noticeboard#CleanupListingBot. I'm a bit busy today, (probably procrastinate tmrw)...but it will be done come Monday. I also have to write a wikitable class in addition to the procedural code.

Cleanup Listing Bot procedural outline

//Cleanup Listing Bot //For posting project cleanup listings for Wikipedia //PD November 2010 //11-13-2010 //Smallman12q and Svick //C# .net 3.0 using System; using System.Data; using MySql.Data.MySqlClient; using System.Collections.Generic; using System.Text; using DotNetWikiBot; namespace CListingBot { public static class Cleanup { //Exit codes const int botloginfailure = 5; /// <summary> /// Article object /// </summary> public struct cleanuparticle { } static void Main(string[] args) { //login to database //log into wiki //get cleanup categories List<string> cleanupcats = new List<string>(); //get wikiprojects List<string> projects = new List<string>(); foreach (string project in projects) { //get articles and data for latest run //get articles and data for previous run //compare //print out by article //print out by category } //Generate overall report //Save log file //Successful quit } } }

Smallman12q (talk) 16:32, 13 November 2010 (UTC)

I've created a python script at gist. If you can't make it work, I'll use my C# bot, bot to do the updates...but I don't want to play around with mono atm.Smallman12q (talk) 23:16, 15 November 2010 (UTC)

I've incorporated the script into the main repository, but it needs some work. I've been thinking about how to best present the listing in wiki: Splitting them into pages is a good idea, but that means there should be index for every project. Now that I think about it, a template could take care about that. But I think this approach is problematic with listing by categories. If I want to watch only certain category, I shouldn't find it on page 1 today and on page 2 tomorrow. But the list for some projects is so long that is should be split in some way. On the other hand, having each category on its own page would create lots of tiny pages. Maybe list only top n articles for each category with a link to toolserver? I'm not sure.

Also, I don't quite understand the e-mail you sent me.

Svick (talk) 00:59, 17 November 2010 (UTC)

I must admit, I did like the way that WolterBot delivered the listing: articles by category (subdivided into dates if there are above ~50 articles in the category), with an additional summary at the top for the total articles flagged for cleanup and a list of articles with >2 flags (an example format, which I'm sure you're aware of, here). Obviously the example I gave was for a smallish project, but for these I think a detailed listing like this is useful. Perhaps it could be delivered in this format if there are <750 (e.g.) articles flagged, and delivered in one of the formats you suggest, such as with a link, otherwise; this might even have the beneficial effect of encouraging people to address issues to get a more detailed listing! Zangar (talk) 06:08, 17 November 2010 (UTC)

404 error

The clean up reports say they are not found. Help? Renata (talk) 22:03, 9 November 2010 (UTC)

Sorry, fixed. Svick (talk) 22:14, 9 November 2010 (UTC)

Thanks! One suggestion though: would it be possible to have some basic stats (X project has y articles tagged out of z (x%)...). That percentage is sometimes thoroughly disheartening, but very useful. Renata (talk) 00:00, 10 November 2010 (UTC)

Done. Most projects will get the statistics when they are next regenerated. Svick (talk) 19:02, 17 November 2010 (UTC)

Page column empty in category watchlist

Hi! I found your tool today and set up a list. I see entries coming up, but the "Page" column is always blank. Am I missing something? [1] Thanks, Bovlb (talk) 19:32, 17 November 2010 (UTC)

When the Page column is empty, it means that the category was added to the database. But because your categories are so big, they are added in multiple passes and every pass shows in the table. Once this is done, it should start working normally. Svick (talk) 19:59, 17 November 2010 (UTC)

Thanks. Just out of curiosity, do you have to do that every time someone adds a category to a list, or is it just the first time anyone adds that particular category? Bovlb (talk) 22:21, 17 November 2010 (UTC)

It's done only when the category is not yet in the database, so the latter. But the tool is so little used, that there is no difference between those two options in practice. Svick (talk) 22:45, 17 November 2010 (UTC)

Just came back to say, "Great Tool!" I'm using it a lot. Would it be possible to add the user and summary of the edit that added/removed the category? And can you add a link to the secure.wikimedia.org version of the page URL? Thanks, Bovlb (talk) 21:38, 23 November 2010 (UTC)

There are two problems with figuring out what edit made the category change:

1. I'm getting the changes by scanning the whole category and reporting changes since the last time I scanned it. Because of that, the time of change I report is not precise and can be several hours off. So there is no simple way for me to find out what revision caused the category change.
2. Even if I solved the above problem, the category change may have been caused by an edit to a template transcluded to that page, so there is no edit to point to.

I have added the links to secure server to my to-do list. Svick (talk) 22:31, 23 November 2010 (UTC)

I was afraid that might be the case. Maybe there would be a way to build a link to the relevant slice of the page's revision history. Thanks! Bovlb (talk) 20:12, 24 November 2010 (UTC)

Question about your bot

How does your bot count edits for WikiProjects? The reason I ask is because I noticed several that are defunct or have been merged into other projects but their still showing up on the list. --Kumioko (talk) 03:22, 21 November 2010 (UTC)

If you know SQL you can have a look at the Configuration. If not, it takes all pages in the Wikipedia and Wikipedia talk namespaces whose name starts with “WikiProject ” and that aren't redirects, removes the part after slash (if there is any) and assumes that is the name of the WikiProject. The rest doesn't need to be explained, I think. Svick (talk) 12:46, 21 November 2010 (UTC)

Ok thanks that explains it. --Kumioko (talk) 14:04, 21 November 2010 (UTC)

MfD nomination of Wikipedia:Database reports/Talk pages by size

Wikipedia:Database reports/Talk pages by size, a page you substantially contributed to, has been nominated for deletion. Your opinions on the matter are welcome; please participate in the discussion by adding your comments at Wikipedia:Miscellany for deletion/Wikipedia:Database reports/Talk pages by size and please be sure to sign your comments with four tildes (~~~~). You are free to edit the content of Wikipedia:Database reports/Talk pages by size during the discussion but should not remove the miscellany for deletion template from the top of the page; such a removal will not end the deletion discussion. Thank you. Chris Cunningham (user:thumperward: not at work) - talk 12:59, 21 November 2010 (UTC)

Database reports descriptions and categories

Is it possible to revise the bot to not overwrite the category additions (and other additions) mentioned here at database reports (in the "The Talk pages by size MfD" thread) the next time the reports update? -- Uzma Gamal (talk) 13:57, 26 November 2010 (UTC)

I have just updated it, but if it changed again, I would have to change the bot again. Maybe a system similar to Wikipedia:Dusty articles would be better, but I'm not sure that's necessary. Svick (talk) 19:21, 27 November 2010 (UTC)

Speedy deletion of Template:Towns, cities and Cantonaments in Jhelum

A tag has been placed on Template:Towns, cities and Cantonaments in Jhelum requesting that it be speedily deleted from Wikipedia. This has been done under section T3 of the criteria for speedy deletion, because it is a deprecated or orphaned template. After seven days, if it is still unused and the speedy deletion tag has not been removed, the template will be deleted.

If the template is intended to be substituted, please feel free to remove the speedy deletion tag and please consider putting a note on the template's page indicating that it is substituted so as to avoid any future mistakes (<noinclude>{{transclusionless}}</noinclude>).

Thanks. Talha^{Discuss ©} 17:10, 26 November 2010 (UTC)

Missing cats in clean up list

Hey, I noticed that at least for the Lithuanian list a few categories were not included (Category:Wikipedia references cleanup; Category:Vague or ambiguous time; Category:Pages needing an infobox conversion; Category:All articles needing coordinates) when I compared your list to WalterBot's list. Thanks, Renata (talk) 02:58, 8 December 2010 (UTC)

Thanks for the info, I have added most of the categories you mentioned except Category:Pages needing an infobox conversion, because that tracks talk pages, not articles and the tool can't handle that. Svick (talk) 20:53, 8 December 2010 (UTC)

Thanks! Renata (talk) 22:25, 8 December 2010 (UTC)

Book Cleanup Listing

I've created a gist for book cleanup lisitings. Please have a look and let me know what you think.Smallman12q (talk) 13:56, 11 December 2010 (UTC)

Could you also add Wikipedia:WikiProject Blogging?Smallman12q (talk) 13:20, 13 December 2010 (UTC)

I have added the code to the repository, and fixed it a bit. I don't think it makes much sense to actually run until I have code to output the results and I'm not sure when I get to do that. WP Blogging is added now. Svick (talk) 21:37, 15 December 2010 (UTC)

Q

[2] So why can't we make one? Outback the koala (talk) 05:44, 20 December 2010 (UTC)

We can, but separate stub category is usually created only if there would be at least 60 articles in it, which is not the case here (at least for now). See also WP:WSS/P. Svick (talk) 19:49, 20 December 2010 (UTC)

The da Vinci Barnstar

		The da Vinci Barnstar
		For providing the tool to identify cleanup categories for WikiProjects as a replacement for WolterBot. Jointly awarded to User:Smallman12q

Many thanks on behalf of the Wikipedia:WikiProject Canadian music. Our project never received any cleanup list from the WolterBot. Argolin (talk) 01:43, 26 December 2010 (UTC)

Thanks. Svick (talk) 10:03, 26 December 2010 (UTC)

Template:Asbox/templatepage

Template:Asbox/templatepage is not fully protected so you should be able to edit it yourself. -- WOSlinker (talk) 14:48, 26 December 2010 (UTC)

Huh, you're right. I don't know why I thought it is protected. Thanks. Svick (talk) 14:56, 26 December 2010 (UTC)

editing Prague

Moved to Talk:Prague#editing Prague. Svick (talk) 12:41, 28 December 2010 (UTC)

"Infobox shoudn't categorize"

Hi, thank you for your editing of the template Template:infobox biodatabase. However, i don't really understand what can be the problem in adding a category to an infobox, especially the w:Category:Biolocial databases to this template. Have you got any pointer/ref about this ? Thanks. --Plindenbaum (talk) 22:14, 9 January 2011 (UTC)

I don't know if this is in any policy or guideline, but I think there are several problems with having an infobox that adds a content category (as opposed to a project category):

1. Templates shouldn't do anything unrelated to their primary function, because it's confusing.
2. If I want to replace Category:Biological databases with a more specific one, I should be able to do that.
3. Userspace drafts shouldn't be categorized and this approach would categorize them, if they used this infobox.
4. Some infoboxes (I don't know if it applies to this one), are sometimes used in a section of an article. For example, in an article about an organization, there could be a section about a database it created that has an infobox, but it's notable enough to have its own article. In this case, the category shouldn't be added.

Svick (talk) 23:07, 9 January 2011 (UTC)

Ok, it makes sense to me. Thanks --Plindenbaum (talk) 07:56, 10 January 2011 (UTC)

dab pages

Hi Svick,

Thanks for the list here. Where can I go to generate lists like that? I should probably run it for cases where one or the other is a redirect. — kwami (talk) 05:57, 15 January 2011 (UTC)

If you know SQL (or are willing to learn it) you can request a toolsever account. From toolserver, you get direct access to most parts of Wikipedia's (and other wiki's) database. Or you can use Query service, i.e. request that someone runs a query for you on the toolserver. If you want to update the list periodically and have it formatted in an on-wiki table, you can ask at Wikipedia talk:Database reports. Or I can just run it for you. Svick (talk) 11:06, 15 January 2011 (UTC)

Thanks, Svick. I'll consider how I want to approach this, but meanwhile the list you just compiled will keep me busy. — kwami (talk) 13:58, 15 January 2011 (UTC)

New query and its results

mysql> SELECT substring(page_title, 1, length(page_title) - 7) AS name FROM page as p1 WHERE page_title LIKE '%\_people' AND page_namespace = 0 HAVING (concat(name, '_language') IN (SELECT page_title FROM page WHERE page_namespace = 0 AND p1.page_is_redirect + page_is_redirect < 2)) AND (name NOT IN (SELECT page_title FROM page JOIN categorylinks ON page_id = cl_from WHERE page_namespace = 0 AND cl_to = 'All_disambiguation_pages')); +---------------------------+ | name | +---------------------------+ | A-Pucikwar | | Abipón | | Achuar | | African | | Ahom | | Aja | | Akie | | Akiek | | Aklanon | | Alabama | | Aleut | | Algonquian | | Algonquin | | Ambelau | | Apatani | | Apiacá | | Arab | | Arabic | | Aramaic | | Arawak | | Argobba | | Aromanian | | Arrernte | | Assiniboine | | Atwode | | Ayoreo | | Bai | | Baloch | | Banawá | | Bari | | Basketo | | Batak_Toba | | Belgian | | Bengkulu | | Berau | | Berom | | Bete | | Betsimisaraka | | Bicolano | | Bihari | | Bilen | | Biloxi | | Bit | | Boholano | | Bonda | | Boruca | | Bravanese | | Bribri | | Bujeba | | Bundjalung | | Buru | | Burusho | | Cantonese | | Cashibo | | Chamalal | | Chané | | Cherokee | | Chibcha | | Chin | | Chitrali | | Chittagonian | | Chorotega | | Comanche | | Cree | | Crow | | Cueva | | Cupeño | | Daur | | Defaka | | Dena'ina | | Diaspora | | Dizi | | Dogon | | Duke | | Edo | | Efe | | Efik | | Ekpeye | | Embu | | Epie-Atissa | | Eshira | | Ethiopian | | Extremaduran | | Fang | | Fante | | Fictional | | Flemish | | Fuliiru | | Fur | | Fuzhou | | Ga | | Gadaba | | Gandhari | | Garhwali | | Ghomara | | Gibraltarian | | Gikuyu | | Gogo | | Goguryeo | | Griqua | | Guaraní | | Guarijio | | Guató | | Gurage | | Gurma | | Gutnish | | Gwere | | Haida | | Haiǁom | | Hebrew | | Hindko | | History_of_the_Macedonian | | Hong_Kong | | Hruso | | Huichol | | Idoma | | Ifugao | | Ijaw | | Ilokano | | Imraguen | | Inga | | Inuvialuk | | Isan | | Jakaltek | | Jarai | | Jek | | Jingpo | | Juang | | Kabye | | Kalabari | | Kalash | | Kalinga | | Kam | | Karajá | | Karakalpak | | Karelian | | Karen | | Katla | | Kaurna | | Kawésqar | | Kayeli | | Khakas | | Khamti | | Khamyang | | Khasi | | Khowar | | Khuen | | Kichai | | Kikuyu | | Kom | | Kombe | | Kongo | | Konjo | | Konso | | Koorete | | Korwa | | Krio_Dayak | | Kumam | | Kumaoni | | Kumauni | | Kumyk | | Kwegu | | Kyrgyz | | Lacandon | | Lai | | Lak | | Lari | | Laru | | Lengue | | Lesbian | | Lipan_Apache | | Lisela | | Little | | Lobedu | | Logba | | Logo | | Lopit | | Lotuko | | Luiseño | | Luxembourgish | | Maguindanao | | Mal_Paharia | | Malaysian | | Male | | Malto | | Malvani | | Maléku | | Manchu | | Mandan | | Mansi | | Masbateño | | Mauritian_Creole | | Mbundu | | Median | | Memon | | Merya | | Miami | | Mian | | Minangkabau | | Mingrelian | | Mising | | Miskito | | Mizo | | Mnong | | Mocoví | | Moksha | | Molala | | Monpa | | Moon | | Moroccan | | Mulam | | Mutsun | | Māori | | Nanai | | Ndogo | | Ngasa | | Nkoroo | | Nomlaki | | Nubian | | Nuristani | | Nyamwezi | | Nyaw | | Nyoro | | Oirat | | Ojibwe | | Okanagan | | Okiek | | Old_Prussian | | Oldest | | Ordinary | | Osing | | Paez | | Pangasinan | | Papuan | | Pashayi | | Pashto | | Pashtun | | Patwin | | Pedi | | Phuan | | Pijao | | Pipil | | Plain | | Pokot | | Proto-Germanic | | Pucikwar | | Puinave | | Pyu | | Pökoot | | Rama | | Rer_Bare | | Romblomanon | | Ryukyuan | | Sabir | | Salar | | Sambal | | Saxon | | Selknam | | Semnani | | Senufo | | Seraiki | | Seychellois_Creole | | Shan | | Shanghainese | | She | | Sherpa | | Shinasha | | Shuar | | Singpho | | Sinhalese | | Sinyar | | South_Ndebele | | Southern_Ndebele | | Squamish | | Subiya | | Sukuma | | Sumo | | Surinamese | | Swiss | | Syriac | | Taishanese | | Tangut | | Tao | | Tatar | | Tausug | | Tektitek | | Teochew | | Teribe | | Terik | | Tetete | | Tewa | | Tharu | | Tigrinya | | Tiriyó | | Tonga | | Tripuri | | Trique | | Truku | | Tuareg | | Tulu | | U'wa | | Ulster_Scots | | Urdu | | Valencian | | Venda | | Venetic | | Vengo | | Voro | | Walloon | | Wampanoag | | Warumungu | | Washo | | Wellemmedan | | Wetawit | | Wichí | | Working | | Wyandot | | Yaghnobi | | Yami | | Yanesha' | | Yemsa | | Zuni | | Önge | +---------------------------+ 323 rows in set (25.85 sec)

Wikipedia:Database reports/WikiProjects by changes

Hi, Svick.

When compiling the report for WikiProjects, does SvickBot count the number of edits made to articles that fall under the Project's scope or does it count the edits to the WikiProject page and subpages? If the latter, is there a way of finding out the former? Thanks, Matthewedwards :  Chat  03:48, 6 January 2011 (UTC)

It counts only the project page and its subpages. Some projects don't even have any articles that fall under its scope (e.g. WikiProject Spam). And those that do use inconsistent naming for their categories, so I think it can't be done fully automatically, but it's certainly possible to do it. I'll think about it. If you just want one-off count for few projects, that would be much easier. Svick (talk) 21:12, 6 January 2011 (UTC)

Would it be possible to put the project name in italics if the projects main page is a redirect? -- WOSlinker (talk) 19:10, 23 January 2011 (UTC)

Good idea, done. Svick (talk) 17:06, 26 January 2011 (UTC)

Adding ads

Hi, I made an add, but where do I add it so it appears on the homepage. Also, it won't let me post {{Wikipedia-adnavbox}} on to File:Qxz-ad225.gif (The commons page). Thomas888b (talk) 19:26, 19 January 2011 (UTC)

You can't add that template to the commons page, because it's an English Wikipedia template. What you can do is create another description page for that file here (not on Commons) and put the template there. Which is what I did. (Keep in mind that doing this is quite rare for ordinary images.)

Editing Template:Wikipedia ads is relatively intricate process, although I thought the instructions are clear. I have added the ad to the template and now it will show at random on pages who contain the template. Or you can use the code {{Wikipedia ads|ad=225}} to show only your new ad (see below).

I'm not sure what you mean by “homepage”, but if you mean the Main page, ads like this one aren't usually (ever?) shown there. If that's what you meant, you should ask about it on Talk:Main page, but I doubt you'd be successful.

Svick (talk) 23:05, 19 January 2011 (UTC)

Wikipedia ads	file info – #225

Sorry, by homepage I meant list of adds. Oops. Thanks anyway :-). Thomas888b (talk) 17:47, 20 January 2011 (UTC)

Thanks for Autopatrolled database report

Thanks very much for this database report finding users that are eligible for Autopatrol privilege. I am going to mark my db report request as being fulfilled. I just want to express my appreciation for your help and thank you very kindly. Thanks. - Hydroxonium (H₃O⁺) 03:34, 24 January 2011 (UTC)

		The da Vinci Barnstar
		In grateful appreciation for your superior programming skills, especially in developing autopatrol_eligibles.py and for creating the Autopatrol candidate report, I hereby award Svick the da Vinci Barnstar. Thank you very much for taking on this technical task. I sincerely appreciate your generous efforts. Thanks. - Hydroxonium (talk) 21:28, 24 January 2011 (UTC)

You really deserve a barnstar for that. Thanks again. - Hydroxonium (H₃O⁺) 21:28, 24 January 2011 (UTC)

Thanks. Svick (talk) 17:03, 26 January 2011 (UTC)

for cleaning up my mess

		The Template Barnstar
		For getting Template:Interior Ranges of British Columbia up and running, I award you this barnstar. The Interior(Talk) 17:37, 28 January 2011 (UTC)

Thank you. Svick (talk) 18:44, 28 January 2011 (UTC)

For being so good at what you do

	Valued Contributor Award
	You have been identified as a valued contributor and your efforts are appreciated. We are honored to present you with the Valued Contributor Award and we thank you for donating your time, expertise and effort to Wikipedia. Keep up the good work. Thanks. (more details)

I see you've been updating autopatrol_eligibles.py and I just wanted to say thank for your continued support. Thanks. - Hydroxonium (H₃O⁺) 11:54, 30 January 2011 (UTC)

Sorting links

Hi, thanks for your suggestion at http://en.wikipedia.org/wiki/Wikipedia:Village_pump_%28technical%29/Archive_83#Sorting_Wikipedia_links.3F

The script works fine in theory, but it has a hard time handling punctuation, particularly percent-encoded URLs and parentheses. Is there a suitable workaround for this? —Preceding unsigned comment added by 92.27.210.70 (talk) 02:52, 3 February 2011 (UTC)

It works fine for me. Or do you mean you have the titles in the list percent-encoded? If that's the case, you want to do something like the following:

import sys
import wikitools
import urllib

wiki = wikitools.Wiki()

for line in sys.stdin:
  line = line.strip()
  line = urllib.unquote(line)
  page = wikitools.Page(wiki, line)
  if page.exists:
    print page.title

Svick (talk) 21:43, 9 February 2011 (UTC)

Wikiproject cleanup listing

It does not seem that category:Articles to be expanded and category:All articles needing expert attention are included in the reports. Renata (talk) 03:12, 16 February 2011 (UTC)

I have added both. They should appear when the lists are regenerated. Svick (talk) 15:18, 19 February 2011 (UTC)

DropDownToTabs.js

Hi Svick. Since the upgrade to 1.17, the DropDownToTabs script is a bit wonky; the tabs end up too high. — Edokter (talk) — 13:46, 16 February 2011 (UTC)

Should be fixed. Does it work correctly for you now? (If not, try Ctrl-F5). Svick (talk) 22:21, 16 February 2011 (UTC)

Indeed it does. Thank you! — Edokter (talk) — 22:49, 16 February 2011 (UTC)

Would you mind it if I added the following line? mw.util.addCSS('div#p-cactions {margin-left: 5px;}'); This adds a little space between the p-views and p-cactions tabs (which are now stuck together with a double line). — Edokter (talk) — 14:29, 25 February 2011 (UTC)

That seems like a good idea, I have added the code myself. Svick (talk) 17:29, 25 February 2011 (UTC)

Sorry to bother you again, but the tabs are broken in IE8; all tabs, except Purge, are shifted up. Peeking into IE's DOM, the items are constructed as <li><a><span>, while in Chrome they are <li><span><a>. Reversing <a> and <span> manually in IE fixes it. As a side note; the margin does not seem to be added in IE8. — Edokter (talk) — 13:53, 1 March 2011 (UTC)

Never mind... caching issue. — Edokter (talk) — 14:20, 1 March 2011 (UTC)

I implemented another fix in my fork, replacing the vectorMenu classname instead of simply overwriting the entire class, in order to retain any other classes (notable empltyPortlet, without which an empty tab is drawn on special: pages). — Edokter (talk) — 14:46, 5 March 2011 (UTC)

Wikipedia:Miscellany for deletion/Wikipedia:WikiProject South Wales

I boldly redirected to WP:WALES and closed the mfd. Didn't see a reason to let this sit in MFD any longer. Ten Pound Hammer, his otters and a clue-bat • ^{(Otters want attention)} 19:31, 1 March 2011 (UTC)

I think you're right. I probably should've done that in the first place. Svick (talk) 20:38, 2 March 2011 (UTC)

InterWikiProject Collaboration

The Outline WikiProject is currently working on the Outline of Sikhism.

You, and the other participants of the Sikhism WikiProject are invited to join this collaboration.

The Outline of Sikhism is the latest addition to the religion section of Portal:Contents/Outlines.

We look forward to learning from your expertise on this subject.

The Transhumanist 05:50, 2 March 2011 (UTC)

Quick note about a database report

Hi. This is about one of your database reports. --MZMcBride (talk) 16:31, 2 March 2011 (UTC)

Automating submissions for autopatrol right

Thanks again for all your help with generating the list of autopatrol candidates. I started a thread about automating more of this process at Wikipedia:Village pump (proposals)#Automating submissions for Autopatrol right. I don't want to burden you with more requests so I was going to ask at WP:BOTREQ depeding on whether or not the community decides to automate the process. I just wanted to leave you a note in case you wanted to comment on it. Thanks again. - Hydroxonium (talk) 13:52, 12 March 2011 (UTC)

Speedy deletion contested: Wikipedia:WikiProject Red Bull Air Race World Series/Newsletter1

Hello Svick, and thanks for patrolling new pages! I am just letting you know that I contested the speedy deletion of Wikipedia:WikiProject Red Bull Air Race World Series/Newsletter1, a page you tagged for speedy deletion, because of the following concern: Does not rely on a page that does not exist. You may wish to review the Criteria for Speedy Deletion before tagging further pages. Thank you. Logan _Talk ^{Contributions} 22:55, 1 April 2011 (UTC)

It is a subpage of a page that is just a redirect, a part of a WikiProject that doesn't exist, so I think it qualifies for G8. Svick (talk) 03:42, 2 April 2011 (UTC)

Looks like WOSlinker moved it to the proper location. Logan _Talk ^{Contributions} 23:40, 2 April 2011 (UTC)

Wiki Database Dump

Svick, you seemed to be knowledgeable about the database dumps so I was hoping you could tell me why all of these dumps include all of the Wikipedia namespace pages? It seems that someone downloading wikipedia doesn't need every WP:VFD and WP:AFD and all the other wiki namespace stuff taking up space in the database download.--RaptorHunter (talk) 00:56, 23 April 2011 (UTC)

My guess is that if you want to make a Wikipedia mirror, you're going to want at least some of the pages in the Wikipedia namespace (like Wikipedia:General disclaimer). And it's hard to distinguish those that the mirror would want from those that are actually just talk pages. User<Svick>.Talk(); 18:37, 23 April 2011 (UTC)

The people downloading my torrent aren't building a mirror of wikipedia. They just want a copy of wikipedia in case of the internet is shut down one day (WW3, zombie apocalypse...) It would be nice to have a database dump without all of these pages. — Preceding unsigned comment added by RaptorHunter (talk • contribs) 18:45, 23 April 2011 (UTC)

My opinion is that some of those pages are essential part of any copy of Wikipedia. And I don't think it would be wise to create separate dumps for any possible combination of namespaces. Although it should be quite easy to write a program that creates a copy of the dump without the Wikipedia namespace. You could then publish that. User<Svick>.Talk(); 19:25, 23 April 2011 (UTC)

I wrote a 9 line python script to filter out the Wikipedia articles. It cuts the bzip2 file by 19% or 1.2GiB. That savings seems worth it if most people don't need the non article namespaces.--RaptorHunter (talk) 02:46, 24 April 2011 (UTC)

Batch upload of 5500 Pronunciations

Would you be willing to do a batch upload of ~5500 VOA pronunciations? The files are public domain under {{PD-USGov-VOA}}. I've written a python script (2.7 and requires pywikipedia and ffmpeg) to scrape the site...the total download would be around 110MB for the mp3s which would then be converted to ogg and uploaded to commons. You should be able to do it on the toolserver, and you'll need a bot on commons. For a sample use on this wiki, see Egil Aarvik. If you're interested, respond and I'll send you the script(~250 lines). Smallman12q (talk) 01:08, 26 April 2011 (UTC)

Hi, I'm sorry, but why can't you do it yourself? I don't see any reason why would such a task require toolserver, so you should be easily able to run it from your own computer. User<Svick>.Talk(); 10:15, 1 May 2011 (UTC)

Village pump and newbie

I think your handling of the newbie IP editor through Wikipedia:Village pump (technical)#sandbox was exemplary. Well done. --User:Ceyockey (talk to me) 03:06, 1 May 2011 (UTC)

Thanks. User<Svick>.Talk(); 10:16, 1 May 2011 (UTC)

Wikipedia:Database reports/WikiProject watchers

This database report should probably exclude non-existent pages (such as "Wikipedia:WikiProject on How to Kill A Pedophile"). It'd also be nice to note the watchers cut-off limit in the report description text. --MZMcBride (talk) 23:02, 1 May 2011 (UTC)

Right. I kept the deleted pages there, because I found them interesting and somewhat amusing, but it's useful information only about page-move vandalism, which is not in the scope of the report, so I removed them. User<Svick>.Talk(); 12:35, 7 May 2011 (UTC)

Toolserver list of WikiProjects

I have added 30 WikiProjects from http://toolserver.org/~svick/projects.txt to User:Wavelength/About Wikipedia/List of WikiProjects. On the other hand, I noticed in your list four disambiguation pages which I omitted (Wikipedia:WikiProject Congo, Wikipedia:WikiProject Flags, Wikipedia:WikiProject Rugby, and Wikipedia:WikiProject TRANSWIKI), two soft-redirected pages (Wikipedia:WikiProject Linkification and Wikipedia:WikiProject on XFFs), and four entries which should be subpages with "/". I see that you have edited Wikipedia:WikiProject Education in India\Invite and Wikipedia:WikiProject Water supply and sanitation by country: Manual of Style accordingly, but I do not know whether you have identified Wikipedia:WikiProject Poker (guidelines) and Wikipedia:WikiProject Soviet Union changes list as needing similar revision. Also, Wikipedia:WikiProject United States Government Agencies is tagged for deletion and/or for being merged.
—Wavelength (talk) 02:35, 2 May 2011 (UTC)

Hi, I think it doesn't make much sense to exclude the dab pages and soft redirects, considering that there's only 6 of them and that Wikipedia:WikiProject Rugby and Wikipedia:WikiProject TRANSWIKI aren't even property tagged (so there is no easy way to figure out that a page is a WikiProject dab page). I didn't notice the two pages that should be subpages before, but I moved them to their proper places now. Thanks for the info. User<Svick>.Talk(); 12:29, 7 May 2011 (UTC)

afd top

I have removed the metadata from afd top template, but the result is same. --Reference Desker (talk) 09:07, 8 May 2011 (UTC)

Yes, that's because the template is substituted, not transcluded to the AfD pages. When I removed it from the AfD page you mentioned before, the PDF started to work. Removing the class from the template will make newly closed AfDs visible. User<Svick>.Talk(); 10:47, 8 May 2011 (UTC)

Thanks. This means the afds closing now will be ok. --Reference Desker (talk) 11:31, 8 May 2011 (UTC)

Categories for discussion nomination of Category:The Real Housewives of...

Category:The Real Housewives of..., which you created, has been nominated for discussion. If you would like to participate in the discussion, you are invited to add your comments at the category's entry on the Categories for discussion page. Thank you. —Justin (koavf)❤T☮C☺M☯ 03:21, 9 May 2011 (UTC)

Thanks

For fixing the wiki-ads mistake I made. MBisanz ^talk 00:48, 12 May 2011 (UTC)

WikiProject Mathematics lists

The latest report of new WikiProjects contains 27 entries which probably should be subpages with the virgule "/".
—Wavelength (talk) 15:45, 18 May 2011 (UTC)

Yeah, I noticed and already moved them. They will show on the list for the following month though, as the entries at Special:NewPages weren't changed by the move. User<Svick>.Talk(); 20:16, 18 May 2011 (UTC)

Thank you. If I had visited even one of those pages, I would not have had to mention them to you. I hope to do better in the future.

—Wavelength (talk) 21:51, 18 May 2011 (UTC)

A cookie for you!

Armbrust has given you a cookie! Cookies promote WikiLove and hopefully this one has made your day better. Spread the WikiLove by giving someone else a cookie, whether it be someone you have had disagreements with in the past or a good friend. †

I second that cookie, hadn't even thought of changing the message bar before. Cheers, Feezo (send a signal | watch the sky) 07:08, 22 May 2011 (UTC)

Thank you both. User<Svick>.Talk(); 12:42, 22 May 2011 (UTC)

My bad

Woops, sorry! I just automatically assumed this was Wolterding's cleanup lists. —  HELLKNOWZ  ▎TALK 13:22, 22 May 2011 (UTC)

User:Svick/HarvErrors.js

Hi, just to let you know that I created an (apparently) RL-compatible version of User:Svick/HarvErrors.js at User:Ucucha/HarvErrors.js. Ucucha 13:17, 2 June 2011 (UTC)

Thanks. I updated my version too. User<Svick>.Talk(); 19:22, 2 June 2011 (UTC)

Trachtenberg

You're right, not a TV Guide, my apologies; I had intended to remove my excess specificity on 2011-06-10. Enjoy her episode! — Preceding unsigned comment added by 8.18.145.160 (talk) 23:18, 6 June 2011 (UTC)

I liked the first episode, so I'm sure I will, thanks. User<Svick>.Talk(); 19:35, 7 June 2011 (UTC)

Energy in the United Arab Emirates

Hi User<Svick>, You fixed the Template:Europe topic Template talk:Europe topic. In Template:West Asia topic is a similar problem: link to Energy in the United Arab Emirates is not valid. Can you help? Watti Renew (talk) 15:58, 9 June 2011 (UTC)

Fixed :) Watti Renew (talk) 16:34, 9 June 2011 (UTC)

DropDownToTabs... in jQuery

$(function() {
  $('#p-cactions, #p-twinkle')
    .removeClass('vectorMenu').addClass('vectorTabs').css('margin-left', '0.5em')
    .find('li > a').wrap('<span></span>');
});

What a difference, eh? It is now a gadget. — Edokter (talk) — 22:50, 23 June 2011 (UTC)

Hmm, I don't have much experience using jQuery (or JS in general), but, yeah that code is much better than my version. Good work. User<Svick>.Talk(); 22:55, 23 June 2011 (UTC)

monitor changes in categories

Someone asked about how to monitor changes in categories at the help desk. I shared the tool you developed, which I used to use extensively, how I haven't in some time, because the cat was deleted. Am I doing something wrong? I don't seem to get it to work for any cats I've tried, including ones I know have recent changes.--SPhilbrickT 15:54, 6 July 2011 (UTC)

The way it works is that you create a named list (you can call it for example “SPhilbrick”, or anything else) and then add categories to it. For example, I have just created a list called “Example” and added the two categories you seemed to try to watch today to it: [3]. For now, they show no changes, but changes to them from now on will show there (with a delay). User<Svick>.Talk(); 17:17, 6 July 2011 (UTC)

I think I missed the admonition that you need to wait a bit, for some reason, I thought when you clicked, say seven days, it gave you the results for the last seven days. But I was mistaken. Thanks for the answer.--SPhilbrickT 18:06, 6 July 2011 (UTC)

Ad:Wikipedia:Dusty_articles/List

Ad:Wikipedia:Dusty_articles/List

Is it possible to request similar list for plwiki? (1000 articles, single run, my be generated to my userspace) Bulwersator (talk) 18:12, 14 July 2011 (UTC)

Sorry I didn't respond earlier. The code that I use requires some rewrite and I seem to be unable to find the time during the week. I will most likely do it this weekend. User<Svick>.Talk(); 20:52, 21 July 2011 (UTC)

Or, if it is easier for you - you can regenerate list as on enwiki Bulwersator (talk) 07:04, 22 July 2011 (UTC)

The list is at pl:Wikipedysta:Svick/Dusty. Feel free to edit or move that page any way you wish (the list itself is transcluded there). User<Svick>.Talk(); 14:31, 24 July 2011 (UTC)

Thanks! Bulwersator (talk) 10:24, 21 August 2011 (UTC)

Project

Hello

Its possible to create such list for pl.wiki? PMG (talk) 06:03, 21 July 2011 (UTC)

It would be really useful Bulwersator (talk) 11:49, 21 July 2011 (UTC)

The report is at pl:Wikipedysta:Svick/WikiProjects by changes and is generated weekly. I noticed an anomaly there: Wikiprojekt:Zoologia do 12. It's caused by the page pl:Dyskusja Wikiprojektu:Zoologia do 12/10. If you want to, you can tell the project that it would be best if they moved their archives to something like Dyskusja Wikiprojektu:Zoologia/Archiv 12-10. Also, if you want to translate the report to Polish, please tell me what do you want it to say. User<Svick>.Talk(); 21:32, 21 July 2011 (UTC)

Fixed, is it possible to run bot to clean red links? But of course we can wait one week. But what caused listing of "Wikiprojekt:Nauki Medyczne"? Bulwersator (talk) 07:03, 22 July 2011 (UTC)

On your list there is also Wikiprojekt:Wielkopolska, but nothing links there and there is no "deleted edits". So why this is on list? PMG (talk) 07:43, 22 July 2011 (UTC)

Also why >Wikiprojekt:Albumy muzyczne< is Wikiprojekt:Albumy muzyczne not "Wikiprojekt:Albumy muzyczne"? PMG (talk) 07:48, 22 July 2011 (UTC)

Is it possible to add interwiki? Bulwersator (talk) 08:38, 22 July 2011 (UTC)

• I have just run the report again. The Wikiprojekt:Zoologia do 12 rows are gone.
• Wikiprojekt:Nauki Medyczne is listed because of pl:Dyskusja Wikiprojektu:Nauki Medyczne/Archiwum 1 and Wikiprojekt:Wielkopolska is listed because of pl:Wikiprojekt:Wielkopolska/Opis miejscowości. The script counts edits to all project subpages and those pages look like subpages of projects that don't exist.
• Wikiprojekt:Albumy muzyczne was in italics because of a bug in the script, that is fixed now. Projects in italics are redirects, that nevertheless have some subpages.
• I have added the interwiki link both ways.

User<Svick>.Talk(); 18:42, 22 July 2011 (UTC)

• Thanks! Bulwersator (talk) 21:05, 22 July 2011 (UTC)

102d Intelligence Wing

What does the unit emblem say? Bwmoll3 (talk) 14:50, 24 July 2011 (UTC)

Well, the official page consistently says “102nd”. User<Svick>.Talk(); 16:30, 24 July 2011 (UTC)

Times

I'm afraid I don't get the point of {{times}}. Isn't it easier to use the "×" in the tool box? Sorry but I just felt like putting it up for deletion. JIMp _talk·cont 02:13, 8 August 2011 (UTC)