Key Capabilities
- Bidirectional PSV/XML conversion with configurable delimiters and encoding
- Header detection and custom column mapping capabilities
- Support for various character encodings and special character handling
Overview
Connector Configuration
This section contains all of the configurable connector properties.Settings Tab
Configuration
Settings related to the connector Id and description.Connector Settings
Settings related to the core operation of the connector.Other Settings
Settings not included in the previous categories.Sample Files Tab
Advanced Tab
Message
Logging
Miscellaneous
Automation Tab
Automation Settings
Performance
Alerts Tab
SLAs Tab
Converting PSV to XML
When a file is transformed into XML, the resulting XML has the following structure:Items. The name of all record elements is determined by the Record Name option set in Connector Settings. Each record element then has child elements corresponding to the values in each row of the input file.
Some files include a line of header information that provides context to the values in the file. When the First line is header information setting is enabled, this header line is parsed, and the parsed headers are used as the element names for the value elements (the children of the record elements). Otherwise, the value elements are given generic names such as field_0, field_1, and so on.
Converting XML to PSV
To convert XML to a file, the input XML must have a ‘flat’ structure. This means that, disregarding theItems root element, the depth of the XML structure is two. For example:
- Children of the root element are treated as records (rows) in the resulting file
- Children of each record element are treated as the values in each row
title, year, and runtime.