Reads a CSV file content and loads it into the step’s XML.
The Read CSV step reads any CSV file and loads its content as an XML. As a consequence, the content of the CSV file is available as a source for other following steps.
Property | Type | Category | Description |
---|---|---|---|
Column tag | String | standard | Defines the column tag name. Any tag name to use for columns in XML can be configured using this property. Default value is col. |
Comment | String | standard | Describes the object comment to include in the documentation report. This property generally contains an explanation about the object. |
Encoding | String | standard | Defines the encoding used in the CSV file. Empty property value auto tries utf-8 and iso-8859-1. Default value for encoding is utf-8. |
Is active | boolean | standard | Defines whether the step is active. |
Line tag | String | standard | Defines the lines tag name. Any tag name to use for lines in XML can be configured using this property. Default value is line. |
Source | JS expression | standard | Defines the path of the file to read. This property is a JavaScript expression that is evaluated during the sequence execution and gives the path of the file to read. This path is either absolute or relative to Convertigo environment. Relative paths starting with: • ./ are relative to Convertigo workspace, • .// are relative to current project folder. |
Output | boolean | expert | Defines whether the XML generated by this step should be appended to the resulting XML. Set this property to true to add the step’s resulting XML to the sequence’s output XML (default value for steps generating XML). Set this property to false to prevent the steps’s XML result to appear in the sequence’s output XML. Setting this property to false does not prevent the step’s generated XML from being used as a source by other steps. |
Replace ‘step’ element | boolean | expert | Defines if the root ‘step’ element should be replaced by its content. If ‘true’, the current Step will append the content of the file to the current Sequence, if ‘false’ the content is added to a ‘step’ element appended to the current Sequence. |
Separator | String | expert | Defines the CSV default separator symbol. Any separator character can be configured using this property. Leave empty value to enable the separator auto detection. Default value is ,. |
Title line | boolean | expert | Defines whether the CSV file has a title line or not. If set to true, the first line of the CSV file is handled as a title line which means that each cell of the first line is used as tag name for the following lines, containing content. More precisely, for each cell of the first line, if the cell contains data, the tag associated with the corresponding column is named after this data. Otherwise or if the property is set to false, the tag is named after the Column tag property. |
Vertical direction | boolean | expert | Defines the array reading direction. If set to true, the reading direction is vertical. Otherwise, it is horizontal. |