IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only

  • 1.  need help to develop type tree for the xml input file

    Posted 09/11/09 04:45 AM

    Originally posted by: SystemAdmin


    Hi!

    My iput file as
    <?xml version="1.0" encoding="ISO-8859-1" ?>
    <!-- Edited by XMLSpy®
    -->
    <note>
    <to>Tove</to>
    <from>Jani</from>
    <heading>Reminder</heading>
    <body>Don't forget me this weekend!</body>
    </note>

    I need to develop the type tree for the input card to read data from this file.

    The following steps I have followed.but its not reading data from xml.it shows the command Server message as "Input valid but unknown data found".

    (1) careted the group as note with Initiator value as <note> and terminator value as </note>
    (2)created 4 items (from,to,body,heading) the Initiator value as(<from>,<to>,<body>,<heading>) and terminator value as (</from>,</to>,</body>,</heading>)
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: need help to develop type tree for the xml input file

    Posted 09/11/09 08:47 AM

    Originally posted by: repanzer


    www.w3schools.com?

    I'm doing their XML/webservices tutorial. Good site.

    anyway, your best bet, is to write the DTD, which should only take a couple mintues. Then import it into the type tree designer using import.

    Every XML file I have used as input or output, has been generated by importing a DTD, or a schema, if I could get the latter to work. When it builds it, you'll see there's a lot to XML type trees that wasn't apparent before.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 3.  Re: need help to develop type tree for the xml input file

    Posted 09/14/09 09:04 AM

    Originally posted by: SystemAdmin


    Your input file came from W3C tutorial here: http://www.w3schools.com/XML/xml_validator.asp

    W3C also provided the following XML Schema that describes this document:
    <xs:element name="note">

    <xs:complexType>
    <xs:sequence>
    <xs:element name="to" type="xs:string"/>
    <xs:element name="from" type="xs:string"/>
    <xs:element name="heading" type="xs:string"/>
    <xs:element name="body" type="xs:string"/>
    </xs:sequence>
    </xs:complexType>

    </xs:element>

    If you are using WTX version 8.2 or later then using this schema instead of a type tree.

    If not then import this schema into a type tree.
    1. Save the schema as an XSD file.
    2. Open the type tree designer.
    3. Select "Import..." under the Tree menu.
    4. Select "XML Schema" and follow the rest of the wizard.

    The reason to use WTX is because it automates the process of describing the data structures. It allows coders to input XML Schemas, COBOL copybooks, XML DTD's and Java Classes among other things and it also generates type trees that describe relational database table, queries and stored procedures.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender