You could probably use the 

<xsl:for-each select="your-condition">
<xsl:sort select="substring(@sTime,7,4)" data-type="number"/>
</xsl:for-each>

where @sTime would be the date-time variable

Remember: <xsl:sort/> must be always the first line within the <xsl:for-each/> if used.

Cool... Any idea how to merge 2 or more sources, like 3 facebook status feeds and 2 youtube channels?

Hi Claus (+ Tom),

Actually, you can join all the nodes from various variables using a pipe character in a select, e.g.:

<xsl:for-each select="$youTubeFeed | $facebookFeed | $currentPage/NewsItem">
    <xsl:sort ... />
    <!-- do stuff -->
</xsl:for-each>

But, you might need to get a little creative with the sort select, unless all sources have identical "datetime" data... 

How do they look? 

/Chriztian 

Alright, so i kinda saw the light from your post there Chriztian, it helped a lot. But guess what, im stuck again :)

I got it working by manually inputting the feed urls, but i would like to have the site editor be able to add feeds from the ui.

I have a folder in the content node tree where the editor can create new "Feed" nodes with a text parameter "feedUrl" on the document type for inputting the url.

As i see it, i need to:

1. iterate through these nodes, and create variables from the "feedUrl" field.

2. pass these variables to the <xsl:with-param

But how do i go about these two steps?

My current working code is below: 

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE xsl:stylesheet [ <!ENTITY nbsp "&#x00A0;"> ]>
<xsl:stylesheet 
  version="1.0" 
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
  xmlns:msxml="urn:schemas-microsoft-com:xslt"
  xmlns:umbraco.library="urn:umbraco.library"
  xmlns:Exslt.ExsltDatesAndTimes="urn:Exslt.ExsltDatesAndTimes"
  exclude-result-prefixes="msxml umbraco.library Exslt.ExsltDatesAndTimes">

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

<xsl:param name="currentPage"/>

<xsl:template match="/">

  <xsl:variable name="feedContent"  select="umbraco.library:GetXmlDocumentByUrl('http://feeds.feedburner.com/ClausHingebjergsFacebookStatusUpdates')"/>
  <xsl:variable name="feedContent2" select="umbraco.library:GetXmlDocumentByUrl('http://feeds.feedburner.com/UploadsByProffartholstebro')"/>
  <xsl:variable name="feedContent3" select="umbraco.library:GetXmlDocumentByUrl('http://feeds.feedburner.com/borsen/wqUp')"/>
  <xsl:variable name="feedContent4" select="umbraco.library:GetXmlDocumentByUrl('http://feeds.feedburner.com/CeramicspeedsFacebookWall')"/>
  <xsl:variable name="feedContent5" select="umbraco.library:GetXmlDocumentByUrl('http://jp.dk/jptv/?service=rssfeed')"/>

  <xsl:call-template name="renderFeed">
    <xsl:with-param name="feedContent" select="$feedContent | $feedContent2 | $feedContent3 | $feedContent4 | $feedContent5"/>
  </xsl:call-template>
</xsl:template>
    
<xsl:template name="renderFeed">
  <xsl:param name="feedContent"/>
    <xsl:for-each select="$feedContent//item">
      <xsl:sort select="Exslt.ExsltDatesAndTimes:formatdate(substring (pubDate, 0, 26), 'yyyy-MM-ddTHH:mm:ss')" order="descending" />
         <xsl:if test="position() &lt; 30">
            <div>
              <p style="margin:0px;"><xsl:value-of select="umbraco.library:LongDate(substring (pubDate, 0, 26))"/><br/>
              <a href="{link}">
                <xsl:if test="author !=''"><xsl:value-of select="author"/><br/>
                </xsl:if>
                <xsl:value-of select="title"/>
              </a>
              <xsl:if test="contains(link, 'youtube')">
                <xsl:variable name="myyoutube" select="substring (link, 32, 11)"/>  
                <iframe width="250" height="150" src="http://www.youtube.com/embed/{$myyoutube}" frameborder="0" allowfullscreen="true">.</iframe>
              </xsl:if>
              </p>
              <xsl:if test="not(contains(link, 'facebook'))">
                <xsl:choose>
                  <xsl:when test="string(100) != '0'">
                    <p style="margin:0px;">
                    <xsl:value-of select="umbraco.library:TruncateString(umbraco.library:StripHtml(description), number(100), '...')" disable-output-escaping="yes"/>
                    </p>
                  </xsl:when>
                  <xsl:otherwise>
                    <xsl:value-of select="description" disable-output-escaping="yes"/>
                  </xsl:otherwise>
                </xsl:choose>
              </xsl:if>
            </div>
         </xsl:if>
    </xsl:for-each>
</xsl:template>

</xsl:stylesheet>

Wow, very awesome info Chriztian (as always) - thanks!

This is so insanely cool. Thanks a bunch. Im 99% there. 1 last thing though (I hope ;) )

As you can see, i have a <div> around every post. I would like to define eg. a background color on the different feeds. On a feed level... not on a post level.

Being naive i thought i could just do something like:

<div>
 <xsl:attribute name="style">
background-color:#<xsl:value-of select="$siteRoot/Feeds/Feed/bgcolor"/>;
 </xsl:attribute>

But that colors all feeds the same color... I guess im scoping something wrong... But whaaaaat :)

Ahh another thing ;). How do i limit the number of posts from each feed, say i only want the 5 newest from each?

Hi Claus,

It's not *that* naïve to think you can do that - but you as I always say: "Remember that you get a *set* back from a select." - so when you say $siteRoot/Feeds/Feed/bgcolor - you're actually getting all the bgcolor elements back, but when you ask for the value-of a set, the processor returns the value from the first in the set.

So you need to get the bgcolor that sits on the Feed node that has the same feedUrl as the item you're rendering... so how to get that?  If you're lucky, the feeds you're fetching will have an atom:link with a rel="self" attribute - the href atribute on that element should have the URL of the feed, so something like this (remember to add the namespace for the atom prefix):

<xsl:stylesheet ... xmlns:atom="http://www.w3.org/2005/Atom">
<xsl:template match="item">
    <xsl:variable name="myURL" select="../atom:link[@rel = 'self']/@href" />
    <xsl:if test="position() &lt; 30">
        <div style="background: #{$siteRoot/Feeds/Feed[feedUrl = $myURL]/bgcolor}">
...
</div>
</xsl:if>
</xsl:template>

/Chriztian

Regarding the 5 newest - doesn't that conflict a little with your previous top 30 clause? Or did the specs change? :-)

As you can't sort inside a select, you'll probably have to do some grouping on the feedUrl, and then sort and pick by position... hmmm...

/Chriztian 

Well not really... 30 is the numer of items i wnat to show in total.

What im looking to do is to limit each feed to e.g. 5.

The reason is, if i have, lets say 6 feeds. Taking the 5 newes from each will guarentee something from all of them gets shown. Otherwise some eager poster can swamp the list with his 30 daily facebook updates :). 

Hope this makes sense

Ok, im soooo close now :) im starting to mix the feeds with umbraco nodes and it works, sorta...

<xsl:template match="/">
    <xsl:variable name="feeds" select="document($siteRoot/Feeds/Feed/feedUrl)" />
         <xsl:apply-templates select="$feeds//item | umbraco.library:GetXmlNodeById(1090)/*">
                 <xsl:sort select="Exslt.ExsltDatesAndTimes:formatdate(substring(pubDate, 0, 26), 'yyyy-MM-ddTHH:mm:ss')" order="descending" />
          </xsl:apply-templates>
 </xsl:template>

The problem is the sorting. Ive overcome this by making a "pubDate" field on the umbraco nodes...

What i really would like to do is set the "pubDate" for the umbraco node to "currentdate" at all times, and then stream the time of day from @createDate.

This would keep the umbraco node at the top of the list, but let feed item mingle in between them during the day...

So the optimal solution would be to be able to sort on 2 parameters... E.g "pubDate" and "$myDate"

Any ides how to go about this.?

Hi Claus,

Not entirely sure how you want it sorted (all Umbraco nodes first?) - but you can do something like this, where multiple sort statements are used, but their select attributes are constructed in a way that they're "mutually exclusive":

<xsl:template match="/">
    <xsl:variable name="today" select="umbraco.library:CurrentDate()" />
    <xsl:variable name="feeds" select="document($siteRoot/Feeds/Feed/feedUrl)" />
    <xsl:apply-templates select="$feeds//item | umbraco.library:GetXmlNodeById(1090)/*">
        <xsl:sort select="concat(self::Feed/feedUrl, ':', $today)" order="descending" />
        <xsl:sort select="concat(self::item/../atom:link[@rel = 'self']/@href, ':', Exslt.ExsltDatesAndTimes:formatdate(substring(pubDate, 0, 26), 'yyyy-MM-ddTHH:mm:ss')" order="descending" />
    </xsl:apply-templates>
</xsl:template>

/Chriztian

(Man this logout thing on Our is getting tedious...)

I wnat to do a complete mashup, everything sorted in one big list, rss items and umbraco nodes in one big list. I need it mixed :)

is working on a reply...