Xlsx - Connector Settings
This document details the connector-specific settings for the App4Sales XLSX connector. These settings influence how the connector processes data from and to XLSX (Excel) files, enabling administrators and implementation consultants to configure its behavior without needing to understand the underlying code.
Connector settings are typically managed through a dedicated configuration interface within the App4Sales platform, where values can be defined and applied to control aspects such as data formatting, file handling, and integration logic.
Setting | Description | Values / Defaults | Dependencies / Effects |
DateFormat | Specifies the expected date format used when reading dates from or writing dates to XLSX files. This ensures correct interpretation and formatting of date values exchanged between the external XLSX files and the App4Sales platform. | Accepts a string representing a valid date format (e.g., "yyyy-MM-dd", "MM/dd/yyyy", "dd-MM-yyyy HH:mm:ss"). No explicit default value is defined in the connector's configuration; it is essential to set this according to the date format used in the source XLSX files to avoid parsing errors. | This setting directly impacts the successful parsing and formatting of all date-related fields in XLSX files. An incorrect date format will lead to data conversion errors or incorrect date values being stored in App4Sales. |
Special Logic & Filters
There are no explicit special logic or filtering mechanisms controlled by specific settings found in the current configuration for the XLSX connector.
Domain Specifics
This section is currently not applicable as there are no domain-specific configurations identified beyond general date formatting.
Related Settings & Prerequisites
No direct dependencies on other specific connector settings have been identified. However, proper functioning of the XLSX connector relies on the accessibility of the specified XLSX files and adherence to the defined file structure and content.
Known Limitations
Based on the current settings, the connector's capabilities are limited to basic data exchange, with date formatting as the primary configurable option. Advanced features such as specific sheet selection, column mapping configurations, or complex data transformations are not directly exposed through these settings.