OK, so I will still using a temporary solution Now when this bug will be fixed also I inform you a bug from 1 week about auto generated R2RML file (child and parent column) ??? also How can I get notification these fixed ??
thanks On Mon, Jan 4, 2016 at 4:52 PM, Kingsley Idehen <[email protected]> wrote: > On 1/4/16 4:52 AM, Eng.Bassam wrote: > > Hi > I have tried this solution many times but unfortunately it's fail > the generated IRI by virtuoso as " > http%3A%2F%2Fsws.geonames.org%2F226074%2F > <http://localhost:8890/conductor/http%3A%2F%2Fsws.geonames.org%2F226074%2F> > " > > > now to solve this problem temporary, I' using rr:column not template for > IRI for this situation, > I'm using IRI function then to convert the " <http://sws.geonames.org/> > http://sws.geonames.org/226074" text to IRI in filter clause > like this > select ?countryName > where > { > GRAPH <http://localhost:8890/emrMaster#> > { > > ?patient sio:SIO_000664 ?country. > } > > GRAPH <http://localhost:8890/ontologies/geonames> > { > ?geo gn:name ?countryName. > } > > FILTER(IRI(?country) = ?geo) . > } > GROUP BY ?countryName > > is it a bug ??? or something wrong ??? > thanks again > > On Wed, Dec 30, 2015 at 7:57 PM, Kingsley Idehen <[email protected]> > wrote: > >> On 12/30/15 8:21 AM, Eng.Bassam wrote: >> >> Hi Kingsely and all members >> >> still there is the same problem can't traverse from ontology to other >> cause the generated IRI is text not IRI type, next is the description and >> sorry to be long but it's a problem need to solve ASAP to complete my >> project >> As I have said I have imported SQL DB using custom R2RML: >> <#TriplesMapPerson> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema >> "dataMaster" ; rr:tableOwner "data-ODBC" ; rr:tableName "Person" ]; >> rr:subjectMap [ rr:termType rr:IRI ; rr:template " >> http://localhost:8890/dataMaster/person/PersonID={ID}"; rr:class >> sio:SIO_000393; rr:graph < <http://localhost:8890/dataMaster#> >> http://localhost:8890/dataMaster#> ]; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant sio:SIO_000664 ] ; >> rr:objectMap [ rr:column "Country" ]; ] ; >> >> the column Country contain the IRIs of country geo ontology i.e as >> http://sws.geonames.org/226074/, this ontology I have loaded in my >> Virtuoso server at >> http://localhost:8890/ontologies/geonames >> >> this local ontology have rdf resources as : >> <gn:Feature rdf:about="http://sws.geonames.org/226074/"> >> <rdfs:isDefinedBy rdf:resource="http://sws.geonames.org/226074/about.rdf >> <http://sws.geonames.org/2378080/about.rdf>"/> >> <gn:name>USA</gn:name> >> </gn:Featue> >> >> now my query is : >> >> PREFIX sio: <http://semanticscience.org/resource/> >> prefix gn: <http://www.geonames.org/ontology#> >> select ?country >> FROM <http://localhost:8890/dataMaster#> >> FROM <http://localhost:8890/ontologies/geonames> >> WHERE { ?s a sio:SIO_000393. >> ?s sio:SIO_000664 ?country. >> } >> >> the result unfortunately is the IRIs but in quotation as a text not an >> IRI type i.e " <http://sws.geonames.org/226074/> >> http://sws.geonames.org/226074/", so I can't add to where clause in my >> query ?country gn:name ?cname also can't do ?country a gn:Feature >> >> PREFIX sio: <http://semanticscience.org/resource/> >> prefix gn: <http://www.geonames.org/ontology#> >> select ?country >> FROM <http://localhost:8890/dataMaster#> >> FROM <http://localhost:8890/ontologies/geonames> >> WHERE { ?s a sio:SIO_000393. >> ?s sio:SIO_000664 ?country. >> ?country gn:name ?cname // *this >> triple make a traverse to other local ontology (geonames)* >> } >> >> I think the problem is : >> generated country property is text not IRI type. >> I have try to modify the my R2RML using IRI template as >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant sio:SIO_000664 ] ; >> rr:objectMap [ rr:termType rr:IRI ; rr:constant gn:Feature; rr:template >> "{Country_geo}" ]; ] ; >> >> but also fail the generated IRI "need an encoding"as >> http%3A%2F%2Fsws.geonames.org%2F226074%2F >> <http://localhost:8890/conductor/http%3A%2F%2Fsws.geonames.org%2F226074%2F> >> >> wish to give me a solution :) >> >> thanks >> >> > This looks like a bug in the generator. It should be producing an IRI . > > -- > Regards, > > Kingsley Idehen > Founder & CEO > OpenLink Software > Company Web: http://www.openlinksw.com > Personal Weblog 1: http://kidehen.blogspot.com > Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen > Twitter Profile: https://twitter.com/kidehen > Google+ Profile: https://plus.google.com/+KingsleyIdehen/about > LinkedIn Profile: http://www.linkedin.com/in/kidehen > Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > -- ----------------------------------- > Eng.Bassam Najeeb. >Software Engineer.
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
