Csv - Connector Settings
These settings control the behavior of the CSV connector for importing and exporting data. They affect file parsing, data formatting, and exporting orders.
The settings are configured in the App4Sales portal for a specific connector instance. They are applied at runtime during data synchronization and order export.
Setting | Description | Values / Defaults | Dependencies / Effects |
CleanData | When enabled, the connector will clean the data by trimming whitespace from all fields during the import process. | Boolean ( | Affects all CSV imports. Enabling this can help prevent data mismatches due to leading or trailing spaces. |
UseDeprecatedFreeFieldsFormat | Enables a legacy format for handling free fields in the imported data. This should only be enabled for backward compatibility. | Boolean ( | Affects how free fields are processed. Modern implementations should keep this disabled. |
HideFreeFieldCaption | If enabled, the caption for free fields will not be displayed in the App4Sales interface. | Boolean ( | Affects the UI display of free fields. |
Separator character used in import files (default: ;) | The character used to separate columns in the CSV files. | A single character string. Defaults to | A wrong separator will cause parsing errors for all imported CSV files. |
Use template for CSV Export | When enabled, the connector uses a pre-defined template for exporting orders to CSV format via FTP. | Boolean ( | This setting changes the structure of the exported order CSV file. Requires a template to be configured. |
Order Processing
The UseTemplateForCSVExportToFtp setting allows for customizing the format of order exports to match specific requirements of an external system.
Data Import
The SeparatorCharacter and CleanData settings are crucial for ensuring that CSV files provided by an ERP are parsed correctly.