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

Reply via email to