User talk:Erwin/Archive/2007

Scratchpad

Hi! As others might find your list helpful as well, I added it to to Wikipedia:WikiProject Lakes/Articles/all. Hope you don't mind. -- User:Docu

No problem, glad I could help. --Erwin85 21:40, 28 January 2007 (UTC)

This is a automated to all bot operators

Please take a few moments and fill in the data for your bot on Wikipedia:Bots/Status Thank you Betacommand ^{(talk • contribs • Bot)} 19:03, 12 February 2007 (UTC)

Image:Kees_Vendrik

Hi! I've written the Kees Vendrik-article and I'm looking for illustrations. I saw you contributed a photo of him for the commons. I don't know how to transfer this image here in a way that the link between the image on the commons and here is clear. Could you transfer it? Thanks in advance! C mon 14:55, 18 February 2007 (UTC)

Hi, I don't understand what you mean. You can use an image on Commons the same way you would use a local image, i.e. [[Image:Kees Vendrik.jpg]] would result in the image. --Erwin85 11:40, 20 February 2007 (UTC)

Thanks! I did know that! C mon 12:33, 20 February 2007 (UTC)

Automated message to bot owners

As a result of discussion on the village pump and mailing list, bots are now allowed to edit up to 15 times per minute. The following is the new text regarding bot edit rates from Wikipedia:Bot Policy:

Until new bots are accepted they should wait 30-60 seconds between edits, so as to not clog the recent changes list and user watchlists. After being accepted and a bureaucrat has marked them as a bot, they can edit at a much faster pace. Bots doing non-urgent tasks should edit approximately once every ten seconds, while bots who would benefit from faster editing may edit approximately once every every four seconds.

Also, to eliminate the need to spam the bot talk pages, please add Wikipedia:Bot owners' noticeboard to your watchlist. Future messages which affect bot owners will be posted there. Thank you. --Mets501 02:35, 22 February 2007 (UTC)

Lake Madawaska

I notice a link from a Scratchpad in your userspace to Lake Madawaska. I just wanted to let you know that the page has moved to Madawaska Lake, because there is another lake in Ontario, Canada that is officially called Lake Madawaska, while the lake descibed in that article is officially known as Madawaska Lake. I don't know which you will want to link to, so I've left your link unchanged. - Cafemusique 18:46, 8 March 2007 (UTC)

That was really old stuff on my scratchpad so I removed the contents. Thanks anyway for notifying me! --Erwin85 19:40, 8 March 2007 (UTC)

Australia project category count

Hi Erwin85. Eventually, we'd like all tables at User:Longhair/AUWPtable to be automatically updated by a bot. We certainly don't expect all six tables to be functional asap, but any assistance you can offer to allow a bot to perform this duty is most welcomed. Let me know if you need any further details. -- Longhair\^talk 21:57, 24 September 2007 (UTC)

Everything looks good. Thanks for having a go at getting this functional. Updates twice a day are ok. An error has been made with the categories of Underpopulated categories and Underpopulated Year categories (which both contain sub-categories to be counted, not articles). Otherwise everything else looks and appears to be working just fine. -- Longhair\^talk 23:35, 25 September 2007 (UTC)

When you say replag, do you the mean the delay imposed on you by the tools server? I guess any update is better than none. -- Longhair\^talk 09:51, 13 October 2007 (UTC)

That's a shame with the delay. How do other bots operate on a more regular basis? -- Longhair\^talk 10:00, 13 October 2007 (UTC)

Thanks for this. Like I said any progress is a good thing. Assuming the replag is zero, how often would the category count update? -- Longhair\^talk 10:12, 13 October 2007 (UTC)

If there's anything we should know feel free to feed the information on. I suspect the page will move from being a subpage of my userpage to a subpage of the Australia WikiProject itself. Should this move be made now ? -- Longhair\^talk 10:22, 13 October 2007 (UTC)

The page is now at Wikipedia:WikiProject Australia/BotStatistics. It will need to be separated into single pages for each table if others wish to transclude the results onto their userpages for example. -- Longhair\^talk 10:35, 13 October 2007 (UTC)

I've split the tables into five separate pages to make transclusion of individual tables easier.

• Wikipedia:WikiProject Australia/BotStatistics/Maintenance
• Wikipedia:WikiProject Australia/BotStatistics/Projects
• Wikipedia:WikiProject Australia/BotStatistics/Places
• Wikipedia:WikiProject Australia/BotStatistics/Sports
• Wikipedia:WikiProject Australia/BotStatistics/Photographs

I've edited Wikipedia:WikiProject Australia/BotStatistics to translude the results from all five pages above. -- Longhair\^talk 12:09, 13 October 2007 (UTC)

The category count of Category:Underpopulated Australia categories is broken, showing a result of 1844 when there are 123 categories. Category:Underpopulated (Year) in Australia categories is also broken, showing 0 results, when there are 39 categories. -- Longhair\^talk 12:19, 13 October 2007 (UTC)

Everything looks to be functioning well with the split of the pages into 5 separate pages. One problem I did notice is that the photograph request table (Wikipedia:WikiProject Australia/BotStatistics/Photographs) didn't appear to update with the new category count correctly. See this edit [1], where the only update was to change 1 value for Queensland related images, when for example the category for Northern Territory was populated by myself just today and appeared to be ignored by the bot in this instance? Any ideas? I must add the work you've done in getting this project off the ground is much appreciated.-- Longhair\^talk 12:19, 15 October 2007 (UTC)

Ok, I understand fully now how the replag affects the results. Thanks for your explanation. Let's see how things fare for a while yet before we go making further changes. Is there someplace online I can see the replag delay at any given time and perhaps a historical graph-like log of the delay over a period of time? -- Longhair\^talk 14:55, 15 October 2007 (UTC)

Ignore the above request. I discovered http://tools.wikimedia.de/~leon/stats/replag/en/, and realised that too is way out of date :( -- Longhair\^talk 14:59, 15 October 2007 (UTC)

Bot information

Hello, I was wondering if the pywikipedia code for User:Erwin85Bot is available anywhere, specifically the code that creates Wikipedia:WikiProject Australia/BotStatistics? I've been trying to create a bot to do this kind of thing for Wikipedia:WikiProject Aviation, and am in the process of getting a bot approved to do it, but am having trouble getting the codeing straight. I havn't programmed in years, and I've never used Python so its a bit of a learning experience. ANy help is appreciated. - Trevor MacInnis (Contribs) 11:49, 31 October 2007 (UTC)

I've added the code to my svn repository. It's located at http://fisheye.ts.wikimedia.org/browse/erwin85/trunk/Erwin85Bot/catcount.py. I hope this helps. --Erwin85 14:05, 31 October 2007 (UTC)

Thanks a lot, that's perfect. I've just come across a few problems I don't understand. What does the module querier do? I've gotten the module here, but it calls import MySQLdb, MySQLdb.cursors. I've downloaded MySQL for Python from sourceforge, but is doesn't include a MySQLdb.py file as far as I can tell. I think I may be in over my head! - Trevor MacInnis (Contribs) 21:40, 31 October 2007 (UTC)

If I remember correctly MySQL is simply part of python and you don't need to download a separate module to use it. However, I don't think you need MySQL. My bot runs on the Toolserver and uses the database to get the number of pages in a category. Toolserver access is needed for this bot. I'd be happy to run it for you or you could get the number of pages by checking category pages in which case you don't need Toolserver access. --Erwin85 19:42, 1 November 2007 (UTC)

Ah, thats why I'm getting Unknown MySQL server host sql-s1. I was hoping to run this manually on my computer, and I probably can't get toolserver access for just this bot. If you could expand your bot to process the Wikipedia:WikiProject Aviation that would be great! I've already created a few articles I was going to use at Wikipedia:WikiProject Aviation/BotStatistics/Maintenance and Wikipedia:WikiProject Aviation/Cleanup. OR, alternately, if you could clue me in on a way to do this on my own, perhaps by an different way of counting, without the whole sql part or requiring toolserver... - Trevor MacInnis (Contribs) 22:26, 1 November 2007 (UTC)

By the way, there are probably other projects that would be interested in getting in on this. A dedicated bot would not be a bad idea. If there's anything I can do let me know. - Trevor MacInnis (Contribs) 22:41, 1 November 2007 (UTC)

I've set up Wikipedia:WikiProject Aviation/BotStatistics/Maintenance to use my bot. My bot can simply deal with all categories and is not limited to the Australia WikiProject. So other projects could use it too. If you want to use your own bot you should check pywikipedia's category.py for a function to count the number of pages in a category. --Erwin85 20:03, 2 November 2007 (UTC)

Great! Thanks a lot! - Trevor MacInnis (Contribs) 22:12, 2 November 2007 (UTC)

Biography project

I think we at Wikipedia:WikiProject Biography would be very appreciative if you would set up your bot for the use of the Biography project. I think it would make our project's efforts significantly easier. Thank you for your work on setting up the bot and offering its use to us. John Carter 14:08, 6 November 2007 (UTC)

I see Trevor MacInnis set up Wikipedia:WikiProject Biography/Maintenance/Backlog. That's all there is to it to use my bot. An explanation of its use is available at User:Erwin85/CatCount. If you need help adding categories please let me know. If you want you can give me a list of categories, and if possible please also a list of namespaces to count for those categories, to count and I'll set it up. --Erwin85 18:27, 6 November 2007 (UTC)

Hebrew messages

Messages to be translated for the Hebrew Wikipedia. I've posted the new English and old Hebrew messages. Requested translation at he:. Could you please edit the message in the pre below or give them as 'he' : u'Message' so I can simply copy/paste it?

1

'en': u'Robot-assisted disambiguation: %s - Changed link(s) to %s',
'he': u'תיקון הפניה לדף פירושונים באמצעות בוט: %s',

2

'en': u'Robot-assisted disambiguation: %s - Removed link(s).',
'he': u'תיקון הפניה לדף פירושונים באמצעות בוט: %s',

Thanks. --Erwin85 09:06, 9 November 2007 (UTC)

Received reply at he:. --Erwin85 09:20, 9 November 2007 (UTC)

CatCount

You list <!-- count:Unassessed Australian places articles; ns:1,14 -->0<!-- end --> as the syntax for listing all articles in two namespaces in one category. Would using a comma-delimited list of categories result in a cumulative total for the number of articles in all those categories? I mean to say, if I wrote <!-- count:Wikipedia articles needing copy edit from January 07, Wikipedia articles needing copy edit from February 07, Wikipedia articles needing copy edit from March 07; ns:1,14 -->0<!-- end -->, would the bot update that to the total number of articles in all three categories (currently ~470)?? Happy‑melon 13:26, 2 December 2007 (UTC)

At the moment it wouldn't, but it might be a nice feature. I'll think about adding it for a maximum of say 5 categories. In any case it's rather simple to add, but I'll have to use some limitations as I don't want excessively time consuming queries. --Erwin85 20:38, 2 December 2007 (UTC)