Diversity Agents
Export Wizard
The export wizard provides a possibility to export the data selected in
the main form. The data are exported as tab separated text file. The
export may include transformations of the data as well as information
provided by linked modules and webservices. Choose Data - Export -
Export wizard from the menu and then
select one of the export targets (Event, Specimen, ...). For a short
introduction see the tutorial.
Adding tables
There are the following ways to add tables:
- One parallel table
Several parallel tables according to
selected data
Dependent table
All options will include the depending tables as defined for the default
table. The option for several tables will add
as many tables as there are found in the data.
If you added parallel tables, you should set the sequence of the
datasets within these tables: For the columns that should be used for
sorting the data, set the ordering sequence to a value > 0 and choose
if the ordering sequence should be ascending 
or
descending 
.
Adding related values
Certain columns in the database may provide information linked to
another table 
or a module resp. webservice
. Click on the button
to add a linked value.
Adding and editing file columns
To add columns to the exported file, use the
buttons. In the textbox at the top of the file column, you can change
the header for the column. To change the position of a file column use
the 
resp. 
button. To fuse
a column with the previous column, click in the gray bar
on the left side of the column that will change to 
for fused columns. To remove a file column, use the 
button. Pre- and postfixes for the columns can directly be entered in the corresponding fields. To apply transformations on the data click on the 
button.
Filter
To filter the exported data, use the filter function. Click on the
button and
enter the text for the filter. Only data matching the filter string will
be exported. If a filter is set, the
button will have a red background to remind you of the filter. The
filter may be set for any number of columns you need for the restriction
of the exported data.
Rowfilter
This filter in contrast to the filter above strictly applies to the row
according to the sequence of the data. For an explanation see a short
tutorial
.
Test
To test the export choose the Test tab,
set the number of lines that should be included in the test and click on
the Test export button. To inspect the
result in a separate window, click on the 
button.
SQL
If you want to inspect the SQL commands created during the test check this option. To see the generated SQL click on the SQL button after the Test export. A window containing all commands including their corresponding tables will be shown.
Export
To export your data to a file, choose the Export tab. If you want to store the file in different place use the
button to choose the directory and edit the name of
the file if necessary. Check the 
include a schema option if you want to save a schema together with your
export. To start the export, click on the Export data
button. To open the exported file, use the button.
Export to SQLite
To export your data into a SQLite
database, choose the Export to SQLite tab. You may change the preset name of the database in order to keep previous exports. Otherwise you overwrite previous exports with the same filename. To start the export, click on the Export data
button. To view the exported data, use the
button.
Schema
To handle the settings of your export, choose the
Schema tab. To load a predefined schema,
click on the button. To reset the settings to the
default, click on the 
button. To save the current
schema click on the 
button. With the
button you can inspect the schema in a separate
window.