Using the Text Schema Edit View in the Text Transformation GUI tool

The following procedures are related to creating and modifying an XML schema file for transforming data between a character-delimited variable format and an XML format.

Creating a schema file

To create a new schema file:

  1. Launch the Text Transformation tool.
  2. Select File > New, or click the New icon on the toolbar.
  3. Select a path, and type the name of the XML schema file to create.

    Note: The default file name is "Default.xml."

  4. Select CSV Format.
  5. Note: Do not select WebSphere Commerce Suite Format. This option is only used with earlier versions of WebSphere Commerce.

  6. Click OK when you are finished.

Now you can create new elements and attributes by following the steps indicated below.

Opening a schema file

To open a schema file:

  1. Launch the Text Transformation tool.
  2. Select File > Open, or click the Open icon on the toolbar.
  3. Select a schema file to be opened.
  4. Click OK when you are finished.

Now you can modify the elements and attributes by following the steps described below.

Saving a schema file

To save a schema file:

  1. Launch the Text Transformation tool.
  2. To save any changes that you make to the schema, select File > Save or click the Save icon on the toolbar.
  3. To save a copy of the schema with a new name:
    1. Select File > Save As.
    2. Select a path and type the name of the XML file to create.
    3. Click OK when you are finished.

Editing a schema file

To edit a schema file, open the schema file as described above and follow these procedures.

Adding an element

To add an element:

  1. Type a new element name in the Element List field.
  2. Click the Add row icon.

Removing an element

To remove an element:

  1. Select an element name.
  2. Click the Remove row icon.

Replacing an element

To replace an element:

  1. Type a new element name in the Element List field.
  2. Select the name of the element to be replaced.
  3. Click the Replace row icon.

Moving an element one row up

To move an element one row up:

  1. Select the name of the element to be moved up.
  2. Click the Move row up icon.

Moving an element one row down

To move an element one row down:

  1. Select the name of the element to be moved down.
  2. Click the Move row down icon.

Adding an attribute

To add an attribute:

  1. Type a new attribute name in the Attribute List field.
  2. Click the Add row icon.

Removing an attribute

To remove an attribute:

  1. Select an attribute name.
  2. Click the Remove row icon.

Replacing an attribute

To replace an attribute:

  1. Type a new attribute name in the Attribute List field.
  2. Select the name of the attribute to be replaced.
  3. Click the Replace row icon.

Moving an attribute one row up

To move an attribute one row up:

  1. Select the name of the attribute to be moved up.
  2. Click the Move row up icon.

Moving an attribute one row down

To move an attribute one row down:

  1. Select the name of the attribute to be moved down.
  2. Click the Move row down icon.

Changing a schema file structure

The File Structure view in the lower pane of the Text Schema Edit View describes the layout of a character-delimited variable file. The following fields are required in the expected file structure:

Editing a schema file for transforming data from an XML to a character-delimited variable format

If you are using an XML schema file that was created using the Text Schema Edit View to transform data from an XML format to a character-delimited variable format, you must use a text editor to change the datatype specification in the schema file from "CSV Format" to "XML Format" before processing the transformation.

Feedback