[00:47:40] (03CR) 10JanZerebecki: [C: 032] Batched term lookups for RC lists [extensions/Wikibase] - 10https://gerrit.wikimedia.org/r/180140 (https://phabricator.wikimedia.org/T74310) (owner: 10Daniel Kinzler) [00:50:13] (03Merged) 10jenkins-bot: Batched term lookups for RC lists [extensions/Wikibase] - 10https://gerrit.wikimedia.org/r/180140 (https://phabricator.wikimedia.org/T74310) (owner: 10Daniel Kinzler) [01:26:52] how would I best find all the reverse-examples of a "Instance of" statement? e.g. I want to find all the items that are an instance of https://www.wikidata.org/wiki/Q3220391 [01:27:07] (special:whatlinkshere limited to mainspace gives me a basic list, but I'm guessing there's a better way? https://www.wikidata.org/w/index.php?title=Special%3AWhatLinksHere&target=Q3220391&namespace=0 ) [01:29:04] reasonator? http://tools.wmflabs.org/reasonator/?q=Q3220391 [01:45:27] (03PS1) 10Ori.livneh: MWException -> Exception [extensions/Wikidata] - 10https://gerrit.wikimedia.org/r/184023 [01:45:35] (03CR) 10jenkins-bot: [V: 04-1] MWException -> Exception [extensions/Wikidata] - 10https://gerrit.wikimedia.org/r/184023 (owner: 10Ori.livneh) [02:13:27] oh, it *is* in reasonator, but in a (slithy) collapsed section! Thanks (departed) sjoerddebruin :) [10:40:39] sjoerddebruin: Kijk eens naar https://www.wikidata.org/wiki/Wikidata_talk:WikiProject_Cultural_heritage#Irksome_issues_with_p31 [10:40:44] Jij nog bezwaren? [10:40:54] Ik kan geen bezwaar verzinnen. [10:52:16] 3Wikidata.org, Wikidata: JS error: "unrecognized expression: unsupported pseudo: wikibase-statementview" on old revisions of items - https://phabricator.wikimedia.org/T85804#968188 (10Ricordisamoa) [10:54:21] 3Wikidata.org, Wikidata: JS error: "unrecognized expression: unsupported pseudo: wikibase-statementview" on old revisions of items - https://phabricator.wikimedia.org/T85804#968190 (10Ricordisamoa) The `jquery.wikibase.entityview` module is supposed to register pseudos, but it isn't loaded on old revisions. [11:39:47] Hi [11:40:17] hi GeorgeEdwardC [11:41:05] hi guys [11:42:35] Hi :-) [11:44:31] hey [11:54:24] hai [11:54:35] just me or a strange statement? https://www.wikidata.org/w/index.php?title=Q18718876&curid=20247869&diff=186985063&oldid=186983553 [11:56:22] 3Wikidata.org, Wikidata: JS error: "unrecognized expression: unsupported pseudo: wikibase-statementview" on old revisions of items - https://phabricator.wikimedia.org/T85804#968247 (10hoo) >>! In T85804#968190, @Ricordisamoa wrote: > The `jquery.wikibase.entityview` module is supposed to register pseudos, but it... [11:56:35] sjoerddebruin: maybe caused by the label of the property in their language [12:04:44] multichill: ligt het aan mij of is WDQ eindelijk bijgewerkt? Iig weer actueler? [12:05:27] Ja, ik dacht ook al zoiets. Aantal schilderijen zonder collectie was wel opeens onder de 700 [12:05:38] Zo te zien wel. [12:12:48] multichill: Je burgemeesters komen nog wel langs in de gendergame... [12:13:23] Nog steeds? [12:13:30] Jup [12:14:36] Dat was 20 december. [12:32:34] sjoerddebruin: Autolist wordt wel bijgewerkt. Ben net door alle werken van Walters Art Museum heengegaan om collectie te checken en dat zie ik nu meteen terug [12:33:12] Hm [12:33:25] Voor mijn gevoel ben ik straks klaar met de desa's. Botimport van desacode's kan dan beginnen. [12:37:01] Jup, hij spoelt door. ;) [13:24:10] Shouldn't we link [[Help:Merge]] in the RD gadget? [13:24:22] At the moment it's just plain text [13:32:56] GeorgeEdwardC: I tried that... [13:34:50] sjoerddebruin: Nope, still outdated, see https://www.wikidata.org/wiki/Wikidata:WikiProject_sum_of_all_paintings/Top_collections#Collections_without_country [13:35:05] http://tools.wmflabs.org/wikidata-todo/creator.html is still broken :/ [13:35:22] Stryn: Yes, I've asked Magnus already about that. [13:35:29] (or I made a mess of the query, also possible) [13:35:31] ok, good [13:36:47] sjoer: Oh ok [14:07:51] So many instances of P107 [14:08:00] Would it be worth running a Widar bot for it? [14:08:24] You can't always copy the value of it. [14:09:19] In some cases [14:09:30] The most common one I see is for "geographical object" [14:10:11] Yup, you could harvest from Wikipedia [14:11:07] GeorgeEdwardC: If you add an instance of some other bot will remove the GND thing in a couple of days [14:11:24] But place don't just copy "geographical object" to instance of [14:12:08] I would focus on work. Only 915 left [14:12:22] I'll do that [14:12:38] http://tools.wmflabs.org/autolist/autolist1.html?q=CLAIM%5B107%3A386724%5D [14:12:59] the first one is easy :) [14:13:01] I see a lot of games/computer programs [14:14:11] my bot is deleting where both 107 and 31 exist [14:50:04] hi benestar ... long time no see [14:51:55] hoo: hi :) [14:52:13] yeah, lots of things to do in real life [15:01:01] benestar: i know the feeling :) [15:09:49] why isn't Wikidata part of anyone's real life? :( [15:10:14] :( [15:10:19] benestar! :D [15:11:05] Vogone: it is but there are also things beyond wikidata ;-) [15:28:36] I'm looking for instructions how to get needed data from wikidata dumps suck as all music artists list etc [15:32:18] sergey: Could you please be more specific on what you need? [15:34:11] Since Freebase will be closed. First of all I'd like to know how to use wikidata dumps to quickly get data out of it? [15:34:33] sergey: What kind of data? [15:34:58] If you just need a single item at a time, you're probably better of with the API than using the dumps [15:36:03] hoo: all info about music artist like http://www.freebase.com/m/01vs_v8 [15:37:04] https://www.wikidata.org/wiki/Q1744 [15:37:18] https://www.wikidata.org/wiki/Special:EntityData/Q1744.json [15:37:57] I'm going to create web site about music so I need data about all artists, genres, labels [15:38:19] Ok, for that you'll actually need to use the dumps, I guess [15:39:00] I guess you already ofund them https://dumps.wikimedia.org/other/wikidata/ ? [15:41:18] hoo: ^ no see it for the first time. I'm new to wikidata. What are this jsons? [15:42:20] they are basically a big list of all entities [15:42:48] The entities look like https://www.wikidata.org/wiki/Special:EntityData/Q1744.json [15:43:41] Have you tried to load them into elastic search or in database? [15:44:53] I personally haven't... but several people have done various things with them [15:45:06] Like building custom query engines and stuff like that [15:47:37] !nyan [15:47:37] ~=[,,_,,]:3 [15:52:22] hoo, Lydia_WMDE: http://egonw.tumblr.com/post/107695488987/wikidata-edits-per-day-over-a-period-of-a-bit-more [15:52:53] egonw: Nice one :) [15:53:34] hoo: and for you a big HT for the raw data [15:53:43] Having a 10(?) day average in there would probably be nice [15:54:04] yeah, considered that for a sec... [15:54:10] but doesn't add too much... [15:54:17] yeah [15:54:23] we see a nice constant count with some variance [15:54:44] I think a nice goal for WD4R to break this constant count :) [15:55:02] hehe :D [15:55:06] (though at the risk that something else might beat us to it, which is very likely ;) [15:55:19] Seeing that, I wonder how these edits distribute over the weekdays [15:55:37] Freebase migration will probably also hit hard [15:55:44] and quantities with units [15:55:50] yeah, the last 6~ish months do seem to show a week/weekend pattern :) [15:56:22] units < [15:56:23] <3 [15:56:55] egonw: Awesome :-) [16:05:38] The open RFD counter seems to be stuck at 1 [16:05:47] The live one works, though [16:15:36] hoo: how on earth do you do a history split on an ariticle? >.> [16:16:36] addshore: Delete some revisions, use page move to move the others, restore deleted revision, ~~insanity~~ profit [16:16:48] :P [16:18:08] bingo! [16:18:56] *gets tidying* [16:19:11] hoo: thanks for your help. making some research... [16:39:38] YuviPanda: seems like your fixes helped. Also, the lag (old items keep showing up) seems to be reduced but not good yet. [16:39:49] sjoerddebruin: on wdq you mean? [16:39:59] sjoerddebruin: I re-seeded it with latest dump (from jan 05) [16:40:03] magnus says that should help [16:40:06] Ah. [16:40:08] Yes, it helped. [16:40:23] Will you do it again on monday with the new dump? [16:41:11] sjoerddebruin: is there going to be a new one on Monday? [16:41:26] so, once this grant proposal writing period is over, I think I may actaully want to do some wikidata/rdf hacking for chemical identifiers... [16:41:29] Well, they are weekly so I assume there will be a new one on monday. [16:41:53] YuviPanda: Yes, there will be a new one on Monday, like every week [16:42:12] unless stuff fails again, but I dobut that [16:42:27] (although we never found out why they failed twice in that one week) [16:42:59] hoo: ah, right. [16:43:05] I should script the re-seeding process [16:43:24] re-seeding of WDQ? Or the dumps? [16:44:27] hoo: WDQ [16:44:38] ah, yeah [16:45:17] hoo: it’s slightly complex, since I’ve to generate the binary on one machine, stop wdq, copy it over to the correct location, start wdq, copy the file over to the other machines and restart it there as well [16:45:25] all the while making sure that at least one server is responsive so there’s no downtime [16:46:02] mh :/ [16:46:15] https://www.wikidata.org/wiki/Special:Contributions/BotMultichill <- my first attempt at importing paintings from Commons to Wikidata [16:46:16] uh oh :P [16:46:16] But that screams for automation [16:46:33] the re-seed? [16:46:52] yep [16:50:29] hoo: yeah, completely agree. will probably get to it sometime next week [16:50:34] unless someone else gets to it first ;) [18:17:34] Do you think the username "THE GYM health planet" is promotional? [18:21:20] I'll wait and see what they put on items [18:31:07] GeorgeEdwardC: yeah, that would qualify. [18:33:46] mens sana in corpore sano [18:34:56] Latin? [18:40:55] 3MediaWiki-extensions-WikibaseClient, Wikidata: Order links of the other projects sidebar deterministically - https://phabricator.wikimedia.org/T86328#968554 (10Lydia_Pintscher) p:5Triage>3Normal [18:51:12] 3MediaWiki-extensions-WikibaseClient, Wikidata: Order links of the other projects sidebar deterministically - https://phabricator.wikimedia.org/T86328#968566 (10Tpt) "for instance in alphabetical order of the project code" -> it would be inconsistent between language versions of the same project. Example: link... [19:06:13] is there a rough number of average properties per Wikidata entry (which is close to 13M)? [19:06:30] I'm trying to figure out how many triples a single entry will be... [19:08:25] I think we had statics regarding that at some point [19:08:37] dennyvrandecic_ might know, I think he created them [19:09:07] darn, I can just click that 13M number to get more stats :/ [19:09:09] Or Lydia_WMDE, because Lydia know everything :P [19:09:16] oh, doh [19:09:16] time to take a break from writing, I think... [19:09:22] https://www.wikidata.org/wiki/Special:Statistics [19:09:53] and this one with more relevant data from my Q: https://www.wikidata.org/wiki/Wikidata:Statistics [19:10:08] egonw: https://tools.wmflabs.org/wikidata-todo/stats.php [19:10:14] table for the first graph [19:10:18] "Average number of claims: 0.95 / 2.8" ?? [19:10:35] Lydia_WMDE: ah, thanks! [19:10:42] np [19:11:15] egonw: The stats on that page are from July [19:11:19] so not up to date [19:11:28] yeah, that's OK... [19:11:34] just to get a ball park... [19:11:54] https://tools.wmflabs.org/wikidata-todo/stats.php is current [19:11:55] we were seeing if keeping a SPARQL endpoint live updated... [19:12:01] so, update the endpoint in real time... [19:12:18] there is also a table for distribution of number of statements per item [19:12:24] further down [19:12:56] the hard part is, is to make the proposal clear enough that it convinces the reviewer... [19:13:02] I am not convinced so far... [19:13:13] a full update would need to be within 0.1 sec [19:16:47] ok, thanks all for being so helpful with the numbers! [19:16:49] ttl [20:16:34] 3MediaWiki-extensions-WikibaseClient, Wikidata: Client "add sitelinks" dialog mixes multiple projects without distinction - https://phabricator.wikimedia.org/T71790#968619 (10Nemo_bis) [20:44:49] 3MediaWiki-General-or-Unknown, operations, Services, Wikidata, Analytics, wikidata-query-service: Reliable publish / subscribe event bus - https://phabricator.wikimedia.org/T84923#968636 (10JanZerebecki) http://www.fedmsg.com might fit this need. It is used/developed by Fedora and Debian people and is a federate... [21:11:14] 3Wikidata, MediaWiki-extensions-ConfirmEdit-(CAPTCHA-extension): Cannot add url values as an anonymous or unconfirmed user - https://phabricator.wikimedia.org/T86453#968658 (10aude) [21:16:37] 3Wikidata, MediaWiki-extensions-ConfirmEdit-(CAPTCHA-extension): Cannot add url values as an anonymous or unconfirmed user - https://phabricator.wikimedia.org/T86453#968662 (10aude) I still can't save urls after reverting https://gerrit.wikimedia.org/r/#/c/136323/. When reverting to before https://gerrit.wikimed... [21:20:46] sa [21:29:23] 3Wikidata, MediaWiki-extensions-ConfirmEdit-(CAPTCHA-extension): Cannot add url values as an anonymous or unconfirmed user - https://phabricator.wikimedia.org/T86453#968680 (10aude) [23:58:13] (03CR) 10JanZerebecki: [C: 032] Add missing space to wfDebugLog call in SettingsArray [extensions/Wikibase] - 10https://gerrit.wikimedia.org/r/183860 (owner: 10Hoo man)