CSV table designer

All the buttons from the toolbar are explained below.

The status bar displays the following information.

	Meaning	Description
		Unsaved data present Changes are present that have not yet been saved

Within the table designer, create the design for your CSV file to be exported.

By clicking the New in the toolbar, a new table is inserted, all unsaved changes to the current table are lost.

Using the Save button saves the table to your database. When you open your database on another computer, all your tables are still available.

If the current table is stored in your database, the Delete is available. You can delete the current table by clicking the Delete button, this action is irreversible.

In the frame Table box, you determine the properties of your table.

Enter a clear name for your table here, this name will be used within the programme to indicate this table. For example in the table browser. This text will not appear in the actual CSV file.

Enter a short description for your table here, this description is used within the programme to indicate this table. For example, in the table browser. This text does not appear in the actual CSV file.

For each report, you specify whether it has static columns or dynamic columns.

Tables with dynamic columns are displayed with the purple icon. These tables use the columns from the current entity list, with which the export was called. If the export does not come from the entity list, the default columns are used.

Tables with static columns always use a fixed set of columns, these tables are displayed with the blue icon. This allows you to create specific tables with a specific purpose and structure.

With this option you specify whether the first line in the CSV export should indicate the columns, depending on the application of the exported CSV file, it may be necessary to have no header line or, on the contrary, a header line.

In the example below, we chose not to add a header line.

CSV stands for comma-separated values/comma-separated valuesbut the separator is not always a commabut often a semicolon. Via this option, you specify which character is used as the field separator. This allows you to export the CSV file in the way that any receiving programme can deal with it.

In the example below, the separator is a semicolon.

Via the enclosing character, you specify which character surrounds the value when the value to be exported contains the field separator character. In the example below, the value contains Ms; ir. the semicolon character which is used as the field separator. By surrounding this value with the enclosing character, the structure of the CSV file remains valid.

In the box Columns box, choose which data to include in the table.

The column list displays all the columns to be included in the table. The order in the list corresponds to the order of the columns in the export.

Using the toolbar, add a new column, all fields of the entity as you designed them are available. It is also possible to add the same column multiple times.

When a column is selected in the list, you can use the toolbar to delete the column.

To adjust the order of the columns, you can move each column up and down when it is selected in the list.

Of the selected column in the column list, you can see its properties in the box below the list.

Custom header allows you to give a column a specific name instead of the default field name.

The following hotkeys are valid across the entire window, they do not depend on the focus on a particular component

No