Re: [Virtuoso-users] Escape double quotes in entity name

Hi Yizhen, > Hi all, > > I guess it may be a quick question which can be solved by a quick answer. > The problem is that I have a few entity names like > http://yago-knowledge.org/resource/H._L._"Hub"_Hollis_Field > > so if i run sparql queries like > > Sparql Select * from where > {

Re: [Virtuoso-users] Virtuoso Construct Query - Creating URI problem

Hi Zehra, Debugging CONSTRUCT query can be done by replacing CONSTRUCT with SELECT. So your query would look like: SELECT ?mail ?user WHERE { SELECT (IRI(bif:concat(http://seagent.ege.edu.tr/,?user)) AS ?mail)

Re: [Virtuoso-users] dbg_printf does not print to console

Hi Mirko, Please make sure you are running Virtuoso server in forground. As you have win machine, you can ex. make a xx.bat file that contains this: - :start c:\path-to-your-Virtuoso-installation\bin\virtuoso-odbc-t.exe -f -c "C:\path-to-your-Virtuoso-installation\your-db-folder\v

Re: [Virtuoso-users] bif vs regex, not getting the same results

Hi Leyla, > > > Hi all, > > I have three queries that I think should produce the same results but when I > use bif:contains I get an empty set. Wondering whether it is my query or > something that is missing in the virtuoso configuration. I know sometimes bif > and regex can indeed produce

Re: [Virtuoso-users] Again Internal error: 'output:valmode' declarationconflicts with 'output:format'

Hi Alex, > - Original Message - > From: Alex > To: virtuoso-users@lists.sourceforge.net > Sent: Thursday, June 28, 2012 5:55 PM > Subject: [Virtuoso-users] Again Internal error: 'output:valmode' > declarationconflicts with 'output:format' > > > Hello there, > I would like to use not

Re: [Virtuoso-users] MD5 function

p +backup-dirs default backup directories +debug Show additional debugging info +pwdoldOld DBA password +pwddbaNew DBA password +pwddavNew DAV password On Mon, Jun 25, 2012 at 4:34 PM, Rumi Tsekova wrote: Hi Lorena, Co

Re: [Virtuoso-users] MD5 function

ards, Rumi - Original Message - From: "lorena" To: "Rumi Tsekova" Cc: Sent: Monday, June 25, 2012 4:11 PM Subject: Re: [Virtuoso-users] MD5 function Hi Rumi: I've tried the query with the white space fix in both: conductor sparql section (http://localhost:8

Re: [Virtuoso-users] MD5 function

Hi Lorena, Hi! I'm trying this sample query, from http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksSPARQL11FeaturesExamplesCollection, on my local Virtuoso Version: 06.01.3127. SELECT MD5 ('test') WHERE { ?s ?p ?o } LIMIT 10 And I get the following error Virtuoso 37000

Re: [Virtuoso-users] Virtuoso Docs Chapter 16

Hi Jürgen, Thanks lot for sending the file content! It is reflected in our doc and should be live soon. Best Regards, Rumi - Original Message - From: "Jürgen Jakobitsch" To: Sent: Monday, June 25, 2012 2:21 PM Subject: [Virtuoso-users] Virtuoso Docs Chapter 16 hi, for informati

Re: [Virtuoso-users] Conductor not loaded

Hi Adrian, Subject: [Virtuoso-users] Conductor not loaded Hi group, I did a fresh install of Virtuoso on my FreeBSD box via ports, did that on several other hosts in the past and worked fine. Now I get this error when I try to enter the conductor: HTTP request failed: HTTP/1.1 404 Not Fo

Re: [Virtuoso-users] Transaction aborted because it's log after imagesize went above the limit

Hi Alex, The error occurs as the insert operations are performed in transaction mode. You can turn it off and force the auto-committing of the the transactions to avoid the log limit being exceeded. That is recommended in general for SPARUL operations as detailed at: http://docs.openlinksw.com/

Re: [Virtuoso-users] SQ074: Line 1: SP031: SPARQL: Internal error

Hi Alex, The error you are getting probably comes from this that in your SPARQL query you are using both pragmas output:valmode and output:format. When both are used, then a conflict may occur. The easier way to find out existence of property instances with subject a given could be for ex.:

Re: [Virtuoso-users] demo queries - fct

Hello Houda, You can take a look at http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtFCTFeatureQueries and specifically for adding your own queries the "SPARQL Queries" section should give light for this etc. Best Regards, Rumi - Original Message - From: Houda khrouf

Re: [Virtuoso-users] Delete a tripple with space in subject

Hi Sachit, What if you try sth like this: SPARQL MODIFY GRAPH DELETE { ?s ?p ?o} INSERT { ?p ?o } FROM WHERE { ?s ?p ?o . ?s

Re: [Virtuoso-users] Problems securing SPARQL Enpoint

Hi Peter, I've followed the steps from http://www.openlinksw.com/dataspace/%20dav/wiki/Main/VirtSPARQLProtectSQLDigestAuthentication and the authentication worked for my new created user ( with name: "rnew" ) Could please give us more info what server version you are using, and what are the pro

Re: [Virtuoso-users] What does the '-f' do in the command ...

Hi Herman, virtuoso-t +command list shows all supported commands. Hope this helps. btw, -f is for foreground. Best Regards, Rumi - Original Message - From: Herman A. Junge To: virtuoso-users@lists.sourceforge.net Sent: Saturday, September 24, 2011 4:52 PM Subject: [Vir

Re: [Virtuoso-users] SPARQL Query using "SERVICE"

Hi Boris, Executing the following statement should fix the problem: GRANT EXECUTE on DB.DBA.SPARQL_SINV to SPARQL_SELECT; Best Regards, Rumi - Original Message - From: Boris Villazón Terrazas To: Virtuoso Users Sent: Monday, June 20, 2011 1:25 PM Subject: [Virtuoso-users]

Re: [Virtuoso-users] Dump arbitrary query result as N-Triples

Hi Claus, As described in http://docs.openlinksw.com/virtuoso/fn_exec.html, the "rows" parameter is "An output array with one element per result row containing an array with the leftmost column as element 0 and so forth". Processing further the result can be done for ex. such as: exec (,

Re: [Virtuoso-users] loading big file in virtuoso

Hi Pierre, Thanks for your notes re. doc. Please find my comments below: On Tue, 2011-02-15 at 16:12 +, Hugh Williams wrote: Being are very large dataset have you tuned your Virtuoso Server for running on the target OS as detailed at: http://docs.openlinksw.com/virtuoso/rdfperform

Re: [Virtuoso-users] Searching for dates with bif:contains?

Hi Vanessa, To find all dates starting with 1945, the query could be changed to: SELECT DISTINCT ?s ?date FROM WHERE { ?s ?p ?date . FILTER( bif:contains(?date, '"1945*"' ) && ( str(?p) != rdfs:label)) } LIMIT 30 You can also use date range. See example at http://v

Re: [Virtuoso-users] Strange behavior of MODIFY query

Aleksandr, Another example with no WHERE clause: http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparulexamples13 Best Regards, Rumi Hi Aleksandr, Using MODIFY graph in SPARQL as per below is actually performing UPDATE operation. i.e. you need to specify WHERE clause. See f

Re: [Virtuoso-users] Strange behavior of MODIFY query

Hi Aleksandr, Using MODIFY graph in SPARQL as per below is actually performing UPDATE operation. i.e. you need to specify WHERE clause. See for example in our doc this usage case: http://docs.openlinksw.com/virtuoso/sparqlextensions.html#rdfsparulexamples7 Hope this helps. Best Regards, R

Re: [Virtuoso-users] select into file

Hi Mirko, You can use the following syntax: isql user pass exec="select ..." > file.xx Best Regards, Rumi - Original Message - From: Mirko To: Virtuoso Users Sent: Tuesday, December 07, 2010 3:26 PM Subject: [Virtuoso-users] select into file Hi all, how do I output

Re: [Virtuoso-users] Generating a unique ID via SPARQL HTTP

Hi Aldo, Here are some links of calling (bif) functions in SPARQL queries: 1. http://virtuoso.openlinksw.com/presentations/SPARQL_Tutorials/SPARQL_Tutorials_Part_2/SPARQL_Tutorials_Part_2.html 2. http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsqlfromsparql Best Regards, Rumi Thanks

Re: [Virtuoso-users] Cannot do pulk upload 2nd time - it crashes

Hi Jamshaid, This error means Virtuoso Server is down. Please ensure it is started. If the error appears again, you might see on Virtuoso Server Console what other errors are printed out. ( i.e. ensure initially you have started the server in debug console). Best Regards, Rumi - Original

Re: [Virtuoso-users] Where to change the DBA password?

Hi Matthew, Do you have the conductor package installed (http://s3.amazonaws.com/opldownload/uda/vad-packages/6.1/virtuoso/conductor_dav.vad)? You can use it to change any user pwd. 1, Go to http://cname:port/conductor 2. Log in as dba 3. Go to System Admin -> User Accounts 4. Locate in the show

Re: [Virtuoso-users] ISQL query to completely empty a Virtuoso server

Hi Max-Alexandre, What you could do is (please make a copy of the db for testing purposes) 2 variants: -- rdf global reset: 1. Execute from ISQL or from Virtuoso Conductor -> Database -> Interactive SQL this call: rdf_global_reset (); 2. Now select all graphs from your db should return on

Re: [Virtuoso-users] how to modify sparql endpoint page

Hi Bin, Actually it is not advisable to modify the /sparql endpoint for the purpose in question. Instead you can use the iSPARQL package. (when installed, the endpoint is http://cname:port/isparql) Links: 1. OAT Interactive SPARQL (iSPARQL) Query Builder: http://wikis.openlinksw.com/datasp

Re: [Virtuoso-users] LDAP Server configuration

Hi Bart, Hi All, I'm trying to connect to my ldap server ( at ldaps:// so secured ) from the "LDAP Servers" page in the conductor under the "user accounts" tab. Its not very clear what is intented with all the fields, and the error messages are quiet minimal. furthermore, looking at the l

Re: [Virtuoso-users] sparql aggregate with condition on the aggr result

Hi Silvia, Can you send us the whole script (insert and then select etc.) and the version of Virtuoso Server you are using? Best Regards, Rumi Hi Rumi, Yes, I have a very similar set of triples. Suppose you have the following: sparql clear graph ; SPARQL insert

Re: [Virtuoso-users] sparql aggregate with condition on the aggr result

Hi Silvia, Suppose you have the following: sparql clear graph ; SPARQL insert in graph { 1 . 2 .

Re: [Virtuoso-users] creating user account

Hi Mario, To create new account using Conductor: 1. Go to System Admin->User Accounts 2. In the shown list at the very right column (where Edit/Delete for users are shown) as heading there is a link "Create New Account" Best Regards, Rumi Hello, in a blog i read the following recipe

Re: [Virtuoso-users] Magic Predicates in Virtuoso?

Hi Aldo, Please take a look at http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsqlfromsparql and the examples given in this doc section. Best Regards, Rumi - Original Message - From: "Aldo Bucchi" To: "Virtuoso Users" Sent: Thursday, June 17, 2010 10:57 PM Subject: [Virt

Re: [Virtuoso-users] Querying on all the data in the triple store

Hi Sashikiran, You can take a look at these docs: http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtuosoRDFSinkFolder http://ods.openlinksw.com/dataspace/dav/wiki/ODS/ODSRDFSinkFolder Best Regards, Rumi - Original Message - From: Rameswara Sashi Kiran Challa To: tim.ha

Re: [Virtuoso-users] NOT EXISTS keyword support in virtuoso SPARQL endpoints?

Kingsley, The typo in http://docs.openlinksw.com/virtuoso/rdfsparqlrule.html#rdfsparqlruleexamples6 is corrected. Best Regards, Rumi - Original Message - From: Kingsley Idehen To: Rumi Tsekova Cc: Christian Fuerber ; virtuoso-users@lists.sourceforge.net Sent: Monday

Re: [Virtuoso-users] NOT EXISTS keyword support in virtuoso SPARQL endpoints?

Hi Christian, Additionally to the example Kingsley pointed to, here is another one: http://docs.openlinksw.com/virtuoso/rdfsparqlrule.html#rdfsparqlruleexamples6 Best Regards, Rumi - Original Message - From: Kingsley Idehen To: Christian Fuerber Cc: virtuoso-users@lists.sour

Re: [Virtuoso-users] Free text index update

Hi Alexander, Thank you for your report re. the found wrong documentation example. It is applied to doc and fixed the misleading link you got from the search engine. The correct link is http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsparqlruletimeindexing Regarding the reported one ( h

Re: [Virtuoso-users] vsp sparql variable offset and limit?

Hi Lourens, Unfortunately it is not possible to specify variables limit and offset in sparql+vsp. Even if we re-write the procedure to sth like: create procedure test (in _uri varchar) { declare res varchar; result_names (res); declare _lm, _offset int; _lm :=

Re: [Virtuoso-users] WordPress SIOC queries

Hi Bob, Just to clarify the correct link is http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/WordPressSIOCRef Best Regards, Rumi - Original Message - From: Rumi Tsekova To: Bob Ferris ; virtuoso-users@lists.sourceforge.net Sent: Friday, December 04, 2009 1:59 PM

Re: [Virtuoso-users] WordPress SIOC queries

Hi Bob, Take a look again at http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/WordPressSIOCRef as we have corrected the RDF views script with the right one and also link to the life version of the Views was added. Please let us know after executing the rdf views script if the queries con

Re: [Virtuoso-users] Correct way to shut down the Virtuoso- Server

Hi Sashikiran, Additionally re. uploading in the RDF_Quad table: 1. You can upload files to the ODS RDF Sink folder - see details here: http://ods.openlinksw.com/dataspace/dav/wiki/ODS/ODSRDFSinkFolder - the Graph URI is http://cname/DAV/home/username/rdf_sink 2. Another way is using WebD

Re: [Virtuoso-users] owl sameAs reasoning

Sebastian, > >- Original Message - >From: Kingsley Idehen >To: Sebastian Hellmann >Cc: Virtuoso Users List >Sent: Wednesday, November 18, 2009 3:26 PM >Subject: Re: [Virtuoso-users] owl sameAs reasoning > > >Sebastian Hellmann wrote: >> Hello, >> if I use a >> SELECT DISTINCT ?s >> {?

Re: [Virtuoso-users] Web Robot/Copy

Hi Aldo, You can take a look at the following links: 1. http://docs.openlinksw.com/virtuoso/rdfinsertmethods.html#rdfinsertmethodvirtuosocrawler 2. http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtRDFInsert#ExampleUsingVirtuosoCrawler 3. http://docs.openlinksw.com/virtuoso/virtuoso

Re: [Virtuoso-users] Changing DAV permissions programatically

Aldo, Hi, I upload a file via WebDAV like so curl -u $CREDENTIALS -T "file.txt" http://server.com/DAV/home/dav/folder/ where /folder/ has readable by anyone. However, the uploaded file does not inherit permissions ( unless I am missing something ). Anwyay, as things stand today I need to ch

Re: [Virtuoso-users] SPARQL Query doesn't return uploaded triples

Hi Taalai, Hi all, I have created user "tman" with password gxa and upload rdf file using: $ curl -i -T myTriples.rdf http://localhost:8890/DAV/home/tman/rdf_sink/myTriples.rdf -u tman:gxa (and also tried uploading using webDAV browser) and got the result 201 CreatedCreatedResource /DAV/

Re: [Virtuoso-users] Doc Typos

Hi Aldo, FYI from: http://docs.openlinksw.com/virtuoso/sparqlbi.html in the following paragraph: When expressions occur in result sets, many variables are introduced only to pass a value from triple pattern to the result expression. This is inconvenient because many triple patterns are trivia

Re: [Virtuoso-users] virtuoso and bio2rdf

Hi Pierre, Dear list, I am trying to set up the integration between bio2rdf and the open-source version of virtuoso. I hope this is the right place to ask for advices, if not please let me know. I have set up the open-source version of virtuoso on my machine and installed the go schema using t

Re: [Virtuoso-users] VirtModel default graph

Hi, You should use the second method instead, i.e. createDatabaseModel. Please find more details at http://docs.openlinksw.com/jena/virtuoso/jena/driver/VirtModel.html Best Regards, Rumi - Original Message - From: Ruben Martin To: virtuoso-users@lists.sourceforge.net Sent:

Re: [Virtuoso-users] UTF-16 rdf/xml

Hi Michel, In order to load the file, you need to convert it to UTF-8 and then to load it. You can use this function for the purpose: http://docs.openlinksw.com/virtuoso/fn_charset_recode.html Best Regards, Rumi - Original Message - From: Michel Dumontier To: virtuoso-users@l

Re: [Virtuoso-users] Help needed regarding Virtuoso Facets Web Service

Hi, Could you dump the rdf data for ex. using describe or to make construct in order we to investigate the problem? For ex. to see what is the data for the property http://3ba.se/conferences/start, to check the timezone etc. Best Regards, Rumi - Original Message - From: Jinesh Ge

Re: [Virtuoso-users] sparul policies based on named graphs

Hi Sergio, Dear VOS users, anyone knows a way to stablish policies on sparul role based on named graphs? I've an instance of Virtuoso with several named graphs, and I'd like to stablish concrete policies (read-only, modification by authentification, or something similar) for concrete named gra

Re: [Virtuoso-users] using the vad wiki package

Hi Kurt, The sequence should be: (either using ISQL or Conductor) 1. Install the ods_framework_dav.vad package 2. Install the ods_wiki_dav.vad package 3. Go to http://host:port/ods/ and click Sing Up in order to register user in ODS, for ex. with username kurt 4. When logged in, click the Wiki

Re: [Virtuoso-users] Querying private dataspace data

Hi Steve, You can try (no authentication required) this query to get all user demo for ex. AddressBook contacts: * Note that this will return data only for the user's AddressBook instance(s) which is public. (public is settable from Application Settings->Applications Management->for the instan

Re: [Virtuoso-users] inference context error

his is the place. You need to rebuild the RDF Data too. Best Regards, Rumi Thank you!! Cristian 2009/2/10 Rumi Tsekova : Hi Cristian, Could you please check: 1. in virtuoso ini file what is the value of the URIQA - DefaultHost * if the htttp is on port 80, then this port you must not us

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

o retrieve from, but then the query retrieved nothing. I have a feeling that I'm just missing some tiny detail... Yes FROM GRAPH IRI. Graph IRI should be the IRI/URL of the RDF file in DAV which is not used as Graph IRI inside the Quad Store for the data from the RDF info. resource. King

Re: [Virtuoso-users] trying to load RDF data into OpenVirtuoso and then query it

Hi Bob, > > >Thanks Hugh! > >Any suggestions about point 2? Here is what I performed locally on winxp installation: 1. Go to Conductor and click "Create New Account" 2. Enter account name: user11 and also enter pwd, for ex.: 1 3. Check "User Enabled" and "Allow SQL/ODBC Logins" 4. Add roles SP

Re: [Virtuoso-users] inference context error

nd installed ODS, but the problem persists. curl -i "http://www.univrz.com/ods/api/user.search?pattern=dba"; throws the same error. (-500), i made some experiments (in other instances) trying to force the inference context, but it didn't work either... Best regards, Cristian 2009/2/9 Ru

Re: [Virtuoso-users] inference context error

LL VARCHAR ___ http://www.univrz.com:80/dataspace http://www.univrz.com:80/dataspace/inf NULL virtrdf-label virtrdf-label NULL Today, I dont know what's happening, Thank you in advance, Cris

Re: [Virtuoso-users] inference context error

Hi Cristian, Hello! I'm developing some extensions to the ODS REST API, and i get an error when i make use of the "exec_sparql (q);" procedure, present on the ODS controllers. When i try to invoke it, i get the following error: -500 RDF..: Inference context http://www.univrz.com:80/dataspa

Re: [Virtuoso-users] How to import users profiles into ODS

Hi David, I want to attempt to import our user profile data into ODS from our existing social networking site then I want to change the ODS authentication to map to our internal LDAP for user authentication. Is there any existing FAQ's or posts on these topics? I want to cut over to using OD

Re: [Virtuoso-users] ODS Bookmark Manager Services

Is it possible in requesting a user's bookmarks to a numerical parameter, for example if you want to get bookmarks that were added in 200 bookmarks ago? I suppose you mean using the Bookmarks export feature? If yes, for now in export all boomarks are exported. Maybe. I basically am thinking to

Re: [Virtuoso-users] ODS Bookmark Manager Services

Hi Bryan, Hi, In using the ODS Bookmark Manager Services are these examples expecting what kind of interface - http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/OdsBookmarkManagerServices ? An HTTP Post? You can use this UI endpoint: http://host:port/dataspace/services/bookmark/service

Re: [Virtuoso-users] index in WebDAV rdf_sink inconsistent

Hi Mikael, The problem is acknowledged and we are working on fixing it. Best Regards, Rumi Hi, I'm managing my RDF data files with WebDAV in the rdf_sink directory. The problem I have is that when I remove files from there, the index is not updated accordingly. Is this the intended behavior

Re: [Virtuoso-users] how many triples do I have?

Hi Erick, You can use: select count (*) from where {?s ?p ?o} See here for more examples: http://docs.openlinksw.com/virtuoso/rdfsparqlaggregate.html Best Regards, Rumi Hi, is there an "intelligent" way to get the number of triples I've got in my virtuoso db? thanks, erick --

Re: [Virtuoso-users] ENUM and SET column types

Hi Sören, Hi all, MySQL has the neat feature of defining a table column to be a enumeration or set of a number of elements, e.g.: create table person ( name varchar, sex enum('male', 'female') ) or: create table person ( name varchar, likes_fruits set('apple', 'pear','orange') ) I gues

Re: [Virtuoso-users] Seek tuto and/or advice toimportontologyindatabase - Question about the Configuration File.ini

Hi Brice, The call of the procedure should be with 3 params ( I typed it wrongly with 4 :(, thanks to Tim for noticing this) so here is the correct one: SQL> RDF_LOAD_RDFXML(file_to_string_output('D:/virtuoso-opensource-win32-5.0.1/temp/iarchi.owl'),'','http://myiarchibase'); Best Regards, Rum

Re: [Virtuoso-users] Seek tuto and/or advice to importontologyindatabase - Question about the Configuration File.ini

Hi Brice, > > >Hello, >Thank You for the help. > >The error is persistent, but look my configuration (conf file is attached): > >SQL> select server_root (), virtuoso_ini_path (); >(...) >D:\virtuoso-opensource-win32-5.0.1\var\lib\virtuoso\demo\ > D:\virtuoso-opensource-win32-5.0.1\var\li

Re: [Virtuoso-users] Modifying the ODS Main Menu

Hi Mike, Hi All, The ODS main menu is based on the ods-bar framework with associated code based in ods_bar.vspx, ods_bar.xsl, ods-bar.css and related ones having to do with user instances. ods_bar.xsl appears to be the main one. As an ODS sys admin, it is possible to change menu labels via t

Re: [Virtuoso-users] Seek tuto and/or advice to import ontology in database.

Hi, Cesbron, Brice wrote: Hello, I've downloaded and just installed Virtuoso : virtuoso-opensource-win32-5.0.1 I have already done my ontology so how can I import my file.owl into the virtuoso database? If someone has some example or some tuto I would appreciate it. Thanks in advance. Hi

Re: [Virtuoso-users] Some ODS Bugs in Windows Binaries]

Hi Mike, Hi All, Here are some bugs in the binary Windows distribution of ODS (Virtuoso 5.0.1). These all occur after a fresh re-install, while logged in as 'dav' 'dav' sys admin: -- Apparently, some instances of localhost.localdomain:8890/etc are not registered, with the FF problem loading