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

Reply via email to