[08:13:23] which page to look at if you want to get a musician's full album list? It looks like you need go to the discography page, but many item doesn't have any album bind to it [08:13:33] Thanks in advance! [08:18:32] seanlee: you need to use reasonator or another tool to see the items linked to the page of the musician with the property "performer" [08:19:42] seanlee: Wikidata is made to be visualized through tools and/or re-used, its interface is here for human edition, not really to be human-readable as such [08:20:09] seanlee: so I encourage you to activate reasonator if you want to regularly consult it :) [08:21:10] seanlee: for example, here is how we can see the film in which an actor played: https://tools.wmflabs.org/reasonator/?q=Q342617&lang=en [08:21:56] same thing for musicians, use reasonator and go to the "from related items" section [08:22:09] hope that helps [08:25:50] seanlee: when I said "activate reasonator", I mean that in your preferences you can chose to activate a link to reasonator in the left column, which is really handy [08:26:05] but you can use reasonator without that, of course [08:26:41] * Harmonia_Boulot is always a little rambling before her first cup of tea [08:26:54] (but fortunately, the tea is brewing right now) [08:31:14] Need help on my own. Any idea how to find all items using "Jackie" (exact string) as label in any language, don't care about properties? [08:31:40] SPARQL evidently timeout and I don't know any tools which could do that since Magnus shut down Autolist [08:39:43] please? [08:51:58] :'( [09:03:55] anyone has an idea? [09:30:54] still needing help... [10:04:06] Harmonia_Boulot: thanks alot! I'm actually using the wikidata weekly dump to do this kind of thing, I'll use the offline data since I'll serve for an web app here. I know SPARQL can do this kind of query, but it's kind of hard to inplement that on my machine I think? [10:05:22] seanlee: you want to install your own endpoint instead of using query.wikidata.org ? [10:05:36] no idea how to install your own actually... [10:05:51] (but the SPARQL query is very easy to make) [10:08:30] Harmonia_Boulot: yes..because i don't think you can reply on the wikidata server here. It's better to use it's dump for my own web app? Since I can accpect the data to be one week old here [10:09:02] then probably, yes [10:09:52] and if you query your own dump with your own endpoint, you aren't limited by the 30 sec cut-off of our own endpoint [10:10:08] so if your app need heavier queries, you can do them [10:10:22] but I can't help you in installing your own endpoint, sorry :s [10:13:28] Harmonia_Boulot: thanks a lot still...After some research, seems that you need the RDF database and you could use SPARQL to query [10:14:33] you can download dumps of the database with no problem [10:22:03] Harmonia_Boulot: Found wikidata is using BlazeGraph for SPARQL querying [10:22:11] Harmonia_Boulot: maybe trying this on my own server?.. [10:23:23] really, I can't help you if it's getting technical [10:23:36] sorry [10:23:59] I'm an historian :p [10:24:16] no idea how to operate servers [10:26:07] Harmonia_Boulot: hah! [10:26:17] Harmonia_Boulot: thanks Harmonia! [10:27:52] seanlee: Blazegraph needs quite a bit of resources to function properly. Just some random virtual machine or your laptop won't cut it [10:29:24] Not sure what you want to do exactly seanlee. What is your use case? You might want to look into things like http://linkeddatafragments.org/ (never used it, but looked interesting to play around with) [10:31:28] multichill: Thanks so much for this link! I'll look it up later [10:33:23] multichill: Any idea how to find all items using "Jackie" (exact string) as label in any language, don't care about properties? SPARQL evidently timeout and I don't know any tools which could do that since Magnus shut down Autolist [10:34:05] multichill: seems that exactly what I need in the description, I'm currently build an api using the wikidata dump. But for some query it's kind be hard to do [10:44:02] Harmonia_Boulot: Just an old skool SQL query? [10:44:11] Labels are stored in a table [10:44:27] i don't know how to do an SQL query [10:44:43] I'll write it and put it at https://quarry.wmflabs.org/ [10:45:09] thank you! [10:52:08] Harmonia_Boulot: https://quarry.wmflabs.org/query/14839 [10:52:37] ok, that's not easy to use at all [10:53:18] I'll beg Magnus to add the old autolist functionality to Petscan because that's really to an usable alternative [10:53:54] multichill: thank you [10:54:26] but I won't spend an hour trying to scry the result to find the error that I know exist [10:54:30] results* [10:56:10] Harmonia_Boulot: We might need to start file bugs for cases where the query doesn't work (any more) [10:56:36] So the query engine can be improved or we get better at writing queries [10:57:14] multichill: well queries that don't ever work: queryng labels without restraining it by using properties [10:57:26] querying incomplete labels for people [10:57:35] (like when you search family names) [10:58:42] we used to add semi-automatically given names and surnames by querying people without P735/P734 and partial labels [10:58:53] that's not possible since nearly a year ago [10:59:10] made an huge dent in our progress [10:59:59] Lydia_WMDE: You around? What's your opinion on this? Make one SPARQL performance related bug to see what can be improved? [11:01:05] multichill: right now, I searched all "Jackie" entries because I know there are two items with the couple label "Jackie"/description "given name" (in whatever language) somewhere [11:01:41] because I can't automatically add description to https://www.wikidata.org/wiki/Q16277237 because there is another item with the same couple label/description somewhere [11:01:51] but I can"t find the other one [11:02:25] and i'm not patient enough to scry the 308 "Jackie" out there for my duplicate [11:02:57] the old Autolist gave us a list with descriptions and links [11:03:14] that made correcting this kind of errors easy [11:03:25] and it's a real pain since it was shut down [11:40:09] Harmonia_Boulot: You know the label? [11:40:20] multichill: Jackie [11:41:46] Sorry, description [11:43:46] Harmonia_Boulot: ^ [11:44:10] multichill: not the exact description, no [11:44:37] I know it's "given name" in any of the language handled by the tool which add automatic descriptions [11:44:58] ~60 languages possible [11:45:14] if I knew which, I wouldn't have a problem [12:20:05] Harmonia_Boulot: The question is, what is the exact description you want to add? [12:20:23] And in which language? [12:20:59] I don't want to add a description, I want to merge the two "jackie" given names if there are two, or to correct the wrong descriptions if that's the problem [12:21:35] and I want the Jackie given name item (when there is only one) to have the correct descriptions in all languages handled by the script [12:22:40] which I can't add right now because there is a duplicate somewhere [13:06:47] rip wdq [13:34:52] multichill: sorry. around now. yeah if you want open one. however Stas will announce LDF for testing in the next days. we'll need to see how much that'll help [13:36:59] hello Lydia_WMDE ! [13:37:25] hey Harmonia_Boulot :) [13:37:27] how are you? [13:37:34] better now [13:37:40] \o/ [13:37:51] * Harmonia_Boulot was very bad with Coyau's unexpected death [13:38:04] *hug* [13:38:08] but going to the burial helped me [13:38:17] that's good [13:38:33] and good to hear you were there [13:39:20] he is just in frond of the most unlikely house nearing the cemetery [13:39:27] I think he would have liked that [13:41:20] and in a few hours I have the wikidata workshop :) [13:41:24] :) [13:41:27] awesome [13:41:34] that's always cheers me up [13:41:49] and this time we even have a newbie on the list :p [13:41:54] wohooo [13:41:59] <3 newbies ;-) [13:42:16] :) [13:46:36] Lydia_WMDE: LDF? That sounds like a political party [13:47:27] multichill: lol [13:47:33] linked data fragments [14:57:18] Harmonia_Boulot: did you manage to find the item that's the problem? [14:57:32] nope [14:57:49] but Ash_Crow begged Magnus to activate FIND on Petscan [14:58:15] so I'll try to remember it when Magnus will have done it [14:58:40] what is the error you get? [14:58:52] I don't get an error [14:59:10] simply the script which had automatically descriptions doesn't work [14:59:30] which always mean that a couple label/description already exists in Wikidata [14:59:58] hmm... [14:59:59] so I know that either we have a duplicate to be merged or a wrong description somewhere to correct [15:00:22] i treated hundred of cases like this when we had Autolist [15:00:47] but as SPARQL can't handle without timeout queries about only labels [15:00:53] it's much more difficult now [15:04:21] http://tinyurl.com/z2e7nat maybe it's these two items? [15:05:39] nikki: Q16277237 is one of the problematic ones, yes but Q202444 certainly isn't [15:05:49] it's the generic item about given names [15:05:58] it doesn't have "Jackie" as a label [15:06:11] I worded that badly, I meant only Q19729999 [15:06:33] they both have Джеки as the russian label [15:06:57] nikki: that's it! [15:07:00] thank you [15:07:02] :D [15:07:07] glad I could help [15:09:37] and completed: https://www.wikidata.org/wiki/Q16277237 [15:09:40] :) [15:10:46] I know from previous experience that searching for specific labels is pretty fast (e.g. rdfs:label "Universe"@en) so I thought I would see if it could select the labels for the problem item and then find items which have the same label [15:11:03] I wasn't sure if it would work or time out, but it worked :D [15:11:14] nikki: I didn't see the Russian one [15:11:30] i searched only the Latin-alphabet one [15:11:36] so of course didn't find it [15:11:37] ahh [15:11:39] yeah [15:18:42] anyway, feel free to ping me if you're having problems finding any other items like that. finding things that don't want to be found is very satisfying [15:18:51] ^^ [15:19:43] Lydia_WMDE: do you think SPARQL could be cleaned so items deleted or redirected months ago stop popping in queries? [15:20:10] can something be done about that? [15:22:49] on https://www.wikidata.org/wiki/Wikidata:Contact_the_development_team#More_missing.2Fout_of_date_data_in_query_service it sounds like once the third server is installed, they're going to reload the data [15:23:06] oooh [15:23:08] great [15:23:18] we can hope :) [15:25:50] https://www.wikidata.org/w/index.php?title=User%3AOlaf_Kosinsky%2FNiederlande_Erste_Kammer&type=revision&diff=417022453&oldid=402534273 <- Yah! WDQ to SPARQL conversion :-D [15:26:37] nikki: Could use a hand with https://www.wikidata.org/wiki/Category:Wikidata_list_with_wdq ;-) [15:27:34] huh, I thought listeria automatically replaces wdq queries with sparql? [15:28:21] Only in some cases [15:28:38] https://www.wikidata.org/w/index.php?title=Wikidata:WikiProject_Medicine/Hospitals_by_country/Afghanistan&action=edit <- what the hell are they doing here? [15:30:54] weird. but I guess it's easy to replace it with values ?p31 { ... } and ?item wdt:P31 ?p31 :P [15:32:20] oh wow petscan now supports label/description search... now can happily say goodbye to the autolist [15:32:26] Just did that, going to try if a tree search gives the same result [15:32:42] Stryn: finally! [15:33:46] nikki: https://www.wikidata.org/w/index.php?title=Wikidata%3AWikiProject_Medicine%2FHospitals_by_country%2FAfghanistan&type=revision&diff=417024534&oldid=323179991 [15:34:13] much nicer [15:35:52] And https://www.wikidata.org/w/index.php?title=Wikidata%3AWikiProject_Medicine%2FHospitals_by_country%2FAfghanistan&action=historysubmit&type=revision&diff=417024942&oldid=417024534 is the same so that's easy! [15:35:53] multichill: perhaps ?item wdt:p31/wdt:P279* wd:Q16917? Or would that miss some classes (haven’t checked all of them)? [15:36:05] lol [15:36:10] a second too late :D [15:36:49] I'm just going to have a bot convert the others [15:41:25] https://www.wikidata.org/w/index.php?title=Wikidata%3AWikiProject_Medicine%2FHospitals_by_country%2FAlbania&action=historysubmit&type=revision&diff=417025863&oldid=323841831 bam [15:42:31] * nikki looks confused [15:43:22] I just fixed https://www.wikidata.org/w/index.php?title=Wikidata:WikiProject_Medicine/List_of_New_Zealand_doctors&oldid=251935717 and when I checked the changes it went from being about lighthouses for some reason to doctors (like the page name suggests) [15:43:23] nikki: About what? I'm just using a regex to replace it [15:43:58] Haha, yes, some people copied and paste things and didn't change it [15:44:28] oh I guess it got changed, listeriabot updated it, someone tried to change it back but introduced a syntax error so it never updated again [15:44:58] gave me a bit of a fright though, I wasn't expecting the entire page to change :P [15:46:36] Using a bot makes this a lot easier. Already converted close to 300 lists [15:48:56] cool [15:49:25] https://www.wikidata.org/w/index.php?title=Q413747&type=revision&diff=417026416&oldid=413218554 ... hmm, I wanted to add "314,39" with quickstatements ... Q413747 P2046 314,39 was wrong, help :) [15:52:56] it probably needs to be 314.39 [15:57:36] not it didn't help :/ [16:00:52] strange :/ [16:09:48] oh lovely. I've found some weird behaviour in my keyboard where I can't press C if I haven't completely let go of E (works fine with any other combination of letters I try, also works fine with lowercase...) [16:09:58] no wonder I keep typing SELET instead of SELECT [16:10:34] hoo [16:10:38] is he around? [16:53:57] nikki: Magnus added statistics at https://phabricator.wikimedia.org/T153441 , the WDQ usage is already quite low :-D [18:28:50] can someone help me out with serialization in userscripts/gadgets? I found wikibase.serialization.*Serializer/Deserializer, but `new wikibase.serialization.StatementDeserializer()` returns a blank object (no deserialize method) [18:28:57] is there documentation on this anywhere?