Hi Nashwa, Not sure what you mean, provide a simple test case to demonstrate the issue …
Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ <http://www.openlinksw.com/> Weblog -- http://www.openlinksw.com/blogs/ <http://www.openlinksw.com/blogs/> LinkedIn -- http://www.linkedin.com/company/openlink-software/ <http://www.linkedin.com/company/openlink-software/> Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink> Google+ -- http://plus.google.com/100570109519069333827/ <http://plus.google.com/100570109519069333827/> Facebook -- http://www.facebook.com/OpenLinkSoftware <http://www.facebook.com/OpenLinkSoftware> Universal Data Access, Integration, and Management Technology Providers > On 8 Jan 2016, at 16:34, Nashwa Nabel <nn...@fayoum.edu.eg > <mailto:nn...@fayoum.edu.eg>> wrote: > > Hi all members, > Hi Hugh Williams Especially, > > I want to thank you for your help and your reply. > > I have anthor problem. > > I converted my CSV datasets into relational data and my datasets are > contained "ID" in this form (98825) , but virtuoso tool added "ID" in this > form (1 and so on) . > > How I delete this "ID" that added by virtuoso tool? > > Thanks for your help in advance. > > > > Best Regards, > -- > Nashwa Nabil, > Teaching Assistant, > Information System Department, > Faculty of computer and Information, > > On Mon, Jan 4, 2016 at 2:03 PM, Hugh Williams <hwilli...@openlinksw.com > <mailto:hwilli...@openlinksw.com>> wrote: > Hi Nashwa, > > Who is “Prof Milos” and what is the relevance to the issue ? > > “rr:termType rr:IRI ;” is supported by Virtuoso and used in example R2RML > scripts we provide for the Virtuoso Demo (Northwind) database which validate > and generate the Linked Data View scripts successfully: > > > https://github.com/openlink/virtuoso-opensource/blob/develop/7/binsrc/rdb2rdf/northwind_r2rml.ttl > > <https://github.com/openlink/virtuoso-opensource/blob/develop/7/binsrc/rdb2rdf/northwind_r2rml.ttl> > > If you can provide a sample CSV script (even if only schema) and the exact > steps you performed we can attempt to recreate locally ... > > Best Regards > Hugh Williams > Professional Services > OpenLink Software, Inc. // http://www.openlinksw.com/ > <http://www.openlinksw.com/> > Weblog -- http://www.openlinksw.com/blogs/ > <http://www.openlinksw.com/blogs/> > LinkedIn -- http://www.linkedin.com/company/openlink-software/ > <http://www.linkedin.com/company/openlink-software/> > Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink> > Google+ -- http://plus.google.com/100570109519069333827/ > <http://plus.google.com/100570109519069333827/> > Facebook -- http://www.facebook.com/OpenLinkSoftware > <http://www.facebook.com/OpenLinkSoftware> > Universal Data Access, Integration, and Management Technology Providers > > > >> On 30 Dec 2015, at 17:53, Nashwa Nabel <nn...@fayoum.edu.eg >> <mailto:nn...@fayoum.edu.eg>> wrote: >> >> Hi all members, >> >> >> >> I thank you very much for your help . >> >> >> Prof Milos is one of the very reputable personalities for my help. >> >> I apologize to the my many questions to yours but help me a lot.I test my >> CSV data n virtuoso open source. >> >> I converted my data into relational database and then use linked data views >> to generate RDF triples by R2RML. >> >> And this result show below, >> >> @prefix rr: <http://www.w3.org/ns/r2rml# <http://www.w3.org/ns/r2rml#>> . >> >> @prefix HIFM: <http://localhost:8890/schemas/HIFM/ >> <http://localhost:8890/schemas/HIFM/>> . >> >> @prefix hifm-stat: <http://localhost:8890/HIFM/stat# >> <http://localhost:8890/HIFM/stat#>> . >> >> @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns# >> <http://www.w3.org/1999/02/22-rdf-syntax-ns#>> . >> >> @prefix void: <http://rdfs.org/ns/void# <http://rdfs.org/ns/void#>> . >> >> @prefix scovo: <http://purl.org/NET/scovo# <http://purl.org/NET/scovo#>> . >> >> @prefix aowl: <http://bblfish.net/work/atom-owl/2006-06-06/ >> <http://bblfish.net/work/atom-owl/2006-06-06/>> . >> >> >> <#TriplesMaptest_result_csv> a rr:TriplesMap; rr:logicalTable [ >> rr:tableSchema "HIFM" ; rr:tableOwner "DBA" ; rr:tableName "test_result_csv" >> ]; >> >> rr:subjectMap [ rr:termType rr:IRI ; rr:template >> "http://localhost:8890/HIFM/test_result_csv/IDENTIFICATION={IDENTIFICATION} >> <http://localhost:8890/HIFM/test_result_csv/IDENTIFICATION=%7BIDENTIFICATION%7D>"; >> rr:class HIFM:test_result_csv; rr:graph <http://localhost:8890/HIFM# >> <http://localhost:8890/HIFM#>> ]; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant HIFM:identification ] >> ; rr:objectMap [ rr:column "IDENTIFICATION" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant HIFM:atc_code ] ; >> rr:objectMap [ rr:column "ATC_CODE" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant HIFM:generic_name_inn >> ] ; rr:objectMap [ rr:column "GENERIC_NAME_INN" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >> HIFM:pharmaceutical_dosage_form ] ; rr:objectMap [ rr:column >> "PHARMACEUTICAL_DOSAGE_FORM" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant HIFM:reliability ] ; >> rr:objectMap [ rr:column "RELIABILITY" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >> HIFM:brand_name_of_the_drug ] ; rr:objectMap [ rr:column >> "BRAND_NAME_OF_THE_DRUG" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant HIFM:packing ] ; >> rr:objectMap [ rr:column "PACKING" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >> HIFM:ref_price_per_pack_without ] ; rr:objectMap [ rr:column >> "REF_PRICE_PER_PACK_WITHOUT" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >> HIFM:ref_price_per_pack_with ] ; rr:objectMap [ rr:column >> "REF_PRICE_PER_PACK_WITH" ]; ] . >> >> >> But, there was error appear when I validate R2RML. >> >> This is error “Property <http://www.w3.org/ns/r2rml#termType >> <http://www.w3.org/ns/r2rml#termType>> is not know (typo in its IRI?)”. >> >> I don’t know what the reason for this error is. >> >> Also, I deleted this line “rr:termType rr:IRI ;” and then R2RML validate >> correctly. But triples appear in incorrect form. >> >> Can you help me to understand this error? >> >> >> Thanks for your help in advance. >> >> >> >> >> Best Regards, >> >> -- >> >> Nashwa Nabil, >> >> Teaching Assistant, >> >> Information System Department, >> >> Faculty of computer and Information, >> >> >> On Wed, Dec 30, 2015 at 7:48 PM, Nashwa Nabel <nn...@fayoum.edu.eg >> <mailto:nn...@fayoum.edu.eg>> wrote: >> Hi all members, >> >> I test my CSV data n virtuoso open source. >> >> I converted my data into relational database and then use linked data views >> to generate RDF triples by R2RML. >> >> And this result show below, >> >> @prefix rr: <http://www.w3.org/ns/r2rml# <http://www.w3.org/ns/r2rml#>> . >> >> @prefix HIFM: <http://localhost:8890/schemas/HIFM/ >> <http://localhost:8890/schemas/HIFM/>> . >> >> @prefix hifm-stat: <http://localhost:8890/HIFM/stat# >> <http://localhost:8890/HIFM/stat#>> . >> >> @prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns# >> <http://www.w3.org/1999/02/22-rdf-syntax-ns#>> . >> >> @prefix void: <http://rdfs.org/ns/void# <http://rdfs.org/ns/void#>> . >> >> @prefix scovo: <http://purl.org/NET/scovo# <http://purl.org/NET/scovo#>> . >> >> @prefix aowl: <http://bblfish.net/work/atom-owl/2006-06-06/ >> <http://bblfish.net/work/atom-owl/2006-06-06/>> . >> >> >> <#TriplesMaptest_result_csv> a rr:TriplesMap; rr:logicalTable [ >> rr:tableSchema "HIFM" ; rr:tableOwner "DBA" ; rr:tableName "test_result_csv" >> ]; >> >> rr:subjectMap [ rr:termType rr:IRI ; rr:template >> "http://localhost:8890/HIFM/test_result_csv/IDENTIFICATION={IDENTIFICATION} >> <http://localhost:8890/HIFM/test_result_csv/IDENTIFICATION=%7BIDENTIFICATION%7D>"; >> rr:class HIFM:test_result_csv; rr:graph <http://localhost:8890/HIFM# >> <http://localhost:8890/HIFM#>> ]; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant HIFM:identification ] >> ; rr:objectMap [ rr:column "IDENTIFICATION" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant HIFM:atc_code ] ; >> rr:objectMap [ rr:column "ATC_CODE" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant HIFM:generic_name_inn >> ] ; rr:objectMap [ rr:column "GENERIC_NAME_INN" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >> HIFM:pharmaceutical_dosage_form ] ; rr:objectMap [ rr:column >> "PHARMACEUTICAL_DOSAGE_FORM" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant HIFM:reliability ] ; >> rr:objectMap [ rr:column "RELIABILITY" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >> HIFM:brand_name_of_the_drug ] ; rr:objectMap [ rr:column >> "BRAND_NAME_OF_THE_DRUG" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant HIFM:packing ] ; >> rr:objectMap [ rr:column "PACKING" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >> HIFM:ref_price_per_pack_without ] ; rr:objectMap [ rr:column >> "REF_PRICE_PER_PACK_WITHOUT" ]; ] ; >> >> rr:predicateObjectMap [ rr:predicateMap [ rr:constant >> HIFM:ref_price_per_pack_with ] ; rr:objectMap [ rr:column >> "REF_PRICE_PER_PACK_WITH" ]; ] . >> >> >> But, there was error appear when I validate R2RML. >> >> This is error “Property <http://www.w3.org/ns/r2rml#termType >> <http://www.w3.org/ns/r2rml#termType>> is not know (typo in its IRI?)”. >> >> I don’t know what the reason for this error is. >> >> Also, I deleted this line “rr:termType rr:IRI ;” and then R2RML validate >> correctly. But triples appear in incorrect form. >> >> This is form of triples. >> >> Can you help me to understand this error? >> >> >> Thanks for your help in advance. >> >> >> >> >> Best Regards, >> >> -- >> >> Nashwa Nabil, >> >> Teaching Assistant, >> >> Information System Department, >> >> Faculty of computer and Information, >> >> >> >> www.fayoum.edu.eg <http://www.fayoum.edu.eg/> >> >> ------------------------------------------------------------------------------ >> _______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> <mailto:Virtuoso-users@lists.sourceforge.net> >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users> > > > > www.fayoum.edu.eg <http://www.fayoum.edu.eg/> >
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
