Skip to Content
0
Former Member
Oct 18, 2006 at 07:42 AM

Mail Adapter :: eMail Reporting

60 Views

Hi

I am creating one scenario using following weblog :

/people/community.user/blog/2006/09/08/email-report-as-attachment-excelword

But in my mail I am getting the Headings but not the values which I am providing through my XML file.

I even deleted all the fomatting elements but still the same thing.

My XSLT file is like this now ...

***********************************************

?xml version='1.0'?>

http://www.w3.org/1999/XSL/Transform">

<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

<xsl:template match="/">

http://sap.com/xi/XI/Mail/30">

<Subject>Deliveries from XI</Subject>

<From><i>MY EMAIL ID</i></From>

<To><i>My EMAIL ID</i></To>

<Content_Type>text/html</Content_Type>

<Content>

<xsl:text xsl:space="preserve">Catalog of CDs available:</xsl:text>

<xsl:text xsl:space="preserve">Title</xsl:text>

<xsl:text xsl:space="preserve">Artist</xsl:text>

<xsl:text xsl:space="preserve">Country</xsl:text>

<xsl:text xsl:space="preserve">Company</xsl:text>

<xsl:text xsl:space="preserve">Price</xsl:text>

<xsl:text xsl:space="preserve">Year</xsl:text>

<xsl:for-each select="Catalog_MT/cd">

<xsl:value-of select="title"/>

<xsl:value-of select="artist"/>

<xsl:value-of select="country"/>

<xsl:value-of select="company"/>

<xsl:value-of select="price"/>

<xsl:value-of select="year"/>

</xsl:for-each>

</Content>

</ns1:Mail>

</xsl:template>

</xsl:stylesheet>

*************************************************

My XML file is this

<?xml version="1.0" encoding="ISO-8859-1" ?>

- <ns0:Catalog_MT xmlns:ns0="urn:Reporting">

- <cd>

<title>Empire Burlesque</title>

<artist>Bob Dylan</artist>

<country>USA</country>

<company>Columbia</company>

<price>10.90</price>

<year>1985</year>

</cd>

- <cd>

<title>Hide your heart</title>

<artist>Bonnie Tyler</artist>

<country>UK</country>

<company>CBS Records</company>

<price>9.90</price>

<year>1988</year>

</cd>

</ns0:Catalog_MT>

***************************************

I am getting the output like this in my Mail Body -->

<i><b>Catalog of CDs available:TitleArtistCountryCompanyPriceYear</b></i>

I am not so good in XSLT. Can you pls. suggest what am I missing.

Regards

- Lalit -