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

Reply via email to