This section describes the fields and available options when exporting to a CSV file.
After running the export service, you are presented with configuration and mapping pages. See the sections below for more information.
This page allows you to modify behavior of the export. Part of the modification can include specifying Java classes to transform, or validate data. This page contains the options shown in the following table:
Property/Field/List | Definition |
|---|---|
| File name | Name of the exported file. |
| Export view | Specifies the table's view to export. Only data contained in the view is exported. |
| Preference | All table columns will be exported based on configuration and mapping defined by the selected export preference. |
| First row contains header | Use this option to specify whether the first row of every column in the file being imported is a label (Header), or contains data to import (No header). |
| Disable write access lock | Specifies the write access lock on the data space while exporting. If 'No': The dataspace is locked and the export is executed inside the read only procedure. If 'Yes': The export is executed outside a procedure and users have write access on the data space while exporting. Default value: 'No'. |
| File encoding | Specifies the character encoding to use. The default is UTF-8. |
| Separator | Specifies the separator character used to separate fields. The default is ';'. |
| List separator | Specifies the separator to use for values lists. |
| Delimiter | Specifies the character used to enclose a field value. The exported file will include this delimiter character before and after each field value. By default, CSV files do not use a delimiter. The add-on imports correctly from exported files where data values include the defined separator. These files also display correctly in spreadsheet programs. However, if you define a delimiter and view the file in a spreadsheet program, the display might not reflect the actual data structure. If you select 'Only string', the delimiter is only used for String data types. |
| Date format | Specifies the format of date values in the exported file. |
| Date/time format | Specifies the format of date/time values in the exported file. |
| Use language | If this option is activated, the language and corresponding number format policy are applied. |
| Language | Specify the language and the corresponding number format policy used in the exported file. |
| Export related data | Specifies whether the export includes related data. The add-on exports a ZIP file containing the selected record(s) and all related data. Each file in the archive contains data from a related table. When you select:
|
| Primary key | The exported file will contain an information column with the label of the primary key. |
| Foreign key | The exported file will contain an information column with the label of the foreign key. |
| Export enumerations | The exported file will contain a dedicated column for the labels of the static enumerations. |
| Include computed values | Specifies whether computed values must be included in the export. |
| Extensions | Specifies the Java class that is implemented to transform data during import/export processing. |
This page allows you to map source table columns in the exported CSV file. Use the drop-down list next to each table column to specify which source gets mapped to which target. Below the mapping configuration information, the Save preference group allows you to save the mappings as a reusable preference. Just tic the Create new preference called radio button and enter a name in the field.