[13:49:28] Ugh, wish I could hide label bot edits on my watchlist :( [15:31:00] Technical Advice IRC meeting starting in 30 minutes in channel #wikimedia-tech, hosts: addshore and Lucas_WMDE – all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting [15:31:34] Technical Advice IRC meeting starting in 30 minutes in channel #wikimedia-tech, hosts: @addshore & @Lucas_WMDE - all questions welcome, more infos: https://www.mediawiki.org/wiki/Technical_Advice_IRC_Meeting [17:18:35] Hallo. I have this query: http://tinyurl.com/y8rz68aa [17:18:56] It's based on something that Lucas Werkmeister sent me once. [17:19:07] Very unfortunately, I don't actually know SPARQL :/ [17:19:22] Can anybody please help me modify it a little bit? [17:20:22] I need to filter out all the rows in which ?templateLabel matches the regular expression "^Template:User [a-z-]+" [17:20:43] Lucas_WMDE: ^ :) [17:21:04] aharoni: in a meeting right now, can you ping me again in an hour? :) [17:21:30] np [17:21:55] [ till then, replies from anybody else who knows SPARQL are welcome :) ] [17:23:58] SMalyshev, abartov, addshore, Amir1 [17:24:00] ^ [17:25:11] we all are in the meeting, except abartov [17:29:17] :) [18:03:19] aharoni: http://tinyurl.com/y8gnueo4 [18:03:53] dammit, SMalyshev beat me to it while I was still trying to figure out why http://tinyurl.com/ya52yppj doesn’t work ^^ [18:04:13] Lucas_WMDE: service order is weird :( [18:04:41] sometimes blazegraph just decides to run service in wrong order and ignores all hints, known bug :( [18:05:31] can be solved with subqueries but I am lazy :) [18:06:39] but here’s an alternative suggestion, using the enwiktionary title instead of the English Wikidata label: http://tinyurl.com/y8hjloak [18:07:04] not sure if that’s better or worse… if the two don’t match up it’s probably a bad thing [18:09:30] SMalyshev, Lucas_WMDE - thanks a lot [18:15:18] Lucas_WMDE: yours works too [19:12:24] I suspect that in yours, it only shows items that have a label in English. I'd like to see also those that don't have it. In fact, I don't care in which language the label is shown. But if I just remove `FILTER (lang(?templateLabel) = "en")`, it shows the same item many times in different language. [19:12:28] SMalyshev: ^ [19:13:52] Amir1: I'm trying to do this query for https://phabricator.wikimedia.org/T184716 [19:58:40] Hi, is there a way to do text/string matching on labels? [20:00:40] I've tried FILTER(STRSTARTS(?actorLabel, "American")) but I get no results [20:00:58] I assume it's because the datatype of ?actorLabel is not actually a string? [20:01:16] So I installed Wikibase repo and client on a test wiki and read the primer on the data model and now I've been wondering what to do Wikibase-wise because obviously #1 wouldn't want to dumbly replicate data that is already in Wikidata #2 would like to be able to use data from Wikidata and #3 has no clear understanding how the export and import situation for Wikibase contained information is. [20:27:46] Here's my query btw http://tinyurl.com/yczsowfm [20:28:09] The part that's not working is commented out [20:44:56] audiodude: http://tinyurl.com/y99tjjke seems to work. I haven't been paying much attention lately but I assume it's still not possible to filter on variables created by the label service [21:01:52] It looks like I need to store in Wikibase in an intelligent way information about which which domain of certain online services serves which area and language [21:03:22] some services just change subdomain for language versions but there are those that have multiple coutry-extension with the same name-part and yeay.. languages in subdomains and multiple country-extensions [21:30:18] so I need a way to say that 'Item serves "Country Y" in "Language X" at "subdomain.DomainZ.tld"' [21:31:05] I can't get my brain around this very quickly. Wikibase could be used in soooooooo many ways. [21:44:55] jubo2: It's easy to store that in a relational database, or in tabular format in general (such as an CSV), but you would need more context to properly store that in a knowledge base [21:45:11] What would your items be? [21:45:47] ... or represent? [21:47:58] Missing some context, you could add statements to that "Item" in your example, using the same property (for example, URL) for multiple statements (with a value for each URL) [21:48:30] And you could specify the country and language for each URL as qualifiers [21:51:56] I'm not be very enthusiastic about that solution, but I'm not pretty sure what you want to do [21:52:10] Ok thanks for info abian. [21:52:41] Does that approach serve you, jubo2? [21:52:48] You're welcome :) [21:53:16] abian: Got some lists I have made over the year (knowing that a database is better than a list) [21:54:08] http://test.consumerium.org/wiki/Consumerium_list_of_lists and I want to migrate the information into a Wikibase [21:54:45] I want to do a lot of things and right now sleep [21:55:00] g'nite [21:56:00] G'nite :) [22:52:19] Join