Commons:Bots/Work requests/Archive 9

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search

Images from the Geograph Deutschland project

Hi. Is it possible to upload all Geograph Deutschland images since the last upload? The category [Category:Images from the Geograph Deutschland project] already exists. The Geograph Deutschland site contains many pictures which are useful for Wikipedia, all of them were uploaded under the CC BY-SA 2.0 licence. Would it even be possible to upload them from time to time automatically? --P170 (talk) 15:04, 17 September 2013 (UTC)

Wikidata links

Former and current regrettable neglecting of Wikimedia Commons in phase I of Wikidata causes the consistency more difficult to achieve. Because any fully-fledged solution is not foreseeable yet, we should work on comparation and completion of provisional interproject links. To do:

  • Go through all category pages and add the template(s) {{On Wikidata|<Qnumber>}} for all interwiki links to both Wikipedia articles and categories.
  • Export {{On Wikidata|<Qnumber>}} links as Property:P373 to the linked Wikidata items.
  • Go through all Wikidata items which contains the property Property:P373 and add the item number with the {{On Wikidata|<Qnumber>}} template to the linked Commons category.
  • Go through all Commons category pages which contain {{On Wikidata|<Qnumber>}} template and generate (update) the interwiki links. (Priority/concourse rules for multiple links should be approved previously.)

As soon as the direct connection between Commons and Wikidata will be activated, some of the steps will become redundant. --ŠJů (talk) 17:10, 28 September 2013 (UTC)

(Permanent) Maintenance Bot

In an ideal world I would have asked to setup a permanent maintenance Bot at Labs with multiple maintainers but it would be sufficient if we'd have at least one locally-operated Bot.

  • I have not seen a Bot fixing double redirects in at least file and gallery namespaces for a long time.
  • User:SchlurcherBot is currently inactive for most of the time because the operator has to rely on expensive mobile internet for some time so we need at least one Bot taking-over this important work. It should not be a problem to have two Bots doing this work if Schlurcher comes back online again.
  • I have recently found some galleries or image pages which used localized file prefixes (like Datei:) within gallery tags, may be worth checking. Although some may have come from Bot moves and missed by the Bot-move cleanup Bots.

--Denniss (talk) 09:24, 27 July 2013 (UTC)

I can try for those:
  • Any other namespaces? Hazard-SJ can do better in that since he can work with databases.
  • Would be hard to code.
  • Is there a list of File in other languages other than English? And is there an example for testing?
--Zhuyifei1999 (talk) 10:20, 27 July 2013 (UTC)
File:Rodgau Brunnen 10.jpg and File:Rodgau Skulptur 03.jpg use Bild: inside a gallery tag, I've also seen Datei: and Файл: ,File:Städtisches Stadion Reichsparteitagsgelände (5).jpg has multiple times Bild: inside a gallery tag. --Denniss (talk) 12:18, 27 July 2013 (UTC)
I had previously considered something similar in the past, yes, I could try these and more.  Hazard-SJ  ✈  23:33, 27 July 2013 (UTC)
So who's going to code them? --Zhuyifei1999 (talk) 04:14, 29 July 2013 (UTC)
Sorry for the delay here, User:タチコマ robot fixes double redirects. I'll be looking into the other issues.  Hazard-SJ  ✈  04:56, 28 August 2013 (UTC)
Okay, see Commons:Bots/Requests/Hazard-Bot 14.  Hazard SJ  02:47, 7 September 2013 (UTC)
For some unknown reason the task has not been approved yet. --Denniss (talk) 09:14, 10 October 2013 (UTC)
This section was archived on a request by: Zhuyifei1999 (talk) 01:55, 20 October 2013 (UTC)

Removing WLM category

This is my first time to request to create a bot, I don't know if you will permit the creation of a bot that will remove a template and/or category on 4,000+ uploads to Wiki Loves Monuments? Namayan (talk) 19:31, 26 September 2013 (UTC)

Please request at COM:BRFA, and let the 'crats to decide. This page is for requesting work(s) to be done by a bot. --Zhuyifei1999 (talk) 08:30, 27 September 2013 (UTC)
This section was archived on a request by: Zhuyifei1999 (talk) 09:13, 20 October 2013 (UTC)

Archive Bot User:MiszaBot down since a week

Probably due to the password issue this archival Bot is down and the operator has not been reached by mail yet. Any option for a temporary takeover (running several hours offset from the usual archival time of the original)? Or anyone knowing a better way to contact him? BTW this is another good/important bot that could use another (shared) maintainer. --Denniss (talk) 09:21, 10 October 2013 (UTC)

I can do it, but waiting for another bot approval and MiszaBot returns when the request is still open, that would be embarrassing. --Zhuyifei1999 (talk) 09:55, 10 October 2013 (UTC)
Always better to have a Bot in Reserve if the main Bot fails. Also the maintainer is currently more or less inactive and does not show interest or does not have time to update the Bot. He may not be able/willing to migrate it to Labs (assuming it runs on Toolserver). --Denniss (talk) 09:27, 11 October 2013 (UTC)
I offered to take this over on the English Wikipedia, some time ago, though other people jumped in on the task. However, I control a version of this on Wikidata, and I'm willing to take this up here as well. I noticed that FSV (Fastily's unflagged bot account) did some archiving, based on this task since MiszaBot has gone down, so I'm not sure if he'd like the task (I'll leave him a note, and if he does plan to take it up he'd need to use a account with a bot flag to access the nominornewtalk right), but if not, I'm still willing.  Hazard SJ  04:33, 18 October 2013 (UTC)
Go for it. I was planning to run the bot manually on an infrequent basis, but this is a much better alternative. I'll withdraw the BRFA if you agree. -FASTILY 07:11, 18 October 2013 (UTC)
OK, I've submitted a request.  Hazard SJ  00:54, 23 October 2013 (UTC)

MiszaBot seem have returned. --Zhuyifei1999 (talk) 12:00, 27 October 2013 (UTC)

This section was archived on a request by: Zhuyifei1999 (talk) 12:00, 27 October 2013 (UTC)

Template to cat

Hi, could you add {{Mediagrant|Odborná fotografie/Lom Vršany}} to all files in category:Vršany quarry? Thx.--Juandev (talk) 16:14, 14 October 2013 (UTC)

This can easily be done with Help:VisualFileChange.js. (prepend or append text) --McZusatz (talk) 16:48, 14 October 2013 (UTC)
✓ Done--Gabrielchihonglee (talk) 10:51, 15 October 2013 (UTC)
Please be careful when replacing. --Zhuyifei1999 (talk) 11:09, 15 October 2013 (UTC)
This section was archived on a request by: Zhuyifei1999 (talk) 09:13, 20 October 2013 (UTC)

Encoding error in bot uploads

There was an encoding issue in the NARA upload script that led "&" characters, which are allowed in file names, to be replaced with "^amp,". Example: File:Trackwomen, 1943. Baltimore ^amp, Ohio Railroad Company - NARA - 522888.tif. Would anyone be able to detect and batch-rename these? There may be a few hundred in Category:Media contributed by the National Archives and Records Administration, based on a wild guess. Dominic (talk) 22:01, 18 October 2013 (UTC)

I'd be happy to take a look at this over the weekend. I have a batch renaming script I can tweak and it would be pretty quick to run through the category. To double check, does this need to be "&" or do you think that using "and" might lead to better filenames? -- (talk) 22:21, 18 October 2013 (UTC)
Query
SELECT page.page_title
FROM categorylinks
INNER JOIN page
ON categorylinks.cl_from = page.page_id
WHERE cl_to = "Media_contributed_by_the_National_Archives_and_Records_Administration"
AND page_title LIKE "%^amp,%";
Result
MariaDB [commonswiki_p]> SELECT page.page_title FROM categorylinks INNER JOIN page ON categorylinks.cl_from = page.page_id WHERE cl_to = "Media_contributed_by_the_National_Archives_and_Records_Administration" AND page_title LIKE "%^amp,%";
+----------------------------------------------------------------------------------------------------------------------------------------------+
| page_title                                                                                                                                   |
+----------------------------------------------------------------------------------------------------------------------------------------------+
| The_Destruction_of_Tea_at_Boston_Harbor._1773._Copy_of_lithograph_by_Sarony_^amp,_Major,_1846.,_1931_-_1932_-_NARA_-_532892.tif              |
| The_Bostonian's_Paying_the_Excise-Man,_or_Tarring_^amp,_Feathering._Copy_of_mezzotint_attributed_to_Philip_Dawe,_1774.,_-_NARA_-_532889.tif  |
| Valley_Forge-Washington_^amp,_Lafayette._Winter_1777-78._Copy_of_engraving_by_H._B._Hall_after_Alonzo_Chappel.,_1931_-_1_-_NARA_-_532877.tif |
| The_Java_in_a_Sinking_state,_set_fire_to,_^amp,_Blowing_up._The_Constitution_at_a_distance..._repairing_her_Rigging_^amp_-_NARA_-_535742.tif |
| Storming_of_Independence_Hill_at_the_Battle_of_Monterey._September_1846._Copy_of_lithograph_by_Kelloggs_^amp,_Thayer,_ci_-_NARA_-_531095.tif |
| Storming_of_Monterey._Attack_on_the_Bishop's_Palace._September_1846._Copy_of_lithograph_by_Kelloggs_^amp,_Thayer,_circa_-_NARA_-_531093.tif  |
| View_of_Barracks_Number_1._or_View_of_Citadel_Looking_South-West._Fort_Morgan,_Alabama,_1864._Moses_^amp,_Piffet.,_1861_-_NARA_-_519389.tif  |
| President_Wilson_before_Congress,_announcing_the_break_in_the_official_relations_with_Germany._Harris_^amp,_Ewing.,_02-0_-_NARA_-_533722.tif |
| Riveter_at_work_at_Hog_Island_Shipyard._Pennsylvania,_1918._Kadel_^amp,_Herbert.,_1917_-_1919_-_NARA_-_533745.tif                            |
| Marjorie_Stinson,_only_woman_to_whom_a_pilot's_license_has_been_granted_by_Army_^amp,_Navy_Committee_of_Aeronautics...._-_NARA_-_533715.tif  |
| Trackwomen,_1943._Baltimore_^amp,_Ohio_Railroad_Company_-_NARA_-_522888.tif                                                                  |
| Mechanical_helper,_Baltimore_^amp,_Ohio_Railroad_-_NARA_-_522884.tif                                                                         |
| Letter_to_Superintendent_asking_for_advice_concerning_a_lawsuit_against_the_Denver_^amp,_Rio_Grande_Railroad._-_NARA_-_293316.tif            |
| Looking_out_7"_gun_port,_U.S.S._Pennsylvania._Navy_Bureau_of_Construction_^amp,_Repair._-_NARA_-_533691.tif                                  |
| Letter_of_Appreciation_from_Moore_^amp,_Scott_Iron_Works_to_Admiral_Goodrich_-_NARA_-_296768.tif                                             |
| Letter_of_Appreciation_from_A.P._Hotaling_^amp,_Co._to_Admiral_Goodrich_for_the_efforts_of_Lt._Freeman_and_his_men._-_NARA_-_296771.tif      |
| Statement_of_witnesses_that_Moy_Long_Lam_was_a_merchant_and_a_member_of_the_Boston_firm_of_Sun_Chung_Lung_^amp,_Co._-_NARA_-_278509.tif      |
| Topographical_Map_of_Memphis_and_Vicinity._Surveyed_^amp,_drawn_by_order_of_Maj._Genl._W._T._Sherman_under_the..._-_NARA_-_305792.tif        |
| Map_of_the_Battlefield_of_Bull_Run,_August_29th_^amp,_30th,_1862._Surveyed_by_order_of_Maj._Gen._Sigel_and_under..._-_NARA_-_305590.tif      |
| Positions_of_Humphreys'_Division,_Battle_of_Fredericksburg,_Decr._13th...(and)_Decr._14th,_15th_^amp,_16th,_1862._-_NARA_-_305592.tif        |
| Manufacturing_spiral_puttees_at_plant_of_Alexander_Propper_^amp,_Company,_New_York_City._Preparing_the_puttees_for..._-_NARA_-_533756.tif    |
| Plan_of_the_Town_of_Orange_C._H._Showing_Roads_^amp,c._constructed_therein_during_the_winter_of_1863,_'64._(Compiled)..._-_NARA_-_305700.tif |
| Map_of_the_Shenandoah_^amp,_Upper_Potomac_Including_Portions_of_Virginia,_(West_Virginia),_and_Maryland._Compiled..._-_NARA_-_305597.tif     |
| Sketch_of_the_Site_of_the_O(pe)rations_of_the_10th,_11th,_^amp,_12th,_July_1861,_at_Rich_Mountain_near_Beverly..._-_NARA_-_305586.tif        |
| South_Vietnam....Loretta_Clause_plays_cards,_talks,_etc.,_with_Marines_of_H^amp,S,_1st_Marine_Division._She_is_a..._-_NARA_-_532478.tif      |
| NYA-Arizona-"colored_boys_attending_WPA_household_workers_training_center(WPA_Divisiion_of_Employment_^amp,_U.S.E.S...._-_NARA_-_195373.tif  |
| Map_of_Pilot_Knob,_Mo.,_and_Vicinity._Wm._Hoelcke,_Captn._^amp,_Addl._A._de_C._-_NARA_-_305779.jpg                                           |
| Map_of_Blakely_and_Vicinity._Showing_the_disposition_of_the_2nd_Division,_13th_Army_Corps,_during_the_siege_^amp,_and..._-_NARA_-_305627.jpg |
| Plan_of_the_Position_at_Iuka,_Tishamingo_Co.,_Miss._Surveyed_^amp,_drawn_by_Ch._Spangenberg,_Assistant_Engr.,_Septbr...._-_NARA_-_305676.jpg |
| Map_of_Tishomingo_County,_Mississippi._Compiled_under_the_Direction_of_Col._George_Thom,_A.D.C._^amp,_Chief_of_Topl...._-_NARA_-_305725.jpg  |
| Military_Map_of_Cape_Girardeau,_Mo.,_and_Vicinity,_Showing_the_location_of_the_Forts._Wm._Hoelcke,_Captn._^amp,_Addl...._-_NARA_-_305778.jpg |
| Map_of_Jefferson_City,_Mo.,_and_Vicinity,_showing_the_line_of_defenses._Wm._Hoelcke,_Captn._^amp,_Addl._A._de._C...._-_NARA_-_305777.jpg     |
| Map_of_New_Madrid,_Mo.,_and_Vicinity,_showing_the_position_of_the_fortifications._Surveyed_^amp,_drawn_by_Louis..._-_NARA_-_305776.jpg       |
| Map_Showing_the_Route_of_the_Army_During_the_Red_River_Campaign_in_the_Spring_of_1864._Surveys_^amp,_Reconnoissances..._-_NARA_-_305633.jpg  |
| Old_Capitol_Prison_and_Carrol_Branch_Prison,_Capitol_Hill,_1st_Street_East,_between_A._Str._Sth._^amp,_A_Str._Nth...._-_NARA_-_305821.jpg    |
| Wrangell_Harbor,_Alaska._Wrangell_Ice_^amp,_Storage_Co._dock_-_NARA_-_298727.jpg                                                             |
| Map_of_the_Battlefield_of_Wilson's_Creek,_Mo._Wm._Hoelcke,_Captain_^amp,_Addl._A._de._C.,_U.S.A.,_Chief_Eng...._-_NARA_-_305668.jpg          |
| Young_cigarmakers_in_Engelhardt_^amp,_Co._Three_boys_looked_under_14._Work_was_slack_and_youngsters_were_not_being..._-_NARA_-_523163.jpg    |
| No_caption._Three_young_boys_with_shovels_standing_in_doorway_of_a_Fort_Worth_^amp,_Denver_train_car._-_NARA_-_523335.jpg                    |
| Personnel_of_VB104_^amp,_VB106_gather_around_Chief_Yeoman_Willis_to_receive_their_mail_on_Munda,_New_Georgia_Island._-_NARA_-_520909.jpg     |
| Grand_Review,_1865._Washington,_showing_reviewing_stand_with_Gen._Grant,_^amp,_Pres._Johnson_^amp,_Cabinet._-_NARA_-_524473.jpg              |
| Scene_on_O._^amp,_A._R._R._near_Union_Mills,_Va_-_NARA_-_524605.jpg                                                                          |
| Plan_of_Intrenchments_^amp,_Vicinity_west_of_^amp,_near_Beaufort,_S.C.,_Office_of_Topographical_Corps,_N.Y._Vol...._-_NARA_-_305620.jpg      |
| Route_of_the_Expedition,_Oct._22nd,_1862,_with_the_Battle_grounds_of_Pocotaligo_^amp,_Coosawhatchie._Prepared_form..._-_NARA_-_305618.jpg    |
| Repairing_railroad,_Cattletts_Station,_on_O.^amp,_A._R.R_-_NARA_-_524817.jpg                                                                 |
| Scene_on_the_Orange_and_Alexandria_(O._^amp,_A.)_R.R._near_Union_Mills._-_NARA_-_524855.jpg                                                  |
| View_along_railroad_(O._^amp,_A._R.R.),_Manassas_Junction_-_NARA_-_526146.jpg                                                                |
| MAGAZINES_AND_NEWSPAPERS_LITTER_THE_INTERSECTION_OF_SIXTH_^amp,_BROADWAY_AFTER_DEBRIS_WAS_SPILLED_FROM_A_PASSING_TRUCK_-_NARA_-_543886.jpg   |
| MAGAZINES_AND_NEWSPAPERS_LITTER_THE_INTERSECTION_OF_SIXTH_^amp,_BROADWAY_AFTER_DEBRIS_WAS_SPILLED_FROM_A_PASSING_TRUCK_-_NARA_-_543890.jpg   |
| OF_THE_TROOPS_^amp,_FOR_THE_TROOPS._MILITARY_POLICE_-_NARA_-_515099.jpg                                                                      |
| Man_with_a_derby_hat_stands_atop_a_mound_of_oyster_shells_outside_the_C.H._Pearson_^amp,_Company_oyster_cannery,_ca._189_-_NARA_-_513080.jpg |
| Samuel_Clemens_on_the_left,_^amp,_possibly_Gen._Thomas_Williams_-_NARA_-_529038.jpg                                                          |
| View_of_Chattanooga_^amp,_Lookout_Mountain,_Tenn_-_NARA_-_530185.jpg                                                                         |
| U.S._vs._Julius_^amp,_Ethel_Rosenberg_and_Martin_Sobell,_Government_Exhibit_3,_photograph_of_Mike_and_Anne_Sidorovich_-_NARA_-_278748.jpg    |
| U.S._vs._Julius_^amp,_Ethel_Rosenberg_and_Martin_Sobell,_Government_Exhibit_5,_photograph_of_Harry_Gold_-_NARA_-_278750.jpg                  |
| U.S._vs._Julius_^amp,_Ethel_Rosenberg_and_Martin_Sobell,_Government_Exhibit_6,_Lens_Mold_Sketch_-_NARA_-_278751.jpg                          |
| U.S._vs._Julius_^amp,_Ethel_Rosenberg_and_Martin_Sobell,_Government_Exhibit_7,_sketch_of_setup_to_implode_tubular..._-_NARA_-_278752.jpg     |
| U.S._vs._Julius_^amp,_Ethel_Rosenberg_and_Martin_Sobell,_Government_Exhibit_10,_brown_paper_wrapper_which_contained..._-_NARA_-_278755.jpg   |
| U.S._vs._Julius_^amp,_Ethel_Rosenberg_and_Martin_Sobell,_Government_Exhibit_11,_Photograph_of_Anatoli_A._Yokovlev_-_NARA_-_278756.jpg        |
| U.S._vs._Julius_^amp,_Ethel_Rosenberg_and_Martin_Sobell,_Government_Exhibit_12,_Photograph_of_Klaus_Fuchs_-_NARA_-_278757.jpg                |
| U.S._vs._Julius_^amp,_Ethel_Rosenberg_and_Martin_Sobell,_Government_Exhibit_25_and_25A,_Certified_copy_and..._-_NARA_-_278769.jpg            |
| U.S._vs._Julius_^amp,_Ethel_Rosenberg_and_Martin_Sobell,_Government_Exhibit_28,_Picture_of_a_console_table_-_NARA_-_278771.jpg               |
| U.S._vs._Julius_^amp,_Ethel_Rosenberg_and_Martin_Sobell,_Government_Exhibit_31,_Nominating_Petition_for_Councilman_-_NARA_-_278772.jpg       |
| U.S._vs._Julius_^amp,_Ethel_Rosenberg_and_Martin_Sobell,_Government_Exhibit_32,_Photograph_of_the_studio_of..._-_NARA_-_278773.jpg           |
| Slave_pen_of_Price,_Birch_^amp,_Co.,_Alexandria,_Va_-_NARA_-_528808.jpg                                                                      |
| REAR_OF_LORD_^amp,_JEALOUS_WOOL_MILL_AT_CITY_MILLS,_INDUSTRIAL_TOWN_ON_THE_CHARLES_RIVER_-_NARA_-_550008.jpg                                 |
| Type_of_Bulls_on_the_Burns_C^amp,H_Range,_Myrtle_Park,_Maheur_Forest,_1917._-_NARA_-_299137.jpg                                              |
| Timberline_Lodge_^amp,_Ski_Area_-_NARA_-_299098.jpg                                                                                          |
| Ledo_^amp,_Burma_Roads._Assam,_Burma,_China._1944-45_-_NARA_-_292561.jpg                                                                     |
| TIMBER_LINE_BAR_^amp,_RESTAURANT_ON_SNOWMASS_MOUNTAIN_-_NARA_-_554237.jpg                                                                    |
| THE_YOUNG_WAITRESS_AT_THE_LOCAL_A^amp,W_SNACK_BAR_IS_SAVING_HER_EARNINGS_FOR_OUT-OF-TOWN_SCHOOLING_-_NARA_-_552614.jpg                       |
| Sears,_Roebuck_^amp,_Company_-_NARA_-_279897.jpg                                                                                             |
| Waterfront_at_flood_stage,_businesses_shown_are_Marquette_Cement,_S._Karchmer_^amp,_Company,_Clyde_C._Reed_Machinery..._-_NARA_-_279848.jpg  |
| Jennings,_Al_^amp,_Son,_Rolling_Store_-_NARA_-_280629.jpg                                                                                    |
| Louisville_^amp,_Nashville_railraod_bridge_at_Big_Sandy_River_-_NARA_-_280686.jpg                                                            |
| Panorama_of_dumps_at_Allice_^amp,_Magna_Carta_Mines,_Walkerville,_Montana_-_NARA_-_298146.jpg                                                |
| Rock_bunkers_and_Lewis_^amp,_Clark_River,_and_clam_shell_unloading_barge._-_NARA_-_298262.jpg                                                |
| View_of_dock_at_Leper_Settlement_looking_West._Range_light_green_^amp,_white_are_shwin_on_this_dock_when_steamer_is..._-_NARA_-_296070.jpg   |
| Photograph,_California_no._8,_Oakland_May_23,_1940,_Writers_Project,_and_centers_for_other_P_^amp,_S_projects...._-_NARA_-_296093.jpg        |
| Two_More_P_^amp,_W_Men_Honored_For_Individual_Production_Merit_-_NARA_-_533859.jpg                                                           |
| Warner_^amp,_Swasey_Workers_who_Have_Aided_with_Ideas_of_Victory_-_NARA_-_534239.jpg                                                         |
| We'll_Keep_It_Flying^_Army_^amp,_Navy_-_NARA_-_534376.jpg                                                                                    |
| Let's_Shoot_For_the_Stars^_On_our_Pennant._Army_^amp,_Navy_-_NARA_-_534378.jpg                                                               |
| Work_^amp,_Sweat_for_Victory_-_NARA_-_534397.jpg                                                                                             |
| Midwest_is_Backing_You_On_land_On_sea_^amp,_in_the_Air_-_NARA_-_534609.jpg                                                                   |
| Pratt_^amp,_Whitney-powered_"Marauder"_on_Tunisian_Front_-_NARA_-_534618.jpg                                                                 |
| Work_^amp,_sweat_for_victory^_-_NARA_-_534898.jpg                                                                                            |
| Spies,_saboteurs,_"meatleggers"_^amp,_hoarders._There_isn't_any_great_difference._They're_all_helping_the_enemy._Be..._-_NARA_-_535194.jpg   |
| Scraphappy_Dan_the_slambang_man_piles_tote_boxes_^amp,_smashes_parts._Tell_him_to_cut_it_out^_-_NARA_-_535324.jpg                            |
| Presenting_Elmer_^amp,_Elsie_Alcoa._Watch_for_us._Our_part_in_the_war_effort_will_be_teaching_you_the_safe_way._-_NARA_-_535363.jpg          |
| Rohwer_Relocation_Center,_McGehee,_Arkansas._Mrs._Jeanette_Iwatski_^amp,_Miss_Michike_Kabashima,_teache_._._._-_NARA_-_538954.jpg            |
| Ready_to_make_a_shipment_of_pineapples_to_Hitler,_Hirohito_^amp,Colorado._An_infantryman_at_Fort_Belvoir,_Va.,_holds..._-_NARA_-_196463.jpg  |
| WWII,_Europe,_Near_Toulon,_France,_"Weapons_^amp,_Fortificcations_-_Long_Range_Naval_Gun"_-_NARA_-_195329.jpg                                |
| MOUNTAIN_RANGE_NEAR_CASTLE_VALLEY_^amp,_FICH_LAKE,_ALTITUDE_11575_FEET_ABOVE_SNOW_LINE_FROM_VOLCANIC_PEAK,_WASATCH..._-_NARA_-_523953.jpg    |
| YELLOW_PINE,_TIMBER_TREE_OF_HIGH_PLATEAUS_IN_UTAH,_ARIZONA_^amp,_NEW_MEXICO,_COLORADO_RIVER_-_NARA_-_524009.jpg                              |
| SHOSHONE_FALLS,_SNAKE_RIVER,_IDAHO,_LOOKING_THROUGH_THE_TIMBER_^amp,_SHOWING_THE_MAIN_FALL_^amp,_UPPER_OR_"LACE_FALLS"_-_NARA_-_524083.jpg   |
| GROUP_OF_OFFICERS_^amp,_ASSISTANTS_AT_RENDEZVOUS_CAMP_NEAR_BELMONT,_NEVADA_-_NARA_-_524125.jpg                                               |
| MILL_^amp,_OFFICE,_HYKO_SILVER_MINING_COMPANY,_HYKO,_NEVADA_-_NARA_-_524138.jpg                                                              |
| HEAD_OF_CANYON,_COLORADO_^amp,_PARIA_RIVERS_-_NARA_-_524218.jpg                                                                              |
| PANORAMIC_-_CANYON_OF_COLORADO_^amp,_PARIA_-_NARA_-_524222.jpg                                                                               |
| SIDE_OF_CANYON_^amp,_JUNCTION_OF_COLORADO_^amp,_PARIA_RIVERS_-_NARA_-_524224.jpg                                                             |
+----------------------------------------------------------------------------------------------------------------------------------------------+
101 rows in set (0.46 sec)
Convenient links
  1. File:The Destruction of Tea at Boston Harbor. 1773. Copy of lithograph by Sarony ^amp, Major, 1846., 1931 - 1932 - NARA - 532892.tif
  2. File:The Bostonian's Paying the Excise-Man, or Tarring ^amp, Feathering. Copy of mezzotint attributed to Philip Dawe, 1774., - NARA - 532889.tif
  3. File:Valley Forge-Washington ^amp, Lafayette. Winter 1777-78. Copy of engraving by H. B. Hall after Alonzo Chappel., 1931 - 1 - NARA - 532877.tif
  4. File:The Java in a Sinking state, set fire to, ^amp, Blowing up. The Constitution at a distance... repairing her Rigging ^amp - NARA - 535742.tif
  5. File:Storming of Independence Hill at the Battle of Monterey. September 1846. Copy of lithograph by Kelloggs ^amp, Thayer, ci - NARA - 531095.tif
  6. File:Storming of Monterey. Attack on the Bishop's Palace. September 1846. Copy of lithograph by Kelloggs ^amp, Thayer, circa - NARA - 531093.tif
  7. File:View of Barracks Number 1. or View of Citadel Looking South-West. Fort Morgan, Alabama, 1864. Moses ^amp, Piffet., 1861 - NARA - 519389.tif
  8. File:President Wilson before Congress, announcing the break in the official relations with Germany. Harris ^amp, Ewing., 02-0 - NARA - 533722.tif
  9. File:Riveter at work at Hog Island Shipyard. Pennsylvania, 1918. Kadel ^amp, Herbert., 1917 - 1919 - NARA - 533745.tif
  10. File:Marjorie Stinson, only woman to whom a pilot's license has been granted by Army ^amp, Navy Committee of Aeronautics.... - NARA - 533715.tif
  11. File:Trackwomen, 1943. Baltimore ^amp, Ohio Railroad Company - NARA - 522888.tif
  12. File:Mechanical helper, Baltimore ^amp, Ohio Railroad - NARA - 522884.tif
  13. File:Letter to Superintendent asking for advice concerning a lawsuit against the Denver ^amp, Rio Grande Railroad. - NARA - 293316.tif
  14. File:Looking out 7" gun port, U.S.S. Pennsylvania. Navy Bureau of Construction ^amp, Repair. - NARA - 533691.tif
  15. File:Letter of Appreciation from Moore ^amp, Scott Iron Works to Admiral Goodrich - NARA - 296768.tif
  16. File:Letter of Appreciation from A.P. Hotaling ^amp, Co. to Admiral Goodrich for the efforts of Lt. Freeman and his men. - NARA - 296771.tif
  17. File:Statement of witnesses that Moy Long Lam was a merchant and a member of the Boston firm of Sun Chung Lung ^amp, Co. - NARA - 278509.tif
  18. File:Topographical Map of Memphis and Vicinity. Surveyed ^amp, drawn by order of Maj. Genl. W. T. Sherman under the... - NARA - 305792.tif
  19. File:Map of the Battlefield of Bull Run, August 29th ^amp, 30th, 1862. Surveyed by order of Maj. Gen. Sigel and under... - NARA - 305590.tif
  20. File:Positions of Humphreys' Division, Battle of Fredericksburg, Decr. 13th...(and) Decr. 14th, 15th ^amp, 16th, 1862. - NARA - 305592.tif
  21. File:Manufacturing spiral puttees at plant of Alexander Propper ^amp, Company, New York City. Preparing the puttees for... - NARA - 533756.tif
  22. File:Plan of the Town of Orange C. H. Showing Roads ^amp,c. constructed therein during the winter of 1863, '64. (Compiled)... - NARA - 305700.tif
  23. File:Map of the Shenandoah ^amp, Upper Potomac Including Portions of Virginia, (West Virginia), and Maryland. Compiled... - NARA - 305597.tif
  24. File:Sketch of the Site of the O(pe)rations of the 10th, 11th, ^amp, 12th, July 1861, at Rich Mountain near Beverly... - NARA - 305586.tif
  25. File:South Vietnam....Loretta Clause plays cards, talks, etc., with Marines of H^amp,S, 1st Marine Division. She is a... - NARA - 532478.tif
  26. File:NYA-Arizona-"colored boys attending WPA household workers training center(WPA Divisiion of Employment ^amp, U.S.E.S.... - NARA - 195373.tif
  27. File:Map of Pilot Knob, Mo., and Vicinity. Wm. Hoelcke, Captn. ^amp, Addl. A. de C. - NARA - 305779.jpg
  28. File:Map of Blakely and Vicinity. Showing the disposition of the 2nd Division, 13th Army Corps, during the siege ^amp, and... - NARA - 305627.jpg
  29. File:Plan of the Position at Iuka, Tishamingo Co., Miss. Surveyed ^amp, drawn by Ch. Spangenberg, Assistant Engr., Septbr.... - NARA - 305676.jpg
  30. File:Map of Tishomingo County, Mississippi. Compiled under the Direction of Col. George Thom, A.D.C. ^amp, Chief of Topl.... - NARA - 305725.jpg
  31. File:Military Map of Cape Girardeau, Mo., and Vicinity, Showing the location of the Forts. Wm. Hoelcke, Captn. ^amp, Addl.... - NARA - 305778.jpg
  32. File:Map of Jefferson City, Mo., and Vicinity, showing the line of defenses. Wm. Hoelcke, Captn. ^amp, Addl. A. de. C.... - NARA - 305777.jpg
  33. File:Map of New Madrid, Mo., and Vicinity, showing the position of the fortifications. Surveyed ^amp, drawn by Louis... - NARA - 305776.jpg
  34. File:Map Showing the Route of the Army During the Red River Campaign in the Spring of 1864. Surveys ^amp, Reconnoissances... - NARA - 305633.jpg
  35. File:Old Capitol Prison and Carrol Branch Prison, Capitol Hill, 1st Street East, between A. Str. Sth. ^amp, A Str. Nth.... - NARA - 305821.jpg
  36. File:Wrangell Harbor, Alaska. Wrangell Ice ^amp, Storage Co. dock - NARA - 298727.jpg
  37. File:Map of the Battlefield of Wilson's Creek, Mo. Wm. Hoelcke, Captain ^amp, Addl. A. de. C., U.S.A., Chief Eng.... - NARA - 305668.jpg
  38. File:Young cigarmakers in Engelhardt ^amp, Co. Three boys looked under 14. Work was slack and youngsters were not being... - NARA - 523163.jpg
  39. File:No caption. Three young boys with shovels standing in doorway of a Fort Worth ^amp, Denver train car. - NARA - 523335.jpg
  40. File:Personnel of VB104 ^amp, VB106 gather around Chief Yeoman Willis to receive their mail on Munda, New Georgia Island. - NARA - 520909.jpg
  41. File:Grand Review, 1865. Washington, showing reviewing stand with Gen. Grant, ^amp, Pres. Johnson ^amp, Cabinet. - NARA - 524473.jpg
  42. File:Scene on O. ^amp, A. R. R. near Union Mills, Va - NARA - 524605.jpg
  43. File:Plan of Intrenchments ^amp, Vicinity west of ^amp, near Beaufort, S.C., Office of Topographical Corps, N.Y. Vol.... - NARA - 305620.jpg
  44. File:Route of the Expedition, Oct. 22nd, 1862, with the Battle grounds of Pocotaligo ^amp, Coosawhatchie. Prepared form... - NARA - 305618.jpg
  45. File:Repairing railroad, Cattletts Station, on O.^amp, A. R.R - NARA - 524817.jpg
  46. File:Scene on the Orange and Alexandria (O. ^amp, A.) R.R. near Union Mills. - NARA - 524855.jpg
  47. File:View along railroad (O. ^amp, A. R.R.), Manassas Junction - NARA - 526146.jpg
  48. File:MAGAZINES AND NEWSPAPERS LITTER THE INTERSECTION OF SIXTH ^amp, BROADWAY AFTER DEBRIS WAS SPILLED FROM A PASSING TRUCK - NARA - 543886.jpg
  49. File:MAGAZINES AND NEWSPAPERS LITTER THE INTERSECTION OF SIXTH ^amp, BROADWAY AFTER DEBRIS WAS SPILLED FROM A PASSING TRUCK - NARA - 543890.jpg
  50. File:OF THE TROOPS ^amp, FOR THE TROOPS. MILITARY POLICE - NARA - 515099.jpg
  51. File:Man with a derby hat stands atop a mound of oyster shells outside the C.H. Pearson ^amp, Company oyster cannery, ca. 189 - NARA - 513080.jpg
  52. File:Samuel Clemens on the left, ^amp, possibly Gen. Thomas Williams - NARA - 529038.jpg
  53. File:View of Chattanooga ^amp, Lookout Mountain, Tenn - NARA - 530185.jpg
  54. File:U.S. vs. Julius ^amp, Ethel Rosenberg and Martin Sobell, Government Exhibit 3, photograph of Mike and Anne Sidorovich - NARA - 278748.jpg
  55. File:U.S. vs. Julius ^amp, Ethel Rosenberg and Martin Sobell, Government Exhibit 5, photograph of Harry Gold - NARA - 278750.jpg
  56. File:U.S. vs. Julius ^amp, Ethel Rosenberg and Martin Sobell, Government Exhibit 6, Lens Mold Sketch - NARA - 278751.jpg
  57. File:U.S. vs. Julius ^amp, Ethel Rosenberg and Martin Sobell, Government Exhibit 7, sketch of setup to implode tubular... - NARA - 278752.jpg
  58. File:U.S. vs. Julius ^amp, Ethel Rosenberg and Martin Sobell, Government Exhibit 10, brown paper wrapper which contained... - NARA - 278755.jpg
  59. File:U.S. vs. Julius ^amp, Ethel Rosenberg and Martin Sobell, Government Exhibit 11, Photograph of Anatoli A. Yokovlev - NARA - 278756.jpg
  60. File:U.S. vs. Julius ^amp, Ethel Rosenberg and Martin Sobell, Government Exhibit 12, Photograph of Klaus Fuchs - NARA - 278757.jpg
  61. File:U.S. vs. Julius ^amp, Ethel Rosenberg and Martin Sobell, Government Exhibit 25 and 25A, Certified copy and... - NARA - 278769.jpg
  62. File:U.S. vs. Julius ^amp, Ethel Rosenberg and Martin Sobell, Government Exhibit 28, Picture of a console table - NARA - 278771.jpg
  63. File:U.S. vs. Julius ^amp, Ethel Rosenberg and Martin Sobell, Government Exhibit 31, Nominating Petition for Councilman - NARA - 278772.jpg
  64. File:U.S. vs. Julius ^amp, Ethel Rosenberg and Martin Sobell, Government Exhibit 32, Photograph of the studio of... - NARA - 278773.jpg
  65. File:Slave pen of Price, Birch ^amp, Co., Alexandria, Va - NARA - 528808.jpg
  66. File:REAR OF LORD ^amp, JEALOUS WOOL MILL AT CITY MILLS, INDUSTRIAL TOWN ON THE CHARLES RIVER - NARA - 550008.jpg
  67. File:Type of Bulls on the Burns C^amp,H Range, Myrtle Park, Maheur Forest, 1917. - NARA - 299137.jpg
  68. File:Timberline Lodge ^amp, Ski Area - NARA - 299098.jpg
  69. File:Ledo ^amp, Burma Roads. Assam, Burma, China. 1944-45 - NARA - 292561.jpg
  70. File:TIMBER LINE BAR ^amp, RESTAURANT ON SNOWMASS MOUNTAIN - NARA - 554237.jpg
  71. File:THE YOUNG WAITRESS AT THE LOCAL A^amp,W SNACK BAR IS SAVING HER EARNINGS FOR OUT-OF-TOWN SCHOOLING - NARA - 552614.jpg
  72. File:Sears, Roebuck ^amp, Company - NARA - 279897.jpg
  73. File:Waterfront at flood stage, businesses shown are Marquette Cement, S. Karchmer ^amp, Company, Clyde C. Reed Machinery... - NARA - 279848.jpg
  74. File:Jennings, Al ^amp, Son, Rolling Store - NARA - 280629.jpg
  75. File:Louisville ^amp, Nashville railraod bridge at Big Sandy River - NARA - 280686.jpg
  76. File:Panorama of dumps at Allice ^amp, Magna Carta Mines, Walkerville, Montana - NARA - 298146.jpg
  77. File:Rock bunkers and Lewis ^amp, Clark River, and clam shell unloading barge. - NARA - 298262.jpg
  78. File:View of dock at Leper Settlement looking West. Range light green ^amp, white are shwin on this dock when steamer is... - NARA - 296070.jpg
  79. File:Photograph, California no. 8, Oakland May 23, 1940, Writers Project, and centers for other P ^amp, S projects.... - NARA - 296093.jpg
  80. File:Two More P ^amp, W Men Honored For Individual Production Merit - NARA - 533859.jpg
  81. File:Warner ^amp, Swasey Workers who Have Aided with Ideas of Victory - NARA - 534239.jpg
  82. File:We'll Keep It Flying^ Army ^amp, Navy - NARA - 534376.jpg
  83. File:Let's Shoot For the Stars^ On our Pennant. Army ^amp, Navy - NARA - 534378.jpg
  84. File:Work ^amp, Sweat for Victory - NARA - 534397.jpg
  85. File:Midwest is Backing You On land On sea ^amp, in the Air - NARA - 534609.jpg
  86. File:Pratt ^amp, Whitney-powered "Marauder" on Tunisian Front - NARA - 534618.jpg
  87. File:Work ^amp, sweat for victory^ - NARA - 534898.jpg
  88. File:Spies, saboteurs, "meatleggers" ^amp, hoarders. There isn't any great difference. They're all helping the enemy. Be... - NARA - 535194.jpg
  89. File:Scraphappy Dan the slambang man piles tote boxes ^amp, smashes parts. Tell him to cut it out^ - NARA - 535324.jpg
  90. File:Presenting Elmer ^amp, Elsie Alcoa. Watch for us. Our part in the war effort will be teaching you the safe way. - NARA - 535363.jpg
  91. File:Rohwer Relocation Center, McGehee, Arkansas. Mrs. Jeanette Iwatski ^amp, Miss Michike Kabashima, teache . . . - NARA - 538954.jpg
  92. File:Ready to make a shipment of pineapples to Hitler, Hirohito ^amp,Colorado. An infantryman at Fort Belvoir, Va., holds... - NARA - 196463.jpg
  93. File:WWII, Europe, Near Toulon, France, "Weapons ^amp, Fortificcations - Long Range Naval Gun" - NARA - 195329.jpg
  94. File:MOUNTAIN RANGE NEAR CASTLE VALLEY ^amp, FICH LAKE, ALTITUDE 11575 FEET ABOVE SNOW LINE FROM VOLCANIC PEAK, WASATCH... - NARA - 523953.jpg
  95. File:YELLOW PINE, TIMBER TREE OF HIGH PLATEAUS IN UTAH, ARIZONA ^amp, NEW MEXICO, COLORADO RIVER - NARA - 524009.jpg
  96. File:SHOSHONE FALLS, SNAKE RIVER, IDAHO, LOOKING THROUGH THE TIMBER ^amp, SHOWING THE MAIN FALL ^amp, UPPER OR "LACE FALLS" - NARA - 524083.jpg
  97. File:GROUP OF OFFICERS ^amp, ASSISTANTS AT RENDEZVOUS CAMP NEAR BELMONT, NEVADA - NARA - 524125.jpg
  98. File:MILL ^amp, OFFICE, HYKO SILVER MINING COMPANY, HYKO, NEVADA - NARA - 524138.jpg
  99. File:HEAD OF CANYON, COLORADO ^amp, PARIA RIVERS - NARA - 524218.jpg
  100. File:PANORAMIC - CANYON OF COLORADO ^amp, PARIA - NARA - 524222.jpg
  101. File:SIDE OF CANYON ^amp, JUNCTION OF COLORADO ^amp, PARIA RIVERS - NARA - 524224.jpg

--Zhuyifei1999 (talk) 09:50, 19 October 2013 (UTC)

✓ Done 367 files were renamed. -- (talk) 10:29, 19 October 2013 (UTC)

Thanks so much! Yes, "&" was preferred, since that comes from the archivist's original description. Dominic (talk) 13:53, 21 October 2013 (UTC)
This section was archived on a request by: Zhuyifei1999 (talk) 09:13, 20 October 2013 (UTC)

Unvisible controll characters in category tags

When copying the category name and creating the category tag, an unvisible controll character at the bottom of the tag is often inadvertently intruded (see an example). (Recently identified as char code 8206 (a Left-to-right mark), Substitute character, U+200E, see this (19 June 2012) and this (7 May 2013) report.) Such error is not visible for users and the page is really displayed in the category but some scripts or bots are not able to deal with such category tags (e.g. Cat-a-lot is not able to remove or change such a category tag and give a message "The following pages were skipped, because the old category could not be found:…"). We need:

  • to check and clean all category tags on all pages
  • to prevent an insert of such unvisible character when it is unwanted (remove it when saving, warning messages or tags etc.) --ŠJů (talk) 11:01, 6 October 2013 (UTC)

Picture of the Day to ko.wiki

Hello, I'm from Korean Wikipedia and now I'm admin in this Wikipedia. In our community, we use same picture as COM:POTD to ko:위키백과:오늘의 그림. However, the bot which copies English/Korean caption from Template:Potd is often inactive these days. Can somebody please operate a bot that copies the picture and English & Korean caption to Korean Wikipedia every month?

For example in April, 2024:

Inside each sub-document, there are {{오늘의 그림 목록}}. But don't edit this template to add picture and caption for each month - just change the document that I've mentioned above and you can see there are d1~d31 variable for each day. Add the picture and caption at the proper variable. --관인생략 (talk) 05:12, 31 October 2013 (UTC)

Why not let a ko.wiki bot operator do this? IMO they're more familier with templates on ko.wiki. --Zhuyifei1999 (talk) 08:49, 31 October 2013 (UTC)
The bot operator, User:ChongDae was the only one who operates the bot with harsh work consistently. I think that this job is quite relevant with Commons, and our community is too small to have steady bot operation. --관인생략 (talk) 09:54, 31 October 2013 (UTC)
 Doing… but I don't speak Korean. --Zhuyifei1999 (talk) 10:17, 31 October 2013 (UTC)
ko:위키백과:봇/등록_신청/YiFeiBot --Zhuyifei1999 (talk) 13:15, 31 October 2013 (UTC)
This section was archived on a request by: Zhuyifei1999 (talk) 13:15, 31 October 2013 (UTC)

Tab characters in monument templates

When checking wrong monument identifiers in {{Cultural Heritage Czech Republic}} with [1], i found an often error that many users copied any white character (probably tab character) into the parameter of the monument template and some tools are not able to recognize the identifier. Could somebody permanently check all monument templates in order to remove all unwanted white characters? In case of the Czech template, also internal spaces (especially " / " replace with "/") and all letters should be removed (the ID should contain only digits, "/" and "-". Could be created some prevent or warning system against wrong entries? --ŠJů (talk) 11:44, 7 October 2013 (UTC)

Massive reading of Dutch words: Dutch pronuciation

I'm busy reading ALL the dutch words of the dutch Wiktionary

- the reading is much simplified with help of the shtooka program. - the uploading is much simplified with help of the Commonist program.

There are two quit time consuming tasks left over wich maby could be simplified by an automated procedure / Bot

  • a lot of the dutch words start with (but not all)

{{audio|nl-{{pn}}.ogg|{{pn}}}}'')

question: is there an easy way to fill ALL the dutch words with '{{audio|nl-{{pn}}.ogg|{{pn}}}}'')


  • the audiofiles are categorized with the category Dutch pronunciation

most of the words in Dutch pronunciation have this sentence: [[Category:Dutch pronunciation|aagje]] (aagje is the name of the word) for a good ordering of the list Dutch pronunciation it is neccessary to complete the category with |(name of the word) The file name is: File:Nl-xxxxx.ogg xxxxx is the name of the word.

queston is there an easy way to fill ALL de audiofile in Dutch pronuncion with the sequenze |(name of the word)

Maybe somebody can help

Greetings Marcel coenders

https://commons.wikimedia.org/wiki/User_talk:Marcel_coenders


  • The first bot request actually belongs at nl.wiktionary, sorry about posting this here at Commons. The request is about adding text to pages at nl.wiktionary: all Dutch words at nl.wikt should have a link to the corresponding word pronunciation file at Commons. E.g. the Dutch word blank should have an audio link to File:Nl-blank.ogg . DifoolBot is taking care of this at nl.wikt (e.g. [2]). No further action at Commons is needed.
  • The second bot request is about sorting the files that are in Category:Dutch pronunciation. The pronunciation files are all in the format File:Nl-XYZ.ogg, and need a category sortkey added: [[Category:Dutch pronunciation|XYZ]]. Examples:
    Could a bot do this for all files in Category:Dutch pronunciation that don't have a sortkey yet? User Marcel coenders is creating and uploading many (thousands!) of word pronunciation files for us, and adding the sortkey manually would take a lot of time. Thanks in advance. -- 2Curious (talk) 21:51, 28 October 2013 (UTC) (= User:Curious at nl.wikt)
What about files like File:Nl-- meer.ogg and File:Nl--aal.ogg? --Zhuyifei1999 (talk) 09:15, 29 October 2013 (UTC)
 Coding... --Zhuyifei1999 (talk) 13:30, 2 November 2013 (UTC)
✓ CodedCommons:Bots/Requests/YiFeiBot_(14) --Zhuyifei1999 (talk) 14:34, 2 November 2013 (UTC)
This section was archived on a request by: Zhuyifei1999 (talk) 04:32, 8 November 2013 (UTC)

Batch categorisations

Hi there, i would like the SVG files

Thanks in advance, --Jerome Potts (talk) 22:18, 17 October 2013 (UTC)

You may do this yourself using Cat-a-lot. --Leyo 22:40, 17 October 2013 (UTC)
Thanks for the info, however, i do not see how to accomplish that which i requested above, that is, selecting a certain type of files within a category (and in some cases in its subcats) and applying a change to them. --Jerome Potts (talk) 23:00, 17 October 2013 (UTC)
 Oppose: images should be categorized in the "deepest" categories only; Category:SVG road signs is redundant in most cases. Please don't add it to files directly. --Ricordisamoa 13:43, 18 October 2013 (UTC)

cat removal

An errornous script run placed ~1400 images in Category:CC-BY-SA-2.0 and Category:Flickr images reviewed by File Upload Bot (Magnus Manske) (many of them in both). Those cats are to be placed by templates only so they should be removed. The Script runner somehow failed to correct this error so if another one is able and willing to fix this please feel free to do so. --Denniss (talk) 21:26, 15 October 2013 (UTC)

Only remove the direct category link and do nothing else? --Zhuyifei1999 (talk) 09:57, 16 October 2013 (UTC)
Yep, only the direct category placements. --Denniss (talk) 08:12, 17 October 2013 (UTC)
Was the script run by one user only? If so, please tell the name. This would facilitate fixing. --Leyo 08:32, 17 October 2013 (UTC)
The buggy script was executed by User:Legobot on/around September 6th. --Denniss (talk) 10:17, 17 October 2013 (UTC)

✓ CodedCommons:Bots/Requests/YiFeiBot (12) (I think it's necessary when there's ~1400 images) --Zhuyifei1999 (talk) 11:16, 17 October 2013 (UTC)

Can you also set up a run to remove Category:Self-published work if Self, Self2, PD-self/PD-Self or GFDL-self/GFDL-Self templates are used ? 3k images but not all have dupe cats. --Denniss (talk) 22:26, 17 October 2013 (UTC)

Also Category:Media with locations if {{Location/layout}} is in use (implies use of a location template). --Denniss (talk) 22:33, 17 October 2013 (UTC)
Only if there is a specific editor who edited it. I don't want my bot run for a day and get only one occurrence. Also, I'm not sure if there's a way to get the template transclusions without a very complicated regex. --Zhuyifei1999 (talk) 07:27, 18 October 2013 (UTC)
Could you try to filter those out which had been added by the broken Legobot script? --Denniss (talk) 11:19, 19 October 2013 (UTC)
 coding.... --Zhuyifei1999 (talk) 13:01, 19 October 2013 (UTC)
✓ DoneUser:YiFeiBot/sandbox/3 --Zhuyifei1999 (talk) 09:35, 20 October 2013 (UTC)
The "Files from ... stream (to crop)" was the intended target, everything else an accidental addition. --Denniss (talk) 13:56, 20 October 2013 (UTC)

Statistics on incorrect parameters used

The content of Category:Pages using Information template with incorrect parameter could be reduced from > 10,000 to currently 1,500, mostly by (semi)automated fixes. To help fixing the remaining errors, a statistical evaluation of the parameters causing the errors would be of great benefit. Incorrect parameters that multiple times might get fixed in a semiautomated way. A list of allowed parameters is contained below |opt=. --Leyo 05:24, 17 October 2013 (UTC)

 Running... --Zhuyifei1999 (talk) 13:36, 17 October 2013 (UTC)
✓ DoneUser:YiFeiBot/sandbox --Zhuyifei1999 (talk) 14:17, 17 October 2013 (UTC)
Thank you. Are these all parameter names used in Template:Information? “GFDL” (highest no. of occurrences) is likely to be used e.g. in {{Self}} as a parameter value. --Leyo 14:56, 17 October 2013 (UTC)
That's what textlib.py tells the bot. "GFDL" is found in files like File:Braziliaanse_Ridders_in_de_Militaire_en_Keizerlijke_Orde_van_Christus_na_1843.jpg --Zhuyifei1999 (talk) 14:59, 17 October 2013 (UTC)
OK. Your analysis is also helpful, but I was actually looking for parameter names, not parameter values. Sorry for being unclear. --Leyo 15:06, 17 October 2013 (UTC)
I mean it is using the parameter value when there's no = in the parameter (parameter names like 1 or 2 is useless), else it is the parameter name. (Sorry for being unclear too) --Zhuyifei1999 (talk) 15:08, 17 October 2013 (UTC)
Is it possible to distinguish those two cases? IMO parameters with only one occurrence could be skipped. --Leyo 15:25, 17 October 2013 (UTC)
 Doing… --Zhuyifei1999 (talk) 15:28, 17 October 2013 (UTC)
✓ Done --Zhuyifei1999 (talk) 16:06, 17 October 2013 (UTC)
Thank you. I removed the allowed and some fixed parameters. --Leyo 16:47, 17 October 2013 (UTC)

Possible Rijksmonument

There are more than 100 similar cases, but I am unable to code an appropriate fix. The all have the parameters plaats and provincie. A possible fix looks like this, an aggregated edit simply like this. --Leyo 20:54, 17 October 2013 (UTC)

Somebody partialy removed the Possible Rijksmonument template, this is a temporary template helping with identification of the image. If the template is partially removed this probably means that the image is not of a rijksmonument, the whole template should be removed in that case. Or did I misunderstand the problem?Mvg, Basvb (talk) 23:11, 17 October 2013 (UTC)
All cases seem to go back to one user, I'll inform this user. If you give me a list of images I'll fix them (some seem to be monuments, some seem not to be a monument). Mvg, Basvb (talk) 23:16, 17 October 2013 (UTC)
I don't have a list, but they are all in Category:Pages using Information template with incorrect parameter and have the above-mentioned parameters. --Leyo 23:19, 17 October 2013 (UTC)
Ok, I'm sorting them throught, but it's simply removing those parts left from the template. Something else: Somebody did this kind of edits on multiple images, this introduces errors! could these be fixed by a bot (or reverted!). Mvg, Basvb (talk) 23:32, 17 October 2013 (UTC)
Ok, I fixed all of these (ending on RCE.jpg) Mvg, Basvb (talk) 23:43, 17 October 2013 (UTC)
Thank you. There are a few left. --Leyo 23:48, 17 October 2013 (UTC)

Pipes in URLs

There are several cases in Category:Pages using Information template with incorrect parameter incl. subcategory where there is a pipe in an URL. Is there a way to recognize these cases with a bot and replace | by &#124;? --Leyo 17:01, 18 October 2013 (UTC)

Could you explain? --Zhuyifei1999 (talk) 03:24, 19 October 2013 (UTC)
See this example fix. --Leyo 09:39, 19 October 2013 (UTC)
I think this is a dangerous task as Denniss reported on my talk page. I'll leave this to other bot owners. --Zhuyifei1999 (talk) 01:53, 20 October 2013 (UTC)
Since there are probably not so many cases, it should be done in a semiautomated way. The main issue is to find such URLs. My regex skill are not good enough. --Leyo 14:00, 20 October 2013 (UTC)
Almost working regex:
(?:\[?[a-z]+:|\[)\/\/[^\s\|]*\|[^\s\|]*
(50 hits) but unfortunally there is some false positives like File:WorkNC-Knee prosthesis.jpg --Zhuyifei1999 (talk) 09:37, 21 October 2013 (UTC)
Thank you. I was able to find and fix 58 errors (incl. subcategory). In some cases I also fixed an unsuccessful attempt to fix the error. --Leyo 22:21, 21 October 2013 (UTC)
--Zhuyifei1999 (talk) 08:34, 22 October 2013 (UTC)

template replacing

Hello there,
we need a bot which could replace all usages of the template:location dec through template:object location dec at all photos of User:Epizentrum. I've already asked him and this would be ok. Who could help us?
Thank you very much and best regards, --#Reaper (talk) 16:26, 17 November 2013 (UTC)

Isn't this feasible using VisualFileChange? --Leyo 20:31, 17 November 2013 (UTC)
It is, I've just tried it myself. Cool tool! --Epizentrum (talk) 10:26, 18 November 2013 (UTC)
Oops, sorry, my fault. Haven't thought that this is possible, because I've been rejected some weeks ago to use AWB. Thank you very much! --#Reaper (talk) 22:10, 18 November 2013 (UTC)
This section was archived on a request by: Leyo 11:25, 18 November 2013 (UTC)

Best practice question, how to filter by licence

I'm pulling a report for someone of files within a category tree by licence type (PD and CC0 - i.e. not needing attribution). I have solved this by using pywikipedia to recursively go down the tree then find hidden categories for each image page (the standard call, page.categories(), does not do this as it seems to just sniff the current html page rather than pull on transclusions, so I use in the API for that bit) but I am not terribly happy about how I choose which categories match a licence type. I'm using a regular expression to look for "PD" and "CC-Zero" in the hidden category names.

I know that others have bots that look at licence problems, so is there some more reliable or at least efficient way of asking the API or pywikipediabot for the types of licence(s) that apply to sets of Image pages? Having this as a simple function built into pywikipedia would be pretty useful. N.b. "licence" is how UK folks spell "license". -- (talk) 12:22, 24 October 2013 (UTC)

Each license template uses one of several style layout templates like Template:CC-Layout (see Template:Style formatting license template/doc for full list). So if you want to find all files using PD licenses in lets say Category:Images_uploaded_by_Fæ you can use this CatScan2 query. Also all style layout templates transclude an empty tag template Template:License template tag so to find all files in Category:Images_uploaded_by_Fæ that do not have a license on can use this CatScan2 query. Hope this helps. --Jarekt (talk) 20:04, 24 October 2013 (UTC)
I am already making a bot to find out unlicensed images and to notify the uploader. But since I am currently new to pywikibot, so the process will be a little bit slow...--Gabrielchihonglee (talk) 12:46, 26 October 2013 (UTC)
Thanks for the suggestions. Every time I try the catscan query I get "Fatal error" and I'm not sure how this actually can be limited to all types of PD licence plus CC-Zero. My query sniffing through the licences under Category:Arts and Crafts Movement has hit regression problems (infinite loops) about 5 times now, I don't know of an easy fix for this apart from deleting the self-referencing or other more complex child being a parent possibilities by hand each time they cause my script to breakdown. Supposedly this is with quite limited recursion being set at just 2 levels (subcategoriesList(recurse=2)). -- (talk) 13:59, 26 October 2013 (UTC)
I only use CatScan2 and it is MUCH better after moving to the tool labs. However some of the queries can get expensive and the tool times-out before returning anything or the number of the outputs is too large. For example I can not search for files missing {{License template tag}}, the query just times out. But I can use CatScan2 for files using {{Information}} but not using {{License template tag}} which were uploaded within the last month. I never had a problem with infinite loops while using recursive search, but I also do not usually search deep category trees. --Jarekt (talk) 19:47, 28 October 2013 (UTC)

License review for Bugwood network uploads?

The Bugwood network allows authors to change the license, currently this lead to six DRs - mostly caused by a missing automatism for license review.

Would it be possible for a bot herder to automagically review Bugwood licenses by parsing the source description page [similar to the Flickr review]? As the Bugwood network uses multiple domains (bugwood.org, insectimages.org, forestryimages.org - possibly more) it is problematic to identify all images, one starting point could be Category:Bugwood Network image sources; though not every uploader (me included...) uses the source template.

Thanks, rbrausse (talk) 15:21, 1 November 2013 (UTC)

I'm a bit busy right now (hoping someone else will pick this up), but yes this is possible. You may want to use a template like {{Bugwood licence pending review|<date>}} which could put these in a backlog category and a bot regularly sniffs through and adds an approved/not approved result or corrects the licence template after looking carefully at the licence on the source website. It would help if you could provide a better specification of the problem and a couple of example cases. -- (talk) 18:51, 1 November 2013 (UTC)
thanks!
a few examples (based on the current DRs):
I think those are a cross-section of the general use cases, drop a line if you need more (better?) requirements.
as of the license review backlog (see the pump entry) it would probably better to mark images with CC-BY as "reviewed" and place all inconsistent files (uploaded as CC-BY, description page claims CC-BY-NC) on a distinct error log page for manual review. I'm absolutely willing to check the copy vio protocol every (say) couple of days. rbrausse (talk) 00:51, 2 November 2013 (UTC)

Incorrectly transcluded information templates

In Category:Pages using Information template with incorrect parameter there are many files where a template different from {{Information}} should have been used. Examples for Artwork or Book. It would be great if someone is able to detect other such cases and fix them in an automated way. Many of the cases seem to have been uploaded using derivativeFX. Hence, looking for “derivativeFX” might be a good starting point. --Leyo 01:20, 14 September 2013 (UTC)

 Coding for Uploaded with derivativeFX ones (skip if not) --Zhuyifei1999 (talk) 02:27, 14 September 2013 (UTC)
✓ Coded request submitted at Commons:Bots/Requests/YiFeiBot (8). --Zhuyifei1999 (talk) 03:57, 14 September 2013 (UTC)
Thank you. The last test edits look good.
BTW: Such edits by OgreBot 2 would be correct for the information template, but not for the template that should have been used. I don't know if there is a possibility to handle those. --Leyo 08:34, 14 September 2013 (UTC)

I created Category:Pages using Artwork template with incorrect parameter and will soon create Category:Pages using Book template with incorrect parameter. If a file is not in the corresponding maintenance category after the bot edit, this serves as an additional indication for a successful job. --Leyo 04:03, 18 September 2013 (UTC)

Mostly that's {{{1}}}. Just like {{Description}}. --Zhuyifei1999 (talk) 07:59, 18 September 2013 (UTC)

This is weird: where's the 1 in File:01_Tournai_Ki1JPG.jpg? --Zhuyifei1999 (talk) 03:47, 21 September 2013 (UTC)

As in many cases, there was a spare pipe. --Leyo 21:36, 21 September 2013 (UTC)

Since Category:Pages using Book template with incorrect parameter has been created and almost emptied, it may serve as a check of successful bot changes. --Leyo 08:37, 25 September 2013 (UTC)

There seem to be some false-positives in that category, e.g. where Template:Cite book or fragments of it are used (example). It might be worth to go through the category. The number of files in it decreased from ~190,000 to 97 only. --Leyo 09:46, 26 September 2013 (UTC)
|isbn=1-4160-2328-3 |oclc= |doi=}} is already in {{Cite book}}. So just remove them? --Zhuyifei1999 (talk) 10:14, 27 September 2013 (UTC)
There seemed to be a problem with the brackets. What about this? --Leyo 11:29, 27 September 2013 (UTC)
I'm not sure about what the uploader is trying to do, you may be right. --Zhuyifei1999 (talk) 11:56, 27 September 2013 (UTC)
It might be a problem with derivativeFX, too. I think that it would be good to go through the related bot edits. --Leyo 21:08, 27 September 2013 (UTC)
… or the files in Category:Pages using Book template with incorrect parameter that are clearly not scans of book pages. --Leyo 09:09, 1 October 2013 (UTC)
There's just no way to "Abuse filter" using {{Book}} for images that are clearly not scans of book pages IMO, but it would better if this is discussed on MediaWiki.org so that the MW devs can notice them. --Zhuyifei1999 (talk) 13:54, 2 October 2013 (UTC)
Don't get me wrong. I am simply referring to the false-positives of your bot that may be found by visual inspection of the content of this category. Some can simply be fixed like this. --Leyo 15:59, 2 October 2013 (UTC)
Commons:Infoboxes templates like {{Book}}, {{Photograph}} or {{Artwork}} are not required to be used only by books, photographs and artworks; although they were created with those types of objects in mind. It is OK to use them for other types of objects, as long as the fields make sense. It is a different story with license templates: If you use {{PD-scan}} you should only add them to scans of books and other published material. {{PD-Art}} should only be used with 2D artworks which are in PD. {{Self}} should be only used for the works you are the author of. --Jarekt (talk) 16:49, 2 October 2013 (UTC)
??? I am just talking about the false-positives, i.e. changes {{Information}}{{Book}} his bot made because of broken cite book templates! I'd like him to help fixing them. That's all. --Leyo 22:05, 2 October 2013 (UTC)
I am sorry, I just read the last message and took it out of context. --Jarekt (talk) 02:07, 3 October 2013 (UTC)
ok. Sorry for the misunderstanding, but how exactly (I don't use cite very much)? --Zhuyifei1999 (talk) 06:31, 4 October 2013 (UTC)
✓ Done some with vfc--Zhuyifei1999 (talk) 07:20, 4 October 2013 (UTC)

As Category:Pages using Book template with incorrect parameter and Category:Pages using Artwork template with incorrect parameter are now empty/almost empty, unsuccessful bot edits could easily be found and fixed. Are there more to come? --Leyo 14:07, 23 October 2013 (UTC)

Rerunning, may find some cases. --Zhuyifei1999 (talk) 14:13, 23 October 2013 (UTC)
The two potential target categories (in case of failure) are now completely empty. On the other hand, Category:Pages using Information template with incorrect parameter has been refilled quite a bit over the past couple of days. --Leyo 22:47, 4 November 2013 (UTC)

Pages using ... template with incorrect parameter

There are several directories like:

that could use some bots to correct the images. So far I was trying to identify some type of issue, develop regexp replacement pattern, find all the files that match the pattern and test the replacement to make sure there will be no bad corrections and do the replacements. Than try it again. I could use some help since there is still plenty of files to correct. --Jarekt (talk) 19:15, 4 November 2013 (UTC)

I cleaned out the third (and smallest) category. I hope it will stop being (re)filled soon. --Leyo 22:44, 4 November 2013 (UTC)
Yes we emptied it several times and they still are coming. --Jarekt (talk) 13:07, 5 November 2013 (UTC)
IMO the biggest issue for bots is that how the regex knows what part of the content in template {{Information}} or {{Artwork}} without all the other templates (maybe use a parser?). If this issue can be fixed, make a program for them would be easy. --Zhuyifei1999 (talk) 09:06, 5 November 2013 (UTC)
I agree, In AWB I like to use for such tasks there is no good way to tell if you are in the {{Information}} template or in the "history" section where original metadata as it was on some Wikipedia is copied. One is OK to change while the other should not be changed. I often set up a lot of conditions for when to skip a file. --Jarekt (talk) 13:07, 5 November 2013 (UTC)
After having performed a task using VisualFileChange I usually check Special:RecentChangesLinked/Category:Pages using Information template with incorrect parameter. Unsuccessful fixing attempts will show up there. --Leyo 13:49, 5 November 2013 (UTC)


Its also about finding pattern. Uploads by the same user may be fixed in the same (automated) way. There also several parameters that are used in many files, such as “Title” in animal/plant pictures, or errors caused by pipes in the Permission parameter (example). --Leyo 11:03, 5 November 2013 (UTC)

Bad dates and Flickr metadata

Many people, even today, think that the "date" field in the upload form is the date that they upload the picture, and not the date that the picture was created. If no EXIF or similar metadata is available, this can do some horrible things to provenance and contribute to license washing.

For pictures that come from Flickr, we are fortunate enough to have access to the original metadata (at least, for the pictures that are still up). I've fixed a few files by hand, but there are thousands of files on Commons that are sourced to Flickr. I propose that a bot verify all Flickr-sourced photos (even those whose licensing has already been verified) and compare their Commons-listed creation date with the creation date mentioned on Flickr, and correct the former to match with the latter. DS (talk) 00:29, 5 November 2013 (UTC)

Oh, here's an example. Note that the Flickr Review bot ignored the flawed date. DS (talk) 00:36, 5 November 2013 (UTC)

I recently came across a user, not an OTRS team member, who appears to be tagging his uploads with {{PermissionOTRS}} using fake ticket numbers. Would it be useful to have a bot compare additions to http://commons.wikimedia.org/w/index.php?title=Special:RecentChanges&tagfilter=OTRS+permission+added+by+non-OTRS+member against OTRS ticket numbers to confirm their legitimacy? Or, more broadly, to review for accuracy all current files and future additions in the category Category:Items with OTRS permission confirmed and flag those with problems, either with a problem tag or by placing them in Category:Items with incorrect OTRS ticket ID? --Rrburke (talk) 14:46, 5 November 2013 (UTC)

By the way, in case you mean User:Virginia Gentilini, she was doing exactly as she was advised. The email exchange under the ticket number she is using, asks her to add {{PermissionOTRS}} by herself. At some point during a rewrite of {{PermissionOTRS}} I was trying to flag images with bad OTRS ID's and put them in Category:Items with incorrect OTRS ticket ID. However that process was (and still is) based on the range of the numbers used. I would also like to convert all the files using "ticket" parameter to "id" parameter, which would simplify the template and allow better error checking. I have never figured out how to access OTRS database by a bot (but i also did not try too hard). One of the complicating factors is that OTRS is split into large number of little compartments (last time I checked) and you need to ask for access to each one and without such access you can not check validity of the ticket. You can not ask for access to all. --Jarekt (talk) 17:22, 5 November 2013 (UTC)
Hi, Jarekt. Thanks for your response. No, that's not the user I meant. The relevant COM:ON thread is here. --Rrburke (talk) 20:16, 5 November 2013 (UTC)

CommonsDelinker needs maintainer(s)

See http://lists.wikimedia.org/pipermail/commons-l/2013-November/006969.html --Steinsplitter (talk) 21:24, 6 November 2013 (UTC)

Bryan's Bots

BryanBot

BryanBot is silent since 2 November 2013 and Bryan is inactive. Can someone pleas run BryanBot on his own Botaccount? --Steinsplitter (talk) 16:11, 5 November 2013 (UTC)

You mean run the script on BryanBot it self? --Zhuyifei1999 (talk) 04:46, 6 November 2013 (UTC)#
To run BryanBot on YiFeiBot (for example) --Steinsplitter (talk) 11:29, 6 November 2013 (UTC)
"I am no longer part of the active Commons community and do not intend to become so in the foreseeable future. (...)" --Steinsplitter (talk) 11:34, 6 November 2013 (UTC)
I'm not sure about "mwclient" framework. I would suggest running User:BryanBot (clone) and User:FlickreviewR (clone) etc. --Zhuyifei1999 (talk) 11:51, 6 November 2013 (UTC)

I've send an email to Bryan. Hopefully he can reply here. Trijnsteltalk 15:35, 6 November 2013 (UTC)

FlickreviewR is not working

Hi! Sorry if this is wrong section... Looks like the FlickreviewR bot is not working, since November 2nd. Should we be worried? This bot is also run by Bryan, like the previous headline above. Palosirkka (talk) 10:06, 6 November 2013 (UTC)

Active again; most - though not all - of the backlog has cleared now - MPF (talk) 20:36, 7 November 2013 (UTC)
And fully clear now! - MPF (talk) 22:22, 7 November 2013 (UTC)
Wonderful news! This metallic fellow is a prime aide! Palosirkka (talk) 09:19, 8 November 2013 (UTC)

{{Section resolved|1=[[User:Zhuyifei1999|Zhuyifei1999]] ([[User talk:Zhuyifei1999|<span class="signature-talk">talk</span>]]) 09:35, 8 November 2013 (UTC)}}
Unfortunately, it's not working again, currently a backlog of well over 400 files not reviewed (worse than last week's backlog) - MPF (talk) 19:12, 12 November 2013 (UTC)

Yeah. Toolserver is going to shut down... --Zhuyifei1999 (talk) 10:11, 13 November 2013 (UTC)
At least it worked for about an hour yesterday. Someone really needs to get control over this Bot and move it to labs. This is one of the essential Bots the WMF needs to take control of even if they have to pay a maintainer. Commons Delinker is another one. They should not waste money with fancy stuff like visual editor. --Denniss (talk) 10:30, 13 November 2013 (UTC)
 Doing…Commons:Bots/Requests/FlickreviewR_(clone). --Zhuyifei1999 (talk) 10:51, 13 November 2013 (UTC)

Duplicate flickrreview tags

Is it technically possible to detect images with multiple Flickrreview templates ? The templates in question are User:FlickreviewR/reviewed-pass and Flickrreview, either one of them twice or both once. A problem may be that they are not just as template but with multiple arguments afterwards. I recently stumbled about some images with theses duplicates and 1 out of 5 had different license tags and a positive review only for one. --Denniss (talk) 21:45, 7 November 2013 (UTC)

No idea how to detect this? --Denniss (talk) 12:45, 13 November 2013 (UTC)
 Doing… --Zhuyifei1999 (talk) 09:17, 14 November 2013 (UTC)

For both transcluded (the other one is much harder):

Query
SELECT page_title
FROM page
INNER JOIN templatelinks tl1
ON tl1.tl_from = page.page_id
AND tl1.tl_namespace = 10
AND tl1.tl_title = "Flickrreview"
INNER JOIN templatelinks tl2
ON tl2.tl_from = page.page_id
AND tl2.tl_namespace = 2
AND tl2.tl_title = "FlickreviewR/reviewed-pass"
WHERE page_namespace = 6;
Result
MariaDB [commonswiki_p]> SELECT page_title
    -> FROM page
    -> INNER JOIN templatelinks tl1
    -> ON tl1.tl_from = page.page_id
    -> AND tl1.tl_namespace = 10
    -> AND tl1.tl_title = "Flickrreview"
    -> INNER JOIN templatelinks tl2
    -> ON tl2.tl_from = page.page_id
    -> AND tl2.tl_namespace = 2
    -> AND tl2.tl_title = "FlickreviewR/reviewed-pass"
    -> WHERE page_namespace = 6;
+-------------------------------------------------------------------------------------------------+
| page_title                                                                                      |
+-------------------------------------------------------------------------------------------------+
| Montreal_tower.jpg                                                                              |
| Canadian_Army_LSVW_ambulance.jpg                                                                |
| Mate_de_coca_Peru.jpg                                                                           |
| 11726151_c2bdddb328_Datura_seeds.jpg                                                            |
| Allianz_Arena_-_Panels.jpg                                                                      |
| Art_Car_Parade.jpg                                                                              |
| Jamaica_Road,_London.jpg                                                                        |
| ATMs_In_A_Van.jpg                                                                               |
| Leslie_Nielsen.jpg                                                                              |
| San_Bernardo_003.jpg                                                                            |
| BookcrossingLyon.jpg                                                                            |
| Avenida_San_Juan.jpg                                                                            |
| Sellafield_Visitors'_Centre.jpg                                                                 |
| Andrew_Flintoff_bowling.jpg                                                                     |
| Anti_usa_demo_brazil.jpg                                                                        |
| Serpentine_Pavillion_2002.jpg                                                                   |
| Serpentine_Pavillion_2002-2.jpg                                                                 |
| Kabaddi.jpg                                                                                     |
| Audrey_Hepburn_Hollywood_Star.jpg                                                               |
| Megwhal_woman_with_nosering.jpg                                                                 |
| Youth_lax.jpg                                                                                   |
| Lacrosse_ball.jpg                                                                               |
| Textured_lax_ball.jpg                                                                           |
| STX_lacrosse_head.jpg                                                                           |
| Bhuj_Rabari.jpg                                                                                 |
| Batata_Vada.jpg                                                                                 |
| Jon_"maddog"_Hall_gives_Theo_de_Raadt_a_set_of_red_plastic_horns.jpg                            |
| Duke_lacrosse_signs.jpg                                                                         |
| Hanukkah_dishes.jpg                                                                             |
| Afternoon_Tea_-_English_Style.jpg                                                               |
| Monster_M-80.jpg                                                                                |
| Monster_M-80_(cropped).jpg                                                                      |
| Pandanus_spiralis_fruit.jpg                                                                     |
| Osakadome-1.jpg                                                                                 |
| Alonzo_Mourning_shooting_2005.jpg                                                               |
| Dave_Concepción.jpg                                                                             |
| Barapen_Ceremony_Baliem_Valley.jpg                                                              |
| Bristol_VR_XDV609S.jpg                                                                          |
| SexToysVendingMachine.jpg                                                                       |
| Rachel_Carson_Homestead_yard_and_sign.jpg                                                       |
| NapoliUltras2.jpg                                                                               |
| NapoliUltras1.jpg                                                                               |
| SBS_Gebouw.jpg                                                                                  |
| Hotel_Krone_Buochs.jpg                                                                          |
| Fieldstone.jpg                                                                                  |
| Chinese_porcelain_tiles,_Cochin_synagogue.jpg                                                   |
| Depression_Glass_Juicer.jpg                                                                     |
| Leaded_glass_window.jpg                                                                         |
| Santoor.jpg                                                                                     |
| 2006-11-30_SanAndres_6699.jpg                                                                   |
| Scott_Higgins_with_his_new_jawbone.jpg                                                          |
| Moogerfooger.jpg                                                                                |
| Road_cases_2.jpg                                                                                |
| Onyx_The_Digital_Pied_Piper.jpg                                                                 |
| Mexican_Guitarron.jpg                                                                           |
| FoodCourt.jpg                                                                                   |
| Nameko_soba_なめこそば.jpg                                                                      |
| Baked_Ziti.jpg                                                                                  |
| Strozzapreti.jpg                                                                                |
| Buchstabensuppe.jpg                                                                             |
| Campanelle_with_Summer_Veggies_(top_view).jpg                                                   |
| Pumpkin_Pie_Spice.jpg                                                                           |
| Erythemis_vesiculosa.jpg                                                                        |
| Libellula_semifasciata.jpg                                                                      |
| Isolated_bacteria_-_Micrococcus_luteus.jpg                                                      |
| Oscillatoria.jpg                                                                                |
| Lactococcus_lactis.jpg                                                                          |
| Staphylococcus_epidermis.jpg                                                                    |
| Rural_region_Iraq.jpg                                                                           |
| Ur-Nassiriyah.jpg                                                                               |
| Katja_husen_2006.jpg                                                                            |
| Medusa-acquario_di_Genova.jpg                                                                   |
| Barriera_corallina-acquario_di_Genova.jpg                                                       |
| Acquario_di_Genova-vasca_delle_razze.jpg                                                        |
| Chile_Parque_Torres_Paine.jpg                                                                   |
| Mural_Gabriela_Mistral.jpg                                                                      |
| Plaza_Independencia_de_Montevideo.jpg                                                           |
| World_Tride_Center_Uruguay.jpg                                                                  |
| Amurrioko_erreformategi_zaharra.jpg                                                             |
| Fideua2.jpg                                                                                     |
| Macbook_Air_Ports.jpg                                                                           |
| Rutherford_Quote.jpg                                                                            |
| José_Feliciano.jpg                                                                              |
| Malcolmgladwellflickr.jpg                                                                       |
| Seahorse_-_Singapore.jpg                                                                        |
| Aarti_at_Har-ki-Pauri,_Haridwar.jpg                                                             |
| "IERI_OGGI_DOMANI_SEMPRE_PARTIGIANI"_striscione_a_Piazza_San_Babila_-_Milano_25_Aprile_2007.jpg |
| Cambridge_Secret_garden.jpg                                                                     |
| Birth_of_a_lamb_1.jpg                                                                           |
| Birth_of_a_lamb_2.jpg                                                                           |
| 10th_Avenue_Marine_Terminal.jpg                                                                 |
| The_5th_century_BC_Amathus_sarcophagus.jpg                                                      |
| ChrisBathgate_Flickr_NeuClub.jpg                                                                |
| Tramonto_dal_Belvedere_del_Krcki_Most.jpg                                                       |
| Janaf.jpg                                                                                       |
| Chiostro_interno_monastero.jpg                                                                  |
| Casa_a_Punat.jpg                                                                                |
| Ship_at_Punat.jpg                                                                               |
| Calle_di_Punat.jpg                                                                              |
| Yacht_Punat.jpg                                                                                 |
| Marina_di_Punat.jpg                                                                             |
| Casa_di_Punat.jpg                                                                               |
| Escaleira_do_Museo_do_Pobo_Galego.jpg                                                           |
| 470141966_0ee43083f0_o_Parc_des_Buttes.jpg                                                      |
| Moustached_Treeswift_(Hemiprocne_mystacea).jpg                                                  |
| Spanish_Inquisition_Necklace.jpg                                                                |
| Bud_girl.jpg                                                                                    |
| Licuado.jpg                                                                                     |
| Ion-koshigaya-lake-town.jpg                                                                     |
| Aeriel_Picture_Benton_Harbor.jpg                                                                |
| Estadio_de_Balaídos.jpg                                                                         |
| Estación_de_trenes_de_Montevideo,_Uruguay.jpg                                                   |
| Manifestazione_No_Gelmini_14_novembre_2008.jpg                                                  |
| 60163_Tornado_Tender_28_Dec_2008.jpg                                                            |
| 60163_Tornado_cab_dials_28_Dec_2008.jpg                                                         |
| 60163_Tornado_wheel_28_Dec_2008.jpg                                                             |
| 60163_Tornado_cab_28_Dec_2008.jpg                                                               |
| Kuwait_National_Petroleum_Company_(KNPC)_headquarter.jpg                                        |
| BeitMery.jpg                                                                                    |
| 1974_Fiat_500_Lucertola.jpg                                                                     |
| West_Don_Lands.jpg                                                                              |
| Saipem_7000,_Almeria.jpg                                                                        |
| Tratwą_na_ratunek_klimatowi_Dominik_Paszkiewicz_flickr.jpg                                      |
| Tratwą_na_ratunek_klimatowi_beczki_flickr.jpg                                                   |
| Tratwą_na_ratunek_klimatowi_mocowanie_silnika_flickr.jpg                                        |
| Tratwą_na_ratunek_klimatowi_składanie_flickr.jpg                                                |
| Tratwą_na_ratunek_klimatowi_-_na_wodzie_flickr.jpg                                              |
| Kawalek_Kulki_02.jpg                                                                            |
| Kärkinen_bridge_during_Päijännepurjehdus_2007.jpg                                               |
| Notgeld_-_Geldern_-_25_pf_-1920.jpg                                                             |
| Shell_petrol_station_in_Ähtäri.jpg                                                              |
| Afropixel.jpg                                                                                   |
| Kuokkala_Bridge_2007.jpg                                                                        |
| Ylistönrinne_campus.jpg                                                                         |
| Flickr_-_Furryscaly_-_Smile_for_the_Camera.jpg                                                  |
| Flickr_-_Furryscaly_-_Bilateral_Symmetry.jpg                                                    |
| Flickr_-_Furryscaly_-_Soil_Centipede.jpg                                                        |
| Beach_in_Finland_from_air.jpg                                                                   |
| Aalto_University_School_of_Art_and_Design_from_air.jpg                                          |
| Nattha_Komolvadhin.jpg                                                                          |
| Holler_toronto02.jpg                                                                            |
| Kobayashi_Malaysian_qualy_2010.jpg                                                              |
| Centropus_sinensis_-Wilpattu_National_Park,_Sri_Lanka-8.jpg                                     |
| Tr1_Toijala.jpg                                                                                 |
| Toijala_water_tower.jpg                                                                         |
| Po_River_in_Casale_Monferrato.jpg                                                               |
| Haida_sculpture_(UBC_MOA_2010a).jpg                                                             |
| Early_20th_century_Hopi_corn_(UBC).jpg                                                          |
| Dumetella_carolinensis_-three_eggs_in_nest-8.jpg                                                |
| Dumetella_carolinensis_-three_chicks_in_nest-8_(1).jpg                                          |
| Dumetella_carolinensis_-adult-8.jpg                                                             |
| Malmi_airport_from_air.jpg                                                                      |
| National_road_4_in_Helsinki_from_air.jpg                                                        |
| Erotic_show.jpg                                                                                 |
| Lapdance_Exhibition_Eros_Pyramide_2009.jpg                                                      |
| Combretum_rotundifolium.jpg                                                                     |
| CMA_CGM_Virginia_-_IMO_9351139_(3194444689).jpg                                                 |
| CMA_CGM_White_Shark_-_IMO_9317975_(3660101267).jpg                                              |
| Olivia_Chow_visits_Layton_memorial_in_Nathan_Phillips_Square.jpg                                |
| Sunny_Leone_AVN_2011_2.jpg                                                                      |
| Stormy_Daniels_AVN_2009_1.jpg                                                                   |
| Megan_Fox_TIFF,_2011.jpg                                                                        |
| Stafina_striptease_Eropolis_Toulouse_2008_04.jpg                                                |
| Stafina_striptease_Eropolis_Toulouse_2008_11.jpg                                                |
| Kelly_Divine_AVN_2010.jpg                                                                       |
| Teagan_Presley_AVN_2010.jpg                                                                     |
| Phoenix_Marie_AVN_2010.jpg                                                                      |
| Alysha_Morgan_AVN_2010.jpg                                                                      |
| Flower_Tucci_AVN_2010_3.jpg                                                                     |
| Madison_Parker_AVN_2010.jpg                                                                     |
| Phoenix_Marie_AVN_2011_2.jpg                                                                    |
| Breanne_Benson_AVN_2011.jpg                                                                     |
| Dana_DeArmond_AVN_2011.jpg                                                                      |
| Unknown_AVN_2011_8.jpg                                                                          |
| Angel_Vain_AVN_2011_1.jpg                                                                       |
| Rayveness_AVN_2011_1.jpg                                                                        |
| Alysha_Morgan_AVN_2011_1.jpg                                                                    |
| Madelyn_Marie_AVN_2011_1.jpg                                                                    |
| Kagney_Linn_Karter_AVN_2011_1.jpg                                                               |
| Jynx_Maze_AVN_2011_1.jpg                                                                        |
| Jesse_Jane_AVN_2011_1.jpg                                                                       |
| Teagan_Summers_AVN_2011_1.jpg                                                                   |
| Gemma_Massey_AVN_2011_1.jpg                                                                     |
| Faye_Reagan_AVN_2011_1.jpg                                                                      |
| Sophie_Dee,_Kelly_Devine_AVN_2011_1.jpg                                                         |
| Phoenix_Marie_AVN_2011_1.jpg                                                                    |
| Tori_Black_AVN_2011_1.jpg                                                                       |
| Julia_Ann_AVN_2011_1.jpg                                                                        |
| Angel_Vain_AVN_2011_2.jpg                                                                       |
| Bobbi_Eden_AVN_2011_1.jpg                                                                       |
| Athena_Pleasures_AVN_2011_1.jpg                                                                 |
| Alysha_Morgan_AVN_2011_2.jpg                                                                    |
| Monique_Alexander_AVN_2011_1.jpg                                                                |
| Madelyn_Marie_AVN_2011_2.jpg                                                                    |
| Mary_Carey_AVN_2011_2.jpg                                                                       |
| Athena_Pleasures_AVN_2011_2.jpg                                                                 |
| Ambersin_AVN_2011_1.jpg                                                                         |
| Tory_Lane_AVN_2011_1.jpg                                                                        |
| Flower_Tucci_AVN_2009_1.jpg                                                                     |
| Faye_Reagan_AVN_2009_1.jpg                                                                      |
| Kelly_Madison_AVN_2009_1.jpg                                                                    |
| Tiffany_Mynx_AVN_2009_1.jpg                                                                     |
| Kristina_Rose_AVN_2009_1.jpg                                                                    |
| Julia_Ann_AVN_2009_1.jpg                                                                        |
| Phoenix_Marie_AVN_2009_1.jpg                                                                    |
| Flower_Tucci_AVN_2009_3.jpg                                                                     |
| Flower_Tucci_AVN_2009_2.jpg                                                                     |
| Orion-belt.jpg                                                                                  |
| Christie_Stevens_at_AVN_Adult_Entertainment_Expo_2012_1.jpg                                     |
| Bibi_Jones_at_AVN_Adult_Entertainment_Expo_2012_1.jpg                                           |
| Tasha_Reign_at_AVN_Adult_Entertainment_Expo_2012_2.jpg                                          |
| Diamond_Kitty_at_AVN_Adult_Entertainment_Expo_2012_1.jpg                                        |
| Veronica_Avluv_at_AVN_Adult_Entertainment_Expo_2012_2.jpg                                       |
| Sami_Slider_at_AVN_Adult_Entertainment_Expo_2012.jpg                                            |
| Tania_Tapia_at_AVN_Adult_Entertainment_Expo_2012.jpg                                            |
| Unknown_at_AVN_Adult_Entertainment_Expo_2012_(2).jpg                                            |
| A_nude_girl_in_lounge.jpg                                                                       |
| A_girl_in_a_bedroom_wearing_panties.jpg                                                         |
| A_boy_smooching_a_girl.jpg                                                                      |
| A_girl_with_her_big_tits.jpg                                                                    |
| Observation_Deck_at_The_Peak_-_Hong_Kong.jpg                                                    |
| Linzer_Donaulände_2002.jpg                                                                      |
| ZMVM.jpg                                                                                        |
| Wichita_Mountains_-_Oklahoma_(5344372039).jpg                                                   |
| Wichita_Mountains_-_Oklahoma_-_January_2011_(5344372011).jpg                                    |
| Trithemis_kirbyi_(8415667947).jpg                                                               |
| ErosPyramide2009.jpg                                                                            |
+-------------------------------------------------------------------------------------------------+
227 rows in set (2.31 sec)
Convenient links
  1. File:Montreal_tower.jpg
  2. File:Canadian_Army_LSVW_ambulance.jpg
  3. File:Mate_de_coca_Peru.jpg
  4. File:11726151_c2bdddb328_Datura_seeds.jpg
  5. File:Allianz_Arena_-_Panels.jpg
  6. File:Art_Car_Parade.jpg
  7. File:Jamaica_Road,_London.jpg
  8. File:ATMs_In_A_Van.jpg
  9. File:Leslie_Nielsen.jpg
  10. File:San_Bernardo_003.jpg
  11. File:BookcrossingLyon.jpg
  12. File:Avenida_San_Juan.jpg
  13. File:Sellafield_Visitors'_Centre.jpg
  14. File:Andrew_Flintoff_bowling.jpg
  15. File:Anti_usa_demo_brazil.jpg
  16. File:Serpentine_Pavillion_2002.jpg
  17. File:Serpentine_Pavillion_2002-2.jpg
  18. File:Kabaddi.jpg
  19. File:Audrey_Hepburn_Hollywood_Star.jpg
  20. File:Megwhal_woman_with_nosering.jpg
  21. File:Youth_lax.jpg
  22. File:Lacrosse_ball.jpg
  23. File:Textured_lax_ball.jpg
  24. File:STX_lacrosse_head.jpg
  25. File:Bhuj_Rabari.jpg
  26. File:Batata_Vada.jpg
  27. File:Jon_"maddog"_Hall_gives_Theo_de_Raadt_a_set_of_red_plastic_horns.jpg
  28. File:Duke_lacrosse_signs.jpg
  29. File:Hanukkah_dishes.jpg
  30. File:Afternoon_Tea_-_English_Style.jpg
  31. File:Monster_M-80.jpg
  32. File:Monster_M-80_(cropped).jpg
  33. File:Pandanus_spiralis_fruit.jpg
  34. File:Osakadome-1.jpg
  35. File:Alonzo_Mourning_shooting_2005.jpg
  36. File:Dave_Concepción.jpg
  37. File:Barapen_Ceremony_Baliem_Valley.jpg
  38. File:Bristol_VR_XDV609S.jpg
  39. File:SexToysVendingMachine.jpg
  40. File:Rachel_Carson_Homestead_yard_and_sign.jpg
  41. File:NapoliUltras2.jpg
  42. File:NapoliUltras1.jpg
  43. File:SBS_Gebouw.jpg
  44. File:Hotel_Krone_Buochs.jpg
  45. File:Fieldstone.jpg
  46. File:Chinese_porcelain_tiles,_Cochin_synagogue.jpg
  47. File:Depression_Glass_Juicer.jpg
  48. File:Leaded_glass_window.jpg
  49. File:Santoor.jpg
  50. File:2006-11-30_SanAndres_6699.jpg
  51. File:Scott_Higgins_with_his_new_jawbone.jpg
  52. File:Moogerfooger.jpg
  53. File:Road_cases_2.jpg
  54. File:Onyx_The_Digital_Pied_Piper.jpg
  55. File:Mexican_Guitarron.jpg
  56. File:FoodCourt.jpg
  57. File:Nameko_soba_なめこそば.jpg
  58. File:Baked_Ziti.jpg
  59. File:Strozzapreti.jpg
  60. File:Buchstabensuppe.jpg
  61. File:Campanelle_with_Summer_Veggies_(top_view).jpg
  62. File:Pumpkin_Pie_Spice.jpg
  63. File:Erythemis_vesiculosa.jpg
  64. File:Libellula_semifasciata.jpg
  65. File:Isolated_bacteria_-_Micrococcus_luteus.jpg
  66. File:Oscillatoria.jpg
  67. File:Lactococcus_lactis.jpg
  68. File:Staphylococcus_epidermis.jpg
  69. File:Rural_region_Iraq.jpg
  70. File:Ur-Nassiriyah.jpg
  71. File:Katja_husen_2006.jpg
  72. File:Medusa-acquario_di_Genova.jpg
  73. File:Barriera_corallina-acquario_di_Genova.jpg
  74. File:Acquario_di_Genova-vasca_delle_razze.jpg
  75. File:Chile_Parque_Torres_Paine.jpg
  76. File:Mural_Gabriela_Mistral.jpg
  77. File:Plaza_Independencia_de_Montevideo.jpg
  78. File:World_Tride_Center_Uruguay.jpg
  79. File:Amurrioko_erreformategi_zaharra.jpg
  80. File:Fideua2.jpg
  81. File:Macbook_Air_Ports.jpg
  82. File:Rutherford_Quote.jpg
  83. File:José_Feliciano.jpg
  84. File:Malcolmgladwellflickr.jpg
  85. File:Seahorse_-_Singapore.jpg
  86. File:Aarti_at_Har-ki-Pauri,_Haridwar.jpg
  87. File:"IERI_OGGI_DOMANI_SEMPRE_PARTIGIANI"_striscione_a_Piazza_San_Babila_-_Milano_25_Aprile_2007.jpg
  88. File:Cambridge_Secret_garden.jpg
  89. File:Birth_of_a_lamb_1.jpg
  90. File:Birth_of_a_lamb_2.jpg
  91. File:10th_Avenue_Marine_Terminal.jpg
  92. File:The_5th_century_BC_Amathus_sarcophagus.jpg
  93. File:ChrisBathgate_Flickr_NeuClub.jpg
  94. File:Tramonto_dal_Belvedere_del_Krcki_Most.jpg
  95. File:Janaf.jpg
  96. File:Chiostro_interno_monastero.jpg
  97. File:Casa_a_Punat.jpg
  98. File:Ship_at_Punat.jpg
  99. File:Calle_di_Punat.jpg
  100. File:Yacht_Punat.jpg
  101. File:Marina_di_Punat.jpg
  102. File:Casa_di_Punat.jpg
  103. File:Escaleira_do_Museo_do_Pobo_Galego.jpg
  104. File:470141966_0ee43083f0_o_Parc_des_Buttes.jpg
  105. File:Moustached_Treeswift_(Hemiprocne_mystacea).jpg
  106. File:Spanish_Inquisition_Necklace.jpg
  107. File:Bud_girl.jpg
  108. File:Licuado.jpg
  109. File:Ion-koshigaya-lake-town.jpg
  110. File:Aeriel_Picture_Benton_Harbor.jpg
  111. File:Estadio_de_Balaídos.jpg
  112. File:Estación_de_trenes_de_Montevideo,_Uruguay.jpg
  113. File:Manifestazione_No_Gelmini_14_novembre_2008.jpg
  114. File:60163_Tornado_Tender_28_Dec_2008.jpg
  115. File:60163_Tornado_cab_dials_28_Dec_2008.jpg
  116. File:60163_Tornado_wheel_28_Dec_2008.jpg
  117. File:60163_Tornado_cab_28_Dec_2008.jpg
  118. File:Kuwait_National_Petroleum_Company_(KNPC)_headquarter.jpg
  119. File:BeitMery.jpg
  120. File:1974_Fiat_500_Lucertola.jpg
  121. File:West_Don_Lands.jpg
  122. File:Saipem_7000,_Almeria.jpg
  123. File:Tratwą_na_ratunek_klimatowi_Dominik_Paszkiewicz_flickr.jpg
  124. File:Tratwą_na_ratunek_klimatowi_beczki_flickr.jpg
  125. File:Tratwą_na_ratunek_klimatowi_mocowanie_silnika_flickr.jpg
  126. File:Tratwą_na_ratunek_klimatowi_składanie_flickr.jpg
  127. File:Tratwą_na_ratunek_klimatowi_-_na_wodzie_flickr.jpg
  128. File:Kawalek_Kulki_02.jpg
  129. File:Kärkinen_bridge_during_Päijännepurjehdus_2007.jpg
  130. File:Notgeld_-_Geldern_-_25_pf_-1920.jpg
  131. File:Shell_petrol_station_in_Ähtäri.jpg
  132. File:Afropixel.jpg
  133. File:Kuokkala_Bridge_2007.jpg
  134. File:Ylistönrinne_campus.jpg
  135. File:Flickr_-_Furryscaly_-_Smile_for_the_Camera.jpg
  136. File:Flickr_-_Furryscaly_-_Bilateral_Symmetry.jpg
  137. File:Flickr_-_Furryscaly_-_Soil_Centipede.jpg
  138. File:Beach_in_Finland_from_air.jpg
  139. File:Aalto_University_School_of_Art_and_Design_from_air.jpg
  140. File:Nattha_Komolvadhin.jpg
  141. File:Holler_toronto02.jpg
  142. File:Kobayashi_Malaysian_qualy_2010.jpg
  143. File:Centropus_sinensis_-Wilpattu_National_Park,_Sri_Lanka-8.jpg
  144. File:Tr1_Toijala.jpg
  145. File:Toijala_water_tower.jpg
  146. File:Po_River_in_Casale_Monferrato.jpg
  147. File:Haida_sculpture_(UBC_MOA_2010a).jpg
  148. File:Early_20th_century_Hopi_corn_(UBC).jpg
  149. File:Dumetella_carolinensis_-three_eggs_in_nest-8.jpg
  150. File:Dumetella_carolinensis_-three_chicks_in_nest-8_(1).jpg
  151. File:Dumetella_carolinensis_-adult-8.jpg
  152. File:Malmi_airport_from_air.jpg
  153. File:National_road_4_in_Helsinki_from_air.jpg
  154. File:Erotic_show.jpg
  155. File:Lapdance_Exhibition_Eros_Pyramide_2009.jpg
  156. File:Combretum_rotundifolium.jpg
  157. File:CMA_CGM_Virginia_-_IMO_9351139_(3194444689).jpg
  158. File:CMA_CGM_White_Shark_-_IMO_9317975_(3660101267).jpg
  159. File:Olivia_Chow_visits_Layton_memorial_in_Nathan_Phillips_Square.jpg
  160. File:Sunny_Leone_AVN_2011_2.jpg
  161. File:Stormy_Daniels_AVN_2009_1.jpg
  162. File:Megan_Fox_TIFF,_2011.jpg
  163. File:Stafina_striptease_Eropolis_Toulouse_2008_04.jpg
  164. File:Stafina_striptease_Eropolis_Toulouse_2008_11.jpg
  165. File:Kelly_Divine_AVN_2010.jpg
  166. File:Teagan_Presley_AVN_2010.jpg
  167. File:Phoenix_Marie_AVN_2010.jpg
  168. File:Alysha_Morgan_AVN_2010.jpg
  169. File:Flower_Tucci_AVN_2010_3.jpg
  170. File:Madison_Parker_AVN_2010.jpg
  171. File:Phoenix_Marie_AVN_2011_2.jpg
  172. File:Breanne_Benson_AVN_2011.jpg
  173. File:Dana_DeArmond_AVN_2011.jpg
  174. File:Unknown_AVN_2011_8.jpg
  175. File:Angel_Vain_AVN_2011_1.jpg
  176. File:Rayveness_AVN_2011_1.jpg
  177. File:Alysha_Morgan_AVN_2011_1.jpg
  178. File:Madelyn_Marie_AVN_2011_1.jpg
  179. File:Kagney_Linn_Karter_AVN_2011_1.jpg
  180. File:Jynx_Maze_AVN_2011_1.jpg
  181. File:Jesse_Jane_AVN_2011_1.jpg
  182. File:Teagan_Summers_AVN_2011_1.jpg
  183. File:Gemma_Massey_AVN_2011_1.jpg
  184. File:Faye_Reagan_AVN_2011_1.jpg
  185. File:Sophie_Dee,_Kelly_Devine_AVN_2011_1.jpg
  186. File:Phoenix_Marie_AVN_2011_1.jpg
  187. File:Tori_Black_AVN_2011_1.jpg
  188. File:Julia_Ann_AVN_2011_1.jpg
  189. File:Angel_Vain_AVN_2011_2.jpg
  190. File:Bobbi_Eden_AVN_2011_1.jpg
  191. File:Athena_Pleasures_AVN_2011_1.jpg
  192. File:Alysha_Morgan_AVN_2011_2.jpg
  193. File:Monique_Alexander_AVN_2011_1.jpg
  194. File:Madelyn_Marie_AVN_2011_2.jpg
  195. File:Mary_Carey_AVN_2011_2.jpg
  196. File:Athena_Pleasures_AVN_2011_2.jpg
  197. File:Ambersin_AVN_2011_1.jpg
  198. File:Tory_Lane_AVN_2011_1.jpg
  199. File:Flower_Tucci_AVN_2009_1.jpg
  200. File:Faye_Reagan_AVN_2009_1.jpg
  201. File:Kelly_Madison_AVN_2009_1.jpg
  202. File:Tiffany_Mynx_AVN_2009_1.jpg
  203. File:Kristina_Rose_AVN_2009_1.jpg
  204. File:Julia_Ann_AVN_2009_1.jpg
  205. File:Phoenix_Marie_AVN_2009_1.jpg
  206. File:Flower_Tucci_AVN_2009_3.jpg
  207. File:Flower_Tucci_AVN_2009_2.jpg
  208. File:Orion-belt.jpg
  209. File:Christie_Stevens_at_AVN_Adult_Entertainment_Expo_2012_1.jpg
  210. File:Bibi_Jones_at_AVN_Adult_Entertainment_Expo_2012_1.jpg
  211. File:Tasha_Reign_at_AVN_Adult_Entertainment_Expo_2012_2.jpg
  212. File:Diamond_Kitty_at_AVN_Adult_Entertainment_Expo_2012_1.jpg
  213. File:Veronica_Avluv_at_AVN_Adult_Entertainment_Expo_2012_2.jpg
  214. File:Sami_Slider_at_AVN_Adult_Entertainment_Expo_2012.jpg
  215. File:Tania_Tapia_at_AVN_Adult_Entertainment_Expo_2012.jpg
  216. File:Unknown_at_AVN_Adult_Entertainment_Expo_2012_(2).jpg
  217. File:A_nude_girl_in_lounge.jpg
  218. File:A_girl_in_a_bedroom_wearing_panties.jpg
  219. File:A_boy_smooching_a_girl.jpg
  220. File:A_girl_with_her_big_tits.jpg
  221. File:Observation_Deck_at_The_Peak_-_Hong_Kong.jpg
  222. File:Linzer_Donaulände_2002.jpg
  223. File:ZMVM.jpg
  224. File:Wichita_Mountains_-_Oklahoma_(5344372039).jpg
  225. File:Wichita_Mountains_-_Oklahoma_-_January_2011_(5344372011).jpg
  226. File:Trithemis_kirbyi_(8415667947).jpg
  227. File:ErosPyramide2009.jpg

--Zhuyifei1999 (talk) 09:45, 14 November 2013 (UTC)

Cleanup on commonist uploads

Could someone please help me to cleanup files on Category:Cancioneiro da Ajuda?

Lines to remove:

{{Information
|Description=
|Source=
|Date=
|Author=
|Permission=
|other_versions=
}}

I've tried to do this running replace.py on my bot account without success. If possible, share the chosen regex, for further needs =) Lugusto 23:15, 12 December 2013 (UTC)

Have you tried VisualFileChange? --Leyo 23:34, 12 December 2013 (UTC)
Worked! Many thanks Lugusto 00:01, 13 December 2013 (UTC)
This section was archived on a request by: Leyo 09:39, 13 December 2013 (UTC)

Fix convert

Template:Convert (for converting, for example, from kilograms to pounds) was recently changed to use the new Module:Convert. I periodically check the error categories and fix them, but the following should be done by AWB.

Most pages in Category:Convert invalid options need this fix:

  • In template {{convert|...}} change "abbrev=on" to "abbr=on".

The "abbr=on" option means that both input and output units are abbreviated—shown as symbols. If there are any issues that can't be easily resolved when that's done, I'll fix them in due course. Johnuniq (talk) 02:37, 13 December 2013 (UTC)

This section was archived on a request by: Leyo 09:44, 13 December 2013 (UTC): Done

Unvisible controll characters in category tags

The case Commons:Bots/Work requests/Archive 9#Unvisible controll characters in category tags seems to be not resolved yet. I met several remaining occurences in Category:Brick castles in Category:Brick castles in Iran:

Could we systematically correct and effectively prevent such errors? --ŠJů (talk) 22:43, 18 November 2013 (UTC)

Simple fix for recently broken links

Can someone use their bot and fix links to www.culteducation.com that are currently pointing to www.rickross.com ?

The website recently moved, and all the other details in the links are the same, just need to switch from www.rickross.com to www.culteducation.com.

Thank you!

-- Cirt (talk) 20:02, 19 October 2013 (UTC)


Sorry, to make this a little more clear:

  1. www.rickross.com = old links
  2. www.culteducation.com = need to be switched to this new link.

All the rest of the info in those links should be the same, just the domain name need to be updated. -- Cirt (talk) 03:33, 20 October 2013 (UTC)

 Doing…--Gabrielchihonglee (talk) 11:26, 1 November 2013 (UTC)
I believe this has since been ✓ Done, thank you to all who helped out, -- Cirt (talk) 15:44, 24 November 2013 (UTC)
This section was archived on a request by: Zhuyifei1999 (talk) 13:28, 14 December 2013 (UTC)

Replacing description page content with content of the description page of a corresponding file

There's a set of mushroom drawings for which I've uploaded better versions as new files. Copying over the content of the description page from the corresponding old file to the new one would likely be all I need to catch it from there. The old files are named Coloured Figures of English Fungi or Mushrooms - t. 1.png through to number 438 with numbers 409, 423, 427, and 437 missing. The new ones bear the exactly same file name with the ending changed from .png to .jpg. (I've found somebody who agreed to do this back in 2011 when the uploads happened but somehow it never happened.)--Natr (talk) 02:27, 20 November 2013 (UTC)

Opportunities to add images

Hi, I've been running some newbie training events, and one of my more popular exercises is adding images to articles. But I need lists of articles which lack images but for which we have possible images. There is a convoluted query system for finding such opportunities, but for newbies we need a list. I'm hoping to get w:Wikipedia:Articles_with UK_Geocodes but_without_images refreshed for EN wiki, but could anyone here produce lists of:

  1. Wikipedia articles which lack images but which have a version in another language which does have a Wikimedia Commons image by Wikipedia Language. This would look similar to w:Wikipedia:Articles_with_UK_Geocodes_but_without_images but with a second column for the article that does have an image.
  2. Wikipedia articles which lack images but which have a Wikimedia Commons category by Wikipedia Language. This would look similar to w:Wikipedia:Articles_with_UK_Geocodes_but_without_images but with a second column for the Wikimedia Commons category.
  3. Wikipedia articles which lack images but where we a Wikimedia Commons image within 100 metres according to the geocodes of the article and the image by Wikipedia Language. This would look similar to w:Wikipedia:Articles_with_UK_Geocodes_but_without_images but with a second column for the Wikimedia Commons image(s).

Ideally I would like to start off with lists for the English and Welsh language Wikipedias but there may be interest elsewhere. Jonathan Cardy (WMUK) (talk) 12:44, 29 November 2013 (UTC)

Notifying uploaders of files in a category

I did not find a handy way for compiling a list of files uploaded by a user that are in a specific category. If e.g. several files of an active user are in a maintenance category such as Category:Pages using Information template with incorrect parameter, the user is likely willing to fix them, but a list of these files needs to be provided. Does anyone have a bot that is able to compile such lists and possibly also to post them on the respective user talk page? I guess that such a process would be useful for other maintenance categories, too. --Leyo 23:27, 3 December 2013 (UTC)

What about
  1. VFC Category:Pages_using_Information_template_with_incorrect_parameter
  2. Cute select uploader
  3. Select "prepend text, notify uploader"
  4. Do not fill in any text but the message to the uploader
  5. seems to work
--McZusatz (talk) 08:31, 4 December 2013 (UTC)
Thank you. I was not aware that VFC may be used for this without changing the files pages.
There are, however, also a few drawbacks in this method: Among the many uploaders of files in this category there are many inactive users or ones with just one file; due to the large number of files in this category, VFC gets slow (unresponsive script warnings); files in a subcategory cannot be included. But I started using this method anyway. --Leyo 09:31, 4 December 2013 (UTC)
The easiest way to notify users would be to selected all files in a category. This would produce messages to a lot of users, but would probably also have the biggest impact. --Leyo 14:02, 5 December 2013 (UTC)

Hi, I am currently trying to categorize uncategorized templates and found in Special:UncategorizedTemplates thousends of templates named Australian2011CensusMaps/bcpfieldcat/<number>. I've created Category:Australian 2011 Census map templates for them an started to edit manually each template. But that are realy far too much for manual edits (more then 7000). Can a Bot just add <noinclude>[[Category:Australian 2011 Census map templates]]</noinclude> to each template like I did it i.e. here. Thx in advance. --JuTa 22:53, 22 November 2013 (UTC)

Ok, I'm onto it, sorry about leaving them uncategorized. --99of9 (talk) 13:08, 24 November 2013 (UTC)
You should also do this fix everywhere. --Leyo 14:06, 24 November 2013 (UTC)
Hmm, unfortunately that breaks the categories that are now all created. Sorry, I think this is not important enough to make many category redirects, people will figure out what I mean! --99of9 (talk) 05:44, 3 December 2013 (UTC)
Thx, but anyhow the bot stopped after 1021 actions. Can you please restart it. --JuTa 20:03, 25 November 2013 (UTC)
Yes, I could only load a limited number into AWB from a search, and I'm not sure how to get the next lot. I'll look into it, but if you have ideas, let me know. --99of9 (talk) 05:44, 3 December 2013 (UTC)
Ok, nevermind, I found a way... working through them now. --99of9 (talk) 05:55, 3 December 2013 (UTC)
Thx a lot, but there are still abou 2000 missing - see here. Perhaps you could reinvestigate this case... --JuTa 11:44, 8 December 2013 (UTC)
Hmm, not sure why they didn't show up on my list last time. Trying again now. --99of9 (talk) 23:07, 8 December 2013 (UTC)

bot request: add Motd Template to Motd Files

I figure out, not all Modt files have the Media of the day template. It looks like it was added by hand and often nobody add it. Can anybody write and run a bot that check the last Modt daily and add this template? Additional an initial check over all Modt may be usefull. --Slick (talk) 08:01, 5 December 2013 (UTC)

This section was archived on a request by: AdmrBoltz 15:28, 14 January 2014 (UTC)

All images in this category should be tagged {{PD-USGov-DOT}} and not just {{PD-USGov}} (or any other license) as the Bureau of Public Roads is a predecessor to the Federal Highway Administration, a division of the United States Department of Transportation. All 104 images in the cat should be re-tagged. --AdmrBoltz 14:52, 14 January 2014 (UTC)

Have you tried COM:VFC? --Zhuyifei1999 (talk) 15:20, 14 January 2014 (UTC)
Thanks. That did the trick. --AdmrBoltz 15:28, 14 January 2014 (UTC)

categorize categories

Hello,

Could someone add Category:Inscriptions in Cemetery Père-Lachaise in French to categories listed on this page (User:~Pyb/Brouillon11). Thx in advance. Pyb (talk) 11:19, 19 December 2013 (UTC)

@Pyb: Do I get it right: for every category listed on User:~Pyb/Brouillon11: categorize to Category:Inscriptions in Cemetery Père-Lachaise in French? --Zhuyifei1999 (talk) 11:26, 19 December 2013 (UTC)
Yes. Pyb (talk) 11:27, 19 December 2013 (UTC)
ok,  coding... I hope it doesn't need a bot request. --Zhuyifei1999 (talk) 11:47, 19 December 2013 (UTC)
 Running... --Zhuyifei1999 (talk) 11:51, 19 December 2013 (UTC)
@Pyb: Seem to be ✓ Done --Zhuyifei1999 (talk) 15:40, 19 December 2013 (UTC)

It would probably make sense to find author matches that occur in many (e.g. > 30) cases. Is it feasible to create such a list? --Leyo 17:29, 28 November 2013 (UTC)
And how can false-positives such as those be removed from the maintenance category? --Leyo 17:37, 28 November 2013 (UTC)

@Leyo: could you explain please? --Zhuyifei1999 (talk) 07:33, 8 December 2013 (UTC)
Please be more specific. Which part is not clear? --Leyo 18:16, 8 December 2013 (UTC)
@Leyo: Do you mean to make a list like User:YiFeiBot/sandbox/1 with all the parameter values of the field "A/author" of {{Information}}? --Zhuyifei1999 (talk) 09:07, 9 December 2013 (UTC)
A similar list, but not the same. I think it is enough to restrict is to authors with > 30 occurrences or 100 author names totally. --Leyo 18:44, 9 December 2013 (UTC)
Author Files
Some author File 1
File 2
File 3
Another author File 4
File 5
 Doing… --Zhuyifei1999 (talk) 09:01, 10 December 2013 (UTC)
 Running... --Zhuyifei1999 (talk) 11:15, 13 December 2013 (UTC)
About 30000 processed, the most matched author is {{unknown}} --Zhuyifei1999 (talk) 04:36, 14 December 2013 (UTC)
I did not expect that it was such a big effort.
Hm, which creator template is supposed to match {{unknown}}? --Leyo 11:07, 14 December 2013 (UTC)
{{unknown|author}} seem to work. See my contribs (regex replacing /(\| *[Aa]uthor *= *)(?:\{\{)?[Uu]nknown(?:\}\})?(\s*(?:\||\}\}))/g with $1{{unknown|author}}$2) --Zhuyifei1999 (talk) 12:48, 14 December 2013 (UTC)
Error 503 Service Unavailable just happened while processing #48348. Have to fix some and run again (or use incomplete data) --Zhuyifei1999 (talk) 12:59, 14 December 2013 (UTC)
✓ 48348 files and corresponding authors loaded to database. I'll do a final script tomorrow. --Zhuyifei1999 (talk) 15:15, 14 December 2013 (UTC)
✓ DoneUser:YiFeiBot/sandbox/3 (case insensitive, for authors with > 30 hits) with "unknown" (4735 hits) and "{{unknown}}" (33882 hits) skipped. Some may be empty due to encoding problems. --Zhuyifei1999 (talk) 04:42, 15 December 2013 (UTC)
For the regex replace → Commons:Bots/Requests/YiFeiBot (15) --Zhuyifei1999 (talk) 06:07, 15 December 2013 (UTC)
@Zhuyifei1999: I don't know which process you did use, but I've noticed that your bot missed some images, e.g. in Category:Léopold-Émile Reutlinger and subcategories, some images don't have the Creator template, and they are not tagged with this category. I think it is because the author is noted as Léopold Reutlinger, and not as Léopold-Émile Reutlinger. I just added the Creator template in some: File:Fbrun.jpg, File:La Bella Otero 1901 Reutlinger-MAE-200452 1.jpg. Regards, Yann (talk) 16:41, 15 December 2013 (UTC)
@Yann: ok, I've created a redirect: Creator:Léopold Reutlinger --Zhuyifei1999 (talk) 17:09, 15 December 2013 (UTC)
@Leyo: About the false positives (sorry, overlooked this), my suggestion is to append that author name with a disambig name, but I'm trying to temporally fix this by appending a left to right mark (&lrm;). --Zhuyifei1999 (talk) 11:40, 23 December 2013 (UTC)
Linking his name to this webpage might be the best solution. Due to the „BY“ the author field should not be changed visibly. --Leyo 13:44, 23 December 2013 (UTC)
 Agree I think. --Zhuyifei1999 (talk) 14:13, 23 December 2013 (UTC)

Wow, another big backlog of work! As I have been creating quite a number of Creator templates lately, I know that it takes a lot of time if it is done correctly (languages, links to WP, Wikidata, etc.). I think this is a work which does not require any special competences, just a lot of patience. So it seems it'd be useful to advertise this to involve newcomers or people looking for something to help. Yann (talk) 11:36, 14 December 2013 (UTC)

Mass rename request

I need some assistance with a mass move a large list of files to ensure they are in the proper naming scheme. This is covered under file renaming guideline 6. The list of files needing to be renamed (and their new target name) can be found here. This was discussed by members of the U.S. Roads WikiProject here. Thanks in advance. --AdmrBoltz 13:29, 29 January 2014 (UTC)

@: ^^ --Zhuyifei1999 (talk) 13:34, 29 January 2014 (UTC)
Sorry, I'm not an admin and there are several redirects in that list that would need to be deleted. -- (talk) 13:38, 29 January 2014 (UTC)
@: Can you handle the ones that do not have a redirect? --AdmrBoltz 14:17, 29 January 2014 (UTC)
I'll take a look shortly. -- (talk) 14:21, 29 January 2014 (UTC)
Thanks. I moved the ones with redirects I saw to the bottom of the list. --AdmrBoltz 14:25, 29 January 2014 (UTC)
I have nominated the redirects for speedy deletion per Commons:D#General:_speedy_deletion ("a redirect over which another page must be moved"). --AdmrBoltz 15:06, 29 January 2014 (UTC)
First 100 done. The moves should be complete in around an hour and a half. -- (talk) 15:10, 29 January 2014 (UTC)
Shiny. Thanks :) If the speedies aren't handled in time, I have file mover access to move the stragglers. --AdmrBoltz 15:25, 29 January 2014 (UTC)
@: the old redirects were speedy deleted. --AdmrBoltz 16:37, 29 January 2014 (UTC)
Cool, well my renames are at 380/670, so taking quite a bit longer than my first estimate. When finished I'll take a second look to see if any were skipped. -- (talk) 16:44, 29 January 2014 (UTC)
No worries. Thanks for your work :) --AdmrBoltz 17:03, 29 January 2014 (UTC)

✓ Done All the desired links look blue to me. :-) -- (talk) 18:42, 29 January 2014 (UTC)

Thanks :) There may be more for New Jersey at another time. Shall I just ping you direct or come back here? --AdmrBoltz 18:42, 29 January 2014 (UTC)
Best to ask here, I may not be about and I keep an eye on this noticeboard anyway. -- (talk) 19:09, 29 January 2014 (UTC)
Can do. --AdmrBoltz 19:11, 29 January 2014 (UTC)
This section was archived on a request by: AdmrBoltz 19:11, 29 January 2014 (UTC)

In relation to this discussion and this user problem, I request for:

--ŠJů (talk) 23:18, 9 January 2014 (UTC)

  • Please note that TM just removed my comments and recreated the overcat situation. This is disingenuous behaviour by TM and I would like it to be taken into account - along with the behaviour of Sju - when evaluating this request. Liamdavies (talk) 15:19, 11 January 2014 (UTC)
For user problems, please go to COM:AN/U. And please gain consensus first. --Zhuyifei1999 (talk) 15:32, 11 January 2014 (UTC)
I agree Zhuyifei1999 this is not the venue to resolve such discussions. Indeed, this issue is currently under discussion at Commons:Administrators' noticeboard/User problems#Attacking and changes without comunity consensus. This issue has too been raised, but I would like it noted both the disingenuous nature of part of this request, and that my comments were removed. Liamdavies (talk) 15:38, 11 January 2014 (UTC)
  • Sju has again created overcat he complains about in this request. Due to this behaviour I ask that the request be postponed until the content and ANU dispute is resolved. Liamdavies (talk) 16:39, 15 January 2014 (UTC)
Is there an objection against restoration of the groundlessly removed sort keys? --ŠJů (talk) 21:33, 18 January 2014 (UTC)

Misused {{Unknown}}

I noticed a file page where the template {{Unknown}} were misused as a language template for unknown language. Of course, the text from the parameter is not displayed. The image was uploaded by UploadWizard, maybe it's enabled by a bug of UploadWizard. Could you search for all cases where the template {{Unknown}} is used with parameter "1=" with inappropriate value and correct them? --ŠJů (talk) 21:30, 18 January 2014 (UTC)

Easiest way: Ask an admin to change {{Unknown}} so that all files using {{Unknown}} with an inappropriate value could be categorized to a maintenance category. Using bots would be slow. --Zhuyifei1999 (talk) 06:14, 19 January 2014 (UTC)

Picasa image reviewer replacing

Picasa Review Bot (talk · contribs) is inactive since March 2012, and there is huge backlog on category. Can anyone develop a replacer of him? (Source code is published on the user page.) —레비Revi 12:00, 26 January 2014 (UTC)

 Doing… --Zhuyifei1999 (talk) 13:21, 26 January 2014 (UTC)
Commons:Bots/Requests/Picasa Review Bot (clone) --Zhuyifei1999 (talk) 15:29, 26 January 2014 (UTC)
Approved.—레비Revi 10:05, 13 February 2014 (UTC)
This section was archived on a request by: 레비Revi 10:05, 13 February 2014 (UTC)