[09:10:59] <jeluf>	 I've a problem with Q13360264. English "Pie", German "Obstkuchen" - which means 'fruit cake'. Result: Shepherd's Pie is a fruit cake :-(
[09:14:51] <Nemo_bis>	 Hi jeluf, nice to see you
[09:17:15] <jeluf>	 'de' doesn't have an article on pie, just a disambiguation page listing a few pies.
[09:17:24] <jeluf>	 Hi Nemo :-)
[10:30:15] <aude>	 Lydia_WMDE: https://phabricator.wikimedia.org/T84915
[10:30:22] <aude>	 somehow we decided to close it :(
[10:30:24] <Lydia_WMDE>	 addshore: ^
[10:30:32] <aude>	 maybe it was fixed at one point
[10:30:35] <aude>	 and broke again?
[10:36:52] <hoo>	 aude: You have a convenient way to import properties into your test wiki?
[10:38:02] <aude>	 hoo: it's experimental, but https://github.com/filbertkm/WikibaseImport
[10:38:28] <hoo>	 aude: Coool
[10:38:33] <aude>	 :)
[10:39:03] <aude>	 something to work more on the weekend, but not a priority right now :/
[10:39:42] <Lydia_WMDE>	 addshore: T109697
[10:39:48] <Lydia_WMDE>	 https://phabricator.wikimedia.org/T109697
[10:40:30] <addshore>	 added my comment
[10:45:49] <Lydia_WMDE>	 thx
[10:57:55] <Lydia_WMDE>	 Jonas_WMDE: https://phabricator.wikimedia.org/T98172 <- want to link the changesets there?
[11:40:20] <multichill>	 Harmonia_Amanda: Hacked up http://tools.wmflabs.org/multichill/painters/ . It has prefilled quick_statements links :-)
[11:42:09] <Harmonia_Amanda>	 cool !
[12:22:22] <Aliossandro>	 Hi
[12:22:41] <Aliossandro>	 I'd like to ask a question about Wikidata dumps
[12:23:52] <Aliossandro>	 I need the logs of the discussion pages, but I cannot find them in the XML dumps with the history of all the pages
[12:24:41] <Aliossandro>	 In particular, I need property talk pages, where constraints are specified
[12:25:35] <Aliossandro>	 I am using the namespace of Property talk for my search, with no luck
[12:25:42] <Aliossandro>	 Could someone help me?
[12:35:07] <sjoerddebruin>	 Aliossandro: https://www.wikidata.org/wiki/Category:Properties_with_constraints
[12:37:05] <Aliossandro>	 Thanks, sjorddebruin
[12:37:44] <Aliossandro>	 However, I am looking for historical dumps of Property Talks
[12:59:45] <Nemo_bis>	 Aliossandro: why do you want the logs rather than the edits or the latest content?
[13:49:00] <Aliossandro>	 I am carrying out a research on property constraints in Wikidata
[13:49:34] <Aliossandro>	 and I need all the edits made to property constraints
[13:50:14] <Aliossandro>	 I want to understand when constraints have been introduced
[13:51:50] <Aliossandro>	 and their effects on wikidata accuracy
[14:05:08] <Nemo_bis>	 Aliossandro: then you need revisions, not logs; they are in the wikidatawiki-20150704-pages-meta-history* files at https://dumps.wikimedia.org/wikidatawiki/20150704/
[14:07:25] <Aliossandro>	 I have already these files
[14:07:56] <Aliossandro>	 But I wasn't sure whether Property talks would be there too
[14:08:42] <Aliossandro>	 I could extract property and item revisions
[14:08:59] <Aliossandro>	 but I haven't found property talk pages yet
[14:11:01] <Aliossandro>	 I will have to find another approach to search into the files probably
[14:14:48] <Nemo_bis>	 Aliossandro: for the actual processing, you should use http://pythonhosted.org/mediawiki-utilities/
[14:16:47] <Aliossandro>	 Thanks, Nemo_bis. I didn't know that.
[14:17:36] <Aliossandro>	 I have already written a python script to extract all the metadata and text of all item and property revisions
[14:17:52] <Aliossandro>	 and created some statistics on the basis of the data extracted
[14:17:53] <Nemo_bis>	 Too bad
[14:18:01] <Nemo_bis>	 The pages are definitely there https://paste.debian.net/299337/
[14:18:10] <The_Photographer>	 Hi
[14:18:27] <The_Photographer>	 Why I cant add a wikidata link here https://en.wikipedia.org/wiki/Template:Nueva_Esparta of https://es.wikipedia.org/wiki/Plantilla:Nueva_Esparta
[14:19:30] <Aliossandro>	 well, finally I am sure about that
[14:19:39] <Aliossandro>	 that was very helpful, thanks again
[14:27:25] <yurb>	 There's two pages in enwiki and a single page that covers both topics in Ukrainian... But wikidata doesn't allow linking same ukwiki page in interwikis to two enwiki pages... I suppose this is a common scenario, how can I solve it?
[14:32:40] <Nemo_bis>	 yurb: pray $deity for https://phabricator.wikimedia.org/T54564
[17:24:33] <DanielK_WMDE_>	 frimelle: this may also help https://en.wikipedia.org/wiki/File:Git_operations.svg
[17:26:08] <aude>	 frimelle: https://www.mediawiki.org/wiki/User:Aude/Git :)
[17:26:20] <aude>	 all the things i learned along the way, some learned the hard way :/
[17:27:45] <frimelle>	 So cool! Thanks!
[18:20:56] <audephone>	 Did we deploy on Wikipedia yet?
[18:21:10] <audephone>	 I think server admin log says no
[18:45:35] * aude back
[19:09:36] <sjoerddebruin>	 multichill: There are some positive effects of the VIAF import https://www.wikidata.org/w/index.php?title=Wikidata%3ADatabase_reports%2FConstraint_violations%2FP723&type=revision&diff=244272577&oldid=238737953
[19:10:40] <multichill>	 sjoerddebruin: Still plenty to do. Check out http://tools.wmflabs.org/multichill/painters/ :-)
[19:11:22] <sjoerddebruin>	 Working on Dutch given names: https://www.wikidata.org/wiki/User:Sjoerddebruin/Voornaam
[19:24:03] <multichill>	 sjoerddebruin: https://www.wikidata.org/w/index.php?title=Q2369770&type=revision&diff=244121315&oldid=212406892 <- ahum
[19:24:53] <sjoerddebruin>	 Hm?
[19:25:25] <multichill>	 It's quite a famous case. Read the Dutch Wikipedia article. Removing female is incorrect
[19:26:24] <multichill>	 A lot of guesswork
[19:27:21] <sjoerddebruin>	 Two statements seems weird to me.
[19:27:48] <multichill>	 Yup, but that was a very weird case
[19:30:51] <sjoerddebruin>	 Hm, but how can we make this good...
[19:39:28] <multichill>	 sjoerddebruin: Lot's and lot's of sources :P
[19:39:36] <sjoerddebruin>	 :/
[20:10:49] <quiddity>	 Newbie query question: How would I search for a list of all humans born on (P569) August 20 (Q2824) ?  Ideally, with the results in chronological order.  Thanks.
[20:34:21] <SMalyshev>	 quiddity: something like this: https://www.mediawiki.org/wiki/Wikibase/Indexing/SPARQL_Query_Examples#Whose_birthday_is_today.3F ?
[20:37:57] <quiddity>	 SMalyshev, yes!  but that query currently generates errors when I click "execute".. >.>
[20:38:22] <SMalyshev>	 quiddity: hmm... looks like we have a bug...
[20:38:27] <SMalyshev>	 I'll check that out
[20:42:40] <SMalyshev>	 quiddity: bugs aside, that query probably would be very slow... since there's no indexing on partial dates
[20:52:52] <quiddity>	 SMalyshev, nod.  I was trying to work out how much we could now (and in the future) autogenerate the existing 366 pages such as https://en.wikipedia.org/wiki/August_20
[20:53:06] <quiddity>	 (multiplied by all Wikipedias)
[20:53:33] <SMalyshev>	 well, if we add additional properties that allow to index it (which is not impossible) that'd be easy
[20:53:48] <SMalyshev>	 like Random Guy -> born on -> August 20 (schematically)
[20:54:08] <SMalyshev>	 but right now now easy since it effectively has to scan through all dates
[20:54:23] <SMalyshev>	 *not easy
[20:54:31] <aude>	 SMalyshev: born on "august 20" can be a wikibase-item value
[20:54:47] <aude>	 maybe, and then it's just intersecting the values
[20:55:10] <aude>	 https://www.wikidata.org/wiki/Q2824
[20:55:28] <aude>	 that would have to be populated on more items though
[20:55:43] <SMalyshev>	 yeah, definitely can be. 
[20:56:13] <SMalyshev>	 ok, I found the bug - apparently, day() etc. breaks on dates with year 0 :( I need to fix it
[20:56:27] <aude>	 :(
[20:57:39] <SMalyshev>	 good that quiddity pointed me to that example - I didn't check date functions and turns out they are all subtly broken
[20:57:49] <SMalyshev>	 (because our dates are weird)
[20:57:56] <SMalyshev>	 but should be fixable
[20:58:50] * aude nods