Jump to content

  •  

Photo

generate an RSS .xml feed from FileMaker ??


  • Please log in to reply
8 replies to this topic

#1 djbeta  master

djbeta
  • Members
  • 403 posts
  • FM Application:11 Advance
  • Platform:Cross Platform
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 6h 9m 48s

Posted 16 July 2007 - 05:54 AM

Hi there,

I'd like to write a script that generates an
RSS .xml file from FileMaker and saves it to a server.

I was thinking that perhaps I would write a script that would generate the XML by looping through the records in question, and would pass the XML to a variable. Then, maybe save the variable to a global field, and then export one record (only exporting the global field), and saving that to a text file titled: filename.xml

I have a feeling there is a much better way to do this..does anyone have any advice for me ?

thanks :
  • 0
Steven Cappiello
Systems Technology Manager
Sloan-Kettering Institute

#2 Fenton  Post Master General

Fenton
  • Moderators
  • 5,046 posts
  • FM Application:11 Advance
  • Platform:Mac OS X Snow Leopard
  • Skill Level:Expert
  • Membership:TechNet, FileMaker Business Alliance
  • Time Online: 17h 12m 20s

Posted 16 July 2007 - 08:14 AM

It's not that difficult to use Export XML with an XSL stylesheet to produce an RSS feed. It is a pretty simple structure (at least it was, this was a while ago I did this). The following extracts data from FileMaker fields, by numbered column. Example:

<title><xsl:value-of select="fmp:COL[1]/fmp:DATA"/></title>
So all you have to do is to either change the numbers after COL to match your export field order; or change your field order.

Attached Files


  • 0

#3 djbeta  master

djbeta
  • Members
  • 403 posts
  • FM Application:11 Advance
  • Platform:Cross Platform
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 6h 9m 48s

Posted 16 July 2007 - 11:52 AM

thanks

does this assume that we have a flat table that has 4 columns that provide the RSS title, link, description... but that that information exists in each row ?

It looks like the xsl is pulling the RSS channel title out of column 1, 2, 3, 4 but then the item data from columns 5, 6, 7, 8..
  • 0
Steven Cappiello
Systems Technology Manager
Sloan-Kettering Institute

#4 Fenton  Post Master General

Fenton
  • Moderators
  • 5,046 posts
  • FM Application:11 Advance
  • Platform:Mac OS X Snow Leopard
  • Skill Level:Expert
  • Membership:TechNet, FileMaker Business Alliance
  • Time Online: 17h 12m 20s

Posted 16 July 2007 - 01:27 PM

Something like that. It is exporting from the items data table. The channel info is either an unstored calculation of a related field or global. You could use related data directly from another table, but I brought it in and labelled it, just to keep the RSS fields together. Either way should work.

Notice that the xsl is only pulling channel data, from fields 1,2,3,4 in ROW[1], then pulling the other data from all the rows (records).

XSL can do this, print row (record) 1, then separately print all the records, starting over at 1, but different fields. This comes in very handy.
  • 0

#5 djbeta  master

djbeta
  • Members
  • 403 posts
  • FM Application:11 Advance
  • Platform:Cross Platform
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 6h 9m 48s

Posted 17 July 2007 - 06:14 AM

yes... I think I see what it's doing... XSL just scares me... ick..
:

I guess it will get less scary after I get it working!

thanks Fenton
  • 0
Steven Cappiello
Systems Technology Manager
Sloan-Kettering Institute

#6 Martin Brändle  veteran

Martin Brändle
  • Members
  • 890 posts
  • FM Application:12 Advance
  • Platform:Mac OS X Mountain Lion
  • Skill Level:Expert
  • Membership:TechNet
  • Time Online: 10m 40s

Posted 21 July 2007 - 01:58 AM

If you have FMS(A), you can publish RSS feeds directly (by way of XML/XSLT CWP) without scripts, exporting and uploading files.

You can find an example of a news ticker
here.

The example is made so that upon each change of the database, the RSS feed is updated.

The news ticker was part of a course that I gave at the german FileMaker conference 2006. Have a look at folder Schritt4, file news_en.xsl . Have also a look at the accompanying pdf file of the PowerPoint presentation. Although the examples are in german, you may figure out.
Then examine the optimized example in folder Schritt4_optimiert, news_en.xsl . This files uses some tricks to decrease RSS bandwidth considerably.

Before you publish this example on your server, please remove the original messages in the database and add your own.
  • 0

#7 Canaan_moore  newbie

Canaan_moore
  • Newbies
  • Pip
  • 1 posts
  • FM Application:3

Posted 15 February 2010 - 04:02 AM

You guys are the most innovative content distributors on the web, and I think you guys could check this site out and make a credit of it.
http://www.rsschannelwriter.com/
A new version of RSS Channel Writer released by Emergency Soft. This comprehensive, yet easy-to-use software promises to be the most professional in its field.
  • 0

#8 ourcalling  newbie

ourcalling
  • Newbies
  • Pip
  • 1 posts
  • FM Application:12 Advance
  • Platform:Mac OS X Mountain Lion
  • Skill Level:Intermediate
  • Membership:TechNet

Posted 30 January 2014 - 08:04 PM

I know this thread is old, but I am also trying to generate an RSS. 

We use Filemaker to track details on thousands of homeless individuals. We need to generate an RSS to feed our digital signage for who's next on the shower/laundry list. 

 

I know your examples aren't entirely relevant since this thread is almost 7 years old. 

But since I am a rookie can you at least point me in the right direction?

We are using FMS13.

 

Thanks

~w


  • 0

#9 comment  consultant

comment
  • Members
  • 24,212 posts
  • Time Online: 330d 23h 4m 53s

Posted 30 January 2014 - 08:22 PM

I know your examples aren't entirely relevant since this thread is almost 7 years old.

 

I suggest you try the answer given in post #2, nevertheless. Not much has changed on this front since version 6 in 2002.

 

 

EDIT:

Sorry, I have only now noticed you're using a server. I'll try and get a better answer for you, one that doesn't require exporting (I see that the link in post #6 is no longer active).


Edited by comment, 30 January 2014 - 08:30 PM.

  • 0




FMForum Advertisers