User talk:Erwin85

From Wikipedia, the free encyclopedia

Welcome!

Hello, Erwin85, and welcome to Wikipedia! Thank you for your contributions. I hope you like the place and decide to stay. Here are a few good links for newcomers:

I hope you enjoy editing here and being a Wikipedian! Please sign your name on talk pages using four tildes (~~~~); this will automatically produce your name and the date. If you need help, check out Wikipedia:Questions, ask me on my talk page, or place {{helpme}} on your talk page and someone will show up shortly to answer your questions. Again, welcome!

Hello Erwin, nice to see you here too. This is great fun! --Algont 21:14, 8 May 2006 (UTC)

Thanks. Erwin85 21:19, 8 May 2006 (UTC)

[edit] Image Halsema

Hi! I saw you changed the image of Halsema with a GDFL licensed one. I don't mean to attack your photography skills, but I don't think this picture is very beautiful, especially compared to for instance the Wouter Bos or Jan Marijnissen pictures, which are professional publicity shots. I'd prefer to put a professional shot (with its "this is copyrighted"-problems) in the infobox and move your photograph down. Can you live with that? C mon 23:23, 2 November 2006 (UTC)

Sure, go ahead. --Erwin85 10:03, 3 November 2006 (UTC)

[edit] 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)

[edit] 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)

[edit] 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)

[edit] 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)

[edit] 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)

[edit] 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)

[edit] 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)

[edit] 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)

[edit] 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?

[edit] 1

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

[edit] 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)

[edit] CatCount

You list 0 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 0, 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)

[edit] Contribs for multiple users

This is a fantastic tool - thank you very much for creating and running it. I was wondering might it be possible to add another feature so that you can specify the date to look at the contributions? So for example, one could look at the edits both by User:Foo and User:Foo2 in February 2007. That would make it much more useful where a new account was set up to avoid sanctions and the previous one later abandoned. WjBscribe 05:42, 19 January 2008 (UTC)

That's a good idea. I'll definitely add it. I don't know when I have the time to get to it though. --Erwin85 (talk) 17:55, 23 January 2008 (UTC)

[edit] Bot missing a pge

I'm not sure why, but the bot hasn't counted Wikipedia:WikiProject Aviation/Maintenance/B-Class in a few days. Its done all the other Aviation pages, but this one hasn't been updated in two days. There have been no edits to it to stop it from being counted. Could you take a look? - Trevor MacInnis (Contribs) 15:01, 25 January 2008 (UTC)

I've looked in the logs and it does count it. Which should mean that there's no difference in the number of pages. The database is down at the moment so I can't check it manually. I assume it'll be edited again in the next few days, but I'll have a look when the database is back up. --Erwin85 (talk) 16:33, 25 January 2008 (UTC)

Oh, I see. So if there are no changes in any of the categories being counted on the page, no edit is done. Makes sense. - Trevor MacInnis (Contribs) 18:09, 25 January 2008 (UTC)

[edit] Boy was it nice to see your bot

Please could you let me know if you have experienced assessment pages being double tagged - ie under two project assesment schemas? I have never seen as such - and am trying to have discussion about this at Australian Noticeboard - it would be appreciated if someone who knows something could actually join the conversation - thanks Satu Suro 12:05, 15 February 2008 (UTC)

I've never dealt with assessment myself, so I don't think I can help you with this. You could try posting a message on Wikipedia:Bot owners' noticeboard. --Erwin85 (talk) 13:20, 18 February 2008 (UTC)

[edit] CatCount - image namespace?

Hi Erwin, I've added the CatCount code etc to an area of my userspace (User:Nanonic/to do/logo count) to count images in categories but don't seem to be getting any results. Does the bot avoid the Image: namespace or have I made an error somewhere? Nanonic (talk) 02:04, 12 March 2008 (UTC)

Hi, my bot was case sensitive so it didn't recognize football logos as Football logos. I fixed that bug and updated your page. As you already capitalized the first letter yourself it would have been updated automatically later today though. --Erwin85 (talk) 08:24, 12 March 2008 (UTC)

Doh! I thought it'd be something simple, thanks a lot for the fix. Nanonic (talk) 13:50, 12 March 2008 (UTC)

[edit] Bot stopped processing {{Australia opentask/Count}}

User:Erwin85Bot was successfully updating category counts for {{Australia opentask/Count}}, until 23:07, March 10, 2000. The bot is no longer processing this template. No changes have occurred within the template itself to cause the bot to ignore this page. Can you advise why this is occurring thanks? -- Longhair\^talk 02:01, 4 April 2008 (UTC)

I'd have to check the logs, but I can't access them right now. I'll definitely check it out, though it might take a day or two before I do so. --Erwin85 (talk) 11:26, 5 April 2008 (UTC)

There was a bug in dealing with spaces or underscores in category names. I've fixed that now so that spaces and underscores can be interchanged. --Erwin85 (talk) 17:02, 12 April 2008 (UTC)

Thanks for the speedy resolution. Much appreciated. Cheers. -- Longhair\^talk 09:09, 15 April 2008 (UTC)

[edit] Request for assistance with bot

How would one go about updating the totals on the Wikipedia:WikiProject Novels/Members/StatsGraph page to reflect the incorporation the numbers for the newly merged Shannara, Narnia, and Lemony Snicket task forces? Thank you. John Carter (talk) 16:04, 4 April 2008 (UTC)

The only automatically updated count is of Category:WikiProject Novels participants, which is populated using user boxes. So I don't think I can help you. I suggest you ask Wassupwestcoast for help as he updates the other figures. --Erwin85 (talk) 11:34, 5 April 2008 (UTC)

Fair enough. Thanks for the quick response. :) John Carter (talk) 14:57, 5 April 2008 (UTC)

[edit] Query for botreq

What'd query did you come up with for that? I came up with something like:

SELECT page_id, page_title 
FROM templatelinks 
JOIN page ON (tl_from = page_id) JOIN categorylinks ON (cl_to = page_title) 
WHERE tl_title = 'Infobox_Album' 
AND tl_namespace = '10' 
AND cl_to = 'Album_articles_without_infoboxes'

query planner said it wasn't that bad, but I didn't wait it out past 25 minutes to see how long it'd actually take to run. Q ^{T C} 03:09, 24 April 2008 (UTC)

I used:

SELECT p.page_namespace AS ns_id, p.page_title AS title
FROM page AS p
LEFT JOIN page AS tp 
ON p.page_title = tp.page_title
AND p.page_namespace = tp.page_namespace -1
LEFT JOIN categorylinks
ON cl_from = tp.page_id
LEFT JOIN templatelinks
ON tl_from = p.page_id
WHERE cl_to = 'Album_articles_without_infoboxes'
AND tl_title = 'Infobox_Album'
AND tl_namespace IS NOT NULL;

Why do you join categorylinks and page on cl_to = page_title? Your query doesn't work AFAIK. I'm joining page on page because the talk page is in the category and the infobox is on the article. --Erwin85 (talk) 08:09, 24 April 2008 (UTC)

Because the talk page and the mainspace page should have the same page_name, they just have differing page_id's, unless I'm wrong on that point. But yea, that runs a lot faster then mine. Q ^{T C} 09:14, 24 April 2008 (UTC)

[edit] Re:Image

Yeah, I noticed that about 1 second after I uploaded it. I contacted commons:User: Durova, and asked h/er to delete it. But it seems like she hasn't been online lately. Thanks for the heads up though. Milk’s Favorite Cookie ^(Talk) 16:26, 24 April 2008 (UTC)