[protege-discussion] import instances from spreadsheet

[Cecil O. Lynch, MD, MS]

Hi Nick,

I think it stopped working after build 56.

Cecil

-----Original Message-----
From: protege-discussion-bounces at mailman.stanford.edu
[mailto:protege-discussion-bounces at mailman.stanford.edu] On Behalf Of Nick
Drummond
Sent: Wednesday, March 19, 2008 5:29 AM
To: User support for Core Protege and the Protege-Frames editor
Subject: Re: [protege-discussion] import instances from spreadsheet

I'm just checking to see if the Protege4.0 excel import plugin [1] is  
working for the current version of Protege4.0.
It might be worth a look. I'll get back to you when I hear.

Nick

[1] http://www.co-ode.org/downloads/protege-x/plugins/#excel


On 19 Mar 2008, at 10:36, Jonathan Carter wrote:

> Hi,
>
> There are some good tools for importing already in Protégé. However,  
> in my experience, the approach you take mostly depends on whether  
> you are importing into an empty project/ontology or whether you need  
> to map instances from your spreadsheet into an existing class  
> hierarchy. Based on this, I've tried a few approaches with success -  
> ranging from Excel->XML and then pasting the new instances into the  
> PINS file of the Protégé Project (a bit of a hack) to using the  
> Script tab to add instances through the API (more robust).
>
> However, I'd recommend taking a look at the DataMaster Tab. It can  
> import instances from any JDBC or ODBC database. You can of course  
> present your Excel spreadsheet as an ODBC source. If you set up your  
> spreadsheet so that the columns in your sheet match the target  
> classes of the instances you want to import then it will bring them  
> all in for you.
>
> If you need a more complex intepretation of the data you have in the  
> spreadsheet - i.e. a simple mapping isn't possible, then you could  
> look at exporting the spreadsheet as XML and then doing some XSLT  
> over it to create the script that will add the instances you need.
>
> Hope this helps
>
> Jonathan
>
>
> __________________________________________
> Jonathan Carter - Head of Technical Architecture
> Enterprise Architecture Solutions Ltd
> Mobile: +44 (0) 7904 198295
> Email: jonathan.carter at e-asolutions.com
> __________________________________________
>
> Assess your EA maturity at:
> www.enterprise-architecture.com/EAvaluator
> __________________________________________
>
>
>
> -----Original Message-----
> From: protege-discussion-bounces at lists.stanford.edu
[mailto:protege-discussion-bounces at lists.stanford.edu 
> ] On Behalf Of Paul Smith
> Sent: 19 March 2008 08:13
> To: protege-discussion at lists.stanford.edu
> Subject: [protege-discussion] import instances from spreadsheet
>
> Hello,
>
> I need a suggestion from experienced. I want to import some data,  
> that I have in Excel, as instances in to an OWL-Ontology, there are  
> of course strict conceptual relationships between the dataset and  
> the ontology. Which way to import the data from the spreadsheet into  
> the ontology? shall I involve a reasoner (thinking to a Realization  
> Reasoning Service) or via XML ???
>
> Every solution is welcome
>
>
> _______________________________________________
> protege-discussion mailing list
> protege-discussion at lists.stanford.edu
> https://mailman.stanford.edu/mailman/listinfo/protege-discussion
>
> Instructions for unsubscribing:
http://protege.stanford.edu/doc/faq.html#01a.03
>
> _______________________________________________
> protege-discussion mailing list
> protege-discussion at lists.stanford.edu
> https://mailman.stanford.edu/mailman/listinfo/protege-discussion
>
> Instructions for unsubscribing:
http://protege.stanford.edu/doc/faq.html#01a.03

_______________________________________________
protege-discussion mailing list
protege-discussion at lists.stanford.edu
https://mailman.stanford.edu/mailman/listinfo/protege-discussion

Instructions for unsubscribing:
http://protege.stanford.edu/doc/faq.html#01a.03 

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.519 / Virus Database: 269.21.7/1333 - Release Date: 3/18/2008
8:10 AM
 

No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.519 / Virus Database: 269.21.7/1333 - Release Date: 3/18/2008
8:10 AM