Getting a XML file as output

Sne · Post by **Sne** » Wed Apr 25, 2007 12:59 am

I am getting data from a SP and then converting it to XML. what all setting should be done to get the output as XML instead of text file

janhess · Post by **janhess** » Wed Apr 25, 2007 3:25 am

XML is text. What exactly do you want?

Sne · Post by **Sne** » Wed Apr 25, 2007 5:37 am

I want in the format of XML tags
EG:

<header>
<body>
</body>
</header>

Sne · Post by **Sne** » Wed Apr 25, 2007 5:40 am

Sorry For the previous reply!!

I want the file along with the XML tags. For Ex.

<header>
<body>
<tag1>data</tag1>
<tag2>data</tag2>
</body>
</header>

janhess · Post by **janhess** » Wed Apr 25, 2007 5:55 am

If you have an xsd or dtd for the xml, import it into type designer.
If it;s as simple as your example then use the start and end tags as initiators and terminators.
You could generate xsd from something like XMLSpy.

Sne · Post by **Sne** » Wed Apr 25, 2007 6:37 am

Hi,

The solution that you have suggested can be used if the type tree imported is used at input side.

My problem is, I am having a normal type tree which is used at the output side in the map, and I need to set some properties so that I will get the output as XML file. (that is data along with
XML tags).

The other problem is that my ex is much more complex than one that is given in Post. So I am afraid I wont be able to use the tags as initiators and terminators!!!

Thanks in Advance

janhess · Post by **janhess** » Wed Apr 25, 2007 6:42 am

There is no setting to generate xml. You need a type tree which has the tags set as initiators/terminators. As I said before it's best to import an xml schema (xsd) or xml DTD into your Type Designer to generate the type tree for the XML.
Look in Examples folder of software and look for example under xml folder.

jgibby · Post by **jgibby** » Wed Apr 25, 2007 3:19 pm

Sne wrote:Hi,

The solution that you have suggested can be used if the type tree imported is used at input side.

Importing a DTD/XSD into the Type Tree Designer does not force that type tree to be an *Input* type tree only. A Type Tree is capable of being used both as input and as output. Jan is correct. Import the DTD or XSD of your xml (create one if you have to with XMLSpy or other tool) and then create your output card, specifying your new XML Type Tree. You will then only need to specify the values and when the Output Card puts the data on the adapter to write it out, it will format it as XML.

John