Thank you Stian. So VOS supports bulk loading of JSON-LD using iSQL? In the
link you sent it states that it must be one of the following formats for bulk:
> .grdfGeospatial RDF.nqN-Quads
> <http://dbpedia.org/resource/N-Quads>.ntN-Triples
> <http://dbpedia.org/resource/N-Triples>.owlOWL
> <http://dbpedia.org/resource/Web_Ontology_Language>.rdfRDF/XML
> <http://dbpedia.org/resource/RDF/XML>.trigTriG
> <http://dbpedia.org/resource/TriG_(syntax)>.ttlTurtle
> <http://dbpedia.org/resource/Turtle_(syntax)>.xmlRDF/XML
> <http://dbpedia.org/resource/RDF/XML>
You have tried JSON-LD and it works? Do you happen to have an example query
available that worked for you when importing JSON-LD?
> On Aug 23, 2017, at 4:12 AM, Stian Soiland-Reyes
> <soiland-re...@manchester.ac.uk> wrote:
>
> Hi, if you have SSH access to upload the files directly to the server it is
> usually much easier (and faster) to bulk-load multiple RDF files (including
> JSON-LD) using the bulk loader mechanism with isql:
>
> http://vos.openlinksw.com/owiki/wiki/VOS/VirtBulkRDFLoader
> <http://vos.openlinksw.com/owiki/wiki/VOS/VirtBulkRDFLoader>
>
> Note that the graph name you provide to ld_dir() is ignored for any @graph
> structures in the JSON-LD, but it is used for the statements in the JSON-LD
> default graph. You may want to take that into consideration in your SPARQL
> queries.
>
> --
> Stian Soiland-Reyes, eScience Lab
> School of Computer Science, The University of Manchester
> http://orcid.org/0000-0001-9842-9718 <http://orcid.org/0000-0001-9842-9718>
>
> From: Jason Haag <mailto:jhaa...@gmail.com>
> Sent: 22 August 2017 23:49
> To: virtuoso-users@lists.sourceforge.net
> <mailto:virtuoso-users@lists.sourceforge.net>
> Subject: [Virtuoso-users] JSON-LD Help
>
> Hi Virtuoso Users,
>
> I would like to be able to import several JSON-LD published datasets into
> virtuoso and run a crawl job.
>
> I have tried this approach
> https://stackoverflow.com/questions/32298456/how-to-import-json-ld-into-virtuoso
>
> <https://stackoverflow.com/questions/32298456/how-to-import-json-ld-into-virtuoso>
>
> I used the following SPARQL query to import the JSON-LD document from the DAV
> folder:
>
> define get:soft "replace" SELECT * FROM
> <http://34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld
>
> <http://34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld>>
> WHERE {?s ?p ?o}
>
> The SPARQL interface returned the following:
>
> { "head": { "link": [], "vars": ["s", "p", "o"] },
> "results": { "distinct": false, "ordered": true, "bindings": [
> { "s": { "type": "uri", "value":
> "http://34.228.166.79:8890/about/id/http/34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld
>
> <http://34.228.166.79:8890/about/id/http/34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld>"
> } , "p": { "type": "uri", "value":
> "http://www.w3.org/1999/02/22-rdf-syntax-ns#type
> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>" }
> , "o": { "type": "uri", "value": "http://xmlns.com/foaf/0.1/Document
> <http://xmlns.com/foaf/0.1/Document>" }},
> { "s": { "type": "uri", "value":
> "http://34.228.166.79:8890/about/id/http/34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld
>
> <http://34.228.166.79:8890/about/id/http/34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld>"
> } , "p": { "type": "uri", "value": "http://xmlns.com/foaf/0.1/primaryTopic
> <http://xmlns.com/foaf/0.1/primaryTopic>" }
> , "o": { "type": "uri", "value":
> "http://34.228.166.79:8890/about/id/entity/http/34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld
>
> <http://34.228.166.79:8890/about/id/entity/http/34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld>"
> }},
> { "s": { "type": "uri", "value":
> "http://34.228.166.79:8890/about/id/http/34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld
>
> <http://34.228.166.79:8890/about/id/http/34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld>"
> } , "p": { "type": "uri", "value": "http://vocab.deri.ie/void#inDataset
> <http://vocab.deri.ie/void#inDataset>" }
> , "o": { "type": "uri", "value":
> "http://34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld
>
> <http://34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld>"
> }},
> { "s": { "type": "uri", "value":
> "http://34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld
>
> <http://34.228.166.79:8890/DAV/home/dba/rdf_sink/xapi-authored-profiles/adb.jsonld>"
> }
> , "p": { "type": "uri", "value": "http://rdfs.org/ns/void#sparqlEndpoint
> <http://rdfs.org/ns/void#sparqlEndpoint>" }
> , "o": { "type": "uri", "value": "http://localhost:8890/sparql/
> <http://localhost:8890/sparql/>" }} ] } }
>
>
> If I search for the named entity using the Faceted Browser, I get the
> following error:
>> Error 42000
>>
>> SR186:SECURITY: No permission to execute procedure DB.DBA.rdfdesc_http_url
>> with user ID 107, group ID 107
>>
> Is there a better way to import JSON-LD?
>
> I also tried to import using sponger pragmas and the actual graph IRI:
>
> define get:accept "application/ld+json" SELECT * FROM
> <https://w3id.org/xapi/adb <https://w3id.org/xapi/adb>> WHERE {?s ?p ?o} .
>
> And it returned the following.
>
> s p o
> http://34.228.166.79:8890/about/id/https/w3id.org/xapi/adb
> <http://34.228.166.79:8890/about/id/https/w3id.org/xapi/adb>
> http://www.w3.org/1999/02/22-rdf-syntax-ns#type
> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>
> http://xmlns.com/foaf/0.1/Document <http://xmlns.com/foaf/0.1/Document>
> http://34.228.166.79:8890/about/id/https/w3id.org/xapi/adb
> <http://34.228.166.79:8890/about/id/https/w3id.org/xapi/adb>
> http://xmlns.com/foaf/0.1/primaryTopic
> <http://xmlns.com/foaf/0.1/primaryTopic>
> http://34.228.166.79:8890/about/id/entity/https/adlnet.github.io/xapi-authored-profiles/adb.jsonld
>
> <http://34.228.166.79:8890/about/id/entity/https/adlnet.github.io/xapi-authored-profiles/adb.jsonld>
> http://34.228.166.79:8890/about/id/https/w3id.org/xapi/adb
> <http://34.228.166.79:8890/about/id/https/w3id.org/xapi/adb>
> http://vocab.deri.ie/void#inDataset <http://vocab.deri.ie/void#inDataset>
> https://w3id.org/xapi/adb <https://w3id.org/xapi/adb>
> https://w3id.org/xapi/adb <https://w3id.org/xapi/adb>
> http://rdfs.org/ns/void#sparqlEndpoint
> <http://rdfs.org/ns/void#sparqlEndpoint> http://localhost:8890/sparql/
> <http://localhost:8890/sparql/>
>
>
> So it appears to be creating the graph IRI in virtuoso, but I’m not
> understanding why it isn’t importing the data. None of the triples in the
> JSON-LD document are showing up when I query via SPARQL or search via FCT.
>
> Appreciate any tips or guidance.
>
> Regards,
>
> J Haag
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
