Sina, Classes are instances of owl:Class, so you can use the importer to get them in.
Importer will create a resource for every row. Your rows have two resources - a class and its superclasss Assuming that you have a row for each class irrespective of whether it has children or not, you are fine as is and do not need to worry about the fourth column. Let me explain it by example. Let's say you have: my:Person Person my:Woman Woman my:Person Person my:Man Man my:Person Person The first row will create a class Person, the second row will create a class Woman and make it a subclass of the Person, the third row will create a class Man and make it a subclass of a Person. Thus, you do not need a forth column because there was a row with Person in a first column and its label in the second column. If, on the other hand, you do not have a row for each class, you will then need to write some queries to get these resources created. Regards, Irene -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Madani,Sina Sent: Wednesday, June 09, 2010 2:27 PM To: '[email protected]' Subject: RE: [topbraid-users] Re: create ontology from spreadsheet I am a beginner with TopBraid Composer ME and not familiar with that tool. I need to create an ontology from a spreadsheet with 64000 rows and columns related to classes, subclasses, label, and some annotation datatype properties. I am considering only is-a (rdf:type) relationships between concepts at this moment (based on the mapping from SNOMED) but will eventually need to handle more relationships. I appreciate your help/hint/advices. Thanks Sina -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Scott Henninger Sent: Wednesday, June 09, 2010 1:09 PM To: TopBraid Suite Users Subject: [topbraid-users] Re: create ontology from spreadsheet Sina; I am curious about this: <<because I am defining everything in my ontology as classes>> Why not use Composer's ontology editing tools? -- Scott On Jun 9, 12:43 pm, "Madani,Sina" <[email protected]> wrote: > Thank you Scott, > Then I guess spreadsheet import wizard won't be useful for me because I am defining everything in my ontology as classes, there are no instances. > Could you please send me a good reading source for SPARQLmotion? > > Sina > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Scott Henninger > Sent: Tuesday, June 08, 2010 6:07 PM > To: TopBraid Suite Users > Subject: [topbraid-users] Re: create ontology from spreadsheet > > Sina; If the first row has column names with rdfs:label, etc., the > Import wizard will recognize the qname and create the properties as > desired. If you are doing this through a SPARQLMotion script, don't > forget to import system triples, otherwise the script will not know > about rdfs:subClassOf, etc. > > For all spreadsheet importers the rule is that each worksheet defines > one class definition. Note that using the Excel importer, you can > specify multiple sheets. Each row defines an instance of the class. > Each column names a property for instances of that class, not the > class itself. > > So a sheet named "Person" will create the class definition :Person. A > column in that sheet named "rdfs:label" will create a label for each > instance, such as: > ?rowX-Y rdfs:label ?cellValue > > <<I guess my question is how do I assign labels to classes and > subclasses in one spreadsheet?>> > > This could be done in a SPARQLMotion script where you read in the > spreadsheet and interpret the columns as you want with SPARQL > queries. But there isn't a way to do this directly with the > importers, per the above explanation. > > -- Scott > > On Jun 8, 12:53 pm, Sina <[email protected]> wrote: > > Hi, > > how I can assign rdfs:label to a specific column during tab-delimited > > import process? > > I have a spreadsheet of 4 columns: > > owl:Class, rdfs:label, rdfs:subClassOf, rdfs:label > > > how do I assign rdfs:label in the 4th Clim to my superclasses in the > > third column? Obviously the above format doesn't work. I guess my > > question is how do I assign labels to classes and subclasses in one > > spreadsheet? Currently I am doing it with two separate spreadsheets in > > 2 steps. > > > Thanks > > Sina > > -- > You received this message because you are subscribed to the Google > Group "TopBraid Suite Users", the topics of which include 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 athttp://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 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 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 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
