Home > Online Product Documentation > Table of Contents > Convert Fixed Width to XML

< Previous | Next >

Convert Fixed Width to XML

Use the Convert Fixed Width to XML document wizard to convert a fixed-width text file to an XML document. To display the Convert Fixed Width to XML dialog box, select File > Document Wizards in the Stylus Studio menu bar, and double-click Fixed Width to XML.

Fields

Input URL

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

Input Encoding

Specifies 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.

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 fixed width file contains the values for the column names.
    • Specified here indicates that you are typing the names of the columns in the Column Definitions group box.

Column Definitions

Double-click the appropriate field to enter the names and widths of the columns.

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.

Make Default

Stores the current settings in the Windows registry. Stylus Studio uses these default values as the initial settings the next time the dialog box is opened.

Reset Default

Resets the default values of the settings to the values they had when Stylus Studio was installed:

    • document is the root element node
    • row is the row element name
    • Column names are generated as value1, value2, value3, and so on
    • Column values are mapped to children of row elements
    • Comma ( ,) is the delimiter character
    • Double quote ( ") is the quote character
    • UTF-8 is the default encoding of the file being imported

Buttons

Up moves the selected column to be before its preceding sibling.

Down moves the selected column to be after its following sibling.

Delete deletes the selected column.

For More Information

Converting Text Files to XML Documents

Chapter 3Converting Non-XML Files to XML

< Previous | Next >

XML Project

Stylus Studio's Project Window is an intuitive, visual feature for organizing files belonging to a project. It supports different file-type icons and nested folders; many helpful options are available from the context menu.

Web Service Data Mapping

Stylus Studio makes it possible for you to use Web services as live XML data sources for XML mapping projects.

Using DTD in Microsoft Applications

Learn how to integrate DTD's into your Microsoft applications using MSXML or System.XML DTD processing components.

DTD vs. Schema

Stylus Studio provides tools for working with both W3C XML Schema and DTD's - this tutorial explains what the differences are between the two, providing a technical comparison of DTD vs Schema.

Stylus Most Wanted

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2007 All Rights Reserved.