XSLT replace tags

larkojr · December 6th, 2016, 04:56 AM

Hi, sorry to bother you with this.
I'm passing here just a section of my code, since it's like 300 lines in total and that is why some of tags don't match up.
I've give you as much as i have. I've check my whole website folder if there are any more xml generated there, but i can't find it.

When i was googling this, most answer were to add this code:

Code:

<xsl:template match="node()|@*">
    <xsl:copy>
      <xsl:apply-templates select="node()|@*"/>
    </xsl:copy>
  </xsl:template>

to mine

HTML Code:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" exclude-result-prefixes="php">
<xsl:output method="xml" indent="yes" encoding="UTF-8" omit-xml-declaration="yes"/>

<xsl:template match="/">


<products>
<xsl:for-each select="objects/object">
<xsl:element name="product"><xsl:attribute name="st"><xsl:value-of select="position()"/></xsl:attribute>
<xsl:element name="productID"><xsl:value-of select="sku"/></xsl:element>
<xsl:element name="productName"><xsl:value-of select="name"/></xsl:element>
<xsl:element name="url"><xsl:value-of select="product_url"/></xsl:element>
<xsl:element name="description"><xsl:value-of select="description"/></xsl:element>
</products>
</template>

but i doesn't work for me or i don't know how to implement it.

Thank you.

larkojr · December 6th, 2016, 05:05 AM

Hi, sorry to bother you with this.
I'm passing here just a section of my code, since it's like 300 lines in total and that is why some of tags don't match up.
I've give you as much as i have. I've check my whole website folder if there are any more xml generated there, but i can't find it.

When i was googling this, most answer were to add this code:

Code:

<xsl:template match="node()|@*">
    <xsl:copy>
      <xsl:apply-templates select="node()|@*"/>
    </xsl:copy>
  </xsl:template>

to mine

HTML Code:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" exclude-result-prefixes="php">
<xsl:output method="xml" indent="yes" encoding="UTF-8" omit-xml-declaration="yes"/>

<xsl:template match="/">


<products>
<xsl:for-each select="objects/object">
<xsl:element name="product"><xsl:attribute name="st"><xsl:value-of select="position()"/></xsl:attribute>
<xsl:element name="productID"><xsl:value-of select="sku"/></xsl:element>
<xsl:element name="productName"><xsl:value-of select="name"/></xsl:element>
<xsl:element name="url"><xsl:value-of select="product_url"/></xsl:element>
<xsl:element name="description"><xsl:value-of select="description"/></xsl:element>
</products>
</template>

but i doesn't work for me or i don't know how to implement it.

Thank you.

mhkay · December 6th, 2016, 05:26 AM

Sorry I don't think I can help you. Read some books.

larkojr · December 9th, 2016, 05:02 AM

hi,
thank you for your help. I've called my friend, who had the same problem to understand me as you did, until i give him access to our Magento administration.
Here is the solution:
first part

Code:

<description>
<xsl:variable name="s_in" select="php:functionString('html_entity_decode',description)" />
    <xsl:variable name="s_temp">
        <xsl:call-template name="replace-substring">
            <xsl:with-param name="value" select="$s_in" />
            <xsl:with-param name="from" select="'&lt;/p&gt;'" />
            <xsl:with-param name="to" select="''" />
        </xsl:call-template>
    </xsl:variable>
    <xsl:variable name="s_out">
        <xsl:call-template name="replace-substring">
            <xsl:with-param name="value" select="$s_temp" />
            <xsl:with-param name="from" select="'&lt;p&gt;'" />
            <xsl:with-param name="to" select="''" />
        </xsl:call-template>
    </xsl:variable>
    <xsl:value-of select="normalize-space($s_out)" />
</description>

Second part

Code:

<xsl:template name="replace-substring">
    <xsl:param name="value" />
    <xsl:param name="from" />
    <xsl:param name="to" />
    <xsl:choose>
        <xsl:when test="contains($value,$from)">
            <xsl:value-of select="substring-before($value,$from)" />
            <xsl:value-of select="$to" />
            <xsl:call-template name="replace-substring">
                <xsl:with-param name="value" select="substring-after($value,$from)" />
                <xsl:with-param name="from" select="$from" />
                <xsl:with-param name="to" select="$to" />
            </xsl:call-template>
        </xsl:when>
        <xsl:otherwise>
            <xsl:value-of select="$value" />
        </xsl:otherwise>
    </xsl:choose>
</xsl:template>

Thank you again for all of your help and best regards.