Hi Pierre,
The relative path base is the server working directory i.e. in the place where
virtuoso.ini file is, and since your file is on desktop server can't find it
unless full path is given.
Best Regards,
Mitko
On Dec 16, 2010, at 2:38 PM, 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
>
>
>
> 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
--
Mitko Iliev
Developer Virtuoso Team
OpenLink Software
http://www.openlinksw.com/virtuoso
Cross Platform Web Services Middleware
