User talk:Erwin/Archive/2008

Latest comment: 15 years ago by WWGB in topic June Lewis

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)

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)

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 SatuSuro 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)

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)

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)

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)

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)

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)

Charts

Since you are from Dutch Wikipedia, could you tell me if nl:United World Chart and nl:Hot100Brasil are going to be deleted by speedy deletion (both were deleted on en-wiki and pt-wiki. UWC was deleted on several other wikipedias.)? Do they need regular deletion? I don't know how to create a regular deletion because I don't understand dutch. Thanks. Tosqueira (talk) 01:37, 16 June 2008 (UTC)

Both have been nominated for regular deletion after you nominated them for speedy deletion. Again, thanks for the heads up. --Erwin85 (talk) 09:33, 16 June 2008 (UTC)

Query

I need help renaming about 200 articles. Doing this by hand would take me all day.

Can your bot rename articles, or be adapted to do so?

If so, please contact me.

Thank you.

The Transhumanist 22:38, 16 June 2008 (UTC)

Thanks!

Thanks much for creating/maintaining the CatCount bot. I have started using it for our assessment tables. It is very useful!. Thanks, Ganeshk (talk) 21:29, 22 June 2008 (UTC)

Thanks, nice to see it's appreciated. --Erwin85 (talk) 09:29, 23 June 2008 (UTC)

Links

I've replied on my talk page. thanks for your reply. SF007 (talk) 23:51, 24 June 2008 (UTC)

thankyou

thankyou for telling me.HereFord 00:06, 3 August 2008 (UTC)

Ncd/NowCommons

I removed the grumpy thing that the NowCommons template displays telling you to subst it. Is there anything else you'd like to suggest I do? (Note that CommonsHelper adds the subst in of its own accord; someone should perhaps alert Magnus as to the updated template behavior...) —Scott5114 [EXACT CHANGE ONLY] 10:12, 6 August 2008 (UTC)

Well, how I have it set up now is ncd is a simple redirect to NowCommons, so the server basically treats any instances of ncd as being equivalent to NowCommons. Keep in mind that the name parameter still needs to be passed to NowCommons so it can decide if it goes into the "images now on Commons" or "images with the same name now on Commons" category. If you like, I could unprotect ncd so you can tinker with it. —Scott5114 [EXACT CHANGE ONLY] 10:49, 6 August 2008 (UTC)
Sounds good. Copied it into the template. —Scott5114 [EXACT CHANGE ONLY] 11:10, 6 August 2008 (UTC)

Message from LDEJRuff

Hey, thanks for saving those two Disney Channel logos, and protecting them from deletion.
~~LDEJRuff~~ (talk) 22:39, 9 August, 2008 (EDT) —Preceding undated comment was added at 02:39, 10 August 2008 (UTC)

WP:RFBOT

Your recent bot approvals request has been approved. Please see the request page for details. – Quadell (talk) 13:59, 11 August 2008 (UTC)

Thanks. --Erwin85 (talk) 15:12, 11 August 2008 (UTC)

Initial problems with Erwin85Bot

Thanks for notifying me of the problem with the above bot, in that it notified me of something that I had performed! It is nice that you told me what had happened without me having to enquire. I think that the bot it a good idea and hopefully you can iron some of bugs out. Once again, thanks and I wish you good luck with the bot! Arriva436talk 16:23, 11 August 2008 (UTC)

Using Catcount on the subpages of CAT:COPY

Hi Erwin85. Firstly, a huge thanks for creating your catcount bot! :) Anyway, I've been trying to use catcount to count the number of articles in the monthly subpages of CAT:COPY. I've tried everything but it doesn't seem to work. I've transcluded {{User:Erwin85/CatCount}} and placed the code for this subcategory in my sandbox, but the counter returns a zero when there are 80+ articles in the category. Did I do something wrong? Thanks :) -Samuel Tan 12:54, 20 July 2008 (UTC)

Hi, sorry for the late reply, but I just came back from holiday. I see the bot now updates the count, so I guess you already solved it, didn't you? --Erwin85 (talk) 09:04, 1 August 2008 (UTC)
Welcome back! Yes, it works now, thanks :) Just one more question: Does your bot support subcategories, or at least some form of "adding up"? (for example, a script to count number of articles in 10 different categories) Thanks a lot :) -Samuel Tan 09:55, 1 August 2008 (UTC)
At the moment it doesn't. I guess you can use parser functions to add them up, but I haven't actually tried that. --Erwin85 (talk) 12:40, 1 August 2008 (UTC)

Somehow one category is not being counted

Hi there! I've used the correct code for CAT:COPYEDIT at two places on our project page (the spots where we list the "total number of articles", but it's been a few days and the total count has never updated. Any ideas why? Thanks... -Samuel Tan 03:18, 10 August 2008 (UTC)

Hi, it searches for digits in the code, so I removed the comma. It's been updated now. --Erwin85 (talk) 09:11, 10 August 2008 (UTC)
Oh I see... Thanks! -Samuel Tan 05:21, 12 August 2008 (UTC)

BOT MALFUNCTION

I don't understand why it is automatically replacing a welsh royal flag with a picture of a Russian castle?? viz;

NowCommons: Image:Deheubarth1.JPG

Image:Deheubarth1.JPG is now available on Wikimedia Commons as Commons:Image:Bilhorod Dnistrovskyi.jpg. Commons is a repository of free media that can be used on all MediaWiki wiki's. The image(s) will be deleted from Wikipedia, but this doesn't mean it can't be used anymore. You can embed an image uploaded to Commons like you would an image uploaded to Wikipedia, in this case: [image] Note that this is an automated message. --Erwin85Bot (talk) 15:15, 11 August 2008 (UTC)

I don't understand how this bot works but there seems a vacuum of logic surrounding this notification it gave me James Frankcom (talk) 21:22, 12 August 2008 (UTC)

To be honest I don't immediately see why it said the image was being replaced with Image:Bilhorod Dnistrovskyi.jpg. It should have reported that it was being replaced with Commons:Image:Deheubarth1.JPG, which is an exact duplicate. I've checked some of the other edits, but didn't see the same mistake. In any case this was a one time run, but I'll look into it some more just to be sure there are no more errors. Thanks for your message! --Erwin85 (talk) 21:33, 12 August 2008 (UTC)

NowCommons notification

It looks like the bot is working great, thanks for building it! One small request, I was wondering if it could not link to the image in the section heading. Somewhere in the MoS it cautions against doing this, as it can be confusing for screen readers, but also it might look bad once the images are deleted and they become red links. I was also thinking it might be good to combine multiple messages, like the ones listed on User talk:Ebryden. One (possible) solution would be to have the section read something like "An image you've uploaded has been moved to the Commons" or "Your image moved to Commons" (or something), not specifying the image name, and any future notices can be put under that as a simple

Or something to that effect, instead of creating a new section for each image. This would reduce potential clutter. I don't think that bots usually link messages like this, but most bot messages are warnings of some sort, whereas this is more of a positive message. Just a thought. ~ JohnnyMrNinja 19:55, 13 August 2008 (UTC)

I removed the link. I've been thinking about these multiple messages myself, but couldn't come up with an acceptable solution. This sounds like one though. From now on, each time an image is tagged it searches for <!-- ncnotifier --> and if found, adds:
*[[:Image:Example.svg]] is now at [[:Commons:Image:Example.foobar.svg]]. --~~~~
When a user gets a message for the first time it adds:
== NowCommons: Image:Example.jpg==
Current message about Example.jpg being moved. Note that this is an automated message. --[[User:Erwin85Bot|Erwin85Bot]] ([[User talk:Erwin85Bot|talk]]) 00:00, 1 January 1970 (UTC)
<!-- ncnotifier -->
This leaves the first message as it is, but makes less clutter for future messages. Maybe I'll make it less specific in the future, like you suggested. In any case it's a great idea! Thanks. --Erwin85 (talk) 21:22, 13 August 2008 (UTC)
I think it may be best to bullet or space the messages somehow, as now they look a bit cluttered (see User talk:NeithNevelson), but it's by no means vital (and perhaps bulleting would take up too much room?). I don't know, it's just a suggestion. ~ JohnnyMrNinja 01:11, 14 August 2008 (UTC)
Forgot about that. I'm now indenting them. --Erwin85 (talk) 08:27, 14 August 2008 (UTC)

NowCommons: Image:190-04 901117.jpg

Image:190-04 901117.jpg is now available on Wikimedia Commons as Commons:Image:FR Conway Castle.jpg. This is a repository of free media that can be used on all MediaWiki wiki's. The image will be deleted from Wikipedia, but this doesn't mean it can't be used anymore. You can embed an image uploaded to Commons like you would an image uploaded to Wikipedia, in this case: [[Image:FR Conway Castle.jpg]]. Note that this is an automated message. --Erwin85Bot (talk) 16:10, 14 August 2008 (UTC)

Image:110Comb-060103.jpg is now available as Commons:Image:FR Carriage110.jpg. --Erwin85Bot (talk) 17:43, 14 August 2008 (UTC)
Image:119Comb-060103.jpg is now available as Commons:Image:FR Carriage119.jpg. --Erwin85Bot (talk) 17:47, 14 August 2008 (UTC)
Image:117Comb-060104.jpg is now available as Commons:Image:FR Carriage117.jpg. --Erwin85Bot (talk) 17:55, 14 August 2008 (UTC)
The new names of these images is inappropriate. Take the image of 110, the new title does not reflect that this is a composite image and the date of the image has been lost. If you must put these images onto Commons, can you please use the original names. --Stewart (talk) 18:58, 14 August 2008 (UTC)
The image name is now not future proof. Any future images of this items of rolling stock will still have to be dated (for example). Although I believe the image names should that been retained; dates and other relevant info (combination image), should have been retained. For example it is highly likely that images of 117 is green/white livery and all over maroon could be posted. --Stewart (talk) 19:15, 14 August 2008 (UTC)
Hi Stewart, I didn't move these images to Commons myself. My bot only notifies you of this move, so I suggest leaving a a similar message at Commons:User talk:Mattbuck as Mattbuck moved the images to Commons. --Erwin85 (talk) 19:09, 18 August 2008 (UTC)

Thank you

 
WikiThanks

Thank you for you quick help in responding to my bot request. Eklipse (talk) 11:01, 15 August 2008 (UTC)

You're welcome. --Erwin85 (talk) 19:09, 18 August 2008 (UTC)

Bot talk

I think you will find "any more" is two words. Kittybrewster 10:24, 19 August 2008 (UTC)

It can be spelled both as one word and as two words. According to dictionary.com it's most commonly spelled as one word when meaning “any longer”. Thanks for your message though. Wouldn't want to make spelling errors there. --Erwin85 (talk) 10:31, 19 August 2008 (UTC)

Problem responding to {{KeepLocal}} tag

Hi Erwin85, your bot was kind enough to upload this image to Wikimedia Commons. Unfortunately, it seems to have a hard time responding to the {{KeepLocal}} tag that was present on the page before the upload. I've removed the {{NowCommons}} tag, and User:Sam Korn has revised the {{KeepLocal}} to a {{NoCommons}} one. Is there a way for you to program your bot to either ignore the {{KeepLocal}} tags or to do the switch to {{NoCommons}} one directly? That would be very helpful. Thanks, Risker (talk) 22:22, 18 August 2008 (UTC)

Hi, my bot only notifies the authors when an image is tagged with {{NowCommons}}. It doesn't actually move or copy, i.e. upload, images. What do you mean by ignoring the {{KeepLocal}} tags and by switching to {{NoCommons}}? I could of course not leave a message for images tagged with either {{KeepLocal}} or {{NoCommons}}, but I don't know if I should. What do you suggest? Perhaps I could add a task to replace KeepLocal with NoCommons or remove the added NowCommons tag. Is that what you meant? If so, I'll run it through a separate WP:BRFA to get some input. Thanks, Erwin85 (talk) 09:57, 19 August 2008 (UTC)
I agree with Risker -- KeepLocal should be replaced with NoCommons (per the template's documentation). Thanks for the work you do. Sam Korn (smoddy) 16:51, 19 August 2008 (UTC)
Hi Erwin85, thanks for your response. My apologies for assuming that your bot was also doing the uploading to Commons; those of you with programming talents have come up with so many ways of doing useful tasks it's hard for us stone-age editors to keep up. The notification is great, so please don't stop doing it. Your suggestion to add a task to replace KeepLocal with NoCommons and remove the added NowCommons tag sounds like a great idea; if you go for it, please let me know and I will be happy to pop by WP:BRFA to support. Thanks for your help. Risker (talk) 17:12, 19 August 2008 (UTC)
No problem. I've put up a BRFA at Wikipedia:Bots/Requests for approval/Erwin85Bot 7. --Erwin85 (talk) 13:29, 20 August 2008 (UTC)

typo in nowcommons message

when it says ... "This is a repository of free media that can be used on all MediaWiki wiki's" it should be "Wikimedia wikis" instead :) No apostrophe for a simple plural. Thanks for fixing! -- phoebe / (talk to me) 03:10, 22 August 2008 (UTC)

Thanks for your message! At first I though that all MediaWiki wikis could use Commons, but mw:InstantCommons is only a draft. Anyway, I fixed the errors. --Erwin85 (talk) 07:33, 22 August 2008 (UTC)

Query

Why did you remove the link to "www.vincent-van-gogh-gallery.org" from his page? It would seem to be a valid and usefull website for those interested in the subject - and I don't see any commercial stuff going on.--IceHunter (talk) 16:28, 24 August 2008 (UTC)

This link and related links were all added by one user to multiple pages on multiple projects. It's that behaviour that caused me to revert the edits. Feel free to re-add the link if you think it benefits the article. See m:External links policy for more information about so-called cross-wiki spam. --Erwin85 (talk) 18:42, 24 August 2008 (UTC)

Bot flagged

I have flagged your bot. =Nichalp «Talk»= 04:40, 4 September 2008 (UTC)

WP:RFBOT

Your recent bot approvals request has been approved. Please see the request page for details. (This is for task 4, the on-going one.) – Quadell (talk) 13:34, 13 August 2008 (UTC)

Thanks again. --Erwin85 (talk) 14:14, 13 August 2008 (UTC)

Assistance moving an image

I am unclear how to move an image of Pal Teleki on the Hungarian language site to Wikipedia commons, or if the copyright (in Hungarian) permits this usage. Can you help? When I attempted to use CommonsHelper[1], it displayed the following message:

"This image has no verificable good license, and can thus not be uploaded to commons through this tool."

-- btphelps (talk) (contribs) 08:29, 4 October 2008 (UTC)

According to the template at hu:Kép:Teleki.jpg it's a non-free license, so you can't move it to Commons. --Erwin(85) 11:36, 4 October 2008 (UTC)

How to reference Yama.jpg from Commons on Wikipedia

The Image:Yama.jpg is not the same as the one on Commons. How do I use the new location syntax. I tried Image:Yama.jpg in the article and it is not the Dharmapala image I wanted. Thank you, --Ancheta Wis (talk) 16:33, 31 October 2008 (UTC)

Erwin, can you give an example article which references a Commons image. --Ancheta Wis (talk) 13:28, 1 November 2008 (UTC)

The problem is that there's a local image with the name Yama.jpg as well. This image is not the same as Yama.jpg at Commons. This means that either you have to use the old file name — Image:102 0812.jpg — or that the local Yama.jpg has to be moved out of the way. Do you need help with that? --Erwin(85) 09:57, 2 November 2008 (UTC)

Image:HMSLiondamagetoQturret.jpg

With regard to erwinbot moving this image to commons. I have already myself uplaoded an identical copy of this image to commons. However, since I was then uncertain whether it is copyright free anywhere except in the USa, I placed a second copy here pending any further information. I would say it is probably copyright free, but since I don't know who took it, it may have been taken by a private individual rather than a navy officer in the course of his duties, and as such might still be copyright under the rule life + 70 years. Except not in the USA, of course. Sandpiper (talk) 14:06, 7 November 2008 (UTC) PS. I have come across a few old similar images which have been transferred to commons and then get struck out without being returned whence they came.

My bot didn't actually move the image. Someone else did and it notified you of the change. It's a good idea to keep a local one in this case though. --Erwin(85) 18:43, 7 November 2008 (UTC)

June Lewis

The bot keeps adding June Lewis to Wikipedia:WikiProject Deletion sorting/Living people. She's dead! WWGB (talk) 00:55, 26 November 2008 (UTC)

Talkback

 
Hello, Erwin. You have new messages at Wikipedia:Bot requests.
You can remove this notice at any time by removing the {{Talkback}} or {{Tb}} template.

Talkback

 
Hello, Erwin. You have new messages at Wikipedia:Bot requests.
You can remove this notice at any time by removing the {{Talkback}} or {{Tb}} template.