User interface description

All options of Ontorion™ Text Mining Tools for Excel are situated in Ontorion tab. Below image shows its user interface:

Figure 1

1.0 Generate Taxonomy

Use this button to generate the taxonomy, before using it make sure that you have prepared predefined taxonomy columns (see). Clicking it will open new window as below:

Figure 2

1.1 - Input

Specify here range of the input raw data. Currently it supports only a single column range.

1.2 - Taxonomy

Specify here range which contains the predefined taxonomy which will be used to extract the data from raw text. It is enough to select only headers, and all values that are below them will be read automatically.

1.3 - Reduce input by matched columns

If checked, then during the matching process, the normalized string will be reduced by the matched words from each taxonomy column and then passed to the next columns. Check this one to get the better results for the taxonomy columns with “*” attribute.

1.4 - Add Tag Column

Check to enable the tags feature.

1.5 - Tags source

Specify here a column with the tags. The header of that column should be named “TAGS”.

1.6 - Apply

Clicking this button will open another form on which it is possible to apply a tags for a specific predefined taxonomy values:

Figure 3

There are two ways of doing it:

Use DELETE key on keyboard to remove items from list box with tags(the one on the right side).

Refer to Sample 2 for more information how to use this feature.

1.7 - Equivalents

Specify here a two column range where the first one contains item names and second one their equivalents. Equivalents will be used instead of the item names in Taxonomy Output. These two column headers have to be named as NAME and EQUIVALENT.

1.8 - Output

Specify here where the Taxonomy Output will be written. It is possible to write only one Taxonomy Output on single Excel worksheet.

2.0 Refresh

Use this button during edition of predefined taxonomy to refresh the Taxonomy Output. Note that using this button refreshes only content of ranges that were specified in Generate Taxonomy window, so if you e.g. added new column with taxonomy, then you will have to use Generate Taxonomy button and adjust new range manually. This button is enabled only on the worksheet with predefined taxonomy.

3.0 Export to Fluent Editor

Converts generated taxonomy to the controlled natural language(CNL) and Exports it to Fluent Editor. If you are not familiar with a grammar concepts of Fluent Editor please refer at first to Fluent Editor documentation( Grammar section), which can be find in Fluent Editor application.

Clicking this button will open following window:

Figure 4

In this window we can specify configuration for conversion of taxonomy into CNL.

3.1 - Identifier

Specifies the identificator name under which the input rows will be represented inside Fluent Editor. To this identificator, consecutive numbers will be added in order to provide unique name. To provide the starting number, to the end of the identifier add "@" and then the number e.g. Computer@100

3.2 - Cluster sentences

Checking this option will aggregate all of the statements which concerns an input row, into a single CNL sentence.

3.3 - Advanced

Checking this will show more advanced options, as seen ont the Figure 4.

By default(if 3.3 Advanced checkbox is not checked) input rows will be treated as an instances with pattern "{ID} {DESC}.". In the datagrid we can decide how to treat each column of our taxonomy. This configuration will be saved, so after reopening this window it will show the previously set configuration. Note that the configuration will be saved for each taxonomy output worksheet separately. After finishing the configuration, click an Export! button in order to create and export CNL to Fluent Editor.

For full information about how to use this window please refer to Sample 3.

4.0 Language

Here you can choose language in which the taxonomy processing will be executed.

5.0 Help

Opens this Help.

6.0 License Info

Opens message box with license information. If your product is not registered, you can register it using this button. The following window will be displayed then:

Figure 5

Just paste the license key provided by Cognitum company and click Register button to complete the registration process.