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 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


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
Language Label Description Also known as; English: Jonathan Allen. English artist

and I can see Photographers' Identities Catalog ID

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-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.
 

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

Photographers' Identities Catalog


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


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)

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. 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


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


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


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


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.

David

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

Photographers' Identities Catalog


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

_______________________________________________
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