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ö salgo60@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
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-bounces@lists.wikimedia.org on behalf of David Lowe davidlowe@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 jane023@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 davidlowe@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 jane023@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 davidlowe@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 davidlowe@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 jane023@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 davidlowe@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 jane023@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 davidlowe@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 jane023@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 davidlowe@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 < >>>>>> sjoerddebruin@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 davidlowe@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