Topic How to create a schema for an XMl file

, , , , ,
1 
Hi,

How do we create a flat file dictionary and flat file schema for an XML file.?
Can anyone help me on this.

Regards,
Srikanth
2

Hi Srikanth,

You can create a flat-file dictionary and schema for a flat-file type that contains records which has fields delimited or fixed length etc.
Please refer to webMethods Flat File Guide for more info on the same.

If you are talking about the XMI document then the structure of the same resembles like XML only I guess, so I don’t think so you can parse it using flat-file schema and dictionary.

Share the file format with dummy data to understand more about this requirement.

Regards,
Firoz N

1 Like
3 
Yes @Firoz.
I'm referring to XML document like how to create canonical document structure for an XML file.
I'm sharing some dummy data below

<?xml version="1.0"?>
<catalog>
   <item id="bk101">
      <author>Gambardella, Matthew</author>
      <title>XML Developer's Guide</title>
      <genre>Computer</genre>
      <price>44.95</price>
      <publish_date>2000-10-01</publish_date>
      <description>An in-depth look at creating applications 
      with XML.</description>
   </item>
   <item id="bk102">
      <author>Ralls, Kim</author>
      <title>Midnight Rain</title>
      <genre>Fantasy</genre>
      <price>5.95</price>
      <publish_date>2000-12-16</publish_date>
      <description>A former architect battles corporate zombies, 
      an evil sorceress, and her own childhood to become queen 
      of the world.</description>
   </item>
   <PO id="bk103">
      <author>Corets, Eva</author>
      <title>Maeve Ascendant</title>
      <genre>Fantasy</genre>
      <price>5.95</price>
      <publish_date>2000-11-17</publish_date>
      <description>After the collapse of a nanotechnology 
      society in England, the young survivors lay the 
      foundation for a new society.</description>
   </PO>

   <DO id="bk105">
      <author>Corets, Eva</author>
      <title>The Sundered Grail</title>
      <genre>Fantasy</genre>
      <price>5.95</price>
      <publish_date>2001-09-10</publish_date>
      <description>The two daughters of Maeve, half-sisters, 
      battle one another for control of England. Sequel to 
      Oberon's Legacy.</description>
   </DO>
   <DO>
		<name>windows</name>
		<price>100</price>
	</DO>
	 <PO id="bk104">
      <author>Corets, Eva</author>
      <title>Oberon's Legacy</title>
      <genre>Fantasy</genre>
      <price>5.95</price>
      <publish_date>2001-03-10</publish_date>
      <description>In post-apocalypse England, the mysterious 
      agent known only as Oberon helps to create a new life 
      for the inhabitants of London. Sequel to Maeve 
      Ascendant.</description>
   </PO>
   <item id="bk102">
      <author>Ralls, Kim</author>
      <title>Midnight Rain</title>
      <genre>Fantasy</genre>
      <price>5.95</price>
      <publish_date>2000-12-16</publish_date>
      <description>A former architect battles corporate zombies, 
      an evil sorceress, and her own childhood to become queen 
      of the world.</description>
   </item>
</catalog>

So for the above file format how do I create a Canonical document?```
4

@Srikanth,

You can directly create the documentType in the designer by selecting source type as XML, and upload the sample XML file. Assuming you have all possible elements like PO, DO and item in the XML you are using to create the document type.

Regards,
Firoz N

5

Thanks @Firoz

Regards,
Srikanth