Replacing values in different elements in target xml file

kushanxp · May 16th, 2012, 10:10 AM

Hi,

I have source XML file, from that I need to put the same values in those elements in different elements in the targed XML file. Need to do this using XSL.

Source XML

Code:

<SearchRequest xmlns = "http://www.nyl_ltc.com/ltc_common">
    <UserLoginName>SHANE</UserLoginName>
    <TransactionGUID>Test ID</TransactionGUID>
    <MaxRecords>20</MaxRecords>
    <CriteriaExpression xmlns = "http://www.ttc.com/shared_transaction">
        <Criteria>
            <PropertyName>LastName</PropertyName>
            <PropertyValue>SCOTT</PropertyValue>
            <Operation>EQUALS</Operation>
        </Criteria>
    </CriteriaExpression>
</SearchRequest>

Target XML

Code:

<TTC xmlns="http://ttc/2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Version="2.18.02">
    <UserAuthRequest>
        <UserLoginName>SHANE</UserLoginName>
    </UserAuthRequest>
    <TTCRequest>
        <TransRefGUID>Test ID</TransRefGUID>
        <TransType tc="301"/>
        <TransExeDate>2012-04-26</TransExeDate>
        <TransExeTime>10:28:15</TransExeTime>
        <InquiryLevel tc="3">3</InquiryLevel>
        <MaxRecords>20</MaxRecords>
        <CriteriaExpression>
            <Criteria>
                <ObjectType tc="252">OLI_OLIFEEXTENSION</ObjectType>
                <PropertyName>ProducerIdentifier</PropertyName>
                <PropertyValue>939168</PropertyValue>
                <Operation tc="1"/>
            </Criteria>
        </CriteriaExpression>
    </TTCRequest>
</TTC>

Above you can see my source and target XML are different, How can transform above source XML file using XSL to required target XML.

mhkay · May 16th, 2012, 10:17 AM

Unfortunately your source XML and target XML are so different from each other that's it's hard to see what the relationship is. You need to explain something about the rules for getting the target from the source.

kushanxp · May 16th, 2012, 10:21 AM

Quote:

Originally Posted by mhkay

Unfortunately your source XML and target XML are so different from each other that's it's hard to see what the relationship is. You need to explain something about the rules for getting the target from the source.

Source and Target XML are in different layers of the program, And those layers accepting that format only. Some third party systems anticipates that target XML in that format. So I cannot change it.

kushanxp · May 16th, 2012, 10:31 AM

I have started like this, Im not sure is this the best approach to do this, having trouble of accessing the value of <UserLoginName> element now.

My XSL

Code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="xml" omit-xml-declaration="yes" indent="yes" />

	<xsl:template match="/">
		<TTC xmlns="http://ttc/2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
			<UserAuthRequest>
			<UserLoginName>
					<xsl:apply-templates select="TTC/UserAuthRequest/UserLoginName" />
				</UserLoginName>
			</UserAuthRequest>
		</TTC>
	</xsl:template>

	<xsl:template match="TTC/UserAuthRequest/UserLoginName">
			 <xsl:copy>
			 	<xsl:apply-templates select="text()" /> 
			 </xsl:copy>
	</xsl:template>
</xsl:stylesheet>