On 12/16/10 7:38 AM, Pierre-Yves wrote:
Hi Hugh,
This is what I do:
$ /usr/libexec/virtuoso/isql virtuoso
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (ODBC), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> DB.DBA.RDF_LOAD_RDFXML_MT (file_to_string_output
('/home/pingou/Desktop/file.rdf'), '', 'http://test.pbr.wur.nl/');
Done. -- 44007 msec.
SQL>
SQL> DB.DBA.RDF_LOAD_RDFXML_MT (file_to_string_output ('file.rdf'), '',
'http://test.pbr.wur.nl/');
*** Error 42000: [OpenLink][Virtuoso iODBC Driver][Virtuoso
Server]FA112: Can't stat file 'file.rdf', error (2) : No such file or
directory
at line 3 of Top-Level:
DB.DBA.RDF_LOAD_RDFXML_MT (file_to_string_output ('file.rdf'), '',
'http://test.pbr.wur.nl/')
While running the isql from the correct folder.
Best regards,
Pierre
Pierre,
It depends on your server 'root' re. Virtuoso. Note, there are two
realms in play re. scope: DBMS engine and HTTP. For DBMS the directory
($VIRT_HOME/database) hosting .ini and .db is the 'root' while for HTTP
it's $VIRT_HOME/vsp .
Absolute and Relative references work.
Kingsley
On Thu, 2010-12-16 at 11:09 +0000, Hugh Williams wrote:
Hi Pierre,
Relative paths work for me:
$ /opt/virtuoso/bin/isql 1162
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> DB.DBA.RDF_LOAD_RDFXML_MT (file_to_string_output ('dumps/vc-db-1.rdf'),
'', 'http://mytest.com');
Done. -- 531 msec.
SQL> sparql select count(*) from<http://mytest.com> where {?s ?p ?o};
callret-0
INTEGER
_______________________________________________________________________________
16
1 Rows. -- 13 msec.
SQL>
How are you calling the function ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 16 Dec 2010, at 10:37, Pierre-Yves wrote:
Hi,
Just a small remark about this subject. When I use the method [1], I
have to specify the full path, not just the relative path as shown in
the example.
Thanks for your help,
Pierre
[1]: http://docs.openlinksw.com/virtuoso/fn_rdf_load_rdfxml_mt.html
On Wed, 2010-12-15 at 08:42 +0100, Pierre-Yves wrote:
Hi Hugh,
I guess you were refering to :
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFInsert#Loading%20RDF%20datasets%20into%20one%20or%20more%20Virtuoso%20Graph%20IRIs
and
http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFInsert#Loading%20RDF%20datasets%20into%20a%20Virtuoso%20Graph%20IRI
Thanks a lot for documenting this !
Best regards,
Pierre
On Wed, 2010-12-15 at 02:42 +0000, Hugh Williams wrote:
Forgot the link,
http://edit-wiki.usnet.private/dataspace/dav/wiki/VOS/VirtRDFInsert#Loading%20RDF%20datasets%20into%20a%20Virtuoso%20Graph%20IRI
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 15 Dec 2010, at 02:39, Hugh Williams wrote:
Hi Pierre,
You can use one of the two Virtuoso functions for loading TTL and RDF/XML
datasets, which I have just added to the VirtInsertRDF page you refer to.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 14 Dec 2010, at 16:17, Pierre-Yves wrote:
Dear list,
I have to upload a medium size rdf file into a virtuoso (Version:
06.01.3126). I have been looking at the page [1] but it seems to only go
through the webdav when it comes to upload a file.
I tried :
curl -i -T myrdf.rdf
http://localhost:8890/DAV/home/pingou/rdf_sink/test.rdf -u user:passwd
This seems to work.
Then I ran
curl -F "query=SELECT DISTINCT ? FROM
<http://localhost:8890/DAV/home/pingou/rdf_sink/> WHERE {?s ?p ?o}"
http://localhost:8890/sparql
But this returns an empty list.
I tried to run
SPARQL SELECT * FROM<http://localhost:8890/DAV/home/pingou/rdf_sink>
WHERE {?s ?p ?o} LIMIT 100;
via isql but this also return an empty list.
On my machine I have access to a newer virtuoso (Version: 06.01.3127)
which contains on the conductor> RDF a "RDF Store Upload" with which I
can upload any rdf file to the graph of my choice.
I was wondering if I could do something like (in isql):
SPARQL INSERT IN GRAPH<http://BookStore.com> { myrdf.rdf };
(of course I tried this and things like cat(myrdf.rdf) and it does not
work)
(Also as a side question, when I insert in graph via isql, I can query
it in the localhost:8890/sparql, but I don't see the graph being shown
under Conductor> RDF> Graphs. Is this expected ?)
So in summary, do I have a way to upload a file into the graph of my
choice when not having the "RDF Store Upload" tab ?
Thanks in advance,
Pierre
[1] http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFInsert
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Regards,
Kingsley Idehen
President& CEO
OpenLink Software
Web: http://www.openlinksw.com
Weblog: http://www.openlinksw.com/blog/~kidehen
Twitter/Identi.ca: kidehen
