Hello Bob,
Will it be possible to comment out the below query? That will allow to have
a better understanding.
Thank you for your time.
On Wednesday, July 18, 2012 9:50:36 AM UTC-4, Bob DuCharme wrote:
>
> TopBraid's Import Spreadsheets feature assumes that rows are instances of
> a class with columns representing properties. A more flexible alternative
> is importing a spreadsheet into the spreadsheet ontology, which lets you
> address cells individually in a SPARQL query and convert them to conform to
> whatever model you like.
>
> This feature works with .xls spreadsheets, so you'd have to convert your
> data to that first. After doing so, pick Import from the File menu and then
> pick Import Excel File into Spreadsheet Ontology. After you identify the
> file to import and finish up, you'll have an RDF file where the data is
> modeled using the ss:Cell, ss:Sheet, and ss:Workbook classes of the
> spreadsheet ontology. After doing this with your data, a transformation
> query similar to the following should convert its values to the class
> declarations that you describe:
>
> CONSTRUCT {
> ?newClass a rdfs:Class .
> ?newClass rdfs:subClassOf ?superClass .
> }
> WHERE {
> ?c a ss:Cell .
> ?c ss:row ?row .
> ?c ss:column ?col .
> ?c ss:cellContents ?contents .
> FILTER (?row > 0) .
> BIND ((?col - 1) AS ?parentCol) .
> OPTIONAL {
> ?parent ss:row ?row .
> ?parent ss:column ?parentCol .
> ?parent ss:cellContents ?parentContents .
> } .
> BIND (IRI(fn:concat("http://example.org/";, ?contents)) AS ?newClass) .
> BIND (IRI(fn:concat("http://example.org/";, ?parentContents)) AS
> ?superClass) .
> }
>
> Bob DuCharme
> TopQuadrant
>
> On Tue, Jul 17, 2012 at 1:11 PM, OntoLearner wrote:
>
>> Hello everyone,
>>
>> I have a spreadsheet with 5 columns, which needs to be converted into
>> OWL. The columns contain sub-category (sub-class), and I am trying to
>> convert the spreadsheet in a way that allows for the lowest level element
>> to be related to the subclass above it in the hierarchy, and the so that
>> there is some kind of cascading effect. The columns are: A, B, C, D, E, and
>> F, so the result should be as follows: E->D->C-B->A. With A being the
>> highest class in the chain. By making F a subclass of E, I am hoping to
>> have a cascading effect, whereby E will be automatically related to D, C,
>> B, and A.
>>
>> Here is an example of my spreadsheet:
>>
>> column1 column2 column3 column3 column4 SuperClass 1 SubClass 1-1
>> SuperClass 2 SubClass 1-2 SubClass 2-1
>> SuperClass 3 SubClass 1-3 SubClass 2-2
>> SuperClass 4 SubClass 1-4 SubClass 2-3
>> SuperClass 5 SubClass 1-5 SubClass 2-4
>> SuperClass 6 SubClass 1-6 SubClass 2-5
>> SuperClass 7 SubClass 1-7 SubClass 2-6 SubClass 3-1 SubClass 4-1
>> SuperClass 8 SubClass 1-8 SubClass 2-7 SubClass 3-2 SubClass 4-2
>>
>> So column4 is a subclass to column3, column3 subclass to column2, and
>> column2 subclass to column1, which is my superclass.
>>
>> Hopefully this makes sense to you.
>>
>> PS: I have also attached sample data for easy reference.
>>
>> --
>> -- You received this message because you are subscribed to the Google
>> Group "TopBraid Suite Users", the topics of which include Enterprise
>> Vocabulary Network (EVN), TopBraid Composer, TopBraid Live,
>> TopBraid Ensemble, SPARQLMotion, SPARQL Web Pages and SPIN.
>> To post to this group, send email to
>> [email protected]
>> To unsubscribe from this group, send email to
>> [email protected]
>> For more options, visit this group at
>> http://groups.google.com/group/topbraid-users?hl=en
>>
>>
>>
>
>
--
-- You received this message because you are subscribed to the Google
Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary
Network (EVN), TopBraid Composer, TopBraid Live,
TopBraid Ensemble, SPARQLMotion, SPARQL Web Pages and SPIN.
To post to this group, send email to
[email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/topbraid-users?hl=en
