Search Mailing List Archives


Limit search to: Subject & Body Subject Author
Sort by: Reverse Sort
Limit to: All This Week Last Week This Month Last Month
Select Date Range     through    

[protege-owl] DataMaster and Excel, not still working

mbikinyi brat mbikinyi_brat at yahoo.com
Sun Mar 15 12:55:53 PDT 2009


Dear Csongor,
Thanks for your advice.
I have done as you said, yet I have not been successful.
See my results attached again.
 
Regards,
Nan
 


--- On Sat, 3/14/09, Csongor Nyulas <csongor.nyulas at stanford.edu> wrote:


From: Csongor Nyulas <csongor.nyulas at stanford.edu>
Subject: Re: [protege-owl] DataMaster and Excel
To: "User support for the Protege-OWL editor" <protege-owl at lists.stanford.edu>
Date: Saturday, March 14, 2009, 5:02 PM


Hi Nan,

The problem is that, you did not specify the name of the columns. XlSQL interprets each spread sheet as a database table, the first row in the sheet is interpreted as the name of the table columns, and all the following rows are interpreted as rows in the table. See attached the corrected Excel table, that you should be able to be import byusing DataMaster with the xlSQL-Y8 driver.

In case you are wondering about the column types: they are detected from the formatting of the cells in the second row.

Csongor

mbikinyi brat wrote:
> Dear All,
> I wish to import data into protege using DataMaster. My data is an Excel spread sheet. I have followed the execution steps in this link:
> http://protegewiki.stanford.edu/index.php/XlSQL-Y8#New_Features
>  When I click on "connect" see my results attached. I do not know what to do with it. any help.
> Nan
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> protege-owl mailing list
> protege-owl at lists.stanford.edu
> https://mailman.stanford.edu/mailman/listinfo/protege-owl
> 
> Instructions for unsubscribing: http://protege.stanford.edu/doc/faq.html#01a.03   


-----Inline Attachment Follows-----


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

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-owl/attachments/20090315/db0dc7d5/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: DataMaster Trial.JPG
Type: image/bmp
Size: 1213882 bytes
Desc: not available
URL: <http://mailman.stanford.edu/pipermail/protege-owl/attachments/20090315/db0dc7d5/attachment.JPG>


More information about the protege-owl mailing list