ISNI - Revision history

Tobiasco at 2023-04-08T23:31:41

2023-04-08T23:31:41Z

← Older revision		Revision as of 2023-04-08T23:31:41
Line 129:		Line 129:
	==About==		==About==
	*https://wiki.duraspace.org/display/PCCISNI/Getting+started+with+ISNI+and+the+ISNI+web+interface		*https://wiki.duraspace.org/display/PCCISNI/Getting+started+with+ISNI+and+the+ISNI+web+interface

			==Website search==
			https://isni.org/isni/0000000401061251
			Pérez Pardal, Juan José
			not found when searching
			Juan Pardal
			Pardal, José

2018-09-04T00:30:54Z

← Older revision		Revision as of 2018-09-04T00:30:54
Line 126:		Line 126:
	WHERE wikidata_qid_isni.qid IS NULL		WHERE wikidata_qid_isni.qid IS NULL
	AND viaforg_viaf_isni.isni IS NOT NULL		AND viaforg_viaf_isni.isni IS NOT NULL

			==About==
			*https://wiki.duraspace.org/display/PCCISNI/Getting+started+with+ISNI+and+the+ISNI+web+interface

2017-09-22T03:14:15Z

Wikidata

← Older revision		Revision as of 2017-09-22T03:14:15
Line 114:		Line 114:
	}		}
	ORDER BY ?qid		ORDER BY ?qid
			===Wikidata missing===
			SELECT wikidata_qid_viaf.qid,wikidata_qid_viaf.viaf,viaforg_viaf_isni.isni
			FROM `wikidata_qid_viaf`

			LEFT JOIN wikidata_qid_isni
			ON wikidata_qid_viaf.qid = wikidata_qid_isni.qid

			LEFT JOIN viaforg_viaf_isni
			ON wikidata_qid_viaf.viaf = viaforg_viaf_isni.viaf

			WHERE wikidata_qid_isni.qid IS NULL
			AND viaforg_viaf_isni.isni IS NOT NULL

2017-09-21T18:34:19Z

Wikidata

← Older revision		Revision as of 2017-09-21T18:34:19
Line 95:		Line 95:

	Timeout		Timeout
			http://tinyurl.com/yd4bmqgj
	SELECT ?qid ?viaf		SELECT ?qid ?viaf
	WHERE		WHERE
Line 101:		Line 102:
	?item wdt:P214 ?viaf		?item wdt:P214 ?viaf
	FILTER NOT EXISTS{ ?item wdt:P213 ?isni }		FILTER NOT EXISTS{ ?item wdt:P213 ?isni }
			}
			ORDER BY ?qid

			2017-09-21: 1064452 results
			http://tinyurl.com/yafxk3cj
			SELECT ?qid ?viaf
			WHERE
			{
			BIND( xsd:integer( STRAFTER( STR( ?item ), STR( wd:Q ) ) ) AS ?qid )
			?item wdt:P214 ?viaf
	}		}
	ORDER BY ?qid		ORDER BY ?qid

2017-09-21T18:30:34Z

Wikidata

@@ Line 91: / Line 91: @@
    ?item wdt:P214 ?viaf
    OPTIONAL {?item wdt:P213 ?isni.}
+  }
   ORDER BY ?qid

2017-09-21T18:21:10Z

Wikidata

2017-09-21T18:18:48Z

Wikidata

@@ Line 69: / Line 69: @@
    BIND( xsd:integer( STRAFTER( STR( ?item ), STR( wd:Q ) ) ) AS ?qid )
    ?item wdt:P213 ?isni
+  }
   ORDER BY ?qid

2017-09-21T17:34:41Z

viaf-20170806-links.isni-noprefix.isni

← Older revision		Revision as of 2017-09-21T17:34:41
Line 58:		Line 58:

	===viaf-20170806-links.isni-noprefix.isni===		===viaf-20170806-links.isni-noprefix.isni===
	zcat viaf-20170806-links.txt.gz \| fgrep 'ISNI' \| sed -e 's@http://viaf.org/viaf/@@' -e 's/[\t\|]/,/g~~' -e s'/ISNI,//~~' -e s'/[0-9]*,//'> viaf-20170806-links.isni-noprefix.isni.txt		zcat viaf-20170806-links.txt.gz \| fgrep 'ISNI' \| sed -e 's@http://viaf.org/viaf/@@' -e s'/ISNI,//' -e 's/[\t\|]/,/g' -e s'/[0-9]*,//'> viaf-20170806-links.isni-noprefix.isni.txt

	==Wikidata==		==Wikidata==

2017-09-21T17:34:10Z

viaf-20170806-links.isni-noprefix.isni

← Older revision		Revision as of 2017-09-21T17:34:10
Line 56:		Line 56:
	===viaf-20170806-links.isni-noprefix.isni-viaf===		===viaf-20170806-links.isni-noprefix.isni-viaf===
	7z a viaf-20170806-links.isni-noprefix.isni-viaf.sort.csv.7z viaf-20170806-links.isni-noprefix.isni-viaf.sort.csv		7z a viaf-20170806-links.isni-noprefix.isni-viaf.sort.csv.7z viaf-20170806-links.isni-noprefix.isni-viaf.sort.csv

			===viaf-20170806-links.isni-noprefix.isni===
			zcat viaf-20170806-links.txt.gz \| fgrep 'ISNI' \| sed -e 's@http://viaf.org/viaf/@@' -e 's/[\t\|]/,/g' -e s'/ISNI,//' -e s'/[0-9]*,//'> viaf-20170806-links.isni-noprefix.isni.txt

	==Wikidata==		==Wikidata==

2017-09-21T17:24:39Z

Wikidata