How to clean up HTML in a feed - XML Module [Lead: Stefan Cullmann]

Forum DotNetNuke® Pro... XML Module [Lea... How to clean up HTML in a feed

6/12/2006 4:03 AM

	Keith Tuomi
73 posts
www.flyerstarter.com

How to clean up HTML in a feed

I tried using the News Feeds module to display a feed from a remote site, the problem is that the feed is not 'clean' and in it's 'Description' tag consists of raw HTML, which sometimes has unclosed tags: a real mess.

So I googled up on XSL to try and transform the feed so the DNN News Feed would not choke on it, but with no luck. I would like to keep the HTML tags and not strip them out, if possible (realizing that there will be some issues when the HTML tags are unclosed).

Here is a sample of the feed:

<rss version="2.0">
−
    <channel>
<title>News Feed</title>
<description/>
<link>http://www.website.com/forum/index.php</link>
<pubDate>Mon, 12 Jun 2006 06:59:54 -0400</pubDate>
<ttl>5</ttl>
−
    <item>
<title>Psp Tv Receiver</title>
−
    <link>
http://www.website.com/forum/index.php?showtopic=69137
</link>
−
    <description>
need info. can you get a bolt on TV receiver for a PSP in the UK?
</description>
<pubDate>Mon, 12 Jun 2006 05:54:02 -0400</pubDate>
<guid isPermaLink="false">69137</guid>
</item>

6/12/2006 4:41 AM

	Stefan Cullmann
1452 posts

Re: How to clean up HTML in a feed

Hi flyerstarter,

the DNN news feeds are alright, please give me the URL if it is not. Did you disable the output escaping?

Stefan Cullmann - stefan.cullmann [at] dotnetnuke.com

forms & Lists (UDT5.0) will be the next major release of the User Defined Table project.
A first Preview is available, though it requires DotnetNuke 5 (Beta 5).

Need to import external data to a UDT? Try http://www.codeplex.com/Csv2UDTImport

6/12/2006 9:39 AM

	Keith Tuomi
73 posts
www.flyerstarter.com

Re: How to clean up HTML in a feed

Modified By Keith Tuomi on 6/13/2006 2:50:57 AM)

Hi,

Sorry, I didn't even notice that the example I posted has no HTML in it. :)

Here is a more problematic example:

<item>
<title>Bacardi B-live Party With Quentin Harris</title>
−
    <link>
http://www.undergroundhouse.net/forum/index.php?showtopic=69163
</link>
−
    <description>
<img src="http://www.ultragroove.co.uk/uploads/images/imagesHome/blive-1.jpg" border="0" alt="IPB Image" /><img src="http://www.ultragroove.co.uk/uploads/images/imagesHome/blive.jpg" border="0" alt="IPB Image" />
</description>
<pubDate>Mon, 12 Jun 2006 12:13:37 -0400</pubDate>
<guid isPermaLink="false">69163</guid>
</item>

The XSL sheet I created to deal with this is as follows (im not sure where to place the output escaping line you suggested?):

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
        <xsl:for-each select="root/pageinfo/description">
            <xsl:copy-of select="p" />
        </xsl:for-each>
</xsl:template>
<xsl:template match="p">
    <xsl:copy-of select="." />
</xsl:template>
</xsl:stylesheet>

6/13/2006 4:14 AM

	Stefan Cullmann
1452 posts

Re: How to clean up HTML in a feed

Flyerstarte, I don't get this:

Xpath root/pageinfo/description does not match to your example
Why do you want to copy xml nodes?
There are no p tags inside your example.

In standard rss feeds the content of the description is html escaped, so there are no tags inside. It is neither Xml or Html. For example there is < instead of <p>.

Reading your example i assume that it contains the following XML as text:

IE will shows it like this, please not the black font color inside description.

You would normally access the node like <xsl:value-of select="description" disable-output-escaping="yes"/> .

Need to import external data to a UDT? Try http://www.codeplex.com/Csv2UDTImport

7/22/2006 3:07 PM

	Keith Tuomi
73 posts
www.flyerstarter.com

Re: How to clean up HTML in a feed

Hi Stefan,

Sorry for the delay in response.

I am quite confused already. :)

Basically what I would like to to do is take a feed such as:

http://www.lounge72.com/root/xml.php

and present it in the XML/XSL module in a human-readable form (aka, no tags). I need to know the XSL file required for this ..

Thanks

Page 1 of 2

Forum

DotNetNuke® Pro...

XML Module [Lea...

How to clean up HTML in a feed