Do you mean comment out a line? Yes, the '#' syntax
comments out the rest of a line, i.e.:
# this is my comment
CONSTRUCT {
?newClass a rdfs:Class .
...
-- Scott
On 7/19/12 6:06 AM, OntoLearner wrote:
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 .
} .
}
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
topbraid-users@googlegroups.com
To unsubscribe from this group, send email to
topbraid-users+unsubscribe@googlegroups.com
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
--
-- 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
|
