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-discussion] excel file imports in Protege Owl 3.3.1

himali shah dr_himalishah at yahoo.co.in
Tue Jul 29 09:50:01 PDT 2008


Dear Csongor:

Thanks for your prompt reply and suggestion. I will try that option as well.

Regards,
Himali.


--- On Tue, 29/7/08, Csongor Nyulas <csongor.nyulas at stanford.edu> wrote:

> From: Csongor Nyulas <csongor.nyulas at stanford.edu>
> Subject: Re: [protege-discussion] excel file imports in Protege Owl 3.3.1
> To: "User support for Core Protege and the Protege-Frames editor" <protege-discussion at lists.stanford.edu>
> Date: Tuesday, 29 July, 2008, 12:12 AM
> <div id=yiv1804267815><!DOCTYPE html PUBLIC
> "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
>   
>   <title></title>
> </head>
>  
> I forgot something important form my previous
> answer:<br>
> <pre><span class="moz-txt-star">I
> strongly recommend</span> you to use DataMaster
> version 1.3.1 coming with the latest version of Protege 3.4
> beta (or downloadable from the DataMaster wiki page:
> <a rel="nofollow"
> class="moz-txt-link-freetext"
>  target="_blank"
> href="http://protegewiki.stanford.edu/index.php/DataMaster">http://protegewiki.stanford.edu/index.php/DataMaster</a>
> which contains many important improvements compared to
> version 1.2.1.
> 
> Csongor
> </pre>
> <br>
> Csongor Nyulas wrote:
> <blockquote type="cite">
>   
> Dear Himali,<br>
>   <br>
> You did indeed everything very well by following the
> instructions. The
> reason the xlSQL driver cannot recognize your
> spreadsheet(s) as tables
> is that the content of the first row, is not interpretable
> as valid
> column names (either it does not contain text, or one of
> the the values
> contains invalid characters, i.e. anything else then a-z,
> A-Z, _, and
> 0-9). If you correct the first rows of your Excel sheets,
> you will be
> able to read them with the help of xlSQL driver.<br>
>   <br>
>   <b>Hint</b>: the formatting of the
> <u>second row</u> will inform the
> driver about the type of the content of each column
> (string, float,
> boolean, date/time etc).<br>
>   <br>
> Hope this helps,<br>
> Csongor<br>
>   <br>
> himali shah wrote:
>   <blockquote
>  type="cite">
>     <pre>Hi there:
> 
> I am trying to import excel files using DataMaster tab in
> Protege Owl 3.3.1. As per the instructions at 
> 
> <a rel="nofollow"
> class="moz-txt-link-freetext"
>  target="_blank"
> href="http://protegewiki.stanford.edu/index.php/XlSQL-Y8">http://protegewiki.stanford.edu/index.php/XlSQL-Y8</a>
> 
> 
> I downloaded The Excel JDBC driver xlSQL-Y8 on my machine
> and copied the relevant .jar files to DataMaster plug-in
> folder under Protege Owl. I also changed the Driver name and
> JDBC URL in the DataMaster Tab as per the instructions (Step
> 4 in the above webpage). However - even though my excel
> worksheets are stored in the specified directory - I
> consistently get the following message:
> 
> No table found in this data source
> 
> Kindly let me know what I am doing wrong.
> 
> Thanks,
> Himali.
> 
> PS: I understand that I can import and work with excel
> files easily in Protege Owl 4.0. However, I have to work
> with Jambalaya Tab which is supported in Protege Owl 3.3.1
> version and not in 4.0.
> 
> 
> 
> 
> 
> 
>       Share files, take polls, and make new friends - all
> under one roof. Go to <a rel="nofollow"
>  class="moz-txt-link-freetext"
>  target="_blank"
> href="http://in.promos.yahoo.com/groups/">http://in.promos.yahoo.com/groups/</a>
> _______________________________________________
> protege-discussion mailing list
> <a rel="nofollow"
> class="moz-txt-link-abbreviated"
>  target="_blank"
> href="mailto:protege-discussion at lists.stanford.edu">protege-discussion at lists.stanford.edu</a>
> <a rel="nofollow"
> class="moz-txt-link-freetext"
>  target="_blank"
> href="https://mailman.stanford.edu/mailman/listinfo/protege-discussion">https://mailman.stanford.edu/mailman/listinfo/protege-discussion</a>
> 
> Instructions for unsubscribing: <a
> rel="nofollow"
>  class="moz-txt-link-freetext"
>  target="_blank"
> href="http://protege.stanford.edu/doc/faq.html#01a.03">http://protege.stanford.edu/doc/faq.html#01a.03</a>
> 
>   </pre>
>   </blockquote>
>   <br>
>   <pre>
> <hr size="4" width="90%">
> _______________________________________________
> protege-discussion mailing list
> <a rel="nofollow"
> class="moz-txt-link-abbreviated"
> target="_blank"
> href="mailto:protege-discussion at lists.stanford.edu">protege-discussion at lists.stanford.edu</a>
> <a rel="nofollow"
> class="moz-txt-link-freetext"
> target="_blank"
> href="https://mailman.stanford.edu/mailman/listinfo/protege-discussion">https://mailman.stanford.edu/mailman/listinfo/protege-discussion</a>
> 
> Instructions for unsubscribing: <a
> rel="nofollow"
> class="moz-txt-link-freetext"
> target="_blank"
> href="http://protege.stanford.edu/doc/faq.html#01a.03">http://protege.stanford.edu/doc/faq.html#01a.03</a>
> 
>   </pre>
> </blockquote>
> <br>
>  
> </html>
> </div>_______________________________________________
> 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


      Bring your gang together. Do your thing. Find your favourite Yahoo! group at http://in.promos.yahoo.com/groups/



More information about the protege-discussion mailing list