Looking for someone to help update the attached file for import xml, and explain how it works.
FileMaker (8.5 or later because you need Web Viewer);
A FileMaker database ;
An XSLT style sheet; (I found this style sheet somewhere some time ago; didn’t write it myself)
A web host where you can post the XSLT file;
An RSS feed that actually works with this (e.g. Yahoo Stocks: [login to view URL]);
A script that pulls the info (which now can be run on server if you have FMS 9 or 10);
A table in your DB for storing the RSS feeds;
A portal on your layout that shows the list of RSS feeds;
A web viewer in your database that can display the resulted web page;
A script that tells the web viewer to show the requested article.
[login to view URL]
Directions
Create a new table called ‘RSS_Feed’ in your solution (since this only works in FM 8.5 and later, there’s no need for a separate file). Create the following fields: ID, Title, Description, Link, PubDate, SelectedLink;
Link the new table to your preferred table (Global, Solution, etc.) by showing all records (‘x’ symbol);
Create a new layout in your solution, place a portal on it showing the records from the RSS Feed table (link and description fields, minimum). Place a web viewer next to it. Name your web viewer object “article”;
Create a script similar to this example to refresh the feed (you can run this script from a button on your layout or at certain intervals from the server):
Go to Layout [ "Layout Name" (Table Name) ] Enter Browse Mode Show All Records Delete All Records [ No dialog ] Import Records [ XML (from http): [login to view URL]; XSL (from http): [login to view URL] ] [ No dialog ] Go to Layout [ original layout ]
Create a script for showing the article:
Set Field [ RSS_Feed::SelectedLink; RSS_Feed::Link ] Set Web Viewer [ Object Name: "article"; URL: RSS_Feed::SelectedLink ]
Turn your title field on your portal into a button and link to perform the script above.
This is most likely not the only method; it may not be the best method either. It is, however a working method. Any questions, suggestions, feel free to respond.