Export wizard

The export wizard provides a possiblity to export the data selected in the main form. The data are exported as tab separated text file. The export and may include transformations of the data as well as informations provided by linked modules and webservices. Choose Data - Export - Export wizard - Export Taxon... from the menu. 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 colums 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 informations 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 colums 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.

Filtering data

To filter the data you have 2 options. Either filter the content of the whole table using the table filter or select a certain row in the data using the row filter.

•      Filter the content of the whole table = from the whole table only datasets matching the filter will be exported
•     Filter the content of the table in a certain file column = if the content matches the filter the data will be exported in the corresponding file column

To set a filter just click on the corresponding buttons and enter the filter you need. To remember you of the set filter, the background of the button will become red.

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.

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.

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.