I believe for your use case you should consider the spreadsheets
importer(s) as some intermediate step that produces a basic RDF model
from which you map into the "real" target ontology. In many cases SPARQL
is a good choice to write transformations that take the "raw" RDF and
map it into the target RDF. SPIN might be interesting, and in particular
SPINMap
http://composing-the-semantic-web.blogspot.com.au/2011/04/spinmap-sparql-based-ontology-mapping.html
Holger
On 3/15/2012 11:50, Florina Halasan wrote:
Hi Scott,
Thanks for your reply. I did watch the wizard and yes, I did transorm
the excel file into a tab delimited one. Unfortunately, from what I
uderstood the only option available for columns is: the first one a
class and the rest properties of the above mentioned class. It is
correct, the rows are instances of the class and its properties.
Let me try and explain my example better:
column 1 = class (rows under it are instances of this class going from
1 to 10)
column 2= properties with domain the class in column 1 and range the
class in column 3
column 3 = class (its rows are instances A to V)
Now, instance 1 (from column 1, row 1) has property (column 2, row
1) instance a (column A, row 1)
George hasFather
Mark
Mark hasCar
Toyota
My understanding is this is not something I can upload (i.e. with the
relation between instances in place) just using the feature you
mentioned - the menu doesn't give me this option.
P.S. Sorry for the misspelling of excelin my original post. Can the
fact that I am not a windows user count as an excuse? :)
On Thursday, March 15, 2012 1:06:16 PM UTC+13, Scott Henninger wrote:
Florina; I take it you are referring to Import Tab-Delimited
Spreadsheet file, not Excel. If you take a look at Help > Import and
Export > Import external information > Import Spreadsheets, it will
show how the wizard works. See part 2 for importing into an existing
ontology. In this case, the first row of the first column is the
class name (a class in the existing ontology) and the rest of the
rows
in the first column are interpreted as instance names.
If you are importing a tab-delimited file to create a class (i.e.
'Import to the current ontology' is not checked), then all rows are
interpreted as instances of a class that you name in the last window
of the wizard. This is part 1 of the aforementioned Help file.
In either case the last page in the wizard, Preview Spreadsheet, will
allow you to set the property name in the ontology and the data type
in the ontology. Click on the cell in the grid and it will become
editable. This will allow you to map multiple columns to the same
property if you wish.
Let us know if that helps you out.
-- Scott
On Mar 14, 6:26 pm, Florina Halasan <[email protected]>
wrote:
> Hi,
>
> I am trying to put together an ontology using TBC Standard
Edition. I
> also downloaded a copy of the TBC Maestro.
>
> I ran into the following problem: I would like to import an excell
> file into an existing ontology and have be able to assign
differrent
> labels to columns, i.e. more than one column to form a class.
>
> E.g. Column 1 class, column 2 property, column 3 class. It is of
great
> importance to me since most of my properties have a class as a
range,
> not a string.
>
> The only thing I saw available (part of the actual menu) is first
> column is a class and the rest are properties. Would some sort of
> Sparql motion be a good idea here?
>
> I am happy to get any suggestions. Looking forward to your reply.
>
> Best,
> Florina.
--
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 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 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