Magnus,
Jane was very helpful, and I was able to load in the ID which were
returning errors.
However, the problem now is that the query returns only ~11,000 results,
though it should return nearly 14,000.

PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
PREFIX q: <http://www.wikidata.org/prop/qualifier/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?photographer ?photographerLabel ?pic WHERE {
   ?photographer wdt:P106 wd:Q33231 .
   ?photographer wdt:P2750 ?pic .
   SERVICE wikibase:label {
     bd:serviceParam wikibase:language "en" .
 }
}
Order by ?pic


Here
<https://docs.google.com/spreadsheets/d/1Sw8UE-cZyvnKuTmzrlpzHDdzMfg0doj83GhUpwQ1SkI/edit?usp=sharing>
are 2,600 items with PIC IDs in the record, but which were not returned by
the above search.

I trust this is sufficiently expressed.

d


*David Lowe | The New York Public Library**Specialist II, Photography
Collection*

*Photographers' Identities Catalog <http://pic.nypl.org>*

On Fri, Aug 11, 2017 at 12:48 PM, Magnus Sälgö <salg...@msn.com> wrote:

> If you expect an answer please express what your problem is better
>
> I checked https://www.wikidata.org/wiki/Q6272416
> Jonathan Allen - Wikidata <https://www.wikidata.org/wiki/Q6272416>
> Language Label Description Also known as; English: Jonathan Allen. English
> artist
> www.wikidata.org
>
> and I can see Photographers' Identities Catalog ID
> <https://www.wikidata.org/wiki/Property:P2750>
>
> I do a query then I find them
>
> http://tinyurl.com/ybnuf6es
>
> Regards
> Magnus Sälgö
>
> Ps. I did a video today of using QuickStatement to upload if that is the 
> problem...https://www.youtube.com/watch?v=m229Tmhfwn8
>
>
>
>
> ------------------------------
> *From:* Wikidata <wikidata-boun...@lists.wikimedia.org> on behalf of
> David Lowe <davidl...@nypl.org>
> *Sent:* Friday, August 11, 2017 6:36 PM
> *To:* Discussion list for the Wikidata project.
> *Subject:* Re: [Wikidata] quickstatements invalid snak.
>
> They still don't show up...
>
>
> *David Lowe | The New York Public Library **Specialist II, Photography
> Collection*
>
> *Photographers' Identities Catalog <http://pic.nypl.org>*
>
> On Thu, Aug 10, 2017 at 11:10 AM, Jane Darnell <jane...@gmail.com> wrote:
>
>> Well don't forget it's Wikimania and presumably there is a surge of
>> edits, so there may be a longer database lag than usual.
>>
>> On Thu, Aug 10, 2017 at 10:27 AM, David Lowe <davidl...@nypl.org> wrote:
>>
>>> I was keeping an eye on errors. There were probably less than two dozen
>>> out of 2500, but I was hoping to look at those specifically. Not nearly
>>> enough to account for the difference.
>>> I also notice that this query returns either 11348 results, or 11349
>>> results at different times (I noticed that behavior yesterday, too).
>>> I wonder if the double quotes did something funny...
>>>
>>>
>>> *David Lowe | The New York Public Library **Specialist II, Photography
>>> Collection*
>>>
>>> *Photographers' Identities Catalog <http://pic.nypl.org>*
>>>
>>> On Thu, Aug 10, 2017 at 9:57 AM, Jane Darnell <jane...@gmail.com> wrote:
>>>
>>>> Did you check your output from quick statements? Sometimes quick
>>>> statements returns errors (if the entry is invalid for any reason). I
>>>> noticed that there were several contraints enabled for this property and
>>>> oddly, one of the items I checked of the ones that I did yesterday also
>>>> already had this property set (and it didn't work, so should probably be
>>>> removed)
>>>> https://www.wikidata.org/wiki/Q64714
>>>>
>>>> On Thu, Aug 10, 2017 at 9:47 AM, David Lowe <davidl...@nypl.org> wrote:
>>>>
>>>>> So I loaded another 2500 PIC IDs yesterday, but they don't turn up in
>>>>> the WD Query Service results <http://tinyurl.com/y8xw8mh8>. When I
>>>>> compare the results to what I have locally in my database, and spotcheck
>>>>> those not returned in this query, my PIC IDs are in fact in Wikidata....
>>>>> Why am I getting incomplete results?
>>>>>
>>>>>
>>>>> *David Lowe | The New York Public Library **Specialist II,
>>>>> Photography Collection*
>>>>>
>>>>> *Photographers' Identities Catalog <http://pic.nypl.org>*
>>>>>
>>>>> On Wed, Aug 9, 2017 at 2:13 PM, David Lowe <davidl...@nypl.org> wrote:
>>>>>
>>>>>> Yeah, I must have triggered something once I loaded 500 at once, as
>>>>>> they worked with the integer before that... Anyway, glad to be back to 
>>>>>> work!
>>>>>>
>>>>>> d
>>>>>>
>>>>>>
>>>>>> *David Lowe | The New York Public Library **Specialist II,
>>>>>> Photography Collection*
>>>>>>
>>>>>> *Photographers' Identities Catalog <http://pic.nypl.org>*
>>>>>>
>>>>>> On Wed, Aug 9, 2017 at 2:11 PM, Jane Darnell <jane...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> I vaguely remember there was a problem if I tried to paste too many
>>>>>>> lines of statements. I can't remember what it was, but I could open more
>>>>>>> windows and run several batches at the same time
>>>>>>>
>>>>>>> On Wed, Aug 9, 2017 at 2:08 PM, David Lowe <davidl...@nypl.org>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Huh, weird... And thanks, Jane. I'll try that again.
>>>>>>>>
>>>>>>>> d
>>>>>>>>
>>>>>>>>
>>>>>>>> *David Lowe | The New York Public Library **Specialist II,
>>>>>>>> Photography Collection*
>>>>>>>>
>>>>>>>> *Photographers' Identities Catalog <http://pic.nypl.org>*
>>>>>>>>
>>>>>>>> On Wed, Aug 9, 2017 at 2:04 PM, Jane Darnell <jane...@gmail.com>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Well I just tried this and it worked with no error:
>>>>>>>>> Q6272416
>>>>>>>>> P2750 "1946"
>>>>>>>>> Q64714 P2750 "1956"
>>>>>>>>> Q5301725 P2750 "1976"
>>>>>>>>> Q18356603 P2750 "2010"
>>>>>>>>>
>>>>>>>>> On Wed, Aug 9, 2017 at 1:48 PM, David Lowe <davidl...@nypl.org>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> Jane,
>>>>>>>>>> I did, and still returned an error. Also, I TRIMed and multiplied
>>>>>>>>>> the values by 1 in my spreadsheet to make sure they were integers. I 
>>>>>>>>>> copied
>>>>>>>>>> the values from the spreadsheet both as a .csv and as an excel 
>>>>>>>>>> spreadsheet.
>>>>>>>>>> I also copied into a word document to verify that there were TAB
>>>>>>>>>> characters. It still returned an error.
>>>>>>>>>>
>>>>>>>>>> David
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> *David Lowe | The New York Public Library **Specialist II,
>>>>>>>>>> Photography Collection*
>>>>>>>>>>
>>>>>>>>>> *Photographers' Identities Catalog <http://pic.nypl.org>*
>>>>>>>>>>
>>>>>>>>>> On Wed, Aug 9, 2017 at 1:44 PM, Jane Darnell <jane...@gmail.com>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> did you try it with quotes? Looks like your property is numeric,
>>>>>>>>>>> but I think this doesn't matter for quick statements input
>>>>>>>>>>>
>>>>>>>>>>> On Wed, Aug 9, 2017 at 1:22 PM, David Lowe <davidl...@nypl.org>
>>>>>>>>>>> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Sjoerd,
>>>>>>>>>>>>
>>>>>>>>>>>> No these are unique identifiers in Photographers' Identities
>>>>>>>>>>>> Catalog <http://pic.nypl.org/constituents/1946>.
>>>>>>>>>>>>
>>>>>>>>>>>> David
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> *David Lowe | The New York Public Library **Specialist II,
>>>>>>>>>>>> Photography Collection*
>>>>>>>>>>>>
>>>>>>>>>>>> *Photographers' Identities Catalog <http://pic.nypl.org>*
>>>>>>>>>>>>
>>>>>>>>>>>> On Wed, Aug 9, 2017 at 1:11 PM, Sjoerd de Bruin <
>>>>>>>>>>>> sjoerddebr...@me.com> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> Are these dates? Be sure to note them down in UNIX timestamp
>>>>>>>>>>>>> format, as explained on the first version of QuickStatements.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Op 9 aug. 2017 om 18:52 heeft David Lowe <davidl...@nypl.org>
>>>>>>>>>>>>> het volgende geschreven:
>>>>>>>>>>>>>
>>>>>>>>>>>>> I'm getting 100% "invalid snak." errors when I run
>>>>>>>>>>>>> quickstatement (version 1 and 2).
>>>>>>>>>>>>> It's been awhile since I used it, so I did a single statement,
>>>>>>>>>>>>> which worked, then 10 or so, which also worked. I did 100 
>>>>>>>>>>>>> statements & spot
>>>>>>>>>>>>> checked a couple of them, which seemed to work. I tried 500 and 
>>>>>>>>>>>>> it didn't
>>>>>>>>>>>>> (I hadn't noticed the error log beneath the HOWTO until this 
>>>>>>>>>>>>> point). I
>>>>>>>>>>>>> switched to version 2, and can't update with that either. I can 
>>>>>>>>>>>>> manually
>>>>>>>>>>>>> update the same records, but something's gone wrong with my use of
>>>>>>>>>>>>> quickstatements. Magnus, someone help?
>>>>>>>>>>>>> I'm copy & pasting from Excel:
>>>>>>>>>>>>>
>>>>>>>>>>>>> Q6272416 P2750 1946
>>>>>>>>>>>>> Q64714 P2750 1956
>>>>>>>>>>>>> Q5301725 P2750 1976
>>>>>>>>>>>>> Q18356603 P2750 2010
>>>>>>>>>>>>>
>>>>>>>>>>>>> etc.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Many thanks in advance (love this tool).
>>>>>>>>>>>>>
>>>>>>>>>>>>> David
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> *David Lowe | The New York Public Library **Specialist II,
>>>>>>>>>>>>> Photography Collection*
>>>>>>>>>>>>>
>>>>>>>>>>>>> *Photographers' Identities Catalog <http://pic.nypl.org>*
>>>>>>>>>>>>>
>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>> Wikidata mailing list
>>>>>>>>>>>>> Wikidata@lists.wikimedia.org
>>>>>>>>>>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>>> Wikidata mailing list
>>>>>>>>>>>>> Wikidata@lists.wikimedia.org
>>>>>>>>>>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> _______________________________________________
>>>>>>>>>>>> Wikidata mailing list
>>>>>>>>>>>> Wikidata@lists.wikimedia.org
>>>>>>>>>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> Wikidata mailing list
>>>>>>>>>>> Wikidata@lists.wikimedia.org
>>>>>>>>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> _______________________________________________
>>>>>>>>>> Wikidata mailing list
>>>>>>>>>> Wikidata@lists.wikimedia.org
>>>>>>>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> Wikidata mailing list
>>>>>>>>> Wikidata@lists.wikimedia.org
>>>>>>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Wikidata mailing list
>>>>>>>> Wikidata@lists.wikimedia.org
>>>>>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Wikidata mailing list
>>>>>>> Wikidata@lists.wikimedia.org
>>>>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Wikidata mailing list
>>>>> Wikidata@lists.wikimedia.org
>>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> Wikidata mailing list
>>>> Wikidata@lists.wikimedia.org
>>>> https://lists.wikimedia.org/mailman/listinfo/wikidata
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Wikidata mailing list
>>> Wikidata@lists.wikimedia.org
>>> https://lists.wikimedia.org/mailman/listinfo/wikidata
>>>
>>>
>>
>> _______________________________________________
>> Wikidata mailing list
>> Wikidata@lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/wikidata
>>
>>
>
_______________________________________________
Wikidata mailing list
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata

Reply via email to