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