Home > Online Product Documentation > Table of Contents > Running the Convert CSV to XML and Convert Fixed-Width to XML Document Wizards

< Previous | Next >

Running the Convert CSV to XML and Convert Fixed-Width to XML Document Wizards

To run the Convert CSV to XML and Fixed-Width to XML document wizard:
1. In the Stylus Studio menu bar, select File > Document Wizards. The Document Wizards dialog box appears.
2. In the Document Wizards dialog box, in the XML Editor tab, double-click one of the following according to the format of the file being converted:
    • CSV to XML. The Convert CSV to XML dialog box appears.
    • Fixed-Width to XML. The Convert Fixed-Width to XML dialog box appears.
3. In the Input URL field, type the name of the text file you want to convert, or click Browse to navigate to and select the file you want to convert.
4. In the Input Encoding field, select the character encoding of the text file being converted. 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.
5. In the Root element name field, type the name you want for the root element in the XML document. The default is document.
6. In the Row element name field, type the name you want for the row elements in the XML document. The default is row.
7. In the Column names are group box, click one of the following:
    • Generated indicates that you want Stylus Studio to generate column names. The default column names are value1, value2, value3, and so on.
    • In file indicates that the first line in the text file contains the column names.
    • User defined indicates that you are entering the names of the columns in the text area. Use the buttons to the right of the text area to ensure that the column names are in the correct order.

      • For more information on specifying user defined columns, see Specifying User-Defined Columns.

8. In the Map value to group box, click Child element to map the column values to child elements of the row elements. For example: 
<document>
               
<row>
               

            
<value1>First Value</value1>
               
<value2>Second Value</value2>
               

              

                
</row>
                   
</document>

Click Attribute to map the column values to attributes of the row elements. For example: 

<document>
               
<row value1="First Value" value2="Second Value"</row>
               
</document>

9. If you are converting a fixed-width file, go to step 12. You do not need to specify delimiting or quote characters for fixed-width files.
10. In the Delimiter group box, accept the default delimiter character, which is a comma (,), select another common delimiter, or specify some other delimiter. The delimiter is the character that appears between values in the text file. Stylus Studio automatically displays the hexadecimal value for the character you specify. If you prefer, you can enter the hexadecimal value for the character you want. Stylus Studio automatically displays the correct character in the character field.
11. In the Quote group box, accept the default quotation character, which is a double quote ("), select another common quotation character, or specify that you want to use some other character. Stylus Studio automatically displays the hexadecimal value for the character you specify. If you prefer, you can enter the hexadecimal value for the character you want. Stylus Studio automatically displays the correct character in the character field.
12. To specify that you want the current settings to be the default settings, click Make Default so that it is selected. Stylus Studio copies the current settings to the registry.
13. To specify that you want the default settings to be the values that were in place when you installed Stylus Studio, click Reset Default so that it is selected. Stylus Studio changes the default values to the values specified in About the Default Values.
14. Click OK. Stylus Studio converts the source document to XML and displays the resulting XML document in the XML editor.
15. In the Stylus Studio tool bar, click Save , to give the new XML document a name.

Specifying User-Defined Columns

The procedure for specifying user defined columns varies slightly based on whether you are converting a CSV or a fixed-width file to XML.

Column Names for CSV Files

When you specify a user defined column for a CSV file, you need to supply a name for each column, as shown here.

Figure 119. Specifying Column Names in CSV Files

To specify a column name for a CSV file:
1. Click the entry field next to User defined.
2. Type the name for the first column.
3. Press Enter.
4. Repeat step 2 and step 3 for each additional column.
Tip

 

You can change column order using the Up and Down buttons.

Column Names for Fixed-Width Files

When you specify a user defined column for a fixed-width file, you need to specify both the name and the width of the column, as shown here:

Figure 120. Specifying Column Names in Fixed-Width Files

To specify a column name for a fixed-width file:
1. Click the Specified here button.
2. Click the Name field in the Column Definitions group box.
3. Type a name in the field.
4. Press Tab.

The name value is entered, and a new row for the next column is added to the Column Definitions group box. The cursor appears in the Width field.

5. Enter a value for the column width and press Tab or Enter.

The column definition for the first column is specified in the wizard.

6. Repeat step 2 through step 5 for any additional columns you need to define.
< Previous | Next >
 
Free Stylus Studio XML Training:

RSS Blogs Newsletter

Site Map | XML Converters | XQuery | XML Editor | XML Pipeline Server

Privacy Policy | Terms of Use | Data Privacy Provisions | GDPR Compliance Statement

Copyright © 2005-2026 IVI Technologies Corporation. All Rights Reserved.