Convert CSV to XML

Use the CSV to XML document wizard to convert a Comma Separated Value (CSV) text file to an XML document. To display the Convert CSV to XML dialog box, select File > Document Wizards in the Stylus Studio menu bar, and double-click CSV to XML.

Fields

Input URL

Specifies the absolute path name of the CSV file you want to import.

Input Encoding

Identifies the encoding of the source CSV file. The default for your platform is typically UTF-8 or UTF-16. If you do not specify a value, the wizard uses the default for your platform.

Root element name

Specifies the name of the root element in the resulting XML document. The default is document.

Row element name

Specifies the name of the row elements in the resulting XML document. The default is row. The row elements are the children of the root element.

Column names are

The columns are the children of the row elements.

Generated indicates that the wizard should insert the default column names, which are value1, value2, value3, and so on.

In file indicates that the first line in the CSV file contains the values for the column names.

Specified here indicates that you are typing the names of the columns in the text area.

Map value to

Child element indicates that the wizard should map the column values to child elements of the row elements.

Attribute indicates that the wizard should map the column values to attributes of the row elements.

Delimiter

Indicates the special character that separates the values in the CSV file. The default is a comma ( ,). Select the delimiter you want, or select Other and type the delimiter you want.

Quote

Indicates the special character that acts as a quotation mark. The default is a double quote ( "). Select the special character you want, or select Other and type the character you want.