Re: Update of the MySQL backend database (Csongor Nyulas)

Hi Csongor,

Thanks a lot for your advice.

What I try to do is uploading new individuals, some hundreds.

Configuring the Data master tab in Protégé 3.4.8 might help perhaps.
I'm not sure if the tab supports 3.4.8 and as far as I remembered, new classes were created automatically based on the tab name of the Excel sheet.
The direct import in MySQL seemed a swift alternative but, I would appreciate your advice for any alternative you judge better.
The import may be from .CSV files too.

Thanks in advance.

Kind regards - Meilleures salutations - Mit freundlichen Grüssen - Met vriendelijke groeten

Eddy Vanderlinden

-------------
DIGIT Unit 01, Brussels
MIA - Methodologies, Interoperability and Architectures
Tel.: +32 2 295 26 64
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of [email protected]
Sent: Tuesday, April 23, 2013 9:04 PM
To: [email protected]
Subject: protege-discussion Digest, Vol 81, Issue 25

Send protege-discussion mailing list submissions to
	[email protected]

To subscribe or unsubscribe via the World Wide Web, visit
	https://mailman.stanford.edu/mailman/listinfo/protege-discussion
or, via email, send a message with subject or body 'help' to
	[email protected]

You can reach the person managing the list at
	[email protected]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of protege-discussion digest..."


Today's Topics:

   1. Re: Update of the MySQL backend database (Csongor Nyulas)


----------------------------------------------------------------------

Message: 1
Date: Tue, 23 Apr 2013 11:09:15 -0700
From: Csongor Nyulas <[email protected]>
To: [email protected]
Subject: Re: [protege-discussion] Update of the MySQL backend database
Message-ID: <[email protected]>
Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"

Hi Eddy,

The Protege 3 database back-end is not meant to be edited directly 
(through SQL updates or Excel or anything). The adding of new 
information (new rows) is an especially bad idea, since it is very easy 
to break things.
The Protege back-end is NOT a triple store, but rather a "proprietary" 
storage format developed originally for frames ontologies, and later 
adapted to be used to store OWL ontologies.

You should use the Protege/WebProtege client or the Protege API to 
modify the content of your ontology.

If you explain what you try to achieve, maybe we can provide even more 
specific advise.

Regards,
Csongor


On 04/23/2013 02:15 AM, [email protected] wrote:
> Hello,
> MS Excel offers in the 2010 version a nice feature.
> When we have the MySQL workbench installed on the same PC, there is a 
> connection possible from Excel to MySQL.
> This is accessible through the button as shown hereby .
> We can retrieve and update information in the spreadsheet.
> The possibility to upload triples is available too.
> However, when we do so, they do not appear in the ontology (updates of 
> existing triples do).
> We are using Prot?g? 3.4.8 with Webprot?g? 1 as user interface, the 
> collaborative version in the background does not show the new triples 
> neither.
> An example of the uploaded data in the spreadsheet is shown here:
> *frame* 	*frame_type* 	*slot* 	*facet* 	*is_template* 	*value_index* 
> *value_type* 	*short_value* 	*long_value*
> ArisDiagram 	25 	:DIRECT-TYPE 	
> 	0 	1 	9 	http://ec.europa.eu/ontologies/EC_Glossary.owl#EC_Concept 	
> http://ec.europa.eu/ontologies/EC_Glossary.owl#EC_Concept 	9 
> :DIRECT-INSTANCES 	
> 	0 	206 	25 	ArisDiagram 	
> ArisDiagram 	25 	:NAME 	
> 	0 	0 	3 	ArisDiagram 	
> ArisDiagram 	25 	http://www.w3.org/1999/02/22-rdf-syntax-ns#type 	
> 	0 	0 	9 	http://ec.europa.eu/ontologies/EC_Glossary.owl#EC_Concept 	
> ArisDiagram 	25 	http://www.w3.org/2004/02/skos/core#prefLabel 	
> 	0 	0 	3 	Aris diagram 	
>
> Is there anything we are missing here to make this function?
> Thanks in advance.
> Kind regards
> Eddy Vanderlinden
> -------------
> DIGIT Unit 01, Brussels
> MIA - Methodologies, Interoperability and Architectures
> Tel.: +32 2 295 26 64
>
>
> _______________________________________________
> protege-discussion mailing list
> [email protected]
> https://mailman.stanford.edu/mailman/listinfo/protege-discussion
>
> Instructions for unsubscribing: http://protege.stanford.edu/doc/faq.html#01a.03

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.stanford.edu/pipermail/protege-discussion/attachments/20130423/d42eafc9/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 2600 bytes
Desc: not available
URL: <http://mailman.stanford.edu/pipermail/protege-discussion/attachments/20130423/d42eafc9/attachment-0001.jpe>

------------------------------

_______________________________________________
protege-discussion mailing list
[email protected]
https://mailman.stanford.edu/mailman/listinfo/protege-discussion


End of protege-discussion Digest, Vol 81, Issue 25
**************************************************
_______________________________________________
protege-discussion mailing list
[email protected]
https://mailman.stanford.edu/mailman/listinfo/protege-discussion

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