Importing property relations into existing classes? Possible?

[Jack Hodges]

I have a tab-delimited file that defines a set of properties as follows:

S1 predicate O1
S1 predicate O2
S2 predicate O2
S2 predicate O4
...

I have used tab-delimited files in import, before, but it was always to create new instances. In this case I just want to add properties to existing classes. Using import tab-delimited doesn't appear to be the right approach for this. What is? Thank you.

Jack

[Irene Polikoff]

Hi Jack,

 

Tab-delimited import wizard has an option: Import to the current ontology: By using this checkbox, you can choose to import the spreadsheet to the currently selected ontology.

 

Current ontology is the one you have opened and active in TBC. This will allow you to add data to the existing graph and to resources in the graph. It will try to match info in the spreadsheet with resources in the ontology  and allows you to map columns in the spreadsheet with the existing properties in the model.

 

However, you are asking how to create new properties and associate them with classes. In other words, you need to import schema rather than data. The best approach is probably to use the Excel importer and then run SPARQL queries to transform the information the way you want. It is up to you if you want to create restrictions or domain/range declarations. If this process needs to be repeatable, create SPIN rules that can be re-run.

 

Regards,

 

Irene

--
-- 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 Insight, SPARQLMotion, SPARQL Web Pages and SPIN.
To post to this group, send email to
topbrai...@googlegroups.com
To unsubscribe from this group, send email to
topbraid-user...@googlegroups.com
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 Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Jack Hodges]

Irene,

That is what I was trying to use (import to current ontology) but I probably had the spreadsheet syntax wrong. Then I found in the documentation how to do it and tried that. Here are a couple of lines from the file:

biomed-symp:Symptom	biomed-symp:involvesProperty
obo:SYMP_0000008	quantity:Wavelength
obo:SYMP_0000012	quantity:Wavelength
obo:SYMP_0000018	quantity:Wavelength
obo:SYMP_0000019	quantity:SoundPowerLevel

Note that the items in the first column are classes, not instances (i.e., they are subclasses of biomed-symp:Symotom). When I run the import on this file I get the dialog that says that the "Spreadsheet import successful" but then get an error "Could not import spreadsheet" (I am not sure why it says spreadsheet when it is a tab-delimited file but that is beside the point). Also, the "Preview Spreadsheet" dialog stays after you hit the "Finish" button, even after the other dialog has come and gone. And the "Finish" button remains enabled. You should probably put it on your endless list of things to do to fix this. I seem to recall this has been a problem for many iterations. The import is taking a long time so I don't actually know whether it is working this time.

[Irene Polikoff]

Jack, if you send your data  (of the list) to support, we will try to reproduce.

Regards, Irene 

Sent from my iPhone

--