Thanks, Irene. I saw these options mentioned in the Help contents. I tried the first method you mentioned, but, as tab-delimited text., the task was interrupted and I got this message:
Could not import spreadsheet String index out of range: 0 I could not see what I was doing wrong, but when I tried to create an ontology first, it worked much better. In the end, importing the data into an existing .n3 file worked without a problem, so I have been using that method since. Dalia Varanka, Ph.D. U.S. Geological Survey Center of Excellence for Geospatial Information Science 1400 Independence Road, Room 523 Rolla, Mo 65401 Office phone. 573.308.3897 Mobile phone: 573-466-0460 Fax 573.308.3652 Email: [email protected] From: "Irene Polikoff" <[email protected]> To: <[email protected]> Date: 09/02/2009 11:28 AM Subject: [tbc-users] Re: create subclasses from Excel? Sent by: [email protected] Just an extra point of information. In addition to the text importer discussed here, TopBraid also provides importers directly from Excel. If you select import -> OWL Spreadsheet from Excel, this importer does not make any assumptions about the meaning of information. Instead, everything in the spreadsheet is converted as cell values that have certain row and column indexes. This importer is very flexible as it can convert spreadsheets with multiple worksheets and spreadsheets that do not have a regular tabular structure - contain more than just one table. You will then need to run SPARQL query(s) to adjust the raw RDF. Additionally, you can place a spreadsheet (.xls file, .xlsx not supported yet) in TBC workspace and simply double click to open it. This will convert it automatically and supports round tripping - you can edit it in TBC and save back as Excel. We also have importers that convert common hierarchical spreadsheet patterns, but this is a separate topic. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Gokhan Soydan Sent: Wednesday, September 02, 2009 11:14 AM To: [email protected] Subject: [tbc-users] Re: create subclasses from Excel? Dalia, Since there isn't private data, I will answer your question directly in TopBraid Composer Users group. Yes, you can create subclasses by specifying the subclasses in the first column, the "rdfs:subClassOf" property as the second column header, and the super classes in the second column. If the subclasses don't exist yet, you could also provide "owl:Class" as the first column header. Gokhan Dalia E Varanka wrote: > > Gokhan: > > Your answer is very helpful to me, but I wonder: > is it possible to create subclasses by naming the subclasses in the > first column, have the owl term for subclass as the predicate and the > class name as the object? > > thanks > > Dalia > > > From: Gokhan Soydan <[email protected]> > To: [email protected] > Date: 09/01/2009 04:32 AM > Subject: [tbc-users] Re: Import ontology classes from spreadsheet > Sent by: [email protected] > > > ------------------------------------------------------------------------ > > > > > Hello Frank, > > If you specify the header of first column as "owl:Class", then all the > cells in the first column will be created as classes, since instances of > owl:Class are essentially classes. You would also have to use "Import to > the current ontology" option in the "Import Spreadsheet" wizard page, > while the ontology is already open. > > Gokhan > > > Frank wrote: > > I have a spreadsheet with all the classes for my ontology in the first > > column, and the subsequent columns as properties and the cells as > > property values for each class (row). I tried using the import > > wizard, but it imported all the rows as instances instead of classes. > > Is there an easy way to import ontology classes from spreadsheet? > > > > I am running TBC Maestro 3.0.1 > > > > Thanks, > > Frank > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TopBraid Composer Users" group. 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-composer-users?hl=en -~----------~----~----~----~------~----~------~--~---
