Need Help on Lookup on XSLT

EDN Admin · Jun 20, 2012

Hey,
I am new to XSLT and finding way make look up from external text file. I am using XSLT to transform XML to text file. I have a requirement to map external image name if the SKU, exists in my lookup file.
Example:- I have SKUs 1, 2, 3, 4, 5 in XML, on of the SKU 2 has some problem with image, for those SKUs I want to map corrected image from lookup file by mapping SKU(I already has list of these images based on SKU, need to map images names from lookup file
on finding matching SKUs else populate the image <largeFrontImage> element from XML).
Can some one help me on this.

Following is the XML snippet
--------------------------------------------------------------------------------------------------------

<products> 
<product><sku>4776078</sku> 
<name>Acer - 10.1" Aspire One Netbook - 1GB Memory - 320GB Hard Drive - Espresso Black</name> 
<regularPrice>268.98</regularPrice> 
<largeFrontImage>http://images.bestbuy.com/BestBuy_US/images/products/4776/4776078_sa.jpg</largeFrontImage> 
<image>http://images.bestbuy.com/BestBuy_US/images/products/4776/4776078_sc.jpg</image> 
<product> 
</products>

------------------------------------------------------------------------------------------------------------------

My XSLT
---------------------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-8" ?> 
 
 
 
<xsl:stylesheet version="2.0" 
 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
 
xmlns:xs="http://www.w3.org/2001/XMLSchema" 
xmlns:fn="http://www.w3.org/2005/xpath-functions" 
xmlns:xdt="http://www.w3.org/2005/xpath-datatypes" 
xmlns:err="http://www.w3.org/2005/xqt-errors" 
exclude-result-prefixes="xs xdt err fn 
<xsl

utput method="text" indent="yes"/> 
 
 
<xsl

aram name="separator" select="	"/> 
<xsl

aram name="empty" select=""/> 
<xsl

aram name="line-separator" select="
"/> 
 
 
<xsl:template match="/ 
<xsl:apply-templates select="//products"/> 
 
 
<xsl:apply-templates select="//product 
<xsl:with-param name="adsize" select="300x250"/> 
</xsl:apply-templates> 
 
 
<xsl:apply-templates select="//product 
<xsl:with-param name="adsize" select="728x90"/> 
</xsl:apply-templates> 
 
 
<xsl:apply-templates select="//product 
<xsl:with-param name="adsize" select="160x600"/> 
</xsl:apply-templates> 
 
</xsl:template> 
 
 
 
<xsl:template match="products 
<xsl:text>PRODUCT_SKU	PRODUCT_NAME	PRICE	IMAGE_URL</xsl:text>
 
<xsl:value-of select="$line-separator"/>
 
</xsl:template> 
 
<xsl:template match="product 
<xsl

aram name="adsize"/> 
<xsl:if test="(manufacturer=Acer) or (manufacturer=Asus) or (manufacturer=ASUS) or (manufacturer=Dell) or (manufacturer=HP) or (manufacturer=Lenovo) or (manufacturer=Samsung) or (manufacturer=Sony) or (manufacturer=Toshiba) or (manufacturer=Apple&#xAE

or (manufacturer=Apple) or (manufacturer=Gateway) 
 
 
<xsl:value-of select="sku"/> 
<xsl:value-of select="$separator"/> 
<xsl:value-of select="translate(./name,
, )"/> 
<xsl:value-of select="$separator"/> 
<xsl:value-of select="regularPrice"/> 
<xsl:value-of select="$separator"/> 
 
<xsl:apply-templates select ="largeFrontImage" /> 
<xsl:value-of select="$line-separator"/> 
 
 
</xsl:if> 
 
 
</xsl:template> 
 
 
 
<xsl:template match="includedItem 
<xsl:value-of select=translate(.,"
","")/> 
<xsl:if test="position() < last() 
<xsl:text>**</xsl:text> 
</xsl:if> 
</xsl:template> 
 
 
<xsl:template match="largeFrontImage 
<xsl:choose> 
<xsl:when test =". = $empty 
<xsl:value-of select="../image"/> 
</xsl:when> 
<xsl

therwise> 
<xsl:value-of select="."/> 
</xsl

therwise> 
</xsl:choose> 
 
</xsl:template> 
 
</xsl:stylesheet>
----------------------------------------------------------------------------------------

View the full article

Need Help on Lookup on XSLT

EDN Admin

Well-known member

Similar threads