XML to XML Translation

[John Yung]

Hi,

I need to translate an XML document into another XML
document. I would like to avoid using XSL that translates
character by character.

Is there a way to map fields between those 2 documents,
and then translate?

Thanks

John Yung

[Christoph Schittko [MVP]]

I am not exactly sure what you mean when you say that XSL translates
character by character. Maybe that's the case behind the scenes, but it
should not concern you how it's done. XSLT is THE technology to transform
XML documents from one form into another. In the .NET Framework these
transformations leverage the performance optimized implementations.

The XSLTs themselves are not character driven at all, they describe mappings
on a node basis, where nodes are identified through an XPath expression.

Can you give more information, maybe we can give you better answers.

--
HTH
Christoph Schittko [MVP]
Software Architect, .NET Mentor

"John Yung" <jy***@fahnestock.com> wrote in message
news:82****************************@phx.gbl...

Hi,

I need to translate an XML document into another XML
document. I would like to avoid using XSL that translates
character by character.

Is there a way to map fields between those 2 documents,
and then translate?

Thanks

John Yung

[Oleg Tkachenko]

John Yung wrote:

Thanks for your reply, I need to translate a XML file into
another XML file.

Original XML File:
<?xml version="1.0" standalone="yes"?>
<trades>
<trade>
<cusip>123456789</cusip>
<rate>0</rate>
<type>S</type>
<quantity>2</quantity>
</trade>
<trade>
<cusip>987654321</cusip>
<rate>0</rate>
<type>B</type>
<quantity>6</quantity>
</trade>
</trades>

New XML File:
<?xml:stylesheet type ="text/xsl"?>
<orders type="orders" tradedate ="2003-07-24"
brokercode="XX">
<order CUSIP="123456789" holdercode="xx" transtype="S"
shares="2"></order>
<order CUSIP="987654321" holdercode="xx" transtype="B"
shares="6"></order>
</orders>

How should I translate those files? Any sample would be
helpful.

It's not clear where orders attributes and holdercode info come from, but you
can start on this one:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="trades">
<orders type="orders" tradedate="2003-07-24" brokercode="XX">
<xsl:apply-templates select="trade"/>
</orders>
</xsl:template>
<xsl:template match="trade">
<order CUSIP="{cusip}" holdercode="xx" transtype="{type}"
shares="{quantity}"/>
</xsl:template>
</xsl:stylesheet>

--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

[John Yung]

Thanks, that is what I needed

John Yung

-----Original Message-----
John Yung wrote:

Thanks for your reply, I need to translate a XML file into another XML file.

Original XML File:
<?xml version="1.0" standalone="yes"?>
<trades>
<trade>
<cusip>123456789</cusip>
<rate>0</rate>
<type>S</type>
<quantity>2</quantity>
</trade>
<trade>
<cusip>987654321</cusip>
<rate>0</rate>
<type>B</type>
<quantity>6</quantity>
</trade>
</trades>

New XML File:
<?xml:stylesheet type ="text/xsl"?>
<orders type="orders" tradedate ="2003-07-24"
brokercode="XX">
<order CUSIP="123456789" holdercode="xx" transtype="S"
shares="2"></order>
<order CUSIP="987654321" holdercode="xx" transtype="B"
shares="6"></order>
</orders>

How should I translate those files? Any sample would be
helpful.
It's not clear where orders attributes and holdercode

info come from, but youcan start on this one:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="trades">
<orders type="orders" tradedate="2003-07-24" brokercode="XX"> <xsl:apply-templates select="trade"/>
</orders>
</xsl:template>
<xsl:template match="trade">
<order CUSIP="{cusip}" holdercode="xx" transtype="{type}"shares="{quantity}"/>
</xsl:template>
</xsl:stylesheet>

--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

.