Open mr-niels-christensen opened 9 years ago
INSERT {{ ?urilink <{rdf.type}> <{sepake.UKEOFActivity}> . ?urilink <{prov.wasInfluencedBy}> ?row . ?urilink <{foaf.homepage}> ?homepage . }} WHERE {{ ?row <{rdf.type}> <{csv.Row}> . ?row <{rdfs.member}> ?typecell . ?typecell <{rdf.type}> <{csv.Cell}> . ?typecell <{csv.fieldName}> "Type" . ?typecell <{csv.fieldValue}> "Activity" . ?row <{rdfs.member}> ?linkcell . ?linkcell <{rdf.type}> <{csv.Cell}> . ?linkcell <{csv.fieldName}> "Link to full record" . ?linkcell <{csv.fieldValue}> ?link . BIND ( STRAFTER ( ?link, "/id/" ) AS ?uuid) BIND ( URI( CONCAT ( STR( <{sepake.UKEOFActivity}> ), "#", ?uuid) AS ?urilink) BIND (URI(?link) AS ?homepage) }}
INSERT {{ ?urilink <{rdf.type}> <{sepake.UKEOFActivity}> . ?urilink <{prov.wasInfluencedBy}> ?row . ?urilink <{foaf.homepage}> ?homepage . }} WHERE {{ ?row <{rdf.type}> <{csv.Row}> . ?row <{rdfs.member}> ?typecell . ?typecell <{rdf.type}> <{csv.Cell}> . ?typecell <{csv.fieldName}> "Type" . ?typecell <{csv.fieldValue}> "Activity" . ?row <{rdfs.member}> ?linkcell . ?linkcell <{rdf.type}> <{csv.Cell}> . ?linkcell <{csv.fieldName}> "Link to full record" . ?linkcell <{csv.fieldValue}> ?link . BIND ( STRAFTER ( ?link, "/id/" ) AS ?uuid) BIND ( URI( CONCAT ( STR( <{sepake.UKEOFActivity}> ), "#", ?uuid) AS ?urilink) BIND (URI(?link) AS ?homepage) }}