Converting CSV to XML
This task will convert the specified CSV Input into XML data and save to the location specified in the Output File setting.
Settings
Column Name Prefix
Required (If Headers not specified)
The prefix that will be used with the Column Index for auto generated Column names (only applicable if Headers are not specified). Column names are used when generating the Context Variables. Defaulted to F.
Delimiter
Optional
The column delimiter used in the Input. This is often a quotation mark. Please see the CSV article if you are unsure what value to use. Defaulted to double quotes e.g. "
Encoding Type
Required
The encoding to use when parsing the Input.
Defaulted to UTF8.
Include Headers
Set this to true to interpret the first row of the Input as column names. Column names are used when generating the Context Variables. Defaulted to true.
Input
Required
The absolute or relative file path on the local computer or network to the CSV file or the actual CSV data you would like to repeat/loop over. See the Zynk Objects article if you require more information on how the Zynk Object file value works. Defaulted to Output from previous task.
Separator
Required
The column separator used in the Input, for a CSV file this will be a comma, for tab delimited use \t. Please see the CSV article if you are unsure what value to use.
Defaulted to ,
Export As Elements
Required
Set to true to output the value of each column as an XML element node, or false to output them as XML attributes.
Defaulted to true.
Output
Required
The absolute or relative file path on the local computer or network to save the converted XML file to.
See the Zynk Objects article if you require more information on how the Zynk Object file value works.
Defaulted to csv_to_xml.xml in the current working directory.
Root
Required
The name to use for the root XML element in the generated Output File.
Defaulted to Root
Row
Required
The XML element name to use for each row in the generated Output File.
Defaulted to Row
Zynk Settings
Examples
Sample input file, which includes a header row:
AccountReference,CompanyName,Balance
A1D001,A1 Design Services,0
BBS001,Bobs Building Supplies,4309.77
Sample output file, when the File Includes Headers setting is set to true, Root is set to Accounts, and Row is set to Account:
<?xml version="1.0" encoding="utf-8"?>
<Accounts>
<Account>
<AccountReference>A1D001</AccountReference>
<CompanyName>A1 Design Services</CompanyName>
<Balance>0</Balance>
</Account>
<Account>
<AccountReference>BBS001</AccountReference>
<CompanyName>Bobs Building Supplies</CompanyName>
<Balance>4309.77</Balance>
</Account>
</Accounts>
Sample input file, which does not include a header row:
Sample output file, when the Include Headers setting is set to false, the Column Name Prefix is set to F and Export As Elements is set to false, Root is set to Root, and Row is set to Row: