User talk:Mike Peel/Archive 40

Wikidata weekly summary #338
Here's your quick overview of what has been happening around Wikidata over the last week. 
 * Discussions
 * Closed request for comments: Political alliance vs P4100, Changes to P2737 and P2738, Why do we have an item for dogs and another one for Canis lupus familiaris?, start time / end time vs. publication date of 1st / last episode, Mapping and improving the data import process, Familypedia links removed for "described at URL", Allow the creation of links to redirects in Wikidata


 * Events
 * Past: Several Wikidata-related presentations at International Data Week from November 5-8 in Gaborone:
 * Wikidata and Wikibase as global platforms for democratizing data publishing
 * WikiCite and Scholia - a Linked Open Data approach to exploring the scholarly literature and related resources
 * A wiki approach to collecting, curating and managing citizen science data
 * A wiki perspective on an Open Science Commons
 * Past: Several Wikidata-related presentations at GLAMWiki conference, including:
 * Wikidata — what's new?
 * Open your structured GLAM data with Wikibase — install your own instance of the technology behind Wikidata
 * Incoming: a new Illuminatis Data Mining workshop on 16-17 November in Gotha
 * Incoming: Wikidata workshop in Vienna
 * Incoming: Wikidata train the trainers in Cologne, Berlin and Vienna (in German)


 * Press, articles, blog posts
 * Incoming partnership with the German National Library by Jens Ohlig (in German)
 * How Wikidata Is Solving Its Chicken-or-Egg-Problem in the Field of Cultural Heritage, by Beat Eastermann


 * Other Noteworthy Stuff
 * wikitable.info is a visualization of Wikidata items in HTML tables in many languages, easy to print and export. Feedback goes to Germartin1
 * OpenRefine 3.1 beta is out, with many fixes and improvements to the Wikidata integration suggested by the community.
 * There's a new Wikidata game: Commons category matches


 * Did you know?


 * Newest properties:
 * General datatypes: location of sense usage, dramaturge, head coach of sports team, beer bitterness, beer color, INEP IGC discrete grade, clinical trial phase, maintained by WikiProject, uses capitalization for
 * External identifiers: NYC Building Identification Number (BIN), Cineuropa person ID, The Guardian article ID, Caselaw Access Project case ID, MGG Online ID, Map of Life ID, AfroMoths ID, FloraWeb ID, FLOW ID, AllPowerlifting.com person ID, Info Flora ID, YÖK Academic Profile ID, Mushroom Observer ID, Schleswig-Holstein object ID, Michigan Flora ID, Observation.org ID


 * New property proposals to review:
 * General datatypes: Vice, sense associated with form, declared patrimony, season ends, inscription mentions, DanNet 2.2 word ID, Study fees, HASC, exchange rate, Verspreidingsatlas.nl ID
 * External identifiers: AllMusic release ID, DBU profile, MusicNotes product ID, MusicNotes song ID, Nobel Prize in Literature ID, Code de l'Autorité de l'Aviation Civile argentine, Playbill venue ID, Digital Flora of Central Africa ID, Portal to the Flora of Italy ID, Envanter.gov.tr Monument ID, B3Kat Joint Union Catalogue, Santiebeati ID, Soccerway team ID, identifiant Littera, Letterboxd actor ID, Letterboxd film ID, Threatened Species Link ID, VD 18 ID, Siamzone film ID, Thaifilm ID, National Portrait Gallery (United States) object ID, Newseum newspaper front page ID, Playbill person ID, SWH Release ID, APA ID, Virtual Guide to the Flora of Mongolia ID, identifiant À nos grands hommes, BioOne ID, Academy Awards Database film ID


 * Query examples:
 * Currently happening figure skating competitions (source)
 * Software developed by groups within Google (source)
 * Knowledge organization systems (source)
 * |wdt%3AP576|wdt%3AP582%20%3Fend.%20%7D%0A%20%20%20%20BIND%28%3Fdate%20-%20%221776-07-04%22%5E%5Exsd%3AdateTime%20AS%20%3FoffsetInt%29%0A%20%20%20%20BIND%28%3FoffsetInt%20-%20%287%20*%20xsd%3Ainteger%28xsd%3Afloat%28%3FoffsetInt%29%20%2F%207.0%29%29%20AS%20%3FoffsetSigned%29%0A%20%20%20%20BIND%28IF%28%3FoffsetSigned%20%3C%200%2C%20%3FoffsetSigned%20%2B%207%2C%20%3FoffsetSigned%29%20AS%20%3Foffset%29%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fcountry%20%3Foffset%0A%7D%20AS%20%25offsets%0AWITH%20%7B%0A%20%20SELECT%20%3Fcountry%20%3Fweekday%20%3Fcount%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25offsets.%0A%20%20%20%20BIND%28IF%28%3Foffset%20%3D%200%2C%20%22Thursday%22%40en%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20IF%28%3Foffset%20%3D%201%2C%20%22Friday%22%40en%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20IF%28%3Foffset%20%3D%202%2C%20%22Saturday%22%40en%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20IF%28%3Foffset%20%3D%203%2C%20%22Sunday%22%40en%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20IF%28%3Foffset%20%3D%204%2C%20%22Monday%22%40en%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20IF%28%3Foffset%20%3D%205%2C%20%22Tuesday%22%40en%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20IF%28%3Foffset%20%3D%206%2C%20%22Wednesday%22%40en%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22unknown%20day%22%40en%29%29%29%29%29%29%29%0A%20%20%20%20%20%20%20%20%20AS%20%3Fweekday%29%0A%20%20%7D%0A%7D%20AS%20%25weekdays%0AWITH%20%7B%0A%20%20SELECT%20%3Fcountry%20%28MAX%28%3Fcount%29%20AS%20%3FmaxCount%29%20%28SUM%28%3Fcount%29%20AS%20%3FtotalCount%29%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25weekdays.%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fcountry%0A%20%20HAVING%28%3FtotalCount%20%3E%3D%203%29%20%23%20filter%20out%20countries%20with%20not%20enough%20data%20%283%20is%20a%20very%20generous%20limit%29%0A%7D%20AS%20%25maxWeekdayCount%0AWITH%20%7B%0A%20%20SELECT%20%3Fcountry%20%28SAMPLE%28%3Fweekday%29%20AS%20%3Fweekday%29%20%3Fcount%20%3FtotalCount%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25weekdays.%0A%20%20%20%20INCLUDE%20%25maxWeekdayCount.%0A%20%20%20%20FILTER%28%3Fcount%20%3D%20%3FmaxCount%29%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fcountry%20%3Fcount%20%3FtotalCount%0A%7D%20AS%20%25maxWeekday%0AWHERE%20%7B%0A%20%20INCLUDE%20%25maxWeekday.%0A%20%20BIND%28%3Fcount%20%2F%20%3FtotalCount%20AS%20%3Fratio%29%0A%20%20BIND%28CONCAT%28SUBSTR%28STR%28100%20*%20%3Fratio%29%2C%201%2C%205%29%2C%20%22%25%22%29%20AS%20%3Fpercentage%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3FtotalCount%29 Most common election days by country (source)


 * Development
 * Displaying Senses before Forms (T208592)
 * Making quality constraints play nicer with the Query Service
 * Putting in the ground work to have quality checks run in jobs
 * Enabling arbritrary access on oldwikisource
 * Allowing configuration of the licence in .ttl output
 * Configuration of more string limits, such as URL and mono / multilingual texts
 * Moving wdqs frontend to a blubber deployment (T192006)
 * Asserting a users name so they can't edit when accidently logged out (T124451)
 * Showcase a termbox placeholder in the mobile frontend of m.wikidata.org (T206200)

You can see all open tickets related to Wikidata here. If you want to help, you can also have a look at the tasks needing a volunteer.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

Read the full report &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 15:23, 12 November 2018 (UTC)

List of Cochrane Reviews already used in Wikipedia
Hi Mike, is it a big job to run an update of this list: https://en.wikipedia.org/wiki/User:Mike_Peel/Cochrane_used ? I would like to use it to try and clean up my list of suggested reviews. Thanks! JenOttawa (talk) 14:28, 13 November 2018 (UTC)
 * I've re-run it today. However, the list is too long to post on wiki now, so I've put it at http://www.mikepeel.net/temp/cochrane_uses_nov18.txt instead. Thanks. Mike Peel (talk) 10:07, 14 November 2018 (UTC)
 * This is super helpful Mike. Thanks! I am going to send it to the Cochrane IT folks and see if they can help get a new list of all the Reviews not yet in Wikipedia... or... better yet... remove the reviews that are already in Wikipedia from this list and add the newly published reviews. JenOttawa (talk) 14:04, 14 November 2018 (UTC)

Wikidata weekly summary #339
Here's your quick overview of what has been happening around Wikidata over the last week. 
 * Events
 * Baltic Audiovisual Archives Council Conference in Tallinn, Estonia - November 7, 2018. Sandra F. gave a keynote on GLAM-Wiki projects, Wikidata and Structured Data on Commons.
 * Museum Computer Network conference in Denver, Colorado - November 14, 2018. - Andrew Lih gave a presentation, A First Date with Wikidata
 * Wikicite on 27-29 November 2018: the program is published


 * Other Noteworthy Stuff
 * A new tool to display Wikimedia Commons categories (and Wikipedia/Wikidata tags) with coordinates on the OSM map
 * The Association of Research Libraries published the draft of a Wikidata Task Force White Paper on how libraries and Wikidata/ Wikibase con join forces aroud linked open data for both library discovery systems and Wikipedia, and advancing a diversity and inclusion agenda in the cultures of both libraries and Wikimedia. The draft is open for public comment until 30 November.


 * Did you know?


 * Newest properties:
 * General datatypes: Winterthur Glossar URL, IIIF manifest, category for members of a team, chord progression, season ends, number of volunteers
 * External identifiers: DBU playerprofile, AllMusic release ID, MusicNotes product ID, Playbill venue ID, Portal to the Flora of Italy ID, Digital Flora of Central Africa ID, Envanter.gov.tr Monument ID, Letterboxd actor ID, Argentinean NCAA Airport code, MusicNotes song ID, B3Kat dataset ID, Sotheby's person ID, Santiebeati ID, Letterboxd film ID, Threatened Species Link ID, Littera ID, Soccerway team ID, Playbill person ID, Siamzone film ID, Thaifilm ID, VD 18 ID, Newseum newspaper front page ID, APA ID, SWH Release ID, Virtual Guide to the Flora of Mongolia ID, DanNet 2.2 word ID, À nos grands hommes ID, Verspreidingsatlas.nl ID, BioOne journal ID, ortsnamen.ch ID, Academy Awards Database film ID, The Hendon Mob ID


 * New property proposals to review:
 * General datatypes: work quoted textually, verbally or lyrically, work whose melody is quoted, excerpt, exonym, Danmarks Statistiks filmkode, text features, mission statement, number of lines, number of stations, funding scheme, noun class, eponymous category, taxa protected, river bank, tautomer of, Global Startup Ecosystem Ranking, proper name of astronomical object, research site
 * External identifiers: Corpus typographique français ID, Academy Awards Database nominee ID, World Poker Tour ID, ANICA ID, r-hockey.ru person ID, Sotheby's Museum Network ID, Académie d'Arles member ID, Google News publication ID, ALCA ID, Luding editor ID, BoardGeekGame editor ID, Atlas of Florida Plants ID, British Executions ID, System16 identifier, BLR ID, LEGO set ID, LEGO design ID, LEGO element ID, NAS ID, Invasive Plant Atlas of the United States ID, Welsh Book Trade Info ID, Sega Saturn game ID, TWAS Fellow ID, Bitraga author ID, Bitraga work ID, EUNIS ID, Cal-IPC ID, eFloraSA id, Dimensions Publication ID, Dimensions Source ID, Dimensions Author ID, Microsoft Academic Work ID, Microsoft Academic Source ID, Microsoft Academic Author ID, Microsoft Academic Institution ID


 * Query examples:
 * [https://query.wikidata.org/#%23defaultView%3AMap%0ASELECT%20DISTINCT%0A%3Fitem%20%0A(SAMPLE(%3Fitem_label)%20AS%20%3Fbattle)%0A(SAMPLE(%3Fplace_label)%20AS%20%3Fplace_label)%0A(SAMPLE(%3FpartOf_label)%20AS%20%3FpartOf_label)%0A(SAMPLE(%3Fyear)%20AS%20%3Fyear)%0A(SAMPLE(%3Fimage)%20AS%20%3Fimage)%0A(SAMPLE(%3Flayer)%20AS%20%3Flayer)%0A(SAMPLE(%3Fcoords)%20AS%20%3Fcoords)%0A(SAMPLE(%3Frgb)%20AS%20%3Frgb)%0AWHERE%20%7B%0A%20%20%7B%0A%20%20%20%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279*%20wd%3AQ178561%20.%20%0A%20%20%7D%20UNION%20%7B%0A%20%20%20%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279*%20wd%3AQ188055%20.%20%0A%20%20%7D%0A%20%20%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3Fitem_label%20.%0A%20%20%20%20FILTER(LANG(%3Fitem_label)%20IN%20('fr'%2C%20'en'))%20.%0A%20%20%7D%0A%20%20%0A%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%3Fitem%20wdt%3AP361%20%3FpartOf%20.%0A%20%20%20%20%3FpartOf%20rdfs%3Alabel%20%3FpartOf_label%20.%0A%20%20%20%20FILTER(LANG(%3FpartOf_label)%20IN%20('fr'%2C%20'en'))%20.%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP18%20%3Fimage%20.%20%7D%0A%20%20%0A%20%20%23%20Place%0A%20%20%3Fitem%20wdt%3AP276%20%3Fplace%20.%0A%20%20%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fplace%20rdfs%3Alabel%20%3Fplace_label%20.%0A%20%20%20%20FILTER(LANG(%3Fplace_label)%20IN%20('fr'%2C%20'en'))%20.%0A%20%20%7D%0A%20%20%0A%20%20%23%20Coords%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP625%20%3FcoordsItem%20.%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fplace%20wdt%3AP625%20%3FcoordsPlace%20.%20%7D%0A%20%20BIND(COALESCE(%3FcoordsItem%2C%20%3FcoordsPlace)%20AS%20%3Fcoords)%0A%20%20%0A%20%20%23%20Date%0A%20%20%3Fitem%20(wdt%3AP585%7Cwdt%3AP580%7Cwdt%3AP582)%20%3Fdate%20.%0A%20%20BIND(YEAR(%3Fdate)%20AS%20%3Fyear)%20.%0A%20%20%0A%20%20%23%20Layer%0A%20%20VALUES%20(%3Flayer%20%3Fmin%20%3Fmax%20%3Frgb)%20%7B%0A%20%20%20%20(%22Prehistory%22%20-100000%20-3500%20%220078BF%22)%0A%20%20%20%20(%22Ancien%20History%20-3500%20%E2%86%92%20500%22%20-3500%20500%20%22DDD700%22)%0A%20%20%20%20(%22Middle%20Ages%20500%20%E2%86%92%201500%22%20-500%201500%20%225BD500%22)%0A%20%20%20%20(%22Early%20Modern%20Period%201500%20%E2%86%92%201750%22%201500%201750%20%2200CE23%22)%0A%20%20%20%20(%22Mid%20Modern%20Period%201750%20%E2%86%92%201914%22%201750%201914%20%2200C699%22)%0A%20%20%20%20(%22Contemporary%20Period%201914%20%E2%86%92%20present%22%201914%203500%20%220078BF%22)%0A%20%20%7D%0A%20%20FILTER%20(%3Fmin%20%3C%3D%20%3Fyear%20%26%26%20%3Fyear%20%3C%20%3Fmax)%0A%0A%7D%20GROUP%20BY%20%3Fitem%20ORDER%20BY%20%3Fyear%20%3Fbattle Battles with location and date in Wikidata] (source)
 * Pictures depicting a kiss with IIIF manifest (source)
 * Software-related companies founded by women (source)
 * Films based on video games (source)
 * Newest database reports: Vasily
 * Showcase items: Fugger


 * Development
 * Fixed a bug that was saving the statement too early when trying to add a qualifier with the keyboard (T154869)
 * Made changes to disallow edits (until the user reloads) if they accidentally get logged out. (T124451)
 * Turn the new change tag back on wikidatawiki (T208846)
 * Better linting against things that don't work in IE11
 * Fixed the wdqs-frontend docker image (T208681, T209206)
 * Fixed html elements in the table result of wdqs (T207257, thanks to user:Frog23)
 * Getting ontology changes deployed to wikiba.se
 * Using maplink or mapframe to view coords on wikidata (T184933)
 * Consistent capitalization of Lexeme/Form/Sense/Item/Property in UI messages
 * Make Lexemes appear in global usage of Commons files (T204066)
 * Work on a new interface for the termbox on mobile (T207150)

You can see all open tickets related to Wikidata here. If you want to help, you can also have a look at the tasks needing a volunteer.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

Read the full report &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 11:18, 20 November 2018 (UTC)

Nomination for deletion of Template:Infobox star
Template:Infobox star has been nominated for deletion. You are invited to comment on the discussion at the template's entry on the Templates for discussion page. Andy Mabbett ( Pigsonthewing ); Talk to Andy; Andy's edits 16:49, 20 November 2018 (UTC)

Cochrane Update bot en français
Hi Mike, I hope that you are well and are having a nice fall. The Cochrane bot is running very smoothly. I would like to intorduce you to a new Wikipedian who works with Cochrane France, Sylvian. He is interested in learning more about your bot and possibly designing one for his project in French Wikipedia (similar to the work I am doing in english). Sylvian may have a few questions for you, if you don’t mind. Thanks again, Jenny JenOttawa (talk) 14:09, 25 October 2018 (UTC)
 * Sure, I'd be happy to help. It's probably quite easy to modify the code to do the same thing on frwp - just change the names of the parameters and templates it uses. I'd be happy to make those changes and set pi bot running it regularly if that would be useful (and pointers to examples can be given). Thanks. Mike Peel (talk) 11:12, 26 October 2018 (UTC)
 * Thanks for the quick reply Mike and offer to help. I will forward this message on to . JenOttawa (talk) 00:24, 28 October 2018 (UTC)
 * Hi Mike, Sylvain is definitely interested in setting this up. Do you want me to create a new project page for the french bot? https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Medicine/Cochrane_update Thanks again!JenOttawa (talk) 14:17, 30 October 2018 (UTC)
 * I've started modifying the code, which is at . It's currently not editing the articles to add the update inline template (since that would probably need bot approval), but it is outputting the list, currently to fr:Utilisateur:Mike Peel/Brouillon. See how that looks? To take this further, I'd need to see examples of how Cochrane references are coded on frwp (so that the regexes can be improved to make sure we find all the articles), and my french probably needs some copyediting. ;-) Thanks. Mike Peel (talk) 15:44, 1 November 2018 (UTC)
 * Wow, that is great. I emailed Sylvain to get his feedback. Thanks Mike. JenOttawa (talk) 16:57, 1 November 2018 (UTC)
 * Thank you Mike for starting this so quickly ! I've started to check how cochrane is sourced on frwp, and when I'm doing a search on wikipedia with cochrane specific DOI or general search  I am finding a big gap (200 vs 800 results). Even if all results from the general search term will not be relevant, I suspect that a lot of cochrane sources included in frwp does not refere to PMID or DOI... What do you think ?. --Sylvain.juchet (talk) 10:52, 6 November 2018 (UTC)
 * The code currently looks for pages that mention 'Cochrane' in the 'périodique' or 'titre' parameter of a reference. It then looks for the PMIDs in those pages and uses those to see if updates are available. I've put a list of the ones it currently finds/checks at fr:Utilisateur:Mike Peel/Cochrane used. The Cochrane DOI isn't currently used, but the PMID is essential for the bot to work. If you can identify patterns that people have used for the Cochrane references on frwp then I can try to modify the bot to also find those. Thanks. Mike Peel (talk) 15:26, 6 November 2018 (UTC)
 * Hi and Mike, I just wanted to follow up on this and see if there is anything that I can do to help. JenOttawa (talk) 14:26, 13 November 2018 (UTC)
 * Hi I think that for frwp the most reliable source to find cochrane references is the review ID (CD + 6 numbers). I tried to follow that. We will probably start here by taking the work you have already done on enwp : listing all enwp articles that have recent (2017-2018) cochrane references already translated in french, find the corresponding frwp article, to make a list kind like this (I may add the link to the enwp in the list also). Then later on, when we will be more confident on our wiki editing, we can start to add new references on new articles... What do you think ? --Sylvain.juchet (talk) 13:42, 14 November 2018 (UTC)
 * Hi, since the bot in english Wikipedia seems to be working quite well with few errors, it would be make sense to also go ahead and get permission to run the same bot in french. I find that people add citations using different methods. PMID/DOI are ideal, but some are missed this way. You probably want two tools Sylvain, similar to in english Wikipedia. A tool to keep the content that is already in french WP up to date, and a tool to keep track of where your citations are and where the holes are (or what reviews that have been translated are not yet in Wikipedia). Not sure if this helps... JenOttawa (talk) 14:03, 14 November 2018 (UTC)
 * Please let me know if there's anything I can do to help - I'm happy to make modifications to the bot code as needed so that it works on frwp. Thanks. Mike Peel (talk) 21:29, 15 November 2018 (UTC)
 * Hi Mike, if you do have the time can we go ahead and make a bot that works the same way in english Wikipedia on the french side? I know that you do a lot of volunteer work, so not pressure here at all! Once we get a basic bot (that works in a similar fashion to en), we can make it more precise/incorporate french translated reviews. I think that you mentioned that we need to go through the same application process as for the english bot? Can I help at all if you are interested in doing this. Thanks!JenOttawa (talk) 18:08, 19 November 2018 (UTC)
 * What I've done already is basically copy-paste the enwp bot and started to make the frwp-specific changes. It's basically ready to go. The main issue is language-based - how's your French? Mine's rather basic! The frwp bot request page is at fr:Wikipédia:Bot/Statut - basically a translation of Bots/Requests for approval/Pi bot 3 would need to be posted there before I can turn on the part of the code that adds fr:Modèle:Passage à actualiser to the articles. Thanks. Mike Peel (talk) 13:07, 20 November 2018 (UTC)
 * I can translate it Mike. Do you mind highlighting what needs to be shared? Thanks again!JenOttawa (talk) 16:08, 21 November 2018 (UTC)
 * Is this what you are thinking? https://en.wikipedia.org/wiki/User:JenOttawa/translating_french_pi_bot_request JenOttawa (talk) 16:14, 21 November 2018 (UTC)
 * Yup, that's about it. Perhaps remove the line on "Links to relevant discussions" (those discussions probably aren't relevant here), and if there's a cochrane update page on frwp already then link to that rather than the enwp one. The new source code link is Thanks. Mike Peel (talk) 16:36, 21 November 2018 (UTC)
 * OK nearly done (I think)User:JenOttawa/translating french pi bot request. I will have it proof ready by tonight. Hope you have a very Happy Thanksgiving!!!! JenOttawa (talk) 01:57, 23 November 2018 (UTC)
 * That looks good, thanks! I've made some tweaks for frwp-specific things (primarily template names). Happy thanksgiving! Thanks. Mike Peel (talk) 10:06, 23 November 2018 (UTC)
 * Thanks for taking a look. I just had a native french speaker take a quick look and he says it looks fine for now. I am not completely bilingual but I live with four franco-ontarians so I consider myself in a permanent french immersion program. Sylvain may have some tweaks but we can probably make these after it is posted. Do you want me to go ahead and post on the bot request page, or do you want to do it (under your username)? Hope you had a nice holiday yesterday. We had our Thanksgiving in October but Canadians are wild for Black Friday. I am going for a walk in the woods to celebrate in my own way!!! Have a nice long weekend and thanks again! JenOttawa (talk) 13:26, 23 November 2018 (UTC)
 * That's great, thanks! I've posted it on frwp now, at fr:Wikipédia:Bot/Statut, let's see how the bot request goes. Thanksgiving isn't a thing here in Brazil, but there was the Proclamation of the Republic (Brazil) holiday last week and there's also Independence Day (Brazil) in September. Black Friday is also big here though! Enjoy the walk in the woods! Thanks. Mike Peel (talk) 13:45, 23 November 2018 (UTC)
 * Great, I sent Sylvain an email to get him up to speed. Have a nice weekend! JenOttawa (talk) 15:14, 23 November 2018 (UTC)

List of Reviews currently used on Wikipedia
Hi Mike, is the code that you used to generate the Nov 18 list the first part of the code you use for the Cochrane bot? Thanks! JenOttawa (talk) 13:40, 26 November 2018 (UTC)
 * Almost, it's actually this code. Thanks. Mike Peel (talk) 13:45, 26 November 2018 (UTC)
 * Great, thanks. This is super helpful! JenOttawa (talk) 14:14, 26 November 2018 (UTC)

Wikidata weekly summary #340
Here's your quick overview of what has been happening around Wikidata over the last week. 
 * Discussions
 * New request for comments: Referencing websites: how do we store the website title?, Many surname items had been un merged because of failure to communicate.


 * Events
 * Past: women editathon in Mexico City, November 24th
 * Past: Wikidata "Train the trainers" workshop in Berlin, November 23th-25th
 * Running: WikiCite 2018, November 27th-29th, Berkeley, California, USA. Some livestream will be provided on Youtube
 * Upcoming: Wikidata "Train the trainers" workshop in Vienna, November 30th-December 2nd
 * Upcoming: Wikidata meetup in Berlin, with a focus on Open Refine, January 15th


 * Press, articles, blog posts, videos
 * Wikidata-related videos during GLAMwiki conference:
 * Wikidata — What's new - Jens Ohlig
 * A Gentle Introduction to Wikidata for Absolute Beginners - Asaf Bartov
 * SPARQL workshop - Maarten Dammers
 * Engaging GLAM institutions with Wikidata - Sharing Experiences and Techniques - Andrew Lih
 * Sum of all Paintings and Open Data - Maarten Dammers
 * Wikidata’s role in metadata creation and reuse workflows in libraries - Michelle Futornick
 * Open your structured GLAM data with Wikibase — install your own instance of the technology behind Wikidata - Jens Ohlig
 * Impact and potential of structured data on Wikimedia projects for the GLAM sector - Sandra Fauconnier
 * Structured Data on Wikimedia Commons - Introduction and panel of Wikimedia pilots
 * Introduction to Wikidata in 7min by Asaf Bartov
 * Introduction to Wikidata by Lydia Pintscher in 20min, during Shani Evenstein's university course about Wikidata


 * Other Noteworthy Stuff
 * Wikidata Senses (documentation), new tool by User:Vesihiisi to add senses to lexemes
 * The Swedish National Heritage Board has started working on a project, related to Structured Data on Commons, that focuses on ways to feed back improved (crowdsourced) metadata to cultural institutions who contribute media files to Wikimedia Commons.
 * Please alert your GLAM partners to a new survey about crowdsourcing, metadata and Wikimedia Commons, which informs the research for this project!
 * Scribe, a project to support under-resourced Wikipedias based on Wikidata's content, has been proposed for a grant
 * Tool to convert Wikibase JSON to RDF without storing it in a repository
 * Call for paper for the data quality workshop in Berlin on January 18th. Open until December 3rd


 * Did you know?


 * Newest properties:
 * General datatypes: running mate, research site, quotes work
 * External identifiers: World Poker Tour player ID, GLAMOS glacier ID, Academy Awards Database nominee ID, ANICA ID, National Portrait Gallery (United States) object ID, r-hockey.ru person ID, Sotheby's Museum Network ID, MNAV artist ID, Google News publication ID, ALCA author ID, Atlas of Florida Plants ID, BoardGeekGame game publisher ID, Invasive Plant Atlas of the United States ID, Luding game publisher ID, NAS ID, Depósito Legal ID, Corpus typographique français ID, British Executions ID, Bantu Lexical Reconstructions ID, Welsh Book Trade Info ID, System16 identifier, Académie d'Arles member ID, Sega Saturn game ID, Bitraga author ID, TWAS Fellow ID, Bitraga work ID, Cal-IPC ID, EUNIS ID, Dimensions Author ID, Dimensions Publication ID, Dimensions Source ID, Disney A to Z ID


 * New property proposals to review:
 * General datatypes: language use, has variant, has version, rationale text, HABS ID, Wikia Article URL, CNPJ
 * External identifiers: AJOL ID, Microsoft Academic Source ID, GameFAQs company ID, BDFA player ID, Sabinet ID, NSW State Archives and Records Authority Agency ID, Guida al fumetto italiano ID, Bygdeband location, OeBL 1815-1950 ID, Badtaste ID, Badgames ID, defined term ID, Wikia Article ID, Female mexican soccer players ID, Geolex ID, OBV editions, BBC News topic id, member of the Portuguese parliament ID


 * Query examples:
 * Place and century of discovery of the archaeological objects of St Raymond museum (France) (source)
 * Location of city halls in Spain (source)
 * Timeline of famous pirates (source)
 * Authors who are the most cited in Nature Chemistry (source)
 * Scholarly articles published about Wikidata (adapted from here)
 * [https://query.wikidata.org/#%23The%20world's%20tallest%20200%20mountains%2C%20and%20if%2Fwhen%20they%20were%20first%20climbed.%0A%23defaultView%3AMap%0ASELECT%20DISTINCT%20%3Fmountain%20%3FmountainLabel%20(sample(%3Fheight)%20as%20%3Fheight)%20(year(%3Fdate)%20as%20%3Fyear)%20(sample(%3Flocation)%20as%20%3Flocation)%20%3Flayer%0AWHERE%0A%7B%0A%20%20%3Fmountain%20wdt%3AP31%20wd%3AQ8502%20.%20%23%20Everything%20that's%20a%20mountain%0A%20%20%3Fmountain%20wdt%3AP625%20%3Flocation%20.%20%23%20and%20has%20a%20coordinate%0A%20%20%3Fmountain%20p%3AP2044%20%3Fheightstatement%20.%20%23%20and%20has%20a%20height-statement%0A%20%20%3Fheightstatement%20psv%3AP2044%20%3FPSVStatement.%20%23%20normalised%20height%20statement%0A%20%20%3FPSVStatement%20wikibase%3AquantityNormalized%20%3Fanother_statement%20.%0A%20%20%3Fanother_statement%20wikibase%3AquantityAmount%20%3Fheight.%23%20height%20-%20phew!%0A%20%20FILTER(%3Fheight%20%3E%206000)%20%23%20only%20the%20tallest%0A%20%20OPTIONAL%20%7B%20%0A%20%20%20%20%3Fmountain%20p%3AP793%20%3Fevent%20.%20%23%20and%20within%20that%20%22significant%20event%22%20statement%0A%20%20%20%20%3Fevent%20ps%3AP793%20wd%3AQ1194369%20.%20%23%20continued...%0A%20%20%20%20%3Fevent%20pq%3AP585%20%3Fdate%20.%20%23it%20has%20a%20%22point%20in%20time%22%20qualifier%20statement.%0A%20%20%20%20bind%20(%22Climbed%22%20as%20%3Flayer)%20%23%20this%20seems%20to%20be%20what%20we%20need%20to%20get%20colour%20labels%20-%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20ie%20if%20it%20falls%20in%20the%20optional%20group%20of%20%22was%20first%20summited%22%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20then%20bind%20to%20a%20new%20layer%2C%20otherwise%20no%20special%20layer%0A%20%20%7D%20%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0Agroup%20by%20%3Fmountain%20%3FmountainLabel%20%3Fdate%20%3Flayer%0AORDER%20BY%20DESC%20(%3Fheight)%0ALIMIT%20200 The world's 200 tallest mountains, and whether Wikidata knows they've been climbed] (source)
 * Newest WikiProjects: WikiProject Kākāpō, WikiProject Scholia
 * Newest database reports: Fugger


 * Development
 * Fix an error when entering an incomplete filename (T199420)
 * Fix the unreadable references for unpriviledged users (T186006)
 * Create new page properties for number of Forms and Senses of a Lexeme (T199611)
 * Adapt the API to efficiently format large numbers of entity IDs (T207484)
 * Switch "save" to "publish" in the Lexeme interface (T203354)
 * Fix a bug showing outdated link formats in the history of Lexemes (T208423)
 * Add Special:MergeLexemes to Special:SpecialPages (T204397)
 * Add Wikipedia link in the other projects sidebar of Wikisource (T180303, thanks to Tpt)
 * Work on displaying the language of the gloss with the language name, both in reading and editing mode (T203457, T209931)
 * More work on improving the interface of the termbox on mobile

You can see all open tickets related to Wikidata here. If you want to help, you can also have a look at the tasks needing a volunteer.


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

Read the full report &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 11:39, 27 November 2018 (UTC)

Facto Post – Issue 18 – 30 November 2018
MediaWiki message delivery (talk) 11:20, 30 November 2018 (UTC)

This Month in Education: November 2018
About This Month in Education · Subscribe/Unsubscribe · Global message delivery · For the team: Romaine 18:18, 30 November 2018 (UTC)

The Signpost: 1 December 2018
 * Read this Signpost in full * Single-page * Unsubscribe * MediaWiki message delivery (talk) 04:47, 1 December 2018 (UTC)

Administrators' newsletter – December 2018
News and updates for administrators from the past month (November 2018). Administrator changes
 * Gnome-colors-view-refresh.svg Al Ameer son • Randykitty • Spartaz
 * Gnome-colors-list-remove.svg Boson • Daniel J. Leivick • Efe • Esanchez7587 • Fred Bauder • Garzo • Martijn Hoekstra • Orangemike

Interface administrator changes
 * Gnome-colors-list-remove.svgk Chan

Guideline and policy news
 * Following a request for comment, the Mediation Committee is now closed and will no longer be accepting case requests.
 * A request for comment is in progress to determine whether members of the Bot Approvals Group should satisfy activity requirements in order to remain in that role.
 * A request for comment is in progress regarding whether to change the administrator inactivity policy, such that administrators "who have made no logged administrative actions for at least 12 months may be desysopped". Currently, the policy states that administrators "who have made neither edits nor administrative actions for at least 12 months may be desysopped".
 * A proposal has been made to temporarily restrict editing of the Main Page to interface administrators in order to mitigate the impact of compromised accounts.

Technical news
 * Administrators and bureaucrats can no longer unblock themselves unless they placed the block initially. This change has been implemented globally. See also this ongoing village pump discussion (permalink).
 * To complement the aforementioned change, blocked administrators will soon have the ability to block the administrator that placed their block to mitigate the possibility of a compromised administrator account blocking all other active administrators.
 * Since deployment of Partial blocks on Test Wikipedia, several bugs were identified. Most of them are now fixed. Administrators are encouraged to test the new deployment and report new bugs on Phabricator or leave feedback on the Project's talk page. You can request administrator access on the Test Wiki here.

Arbitration
 * Voting in the 2018 Arbitration Committee Elections is open to eligible editors until Monday 23:59, 3 December 2018. Please review the candidates and, if you wish to do so, submit your choices on the voting page.

Miscellaneous
 * In late November, an attacker compromised multiple accounts, including at least four administrator accounts, and used them to vandalize Wikipedia. If you have ever used your current password on any other website, you should change it immediately. Sharing the same password across multiple websites makes your account vulnerable, especially if your password was used on a website that suffered a data breach. As these incidents have shown, these concerns are not pure fantasies.
 * Wikipedia policy requires administrators to have strong passwords. To further reinforce security, administrators should also consider enabling two-factor authentication. A committed identity can be used to verify that you are the true account owner in the event that your account is compromised and/or you are unable to log in.

Obituaries
 * (Raymond Arritt) passed away on 14 November 2018. Boris joined Wikipedia as on 8 May 2006 and was an administrator from 30 July 2007 to 2 June 2008.

Discuss this newsletter

Subscribe

Archive Sent by MediaWiki message delivery (talk) 03:36, 3 December 2018 (UTC)

Wikidata weekly summary #341
Here's your quick overview of what has been happening around Wikidata over the last week. 
 * Discussions
 * New request for comments: How to handle heat treating as a qualifier for material properties ?
 * New development input: Identify problems with adding new languages into Wikidata


 * Events
 * Upcoming: "Researcher meets Curator", with a subquestion: "What are the consequences of collecting born digital sources, working with digital network analysis and engaging with linked open data initiatives such as Wikidata", in Maastricht on 22 March 2019. Call for papers
 * Upcoming: Advanced Wikidata Training in India, December 15-16
 * Past: "Wikibase: configure, customize, and collaborate" workshop at SWIB 18 in Bonn, Germany on November 26, 2018. Workshop materials
 * Past: EveryPolitician event to identify political data sources for Wikidata in Madrid, Spain, on December 1, 2018.


 * Other Noteworthy Stuff
 * Author Disambiguator (github source), new tool by d:User:ArthurPSmith (based on SourceMD) for linking author items to their works.
 * OpenRefine 3.1 was released
 * New API module to format multiple entity IDs
 * You can now access the number of Forms and Senses of Lexemes through API and special page


 * Did you know?


 * Newest properties:
 * General datatypes: reference has role, tautomer of, eponymous category, language style, ratified by, funding scheme
 * External identifiers: GameFAQs company ID, AJOL journal ID, LEGO set ID, BDFA player ID, Sabinet journal ID, NSW State Archives and Records Authority Agency ID, Bygdeband location ID, Austrian Biographical Encylopedia ID, Badtaste ID, Badgames ID, Mexican female soccer players ID, member of the Portuguese parliament ID, BBC News topic ID, OBV editions ID, Geolex ID, CNPJ, Defined Term ID, Guida al Fumetto Italiano ID


 * New property proposals to review:
 * General datatypes: gained independence from, nachgewiesen mittels, measured by (KPI), OpenTrials ID, administrated by the administrative territorial entity, level of description, stored as lexeme, taxon author citation, Astronomical coordinates, catchphrase, real estate developer, Danske Taler speaker
 * External identifiers: TrENSmissions person ID, LIGA profile, SEINet ID, BIBSYS work ID, Jewish Museum Berlin person ID, UK Parliament Identifier, HAER ID, Vesti.kz person ID, Genius album ID, Genius song ID, TASS reference, DIR3 ID, NooSFere story ID, L'Encyclopédie philosophique ID, RegiowikiAT ID, Discord Store game SKU, kohanimeregister, ARLLFB member ID, ARB person ID, Biographie nationale de Belgique ID, protected area authority ID, Flora of Wisconsin ID, identifiant Monument aux morts


 * Query examples:
 * Timeline of early Western movies (source)
 * Species represented in the exhibition "Espèces en voies d'illumination" in the natural history museum of Paris (source)
 * Properties most used to describe cats in Wikidata (source)
 * List of UK embassies (source)
 * Map of places of residence for accused witches in Scotland with a layer for occupations (source)

You can see all open tickets related to Wikidata here. If you want to help, you can also have a look at the tasks needing a volunteer.
 * Development
 * Add Lexeme to Wikibase's ontology.owl (T195368)
 * Prepare to drop change_tag.ct_tag column (T194163)
 * Create Federated Wikibase instance on Beta Commons (T204748)
 * More work on preparing a new termbox for the mobile version of Wikidata


 * Monthly Tasks
 * Add labels, in your own language(s), for the new properties listed above.
 * Comment on property proposals: all open proposals
 * Suggested and open tasks!
 * Contribute to a Showcase item.
 * Help translate or proofread the interface and documentation pages, in your own language!
 * Help merge identical items across Wikimedia projects.
 * Help write the next summary!

Read the full report &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 13:35, 4 December 2018 (UTC)