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 (
Keyword type export ...,
Periodical export ... or
Reference export ...). For a short introduction see the
tutorial.
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
.
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.
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.
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.
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 from DiversityCollection
.)
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.
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.
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.
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.