User talk:Mike Peel/Archive 30

Wikidata weekly summary #288
Here's your quick overview of what has been happening around Wikidata over the last week. 
 * Discussions
 * New request for comments: start time / end time vs. publication date of 1st / last episode
 * Proposal to add some order and structure to the various bibliographic corpora we currently have in Wikidata (mailing list post)


 * Events/Press/Blogs
 * Past: IRC office hour about Structured Data on Wikimedia Commons. You can read the log on meta.
 * Upcoming: Wikidata workshop in Prague, December 1st
 * Well structured political data for the whole world: impossible utopia, or Wikidata at its best?
 * Spatial-based Topic Modelling using Wikidata Knowledge Base (in Wikidata as Q43662744)
 * Cleaning BNF identifier in Wikidata by Envlh (in French)
 * Monitoring changes to Wikidata pages of your interest by Egon Willighagen


 * Other Noteworthy Stuff
 * Sandra is co-ordinating an inventory of crucial volunteer tools for Wikimedia Commons, GLAM, and structured data in general. You can provide input and prioritize your favorite tools in this Google spreadsheet.
 * Q43649390 is an item about our concept of "QID"s
 * OpenRefine 2.8 was released. Adding columns from Wikidata and importing Wikitables is now possible.


 * Did you know?


 * Newest properties: type foundry, Accademia della Crusca ID, first appearance, USGHOF athlete ID, Kulturelles Erbe Köln object ID, Städel Museum artist ID, Berlinische Galerie artist ID, Tidal video ID, Tidal track ID, Tidal album ID, Tidal artist ID, HTML entity, Norwegian historical register of persons ID, Merchant Category Code, SS KL Auschwitz Garrison ID, West Australian Football League player ID, Wikidata project, BPH journal ID, SNCZI-IPE reservoir ID, BTO five-letter code, awarded for period, electoral district number, Art Museum of Estonia artwork ID, Art Museum of Estonia artist ID, Japanese Baseball Hall of Fame ID, Basketball-Reference.com WNBA ID, National Collegiate Basketball Hall of Fame ID, IJF ID, SNCZI-IPE dam ID, Indiana Basketball Hall of Fame ID, FAI ID, Canada Games ID, ICRC PoW ID, RA Collections ID, mountain range, Everyone Remembered ID, CNRS research group ID, ARLIMA ID


 * Query examples:
 * People who were Time Person of the Year in two consecutive years (source)
 * Fictional characters “said to be the same as” other fictional characters from the same fictional universe (source)
 * Map of places of birth of deceased sociologists (source)
 * Map of libraries in India (source)
 * [https://query.wikidata.org/#%23defaultView%3AMap%0ASELECT%20%3Ftrain_station%20%3Fcoordinate_location%20%3Flayer%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22eu%22.%20%7D%0A%20%20%3Ftrain_station%20%28wdt%3AP31%2Fwdt%3AP279%2a%29%20wd%3AQ719456.%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP361%20wd%3AQ10862037.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP361%20wd%3AQ123955.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP361%20wd%3AQ149274.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP361%20wd%3AQ2946410.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP81%20wd%3AQ43283383.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP361%20wd%3AQ3239365.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP81%20wd%3AQ43283518.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Ftrain_station%20wdt%3AP81%20wd%3AQ43325427.%20%7D%0A%20%20MINUS%20%7B%20%3Ftrain_station%20%28wdt%3AP131%2Fwdt%3AP131%29%20wd%3AQ55180.%20%7D%0A%20%20MINUS%20%7B%20%3Ftrain_station%20%28wdt%3AP131%2Fwdt%3AP131%29%20wd%3AQ55271.%20%7D%0A%20%20%3Ftrain_station%20wdt%3AP625%20%3Fcoordinate_location.%0A%20%20%3Ftrain_station%20wdt%3AP81%20%3Fconnecting_line.%0A%20%20MINUS%20%7B%20%3Fconnecting_line%20wdt%3AP81%20wd%3AQ5852245.%20%7D%0A%20%20MINUS%20%7B%20%3Fconnecting_line%20wdt%3AP81%20wd%3AQ801991.%20%7D%0A%20%20%3Fconnecting_line%20rdfs%3Alabel%20%3Flayer.%0A%20%20FILTER%28%28LANG%28%3Flayer%29%29%20%3D%20%22eu%22%29%0A%7D Train and subway stations in Basque Country] (source)
 * Newest database reports: Decameron editions and translations


 * Development
 * Result views in the Wikidata Query Service UI can now be configured with options (T155973, Special:Diff/580233265/596922582)
 * Worked more on introducing the concept of sub.entities in the APIs in order to make edits to Forms persistent
 * Worked on edit summaries for edits to Forms

You can see all open tickets related to Wikidata here.


 * 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:44, 27 November 2017 (UTC)

Infobox map errors
There is a problem with Template:Infobox power station, being discussed here: Template talk:Infobox power station. But among the power stations there are a few telescopes and World Heritage Sites with broken maps. It looks like the same error, but I can see no recent changes anywhere that caused it, here or on Wikidata. It’s possibly buried deep in a template. As you worked on both templates you might have a better idea. Here’s the non-power station articles with errors.

-- JohnBlackburne wordsdeeds 19:45, 27 November 2017 (UTC)
 * Beckhampton Avenue
 * Clover (telescope)
 * Cosmic Background Imager
 * Douro DOC
 * Laurel forest
 * MERLIN
 * MiniGrail
 * Thanks for the heads-up. It looks like another editor fixed it before I could get to it. :-) Thanks. Mike Peel (talk) 20:47, 27 November 2017 (UTC)

This Month in Education: November 2017
This Month in Education  Volume 6 | Issue 10 | November 2017

This monthly newsletter showcases the Wikipedia Education Program. It focuses on sharing: your ideas, stories, success and challenges. You can see past editions here. You can also volunteer to help publish the newsletter. Join the team! Finally, don't forget to subscribe!

In This Issue

Subscribe/Unsubscribe · Global message delivery · For the team: Romaine 17:23, 1 December 2017 (UTC)

Cochrane Update bot
Hi. Thank you very much for offering to help with the Cochrane update bot. Unfortunately, I don't have a copy of the code. , do you know where we can find the actual code that the previous volunteer used? provided us with more information about dexbot here on his talk page. James, do you know if the Cochrane update bot has gone through an approval process already? Thanks again for offering to help Mike. It is a pleasure meeting yet another friendly Wikipedian! JenOttawa (talk) 01:30, 22 November 2017 (UTC)
 * User:Ladsgroup runs the bot. I will ask if he can share the code. Doc James  (talk · contribs · email) 01:44, 22 November 2017 (UTC)
 * That would be great. Thanks .JenOttawa (talk) 01:53, 22 November 2017 (UTC)

This is the code, it's super straightforward Ladsgroupoverleg 15:10, 26 November 2017 (UTC)


 * Thank you . We greatly appreciate all your help putting this together and running the bot. It has been a useful tool for us, and volunteers have now completed almost all of the updates that were flagged in August!, is there anything else that I can help with? Do you think that this would be feasible for you? If there is anything that I can do to help, please let me know. Thank you again to both of you! JenOttawa (talk) 15:23, 27 November 2017 (UTC)

OK, so it runs on my desktop, which is a good start. :-) I've put a copy at, and I've just been doing some test runs. I've added some caching code so that it only fetches a given report once to check if it's been updated, which speeds it up a little. Hopefully and  are the desired edits.

I have a few questions :
 * When starting it up, it says "WARNING: API warning (search): The regex search timed out, only partial results are available. Try simplifying your regular expression to get complete results. Retrieving 50 pages from wikipedia:en." - any idea how to improve this?
 * It currently updates WikiProject Medicine/Cochrane update/August 2017 - wouldn't it be better to post updates at WikiProject Medicine/Cochrane update instead? Also, would it help if it auto-archived lines marked with ✅ at the start of the run?
 * If exists anywhere in the page, it doesn't do an update, even if that's not associated with the reference that needs updating. Would it be feasible to change this to e.g.  (where '10484104' is the pubmed ID), or would that break too many pages?
 * I'll run this by the Bot Approval Group shortly, and after that I'll set Pi bot to run the script on the 1st of every month, is that OK or would a different date/frequency be better?

Thanks. Mike Peel (talk) 22:14, 27 November 2017 (UTC)
 * Hi Mike, thanks for doing all this work.
 * In the past, when ran a new version of the bot, it created a new bot page with the date. I am not sure exactly how it works, but my understanding is that each time the bot was run, it re-did all the previous "update needed" tags making a new project page with all the Cochrane updates needed across Wikipedia. If you have the bot set up to add only new reviews to the most recent version (Aug17) and remove the ✅ PMIDs, that is great. Adding to the August page is actually helpful, as the vounteers already have this link and are presently accessing it.  do you agree with me here?
 * I appreciate you offering to run it once a month. This is helpful.
 * no-wiki's: I believe this is in place in case an editor wants to cite an outdated Cochrane review in a historical context within an article. I am glad that you noticed this, as it means we could be missing some updates. If you can make it more specific for Cochrane reviews, that would be great.

Thanks again, JenOttawa (talk) 14:14, 28 November 2017 (UTC)
 * Yes the " " is for the times when we want to use an old review. Not often but sometimes.  Doc James  (talk · contribs · email) 15:23, 28 November 2017 (UTC)
 * OK, archiving is now coded up, and I've run it once manually. I've also now submitted the bot request. Please have a look at both and let me know if there are any problems! Thanks. Mike Peel (talk) 21:00, 28 November 2017 (UTC)
 * Hi Mike, thanks for taking care of all this admin work involved with setting this up. I noticed the one new review added to the August page here, and that it archived all the updates marked ✅. Once you run the bot automatically will it pull the up the additional updates? I would expect at least 20, as it has been nearly 4 months since we have run it. I also looked at your proposal and it looks great. The in-text "update needed" tag looks good as well. Is there anything else that you want me to look at? Thanks again, JenOttawa (talk) 18:26, 30 November 2017 (UTC)
 * Do you have any suggestions on what to do in the case of the "withdrawn" cochrane review. There can be various reasons that Cochrane marks their reviews in this manner, not all negative. For now, I will leave the citation as the most recent non-withdrawn review, however I do not want to mark this with a "done" or put a no-update needed tag in the article, in case Cochrane comes out with a newer non-withdrawn review. I can also just leave these in the list for now, as they are not very frequent.
 * e.g: The one citation added to list was this one, and the newest, 2016 version, has been withdrawn.
 * Article Acupuncture (edit) old review PMID:27145001 new review PMID:27852100 - 22:07, 27 November 2017 (UTC)
 * Thanks! JenOttawa (talk) 18:30, 30 November 2017 (UTC)
 * I only ran the code up to the point where it made its first edit, hence why only one update was posted - the first run by Pi bot will do the rest. I was wondering about the 'withdrawn' status of the update. What happens when a new update is posted that isn't withdrawn - does the replacement ID in the first article get updated to the non-withdrawn one, or does the withdrawn one get a replacement ID? Would it help if there was a separate way of tracking the uses of ones that have been marked as withdrawn (both current refs and updated refs)? It might be best to talk to others and let me know what the ideal process would be here, and I can see if I can add code that does that. Thanks. Mike Peel (talk) 21:04, 1 December 2017 (UTC)
 * Great points. I think it makes separate to separate these tasks, but I am open to suggestions! I am not certain the answer to your question regarding an update to a withdrawn review, I will look into it. I have access to an excel doc on file with DOIs for all withdrawn reviews to date (for future use). All looks good (from what I can see with the bot). I have volunteers ready to go, so your work is very helpful for our project! If I can help you with anything else, please let me know. JenOttawa (talk) 21:10, 1 December 2017 (UTC)

Wikidata weekly summary #289
Here's your quick overview of what has been happening around Wikidata over the last week. 
 * Events/Press/Blogs
 * Past: Using the Digital to Engage Archival Radio Collections: Part II (Wikidata Workshop), Washington, D.C., November 2, 2017 with Andrew Lih and Alex Stinson
 * Past: Wikidata Clinic (slides) in Washington, D.C., December 1, 2017, with Andrew Lih and Rosie Stephenson-Goodknight
 * Past: Wikikonference in Prague with a Wikidata workshop in Czech and a introduction of Wikidata and its community
 * Wikipedia Weekly audio podcast coverage of Wikidata:
 * Episode 126 - Introduction to Wikidata, with Andrew Lih and Rob Fernandez
 * Episode 127 - WikidataCon 2017 roundtable discussion, with Andrew Lih, Liam Wyatt, Stacy Allison-Cassin, Rosie Stephenson-Goodknight, Rob Fernandez
 * Wikidata as authority linking hub: Connecting RePEc and GND researcher identifiers by Joachim Neubert
 * Importing data into Wikidata - Current challenges and ideas future development by Navino Evans
 * The Wikidata map in November 2017 and what changed during the last four months, by Addshore


 * Other Noteworthy Stuff
 * You can now vote for your favorite proposals on the Community Wishlist Survey. The voting phase is open until December 10th.
 * If you run any functionality on Wikimedia sites that uses queries to the Wikidata Query Service, please add it here (more information)
 * The 600,000,000th edit has been made.
 * The first content made specifically for Wikimedia projects in space has been added to Wikidata (see Close encounters of the Wikipedia kind)
 * The Aaron Swartz Fellowship at OSA, Budapest, Hungary, is open for applications (deadline Dec. 31). The second focus area of the fellowship may be of interest to Wikidata folks.


 * Did you know?


 * Newest properties: set designer, Swedish Musical Heritage composer ID, National Film Board of Canada movie ID, South Dakota Sports Hall of Fame ID, World Rugby Hall of Fame ID, Microsoft Store album ID, date of burial or cremation, Lives of WWI ID, polymer of, monomer of, FAPESP researcher ID, FAPESP institution ID, NIOSH Publication Number, post town, arXiv author ID, CPE athlete ID, Mountain Project ID, National Inventory of Canadian Military Memorials ID, Atomic Heritage Foundation ID, Dreadnought Project page, IWGA athlete ID, Argentinian Historic Heritage ID


 * Query examples:
 * [https://query.wikidata.org/#%23defaultView%3ATimeline%0ASELECT%20DISTINCT%20%3Ft%20%3Fvalue%20%20%3FvalueLabel%20%3FrrLabel%20%20%3Frr%20%28SAMPLE%28%3Fimage%29%20as%20%3Fimg%29%0AWHERE%0A%7B%0A%20%20VALUES%20%3Fperson%20%7Bwd%3AQ1512%7D%0A%20%20%7B%3Fperson%20wdt%3AP570%20%3Fdeath%20.%20%0A%20%20%20%3Fperson%20%3Fprop%20%3Ft%20FILTER%20%28datatype%28%3Ft%29%3Dxsd%3AdateTime%29%20FILTER%20%28%3Ft%20%3C%3D%20%3Fdeath%29%20.%0A%20%20%20%3Fvalue%20wikibase%3AdirectClaim%20%3Fprop.%20%7D%0A%20%20UNION%0A%20%20%7B%0A%20%20%20%3Fperson%20%3Fq%20%3Fstatement%20%20FILTER%20regex%20%28STR%28%3Fq%29%2C%22prop%2FP%22%29%20.%20%23exclude%20P%3AdescribedBy%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20.%20%0A%20%20%20%3Fstatement%20%3Fp%20%3Ft%20FILTER%20regex%20%28STR%28%3Fp%29%2C%20%22prop%2Fqualifier%2FP%22%29%20FILTER%20%28datatype%28%3Ft%29%3Dxsd%3AdateTime%29%20FILTER%20%28%3Ft%20%3C%3D%20%3Fdeath%29.%0A%20%20%20%3Fstatement%20%3Fr%20%3Fvalue%20FILTER%20regex%20%28STR%28%3Fr%29%2C%22prop%2Fstatement%2F%22%29%20.%0A%20%20%20BIND%28IRI%28CONCAT%28CONCAT%28SUBSTR%28STR%28%3Fr%29%2C1%2C29%29%2C%22direct%2F%22%29%2CSUBSTR%28STR%28%3Fr%29%2C40%29%29%29%20as%20%3Frprop%29%20%0A%20%20%20%3Frr%20wikibase%3AdirectClaim%20%3Frprop%20.%0A%20%20%20OPTIONAL%20%7B%3Fvalue%20wdt%3AP18%20%3Fimage%7D%0A%20%20%7D%0A%20%20UNION%20%7B%20%23%20author%20of%20%2F%20creator%20of%0A%20%20%20%3Fvalue%20wdt%3AP50%7Cwdt%3AP98%7Cwdt%3AP655%7Cwdt%3AP1773%7Cwdt%3AP170%20%3Fperson%20.%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20.%0A%20%20%20%3Fvalue%20wdt%3AP571%7Cwdt%3AP577%20%3Ft%20.%20%0A%20%20%20%20%20%20%20%20%20%20FILTER%20%28%3Ft%20%3C%3D%20%3Fdeath%29%20%0A%20%20%20%23FILTER%20NOT%20EXISTS%20%7B%3Fvalue%20wdt%3AP629%20%3Fx%20%7D%20%0A%20%20%20FILTER%20NOT%20EXISTS%20%7B%3Fperson%20wdt%3AP800%20%3Fvalue%20%7D%20.%0A%20%20%20OPTIONAL%20%7B%3Fvalue%20wdt%3AP1433%20%3Frr%20.%7D%20%0A%20%20%20OPTIONAL%20%7B%3Fvalue%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%20%20UNION%20%23Notable%20Works%0A%20%20%7B%0A%20%20%20%3Fperson%20wdt%3AP800%20%3Frr%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP570%20%3Fdeath%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3Fbirth%20.%0A%20%20%20%3Frr%20%20wdt%3AP577%7Cwdt%3AP571%7Cwdt%3AP1191%20%3Ft%20FILTER%20%28%28%3Ft%20%3C%3D%20%3Fdeath%29%26%26%28%3Ft%20%3E%3D%20%3Fbirth%29%29.%0A%20%20%20OPTIONAL%20%7B%3Frr%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%20%20%20%20UNION%20%23discoverer%20or%20inventor%0A%20%20%7B%0A%20%20%20%3Frr%20wdt%3AP61%20%3Fperson%20.%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3Fbirth%20.%0A%20%20%20%3Frr%20wdt%3AP575%7Cwdt%3AP571%7Cwdt%3AP585%20%3Ft%20FILTER%20%28%28%3Ft%20%3C%3D%20%3Fdeath%29%26%26%28%3Ft%20%3E%3D%20%3Fbirth%29%29.%0A%20%20%20OPTIONAL%20%7B%3Frr%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%20%20%20UNION%20%23architect%0A%20%20%7B%0A%20%20%20%3Frr%20wdt%3AP84%20%3Fperson%20.%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3Fbirth%20.%0A%20%20%20%3Frr%20wdt%3AP571%7Cwdt%3AP1619%20%3Ft%20FILTER%20%28%28%3Ft%20%3C%3D%20%3Fdeath%29%26%26%28%3Ft%20%3E%3D%20%3Fbirth%29%29.%0A%20%20%20OPTIONAL%20%7B%3Frr%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%20%20UNION%20%23composer%0A%20%20%7B%0A%20%20%20%3Frr%20wdt%3AP86%20%3Fperson%20.%0A%20%20%20%3Fperson%20wdt%3AP570%20%3Fdeath%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP569%20%3Fbirth%20.%0A%20%20%20%3Frr%20wdt%3AP571%7Cwdt%3AP1191%7Cwdt%3AP577%20%3Ft%20FILTER%20%28%28%3Ft%20%3C%3D%20%3Fdeath%29%26%26%28%3Ft%20%3E%3D%20%3Fbirth%29%29.%0A%20%20%20OPTIONAL%20%7B%3Frr%20wdt%3AP18%20%3Fimage%20.%7D%0A%20%20%7D%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2C%20fr%2C%20de%22.%20%7D%0A%7D%20GROUP%20BY%20%3Ft%20%3Fvalue%20%3Frr%20%3FrrLabel%20%3FvalueLabel%0AORDER%20BY%20%3Ft%0A%20 Timeline for the writer Robert Louis Stephenson] (source)
 * Movies with Bud Spencer and Terence Hill (source)
 * Photographers born before the inception of the earliest photograph (source)
 * Newest WikiProjects: Stolpersteine, Jasmerah
 * Newest database reports: Q5 with identical P18


 * Development
 * Wikidata will get dedicated database resources, and go read-only for 30 minutes on 9th January 2018 (T181645)
 * There were no RDF dumps last week due to problems generating them, investigation is still going on (T181385)
 * Improved the threshold for ORES on Wikidata (T180450)
 * Working on fixing a regression after a change in MediaWiki core that makes edit links show up on diff pages (T181807)
 * More work on persistent editing of statements on Forms of a Lexeme (specifically T180467)
 * Improved size of the diff that we sent to Wikipedia and co for changes happening on Wikidata. This is one more needed step towards only showing meaningful edits in the watchlists and recent changes there. (T113468)

You can see all open tickets related to Wikidata here.


 * 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) 16:31, 4 December 2017 (UTC)

This Month in GLAM: November 2017
About This Month in GLAM · Subscribe/Unsubscribe · Global message delivery · Romaine 20:47, 8 December 2017 (UTC)

Administrators' newsletter – December 2017
News and updates for administrators from the past month (November 2017). Administrator changes
 * Gnome-colors-list-add.svg Joe Roe
 * Gnome-colors-view-refresh.svg JzG
 * Gnome-colors-list-remove.svg Ericorbit • Perceval • Thingg • Tristanb • Violetriga

Guideline and policy news
 * Following a request for comment, a new section has been added to the username policy which disallows usernames containing emoji, emoticons or otherwise "decorative" usernames, and usernames that use any non-language symbols. Administrators should discuss issues related to these types of usernames before blocking.

Technical news
 * Wikimedians are now invited to vote on the proposals in the 2017 Community Wishlist Survey on Meta Wiki until 10 December 2017. In particular, there is a section of the survey regarding new tools for administrators and for anti-harassment.
 * A new function is available to edit filter managers which can be used to store matches from regular expressions.

Arbitration
 * Voting in the 2017 Arbitration Committee elections is open until Sunday 23:59, 10 December 2017 (UTC). There are 12 candidates running for 8 vacant seats.

Miscellaneous
 * Over the last few months, several users have reported backlogs that require administrator attention at WP:ANI, with the most common backlogs showing up on WP:SPI, WP:AIV and WP:RFPP. It is requested that all administrators take some time during this month to help clear backlogs wherever possible. It should be noted that AIV reports are not always valid; however, they still need to be cleared, which may include needing to remind users on what qualifies as vandalism.
 * The Wikimedia Foundation Community health initiative is conducting a survey for English Wikipedia contributors on their experience and satisfaction level with Administrator’s Noticeboard/Incidents. This survey will be integral to gathering information about how this noticeboard works (i.e. which problems it deals with well and which problems it struggles with). If you would like to take this survey, please sign up on this page, and a link for the survey will be emailed to you via Special:EmailUser.

Discuss this newsletter

Subscribe

Archive Sent by MediaWiki message delivery (talk) 20:58, 2 December 2017 (UTC)

Wikidata weekly summary #290
Here's your quick overview of what has been happening around Wikidata over the last week. 
 * Events/Press/Blogs
 * Incoming: Wikidata workshop in Rennes, France, December 12th
 * Incoming:Next Structured Commons IRC office hour will be on Tuesday, February 13, 2018, at 18:00 UTC.
 * Past: Tech-talk about knowledge technologies, featuring Wikidata, DBpedia, and Histropedia at Jakarta Digital Valley, Jakarta, Indonesia on Dec 8, 2017. Slides are available at Slideshare link.
 * My vision of a possible strategy. How could we change Wikidata’s core infrastructure to be able to scale better in the future? by ChristianKl.
 * Using WikiData as a multi-lingual multi-dialectal dictionary for Arabic dialects - conference paper
 * WikiCite 2017 report by Dario Taborelli and the organization team


 * Other Noteworthy Stuff
 * Structured Data on Commons: Participate in this survey to help the team understand which tools and functionalities are most important to the Commons and Wikidata communities
 * QuickStatements now has a CSV-like import function (under "import commands")
 * wikidata-cli now support dynamic SPARQL requests using JS files
 * New wikidata-sdk function: wdk.getSitelinkUrl, a function to easily build URLs from Wikidata API sitelinks data
 * Musik Lovers (de) is a project created during Coding da Vinci 2017 and reuses data from Wikidata about composers played in the Koncerthaus of Berlin


 * Did you know?


 * Newest properties: premiere type, name of the character role, Bechdel Test Movie List ID, Iowa Sports Hall of Fame ID, DORIS ID, Online Books Page author ID, ICTV virus genome composition, EK number, identity of object in context, Museum of Fine Arts, Boston object ID, squadron embarked, South Australian Football Hall of Fame inductee ID, trophy awarded, Württembergische Kirchengeschichte person ID, Merkelstiftung person ID, National Library of Brazil ID, AUSNUT 2011–13 Food Group ID, DVV player ID, UniProt journal ID, WAFL FootyFacts ID, watershed, Encyclopedia of Modern Ukraine ID, LKL player ID, LACMA ID, Art Institute of Chicago artwork ID, Queensland Australian Football Hall of Fame inductee ID


 * Query examples:
 * Place of birth of author with pages on the French Wikisource (source)
 * Number of movies passing or failing the Bechdel test by year (source)
 * 100 of the earliest 1000 works created by women on Wikidata with an image on Commons (source)
 * Chemical entities, whom discovered them, and when (source)
 * Sister-city and twin-city relationships of the largest cities (source)
 * Cast age at date of film publication (source)
 * Male saints that are the most used to name French cities after them (source)


 * Development
 * Add anchors to Special:ListDatatypes (T181371)
 * Data Types library has been integrated to Wikibase (T180454)
 * Investigate on the slow problems encountered on Wikidata (T182322)

You can see all open tickets related to Wikidata here.


 * 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) 16:06, 11 December 2017 (UTC)

The Signpost: 18 December 2017
<div class="hlist" style="margin-top:10px; font-size:90%; padding-left:5px; font-family:Georgia, Palatino, Palatino Linotype, Times, Times New Roman, serif;"> * Read this Signpost in full * Single-page * Unsubscribe * MediaWiki message delivery (talk) 06:28, 18 December 2017 (UTC)

Wikidata weekly summary #291
<div style="margin-top:10px; padding-left:5px; font-family:Georgia, Palatino, Palatino Linotype, Times, Times New Roman, serif;">Here's your quick overview of what has been happening around Wikidata over the last week. <div style="-moz-column-count:2; -webkit-column-count:2; column-count:2; -webkit-column-width: 400px; -moz-column-width: 400px; column-width: 400px;">
 * Discussions
 * New request for comments: Mapping and improving the data import process


 * Events/Press/Blogs
 * Upcoming: Introduction to Wikidata for local OpenStreetMap community & others, Riga, Latvia, December 19th
 * Upcoming: 34th Chaos Communication Congress, 27-30 December, Leipzig, Germany. The Wikidata team will be there
 * Wikidata in Collections: Building a Universal Language for Connecting GLAM Catalogs
 * A purposeful #strategy for #Wikidata
 * WikidataCon: Giving more people more access to more knowledge by Peter Kraker
 * Review of the Global Legislative Openness Week by MySociety


 * Other Noteworthy Stuff
 * A script to add links to Wikidata on Twitter by Envlh
 * Resolver can now open an item in tools/third-party sites listed on Q43649390#3303, using the  attribute - for example https://tools.wmflabs.org/wikidata-todo/resolver.php?prop=P496&value=0000-0003-4402-5296&project=scholia
 * New edition of the Structured Data on Commons newsletter


 * Did you know?


 * Newest properties: Wiki Aves bird ID, DACS ID, SAN ID, reservoir, CPDOC ID, Musée d'Orsay artwork ID, Coflein ID, The Numbers person ID, Wikimedia import URL, Flathub ID, partition type identifier, partition table type, ESCO Occupation ID, Welsh assembly ID, BSD Portal athlete ID, identity of subject in context, location of first performance, representation of, RCR number, ESCO skill ID, Philadelphia Museum of Art ID, Colorado Sports Hall of Fame ID, Welsh Chapels ID, photosphere image, Estonian Football Association team ID, The Peerage person ID, FoodEx2 code, Sherpa Juliet ID, Indian Financial System Code


 * Query examples:
 * [https://query.wikidata.org/#%23%20this%20query%20identifies%20the%20date-weekday%20cominations%20for%20when%20disasters%20happened%0A%23%20eg%20%22Tuesday%2012th%22%0A%23%20original%20by%20Mat%C4%9Bj%20Such%C3%A1nek%20%26%20Larske%20-%20https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FWikidata%3ARequest_a_query%23Disasters_starting_on_Friday_13%0A%0ASELECT%20%28%3Fq%20AS%20%3FDate%29%20%28SUM%28%3Fmon%29%20AS%20%3FMon%29%20%28SUM%28%3Ftue%29%20AS%20%3FTue%29%20%28SUM%28%3Fwed%29%20AS%20%3FWed%29%20%28SUM%28%3Fthu%29%20AS%20%3FThu%29%20%28SUM%28%3Ffri%29%20AS%20%3FFri%29%20%28SUM%28%3Fsat%29%20AS%20%3FSat%29%20%28SUM%28%3Fsun%29%20AS%20%3FSun%29%20%20%28COUNT%28%3Fstart_time%29%20AS%20%3FTot%29%20%20WHERE%20%7B%0A%20%7B%20%0A%20%20%3Fdisaster%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ3839081%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20p%3AP580%20%3Fstart_time_stm%20.%20%20%20%20%20%20%20%20%20%20%23%20find%20the%20date%20multi-day%20disasters%20started%0A%20%20%3Fstart_time_stm%20ps%3AP580%20%3Fstart_time%20.%0A%20%20%3Fstart_time_stm%20psv%3AP580%20%3Fstart_time_node%20.%0A%20%20%3Fstart_time_node%20wikibase%3AtimePrecision%20%3Ftp%20.%20FILTER%28%3Ftp%3D11%29%20%0A%20%7D%0A%20UNION%20%0A%20%7B%0A%20%20%3Fdisaster%20wdt%3AP31%2Fwdt%3AP279%2a%20wd%3AQ3839081%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20p%3AP585%20%3Fstart_time_stm%20.%20%20%20%20%20%20%20%20%20%20%23%20find%20all%20those%20which%20have%20%22point%20in%20time%22%20%28ie%20one-day%20events%29%0A%20%20%3Fstart_time_stm%20ps%3AP585%20%3Fstart_time%20.%0A%20%20%3Fstart_time_stm%20psv%3AP585%20%3Fstart_time_node%20.%0A%20%20%3Fstart_time_node%20wikibase%3AtimePrecision%20%3Ftp%20.%20FILTER%28%3Ftp%3D11%29%20%0A%20%7D%0A%20%20%23%20this%20beautiful%20bit%20of%20code%20finds%20all%20the%20relevant%20days%20of%20the%20week%0A%20%20%23%20using%20https%3A%2F%2Fcs.wikipedia.org%2Fwiki%2FAlgoritmus_pro_v%25C3%25BDpo%25C4%258Det_dne_v_t%25C3%25BDdnu%23Zeller%25C5%25AFv_algoritmus%0A%20%20BIND%28%20DAY%28%20%3Fstart_time%20%29%20AS%20%3Fq%20%29%20.%0A%20%20BIND%28%20MONTH%28%20%3Fstart_time%20%29%20%2B%20IF%28%20MONTH%28%20%3Fstart_time%20%29%20%3C%203%2C%2012%2C%200%20%29%20AS%20%3Fm%20%29%20.%0A%20%20BIND%28%20YEAR%28%20%3Fstart_time%20%29%20-%20IF%28%20MONTH%28%20%3Fstart_time%20%29%20%3C%203%2C%201%2C%200%20%29%20AS%20%3F_year%20%29%20.%0A%20%20BIND%28%20%3F_year%20-%20FLOOR%28%20%3F_year%20%2F%20100%20%29%20%2a%20100%20AS%20%3FK%20%29%20.%20%23%20modulo%0A%20%20BIND%28%20FLOOR%28%20YEAR%28%20%3Fstart_time%20%29%20%2F%20100%20%29%20AS%20%3FJ%20%29%20.%0A%20%20BIND%28%20%3Fq%20%2B%20FLOOR%28%2013%20%2a%20%28%20%3Fm%20%2B%201%20%29%20%2F%205%20%29%20%2B%20%3FK%20%2B%20FLOOR%28%20%3FK%20%2F%204%20%29%20%2B%20FLOOR%28%20%3FJ%20%2F%204%20%29%20-%202%20%2a%20%3FJ%20AS%20%3F_h%20%29%20.%0A%20%20BIND%28%20%3F_h%20-%20FLOOR%28%20%3F_h%20%2F%207%20%29%20%2a%207%20AS%20%3Fweekday%29%20.%20%23%20modulo%2C%200%20is%20Saturday%0A%20%20BIND%28IF%28%3Fweekday%3D2%2C1%2C0%29%20AS%20%3Fmon%29%0A%20%20BIND%28IF%28%3Fweekday%3D3%2C1%2C0%29%20AS%20%3Ftue%29%0A%20%20BIND%28IF%28%3Fweekday%3D4%2C1%2C0%29%20AS%20%3Fwed%29%0A%20%20BIND%28IF%28%3Fweekday%3D5%2C1%2C0%29%20AS%20%3Fthu%29%0A%20%20BIND%28IF%28%3Fweekday%3D6%2C1%2C0%29%20AS%20%3Ffri%29%0A%20%20BIND%28IF%28%3Fweekday%3D0%2C1%2C0%29%20AS%20%3Fsat%29%0A%20%20BIND%28IF%28%3Fweekday%3D1%2C1%2C0%29%20AS%20%3Fsun%29%0A%7D%0AGROUP%20BY%20%3Fq%0AORDER%20BY%20%3FDate Number of disasters by date and day of the week] (source)
 * Map with buildings by Brazilian architect Oscar Niemeyer (source)
 * Properties most used for “no value” statements/qualifiers/references (source)
 * Scientific papers with an animal credited as co-author (source)
 * Image grid of what different cryptocurrencies are named after (source)
 * Newest WikiProjects: Narration
 * Newest database reports: Brigata del Decameron


 * Development
 * Additional languages for monolingual values got approved by the language committee: ami (Amis), bnn (Bunun), fos (Siraya), ppu (Papora / Hoanya), pwn (Paiwan), pyu (Puyuma), ssf (Thao), trv (Seediq / Taroko), uun (Pazeh) (see 374052, T144272)
 * More work on caching constraint results so we can enable the constraints checks for all logged-in users by default
 * Fixed a bug when edit links showed up in diff views (T181807)
 * Final step towards being able to store statements on Forms of a Lexeme
 * Disabled RDF support for Lexemes as the mapping isn't defined yet (T182660)
 * Adding some more smart tracking for Lua usage so we better know which properties from an item are used on a Wikipedia article even when the whole item is loaded (T179923)

You can see all open tickets related to Wikidata here.


 * 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!

<div style="margin-top:10px; font-size:90%; padding-left:5px; font-family:Georgia, Palatino, Palatino Linotype, Times, Times New Roman, serif;">Read the full report &middot; Unsubscribe &middot; Lea Lacroix (WMDE) 15:53, 18 December 2017 (UTC)

Cochrane bot updates
Hi Mike, I just wanted to follow up on our conversation about the Cochrane Update bot. We were discussing withdrawn reviews. I have started to look into this, but have not yet found a solution. Are you waiting for this response before the bot runs fully, or is it scheduled for the first of the month? Thanks again for all your help. Jenny JenOttawa (talk) 03:32, 9 December 2017 (UTC)
 * Hi I'm currently waiting for the bot approval group, see Bots/Requests for approval/Pi bot 3 (which is taking longer than I expected, maybe  can help?). Once that's there then I'll set it running to do a one-off update, then schedule it to run on the 1st of each month. If there's a solution to the withdrawn reviews, then I'm happy to implement it, but I don't see this as an issue that stops the bot from running (since the work-around is to leave them in the pending queue until a non-withdrawn update is available). Thanks. Mike Peel (talk) 10:31, 9 December 2017 (UTC)
 * Thanks for the update Mike. JenOttawa (talk) 02:03, 10 December 2017 (UTC)

Hi Mike, congrats on getting the bot up and running! I noticed that it is doing all the "withdrawn" reviews first. Just wondering if this was supposed to happen. This is great that they are included in the bot updates. We did not have them before, it used to just pull all the PMIDs of updated reviews. Thanks again for all your help with the approval process and behind the scenes work getting this up and running. I will be contacting the volunteers and we will get started tackling the new list! JenOttawa (talk) 21:08, 12 December 2017 (UTC)
 * I'm surprised that so many "withdrawn" reviews are being returned, I don't think I changed anything in the code that made it more or less likely for these to be fetched. If you/others can have a look at them and figure out how best to deal with them, that would be good! Thanks. Mike Peel (talk) 21:15, 12 December 2017 (UTC)
 * It is great that it is pulling the withdrawn reviews, these can be easily updated manually on Wikipedia, and it is great to clean up the articles. Once it is finished we will see how it works for the non-withdrawn updated reviews (about 20 per month). There are about 300 withdrawn reviews in total for all cochrane reviews (not sure of time frame on this number). They are pretty rare, maybe a handful a year? Thanks again, Jenny JenOttawa (talk) 21:50, 12 December 2017 (UTC)
 * I only saw the "finished product" the other times the updates were performed, so I am not sure of the order that the bot flagged the updates. I can see that it is still plugging away pulling the withdrawn reviews alphabetically. JenOttawa (talk) 21:52, 12 December 2017 (UTC)
 * OK. It is still running, hopefully it will finish overnight. Thanks. Mike Peel (talk) 22:06, 12 December 2017 (UTC)

Hey Mike. Can you get your bot to not put updates when the update is withdrawn? 

Added Thanks for taking this on :-)  Doc James  (talk · contribs · email) 04:37, 13 December 2017 (UTC)
 * Also can you get the bot to add the pmid for the most recent version?
 * For example https://en.wikipedia.org/w/index.php?title=Croup&type=revision&diff=815112213&oldid=807292961
 * The next update is withdrawn but the one after that in 2013 is good.
 * :-) Doc James  (talk · contribs · email) 04:43, 13 December 2017 (UTC)
 * Can you run the bot on the prior edits to remove the unneeded ones?
 * And might be good to run some practice runs. Doc James  (talk · contribs · email) 05:07, 13 December 2017 (UTC)
 * Can you decide how best to handle the withdrawn cases, and I'll code that up? The bot stopped part-way through last night when trying to fetch a page from nih.gov to check, so I also need to improve the robustness of that part of the code I've made a change to that part of the code to avoid the issue. Thanks. Mike Peel (talk) 19:15, 13 December 2017 (UTC)
 * I've added some code that will catch cases where the updated version has itself been updated (but it won't check for a third level), so that should catch cases like . I can check to see if the new one has 'WITHDRAWN' in it, and not update in that case, if that's what both of you want me to do. Thanks. Mike Peel (talk) 20:14, 13 December 2017 (UTC)
 * Basically we are looking for the most recent not "withdrawn" paper :-) Doc James  (talk · contribs · email) 05:03, 14 December 2017 (UTC)
 * If I exclude any update that contains " WITHDRAWN: " in the HTML, then I think that will do what you want, . It does mean that cases where the currently-used reference has been withdrawn without an update that hasn't been withdrawn will not be flagged, is that OK? any comments? Thanks. Mike Peel (talk) 23:36, 18 December 2017 (UTC)
 * Yes I think that should be good. Doc James  (talk · contribs · email) 23:53, 18 December 2017 (UTC)
 * That makes sense to me. I have an excel doc with all the withdrawn reviews, I can go manually and make sure that the reviews that are withdrawn are replaced with the most recent review. Thanks very much! JenOttawa (talk) 01:32, 19 December 2017 (UTC)

Wishes
It's that time of the year again, Mike. No fancy template, but just wishing you all the best for the holidays and the new year. It's probably a lot warmer where I am than where you  are 😎 Kudpung กุดผึ้ง (talk) 09:15, 21 December 2017 (UTC)
 * Thanks, same to you! Mike Peel (talk) 15:08, 23 December 2017 (UTC)

Merry Christmas!
<div style="border-style:solid; border-radius: 32px; border-color:#009600; background: #FFFBC4; border-width:8px; text-align:center; padding:7px; height:210px;" class="plainlinks"> Merry Christmas !!

Hi, I wish you and your family a very Merry Christmas and a very Happy New Year,

Thanks for all your help and contributions on the 'pedia! ,

– Davey 2010 Merry Xmas / Happy New Year 13:44, 23 December 2017 (UTC)
 * Thanks, same to you! Mike Peel (talk) 15:09, 23 December 2017 (UTC)

Wikidata weekly summary #292
<div style="margin-top:10px; padding-left:5px; font-family:Georgia, Palatino, Palatino Linotype, Times, Times New Roman, serif;">Here's your quick overview of what has been happening around Wikidata over the last week. <div style="-moz-column-count:2; -webkit-column-count:2; column-count:2; -webkit-column-width: 400px; -moz-column-width: 400px; column-width: 400px;">


 * Events/Press/Blogs
 * Upcoming: 34th Chaos Communication Congress, 27-30 December, Leipzig, Germany. The Wikidata team will be there
 * WikiCite 2018
 * Get your vocabularies in Wikidata... so Europeana and others can get them
 * Moths and me
 * Quality and collaboration in Wikidata
 * The Tom Longboat Awards as Wikidata
 * GLOWing the extra mile
 * Seven translation tools you can use to work in multiple languages across Wikimedia projects


 * Other Noteworthy Stuff
 * New tool by YMS to help with vandalism fighting. Give it a try and catch some vandals?
 * Version 0.8.0 of the Wikidata Toolkit have been released. There is a short survey to figure out in which directions to move the library.
 * You can try the Wikidata fulltext search prototype and give feedback
 * You can also tell us what could be improved with the entity suggester
 * The Geo dashboard shows a map on the most used items in Wikipedia and co in a given category
 * Consultation on Blocking tools and improvements
 * New documentation page with information about publishing open data that we can use when talking to institutions about why they should publish their data openly
 * Cou can try the prototype to improve the term box and give feedback


 * Did you know?
 * Newest properties: OpenSecrets organization ID, Oireachtas member ID, Environmental Register code (Estonia), geomorphological unit, Dictionnaire des peintres belges ID, Carnegie Museum of Art ID, Nintendo Game Store ID, National Gallery of Victoria artwork ID, National Gallery of Art artwork ID, Eldoblaje original actor ID, Eldoblaje dubbing actor ID, constraint scope, MAVISE company ID, MAVISE competent authority ID, MAVISE on-demand audiovisual service ID, MAVISE TV channel ID, appears in the form of, Indianapolis Museum of Art artwork ID, Museum of Fine Arts, Houston object ID, EMLO location ID, Hall of Light Amiga database ID, Sjukvårdsrådgivningen Category ID, tabular software version, USA Gymnastics Hall of Fame athlete ID, Buenos Aires legislator ID, Cinemagia actor ID, Cinemagia film ID
 * Query examples:
 * Map with radio telescopes around the world (source)
 * People born on the same day their mother died (source)
 * Largest first-level administrative subdivision by country (source)
 * Data sets released under a Creative Commons NoDerivatives license (source)
 * Type foundries and their typefaces (source)
 * Map of Christmas traditions (source)
 * Movies that are Christmas traditions (source)
 * Newest database reports: list of Christmas films


 * Development
 * Due to the Christmas and New Year's Eve holidays, no deployment will happen before January 3rd.
 * Monolingual language codes for Old French (fro) and Middle French (frm) added (T181823)
 * Finishing touches on storing statements on Forms
 * No longer checking constraints on the property example statements (T183267)
 * More work on caching constraint check results so we can roll out constraint checking for all logged in users


 * 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!

<div style="margin-top:10px; font-size:90%; padding-left:5px; font-family:Georgia, Palatino, Palatino Linotype, Times, Times New Roman, serif;">Read the full report &middot; Unsubscribe &middot; Lydia Pintscher (WMDE) 11:54, 26 December 2017 (UTC)

Seasons' Greetings
...to you and yours, from the Great White North! FWiW Bzuk (talk) 04:35, 24 December 2017 (UTC)
 * Thanks, same to you! Mike Peel (talk) 14:26, 26 December 2017 (UTC)

Holiday Season!
Hi Mike, I just wanted to wish you a nice Christmas holiday. Thank you again for your help getting the bot up and going. Hope you have a chance to relax and enjoy the holiday season. Kind regards, Jenny

JenOttawa (talk) 15:48, 26 December 2017 (UTC)