6. Export Configuration

File Size: Minimum size is 10 MB.

Format

Choose the output format for the export file:

• CSV: Export as CSV. Additional configurations are available.

• XML: Export as XML.

• XSLT: Export with transformations defined by a selected stylesheet.

For more information, see the Style Sheet Overview (window). To create custom stylesheets, contact customer service.

Encoding

Defines the file's character encoding. We recommend UTF-8 for Western languages. More details are available here.

Export File Even if Empty

Choose whether to export a file when no data is available:

• No: No file is generated if no data is available.

• Yes: A file with column names, but no data is generated.

Split Files

Determines whether the export is divided into smaller files:

• No: A single file is created with a maximum size of 9999 MB. Files continue automatically if the data volume exceeds this limit. Compression is calculated after compression.

• Yes (default): Splits the export into multiple files with a minimum size of 100 MB.

Set the Maximum File Size (default: 9999 MB) for each file. Compression size is calculated after compression.

Compression

We highly recommend enabling file compression:

• GZIP: Compresses using GZIP. Learn more here.

• ZIP: Compresses using ZIP. Learn more here.

• No Compression: Suitable only for small exports.

File Name

Defines the structure of the export file name. The default is: export-${exportDef.exportType}-${exportDef.PK}-${ecx:fmtDate(export.creationDate,'yyyy_MM_dd_HH_mm_ss', 'UTC', 'de_DE')}

• ${exportDef.exportType}: Inserts export type.

• ${exportDef.PK}: Inserts export ID (automatically assigned).

Example: export-generic-12345678-2024_09_01_12_12_15.

File Location

Defines where the export file is uploaded:

• FTP, FTP, or FTPS server

• Amazon S3 Account

• Google Storage Account

Ensure the server address is correct. For details, see Credentials Options.

Test Connection

Click Test Connection to verify that the entered export location is correct. Possible outcomes include:

• OK: Successfully connected.

• Syntax Error: Check and correct the server path syntax.

• Unsupported Protocol: Ensure the correct protocol is selected.

• Unknown Host: Check the server host input.

• Connection Error: Retest if the time limit for connection was exceeded.

When CSV is selected as the export format, additional configurations are available:

Structure

Defines how data is displayed in the CSV file:

• Separator: Defines the separator between entries (e.g., comma, semicolon).

• Delimiter: Used to mark fields with special characters (default: straight quotation marks).

• Line Separator: Defines the line break type:

  • Unix (LF): For Unix-like systems (e.g., Mac OS X).

  • Windows (CR+LF): For Windows systems.

Column Configuration

Define column settings for the exported data:

• Position: Adjust the order of columns.

• Data: Only displays data types selected for export in previous steps.

• Column Header: Customize or reset column names to default.