Difference between revisions of "Queries and Export Tab"

From Protege Wiki
Jump to: navigation, search
(corrected spelling of tab widget which caused this plug-in not to show up in the right category)
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
{{Plugin
 
{{Plugin
|Description=This plugin allows you to query knowledge-bases and export the results.  An export button was added to the query-results window to allow for tabular export of selectable slot values of all found result-instances.
+
|Description=This plug-in allows you to query knowledge-bases and export the results.  An export button was added to the query-results window to allow for tabular export of selectable slot values of all found result-instances.
 
|PluginType=Export
 
|PluginType=Export
 
|PluginType2=Tab Widget
 
|PluginType2=Tab Widget
Line 7: Line 7:
 
|ForApplication3=Protege Client-Server
 
|ForApplication3=Protege Client-Server
 
|Screenshot=QueriesTab.png
 
|Screenshot=QueriesTab.png
 +
|HomepageURL=http://protegewiki.stanford.edu/index.php/Queries_and_Export_Tab
 
|DeveloperID1=Daniel Schober
 
|DeveloperID1=Daniel Schober
 
|DeveloperID2=Tania Tudorache
 
|DeveloperID2=Tania Tudorache
Line 13: Line 14:
 
|Topic2=Export
 
|Topic2=Export
 
|Affiliation1=Max Delbrück Center for Molecular Medicine, Berlin
 
|Affiliation1=Max Delbrück Center for Molecular Medicine, Berlin
|Affiliation2=Stanford
+
|Affiliation2=Stanford Center for Biomedical Informatics Research
 
}}
 
}}
 +
 
<div style="float:left;">
 
<div style="float:left;">
  
Line 21: Line 23:
 
== Querying the knowledge-base ==
 
== Querying the knowledge-base ==
  
The querying of the knowledge-base is described in detail in the [http://protege.stanford.edu/doc/tutorial/get_started/create_and_save_queries.html Protege Getting Started Guide].
+
Querying the knowledge-base is described in detail in the [http://protege.stanford.edu/doc/tutorial/get_started/create_and_save_queries.html Protege Getting Started Guide].
  
  
== Exporting the query results to a tab delimited file ==
+
== Exporting query results to a tab delimited file ==
 
 
  
 
You can export the query results to a tab delimited file (the delimiter is configurable) by clicking on the '''E''' icon at the top of the search result list. The exported file will contain a row for each exported entity. The row will contain the values for the exported slots/properties separate by the slot delimiter.
 
You can export the query results to a tab delimited file (the delimiter is configurable) by clicking on the '''E''' icon at the top of the search result list. The exported file will contain a row for each exported entity. The row will contain the values for the exported slots/properties separate by the slot delimiter.
  
  
[[Image:QueriesTab.png]]
+
[[Image:QueriesTab.png|700px]]
  
  
After clicking on the Export icon, you will get a export configuration dialog that looks like this:
+
After clicking on the Export icon, you will get an export configuration dialog:
  
  
Line 39: Line 40:
  
  
This configuration dialog allows you to configure:
+
The configuration dialog allows you to configure:
  
* '''Exported file''': the file where to export the results
+
* '''Exported file''': the file to export the results to
 
* '''Slots to export''': the slots/properties for which the values at the individuals will be exported. To add a new slot/property to export, click on the "Add slot" icon at the top of the "Slots to export" text area.
 
* '''Slots to export''': the slots/properties for which the values at the individuals will be exported. To add a new slot/property to export, click on the "Add slot" icon at the top of the "Slots to export" text area.
 
* '''Slot delimiter''': the delimiter between different slots/properties
 
* '''Slot delimiter''': the delimiter between different slots/properties
 
* '''Slot values delimiter''': the delimiter between different values of a slot/property
 
* '''Slot values delimiter''': the delimiter between different values of a slot/property
* '''Export slot names as first line in the file''': does what it says it does
+
* '''Export slot names as first line in the file'''
 
* '''Export instances types''': add a column to the exported file with the type of the exported instance
 
* '''Export instances types''': add a column to the exported file with the type of the exported instance
  
  
 
+
To '''start the export''', press the "OK" button of the Export Configuration Dialog. After the export, you will get a message dialog as to whether the export was successful or not. If the export was successful, a file was generated in the configured location. It can be opened either with a text editor, or spreadsheet software (e.g., Open Office Spreadsheet, or Microsoft Office Excel).
To '''start the export''', press on "OK" button of the Export Configuration Dialog. After the export, you will get a message dialog of whether the export was successful or not.
+
The result in Open Office will look as follows (similar also in Excel):
If the export was successful, a file was generated in the configured location. It can be opened either with a text editor, or a spreadsheet software (e.g. Open Office Spreadsheet, or Microsoft Office Excel).
 
The result in Open Office will look like this (similar also in Excel):
 
  
  
[[Image:ThesaurusSm_exported.csv.png]]
+
[[Image:ThesaurusSm_exported.csv.png|700px]]
  
  
This plugin is distributed with the Protege installation and it is supported and maintained by the Protege team.
+
This plug-in is distributed with the default Protege installation and is supported and maintained by the Protege team.
  
  
Original documentation for exporting [http://www.bioinf.mdc-berlin.de/~schober/TheQueryExportTab here] (This documentation is outdated).
+
The original documentation for exporting still exists [http://www.bioinf.mdc-berlin.de/~schober/TheQueryExportTab here] (this documentation is outdated).<br /><br />
  
 
</div>
 
</div>

Latest revision as of 14:51, July 17, 2013

Queries and Export Tab

by Daniel Schober, Tania Tudorache

This plug-in allows you to query knowledge-bases and export the results. An export button was added to the query-results window to allow for tabular export of selectable slot values of all found result-instances.

Versions & Compatibility

This section lists available versions of Queries and Export Tab.

No version information available.

If you click on the button below to add a new version of Queries and Export Tab, you will be asked to define a page title for the new version. Please adhere to the naming convention of Queries and Export Tab X.X.X when you define the new page!

Changelog

No version information available.



Querying the knowledge-base

Querying the knowledge-base is described in detail in the Protege Getting Started Guide.


Exporting query results to a tab delimited file

You can export the query results to a tab delimited file (the delimiter is configurable) by clicking on the E icon at the top of the search result list. The exported file will contain a row for each exported entity. The row will contain the values for the exported slots/properties separate by the slot delimiter.


QueriesTab.png


After clicking on the Export icon, you will get an export configuration dialog:


Export To CSV configuration.png


The configuration dialog allows you to configure:

  • Exported file: the file to export the results to
  • Slots to export: the slots/properties for which the values at the individuals will be exported. To add a new slot/property to export, click on the "Add slot" icon at the top of the "Slots to export" text area.
  • Slot delimiter: the delimiter between different slots/properties
  • Slot values delimiter: the delimiter between different values of a slot/property
  • Export slot names as first line in the file
  • Export instances types: add a column to the exported file with the type of the exported instance


To start the export, press the "OK" button of the Export Configuration Dialog. After the export, you will get a message dialog as to whether the export was successful or not. If the export was successful, a file was generated in the configured location. It can be opened either with a text editor, or spreadsheet software (e.g., Open Office Spreadsheet, or Microsoft Office Excel). The result in Open Office will look as follows (similar also in Excel):


ThesaurusSm exported.csv.png


This plug-in is distributed with the default Protege installation and is supported and maintained by the Protege team.


The original documentation for exporting still exists here (this documentation is outdated).