RSS feed

[randhir]

Dear All,

I stuck on a very logical problem here. Please let me know that how can I get XSLT file of any website. So that by using this one I can extract the RSS feeds of that site. I want to store the RSS feeds in FileMaker database. I need it in hurry.

Thanks in advance....

[beverly]

1. study up on RSS. http://www.mnot.net/rss/tutorial/

2. verify that the site(s) you want to "harvest" match the standard RSS format.

3. write an XSLT to read the RSS for import into FileMaker.

You might find some websites that will read the RSS and convert to CSV (comma-separated-values) or somthing you can import more easily.

Beverly

[Agnes Riley]

I've written a blog post on this a long time ago with a demo file. Unfortunately, my website is down at the moment but maybe by the time you read thus it'll be up. Check out blog.zerobluetech.com and search for RSS.

[randhir]

Is Atom format is suppoerted,in FileMaker if so can you give the format of atom's xsl.

thanks in advanced

[randhir]

the code of xsl is given below is for rss feed:

<?xml version="1.0" encoding="utf-8" ?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" >

<xsl:output method="xml" encoding="utf-8" indent="yes" />

<!--

Author: Ryo Sode

Last Modified: 06/09/02

Description: RSS to FMPXMLRESULT transformer for getting RSS Headline. This will enable FileMaker Pro database to be used as temp storage for storing headline information from the top headline on the website.

Technical Background:

This transformation is created based on Rich Site Summary (RSS) 0.91 DTD. We extract the information contained in <item> elements where all the good stuff reside.

A lot of RSS 0.91 compliant XML live-feeds are fed through websites such as moreover.com. figby.com has a number of links to various RSS as well.

Quote:

"RSS is an XML vocabulary for describing metadata abut websites, and enabling the display of "channels" on the "My Netscape" website." (From 0.91 RSS DTD)

-->

<xsl:template match="/rss/channel">

<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">

<ERRORCODE>0</ERRORCODE>

<PRODUCT BUILD="" NAME="FileMaker Pro XML Import" VERSION="6.0v1" />

<DATABASE DATEFORMAT="yyyy.MM.dd" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT="k:mm:ss" />

<METADATA>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Title" TYPE="TEXT" />

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="URL" TYPE="TEXT" />

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="pubDate" TYPE="TEXT" />

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Description" TYPE="TEXT" />

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Content" TYPE="TEXT" />

</METADATA>

<RESULTSET FOUND="15">

<xsl:for-each select="item" >

<xsl:variable name="c">

<xsl:value-of select="position()" />

</xsl:variable>

<ROW MODID="$c" RECORDID="$c" >

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

<COL><DATA><xsl:value-of select="link" /></DATA></COL>

<COL><DATA><xsl:value-of select="pubDate" /></DATA></COL>

<COL><DATA><xsl:value-of select="description" /></D>ATA<C/LO>

<COL><DATA><xsl:value-of select="div" /></DATA></COL>

</ROW>

</xsl:for-each>

</RESULTSET>

</FMPXMLRESULT>

</xsl:template>

</xsl:stylesheet>

... save this as xsl It will work put it in webserver and database file in filemaker server...then make a script to import..

[beverly]

I'd change this bit

===

<RESULTSET FOUND="15">

<xsl:for-each select="item" >

<xsl:variable name="c">

<xsl:value-of select="position()" />

</xsl:variable>

<ROW MODID="$c" RECORDID="$c" >

===

as:

<RESULTSET FOUND="">

<ROW MODID="" RECORDID="">

FileMaker doesn't need these values for import.

Beverly

[randhir]

by using this xsl i am geeting only the title,not the description,url etc how i get all these things?