Queries and Export Tab

2013-06-28T19:08:04Z

Erik:

{{Plugin
|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
|PluginType2=Tab Widget
|ForApplication1=Protege-Frames
|ForApplication2=Protege-OWL
|ForApplication3=Protege Client-Server
|Screenshot=QueriesTab.png
|HomepageURL=http://protegewiki.stanford.edu/index.php/Queries_and_Export_Tab
|DeveloperID1=Daniel Schober
|DeveloperID2=Tania Tudorache
|LastUpdated=May 9, 2008
|Topic1=Search
|Topic2=Export
|Affiliation1=Max Delbrück Center for Molecular Medicine, Berlin
|Affiliation2=Stanford Center for Biomedical Informatics Research
}}

|free text=}}
<div style="float:left;">

__TOC__

== Querying the knowledge-base ==

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 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.

[[Image:QueriesTab.png|700px]]

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

[[Image: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):

[[Image:ThesaurusSm_exported.csv.png|700px]]

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 [http://www.bioinf.mdc-berlin.de/~schober/TheQueryExportTab here] (this documentation is outdated).<br /><br />

</div>

Protege Wiki - User contributions [en]

Queries and Export Tab