Wikipedia:Bots/Requests for approval/DASHBot 10


 * The following discussion is an archived debate. Please do not modify it. To request review of this BRFA, please start a new section at WT:BRFA. The result of the discussion was Symbol keep vote.svg Approved.

DASHBot 10
Operator:

Automatic or Manually assisted: Automatic

Programming language(s): Python

Source code available: Sure, email me.

Function overview: Find orphaned fair use files and tag them for deletion.

Links to relevant discussions (where appropriate):

Edit period(s): Every other night, but thats changeable.

Estimated number of pages affected: A few every few days, after the backlog (currently 4400 files) is cleared.

Exclusion compliant (Y/N): I'll work it in there.

Already has a bot flag (Y/N): Yes, but it wont use one. All edits are major enough to be in the watchlist.

Function details:


 * 1) Use sql to find all the orphaned images, with the uploading user (I tweaked some of CBM's code). Images must be:
 * 2) *Not already tagged for deletion.
 * 3) *Not used in the enwikipedia articlespace
 * 4) *Older then 48 hours.


 * 1) *Has no redirects with links either.
 * 2) Add   ~ to the bottom of the user talk pages of the corresponding uploaders.
 * 3) Check back every few hours to see if the images have been re-included in the article space. If so, de-tagg. (This is true of all orphaned fair use images, tagged for deletion)
 * 4) Wait 48 hours.*
 * 5) Repeat.

* The bot checks to see if the images were re-linked every few hours.

Discussion
BRFA Opened 01:27, 8 March 2010 (UTC)

Here is the query I use to generate the list from the server

Tim1357 (talk) 01:58, 9 March 2010 (UTC)
 * Eyeballing this code I'm concerned that it doesn't do what you think it does. Have you validated any of the returned values in your temporary table? Josh Parris 10:38, 9 March 2010 (UTC)
 * Yes, I have chosen a few at random and saw they met the criteria. Ill put a link to the full table here. Tim1357 (talk) 11:35, 9 March 2010 (UTC)
 * Josh and I conversed in IRC, and I fixed the error he was talking about. Tim1357 (talk) 04:48, 10 March 2010 (UTC)
 * I expanded my code so that the bot will remove deletion templates from files that are tagged as orphans, but have links in the article space. Furthermore, I updated my code so that images without links to the main space are listed, even if they have links to annother space. Tim1357 (talk) 04:12, 11 March 2010 (UTC)

Let's see how this works for 20 images, no more Josh Parris 22:27, 11 March 2010 (UTC)
 * - oh, and this doesn't mean "Discussion over" either. Josh Parris 22:47, 11 March 2010 (UTC)
 * Sure thing boss, Ill do 20 images, which means that up to 40 edits will be made (one for tagging the file and the other for notifying the user) Tim1357 (talk) 23:58, 11 March 2010 (UTC)

38 edts


 * 10 edits were the bot removing image deletion tags.


 * 15 edits were the bot tagging images for deletion.


 * 13 edits were the bot notifying users. Tim1357 (talk) 01:36, 13 March 2010 (UTC)
 * The reason there are less notify edits is because of a silly code error. Fixed! Tim1357 (talk) 01:41, 13 March 2010 (UTC)
 * Have the affected users been notified? Josh Parris 01:47, 13 March 2010 (UTC)
 * Yes, manually. Tim1357 (talk) 02:04, 13 March 2010 (UTC)

Another go at 20 images, no more Josh Parris 02:21, 13 March 2010 (UTC)
 * Done, ran exactly at planned. It did not notify when it tagged these two images because the user-name ended in 'bot'. Tim1357 (talk) 02:50, 13 March 2010 (UTC)

Josh Parris 03:43, 13 March 2010 (UTC)
 * The above discussion is preserved as an archive of the debate. Please do not modify it. To request review of this BRFA, please start a new section at WT:BRFA.