Skip to main content
The CSV connector converts comma-separated values (CSV) files into XML and generates CSV files from XML.

​
Key Capabilities

  • Bidirectional CSV/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 CSV to XML

​
Converting XML to CSV

​
CSV Transformation: Using the XML Map Connector

​
CSV Operations

Operations specific to the functionality of the CSV connector are listed below.

​
csvListRecords

Loops over every record in a specified CSV file or string. See Functions for more details.

​
Required Parameters

  • file: The path to the CSV file.

​
Optional Parameters

  • data: If the CSV data exists as a string rather than stored in a CSV file, use this parameter instead of file.
  • columns: The comma-separated list of columns to include in the output (if unspecified, all columns are included).
  • requireheader: By default, the first row of data is interpreted as column headers; pass false to this parameter to use generic column names (for example, c1, c2, c3).

​
Output

Any script in a csvListRecords operation executes multiple times: once for each record/row in the input CSV file/data. Within the operation, individual CSV values are accessible using the csv formatter. This formatter takes a column name as a parameter, and outputs the value in that column for the current record. For example, imagine the CSV input data contains a set of items purchased in an order, and the name of the item is held in the ItemName column. The following script generates XML containing each ItemName value in an Item element: 
<ItemList>
  <arc:call op="csvListRecords?file=myFile.csv">
    <Item>[csv('ItemName')]</Item>
  </arc:call>
</ItemList>

​
Macros

​
Examples