[03:38:32] <Nazral>	 Hi
[03:39:06] <Nazral>	 https://pastebin.com/uTQjvkyd is working on https://query.wikidata.org but not on the sparql endpoint with curl while yesterday this exact query worked
[03:41:20] <Nazral>	 java.util.concurrent.ExecutionException: org.openrdf.query.MalformedQueryException: Encountered " "count" "COUNT "" at line 1,
[05:01:10] <Nazral>	 Nevermind, I found the mistake
[05:10:46] <frickel>	 can i split an item?
[05:11:09] <frickel>	 and have all the reference to the item, now pointing to the two items
[05:59:27] <beshoo>	 i did : ./loadData.sh -n wdq -d ./data/split , it reach 75 and serverkiled the proc. now i want to start form that file , i restart the server 9999 , from runBlazegraph.sh and "./loadData.sh -n wdq -d ./data/split -s 75 "
[05:59:49] <beshoo>	 it start giving me loop error messages
[05:59:58] <beshoo>	 Caused by: java.lang.RuntimeException: Could not load: url=file://./data/split/wikidump-000000075.ttl.gz, cause=java.net.UnknownHostException: .
[06:00:09] <beshoo>	 with all rest of files 
[06:03:07] <beshoo>	 any advice
[06:03:40] <beshoo>	 here is the error : https://pastebin.com/G1GBywXG
[06:22:32] <SMalyshev>	 hmm it looks like it thinks . is the hostname. Try giving full path to -d
[06:23:04] <beshoo>	 i did
[06:23:08] <beshoo>	 same thing
[06:23:34] <SMalyshev>	 can't be same thing, where it would take "./data/split" then?
[06:24:12] <SMalyshev>	 what is the exact command line you are usng?
[06:24:14] <SMalyshev>	 *using
[06:24:17] <beshoo>	 Hold 
[06:24:24] <beshoo>	 lt seems working 
[06:24:31] <SMalyshev>	 okie
[06:24:37] <beshoo>	 ./loadData.sh -n wdq -d /download/wiki/service-0.3.0/data/split -s 75
[06:26:18] <beshoo>	 Processing wikidump-000000075.ttl.gz
[06:26:19] <beshoo>	 waiting ............. which mean it is working correct ?
[06:26:29] <SMalyshev>	 yep this should work
[06:26:33] <SMalyshev>	 yes this looks good
[06:27:05] <SMalyshev>	 you'd probably need to wait for a while. If there's no exceptions then everything is good
[06:27:12] <beshoo>	 Well , i like to ask , is it important to Processing all file to get human name and gender ?
[06:27:38] <beshoo>	 i can get human names but gender labaile return as ID
[06:27:54] <SMalyshev>	 well, the statemens are in no particular order, so if you want all humans you need all of them, or pre-process the dump (e.g. with something like wikidata toolkit)
[06:28:06] <gotitbro>	 I am getting "potential issues" with the Hoovers property (https://www.wikidata.org/wiki/Property:P5232) even when I input correct data; the URLs still work though. I believe the URL formatter regex is incorrect can someone please have a look at this.
[06:28:20] <SMalyshev>	 you *can* make a TTL with just humans and just genders, but you'll need tool that can process dumps
[06:29:07] <beshoo>	 hold let me show you please
[06:30:58] <beshoo>	 lynx 'http://localhost:9999/bigdata/namespace/wdq/sparql?query=SELECT%20?given_name%20?given_nameLabel%20?fnameLabel%20?genderLabel%20?languageLabel%20WHERE%20{%20?given_name%20wdt:P31%20wd:Q5.%20OPTIONAL%20{?given_name%20wdt:P21%20?gender.}%20OPTIONAL%20{?given_name%20wdt:P735%20?fname.}%20OPTIONAL%20{?given_name%20wdt:P103%20?language.}%20SERVICE%20wikibase:label%20{%20bd:serviceParam%20w
[06:30:58] <beshoo>	 ikibase:language%20"[AUTO_LANGUAGE],en".%20}%20}%20LIMIT%2010'
[06:31:07] <beshoo>	 the output :
[06:31:42] <beshoo>	 https://pastebin.com/WHwvpDhd
[06:32:24] <SMalyshev>	 ok so what about it?
[06:32:40] <beshoo>	                         <binding name='fnameLabel'>
[06:32:40] <beshoo>	                                 <literal>Q4357927</literal>
[06:32:40] <beshoo>	                         </binding>
[06:32:46] <beshoo>	 <literal>Q4357927</literal>
[06:32:58] <beshoo>	 is this mean i have to wait all of them ?
[06:33:04] <beshoo>	 to go to memory ?
[06:33:18] <SMalyshev>	 ah, if you get Q in name then it means no label in that language probably
[06:33:37] <SMalyshev>	 if you get the item in the result, it's probably already in the db, otherwise you wouldn't have it there
[06:33:55] <beshoo>	 Nice , Well other one please , i am very happy , there is an expert to ask :) 
[06:34:15] <SMalyshev>	 all data on item are next to each other, so unless you've got it split between files, usually what you have is no label
[06:34:59] <SMalyshev>	 no sure why though - Q4357927 does have en label on wikidata
[06:35:04] <beshoo>	 as you can see i want all human names and gender , but i like to get all name translation to , how can i do that ... some times the name in other lang.
[06:35:10] <SMalyshev>	 ahh wait
[06:35:22] <SMalyshev>	 it's not item's label, it's name's label
[06:35:32] <SMalyshev>	 then yes, it may mean Q4357927 is not loaded yet
[06:35:48] <SMalyshev>	 the item you found has loaded, but the linked ones have not
[06:36:18] <SMalyshev>	 so you'd have to wait to load all names and genders and so on, unfortunately
[06:36:19] <beshoo>	 see my select 
[06:36:21] <beshoo>	 SELECT ?given_name ?given_nameLabel ?fnameLabel ?genderLabel ?languageLabel WHERE { ?given_name wdt:P31 wd:Q5. OPTIONAL {?given_name wdt:P21 ?gender.} OPTIONAL {?given_name wdt:P735 ?fname.} OPTIONAL {?given_name wdt:P103 ?language.} SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } LIMIT 10
[06:36:31] <SMalyshev>	 yeah I see it
[06:37:01] <beshoo>	 Ok let me show you what i need ... from wiki
[06:37:41] <SMalyshev>	 that's what I am saying - you'd have to wait until those entries load too. which unfortunately hard to predict since dumps are generated in split chunks so it's not exactly ordered inside...
[06:38:33] <beshoo>	 i know but we have to add the select to name lang in other lang. 
[06:39:11] <beshoo>	 http://www.wikidata.org/entity/Q11672
[06:39:34] <beshoo>	 All entered languages
[06:39:46] <beshoo>	 i need the name in all All entered languages 
[06:40:01] <beshoo>	 if it avalable 
[06:40:33] <SMalyshev>	 ah, ok, then do ?given_name rdfs:label ?name
[06:40:59] <SMalyshev>	 instead of SERVICE
[06:41:18] <SMalyshev>	 or wait, do you need given_nameLabel in all languages or fnameLabel?
[06:41:39] <beshoo>	 that is what i dont know , i am learning , please can you add it to my select to see how it is 
[06:42:03] <SMalyshev>	 sure, but I need to know what you want to get as a result?
[06:42:07] <beshoo>	 fnameLabel is the giving name which is only in one lang.
[06:42:20] <SMalyshev>	 yes, sure
[06:43:10] <beshoo>	 so i need the given_nameLabel in all languages
[06:43:20] <SMalyshev>	 ah, ok
[06:43:48] <SMalyshev>	 what about other labels?
[06:44:51] <beshoo>	 which is https://i.imgur.com/7CKFP8y.png
[06:45:25] <SMalyshev>	 sure, got that. but what about fnameLabel and genderLabel? do you need them? in which language?
[06:45:50] <beshoo>	 gender in engelich 
[06:46:15] <beshoo>	 and fnameLabel in english since i will get the other translations
[06:47:59] <SMalyshev>	 ok you can do something like this then: http://tinyurl.com/yalwp5vn
[06:49:01] <beshoo>	 Oh hld let me study it :)
[06:55:15] <beshoo>	 it is like magic 
[06:56:10] <beshoo>	 Well i am doing AI gender program , so i need all names as dataset , and then if you type any name in your mind even if it is not in the dataset
[06:56:19] <beshoo>	 it will give you the gender :)
[06:56:27] <beshoo>	 95% of time
[06:56:39] <beshoo>	 do you like to see a small demo :)
[06:57:56] <beshoo>	 https://instaranker.com/panel/gender6.php check this out , once i have full dataset of names , WAW milions of data to learnrom 
[07:00:27] <beshoo>	 BTW can i group by same names ? like i have same name in 5 lang , "Pedro Aguirre Cerda" so if i have more than name "identecal" we chose the home lang.
[07:00:50] <beshoo>	 the main name lang.
[07:01:27] <SMalyshev>	 you probably can... yes, a lot of names will repeat
[07:01:29] <beshoo>	 so in this case we will shrink the amount of same data
[07:01:48] <beshoo>	 How , you are the master :)
[07:01:53] <SMalyshev>	 basically if you've got a person names John Smith, then all latin script languages would have the same name
[07:03:01] <beshoo>	 how can we say : give me the name if it is not the same of the given_nameLabel
[07:03:27] <beshoo>	 got the idea ?
[07:03:51] <SMalyshev>	 you could try something like this: http://tinyurl.com/y7ycgk4n 
[07:04:08] <beshoo>	 let me study it please
[07:04:10] <SMalyshev>	 but you lose the language
[07:04:28] <SMalyshev>	 or do post-processing with some script on the client end
[07:05:00] <SMalyshev>	 maybe some sparql too can do, but can't think about something right now, too late for it here :)
[07:08:22] <beshoo>	 LOL Thank so much i am laring , but why fnameLabel is empty ,
[07:09:31] <beshoo>	 https://www.wikidata.org/wiki/Q855 Joseph Stalin 
[07:12:31] <beshoo>	 (str(?given_nameLabel) as ?label) what is this mean :)
[11:43:29] <abian>	 Translation admins: could someone please mark https://www.wikidata.org/wiki/Wikidata:Property_proposal/Proposal_preload for translation?
[12:50:43] <beshoo>	 i am loading my file ./loadData.sh -n wdq -d /download/wiki/service-0.3.0/data/split -s , the wikidata.jnl and i am at wikidump-000000143.ttl.gz of wikidump-000000507.ttl.gz and the curent wikidata.jnl is 120GB , what is the expected final size :(
[12:51:30] <beshoo>	 and is there any ready to download wikidata.jnl ? 
[14:17:40] <nikki>	 DanielK_WMDE: I even just found an admin marking historical statements as deprecated :(
[14:24:47] <DanielK_WMDE>	 nikki: *sigh*
[14:25:04] <nikki>	 yeah :(
[14:39:30] <sjoerddebruin>	 :(
[18:22:55] <abian>	 Hi, ChAndrew :)
[18:23:21] <abian>	 ChAndrew: Would you mark https://www.wikidata.org/wiki/Wikidata:Property_proposal/Proposal_preload for translation, please? O:)
[18:26:06] <abian>	 If someone wants to win the race, they can too...
[18:28:38] <abian>	 sjoerddebruin, would you?
[18:29:36] <sjoerddebruin>	 don't forget to adjust the translate comments
[18:29:39] <sjoerddebruin>	 multiple <!--T:22--> now
[18:30:09] <abian>	 Hey :)
[18:30:25] <sjoerddebruin>	 hi :)
[18:30:44] <abian>	 I really don't want people to translate that several times
[18:31:01] <abian>	 A single string would be enough
[18:31:06] <abian>	 Is that possible?
[18:31:31] <sjoerddebruin>	 i don't know, it doesn't proceed 
[18:32:43] <abian>	 So should I write Q1, Q2, Q3, etc., and value1, value2, value3, etc.?
[18:33:53] <sjoerddebruin>	 I don't know, not that good in the translate extension
[18:35:28] <abian>	 We could remove the repeated examples and just give one for example 1, what do you think?
[18:35:53] <sjoerddebruin>	 I'm not really focused anymore, long day.
[18:36:56] <abian>	 Time to rest then :)
[18:37:19] <abian>	 "We could remove the repeated examples and just give one for example 1" → I'll do this
[18:38:45] <abian>	 {{done}}
[20:43:13] <jdlrobson>	 IS Thiemo around? I'm having some CI issues due to a phpunit test in WikibaseQuality
[20:43:37] <jdlrobson>	 guessing not because of the time
[20:44:43] <jdlrobson>	 have opened https://phabricator.wikimedia.org/T197038 if anyone knows that extension and can take a look!
[20:51:55] <vincenttoups>	 So I know a little sparql and I'm a little surprised by the way wikidata sparql queries have ?<x>Label terms
[20:52:30] <vincenttoups>	 Its weird that you can have a query which collects for instance ?itemLabel but never mentions an ?itemLabel in the query
[20:52:38] <vincenttoups>	 Can someone point me to relevant documentation?
[20:55:17] <nikki>	 those come from the label service
[20:55:19] <nikki>	 see https://www.mediawiki.org/wiki/Wikidata_Query_Service/User_Manual#Label_service
[20:57:33] <vincenttoups>	 Thanks!
[21:16:58] <beshoo>	 i am loading my file ./loadData.sh -n wdq -d /download/wiki/service-0.3.0/data/split -s , i am at wikidump-000000230.ttl.gz of wikidump-000000507.ttl.gz and the curent wikidata.jnl is 193G, what is the expected final size :(
[21:17:22] <beshoo>	 and is there any ready to download new wikidata.jnl
[21:22:11] <beshoo>	 any advice ?
[23:10:14] <hoo>	 beshoo: I don't think we have a ready wikidata jnl
[23:11:06] <hoo>	 The one we have at Wikimedia (for query.wikidata.org) currently has around 505G
[23:11:10] <hoo>	 * 550
[23:51:55] <beshoo>	 WAW , larger than my HDD
[23:53:35] <beshoo>	 do think mine will reach tht number