Filemaker - Import XML

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: [url removed, login to view]);

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.

[url removed, login to view]

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): [url removed, login to view]; XSL (from http): [url removed, login to view] ] [ 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.

Cacao Mac OS Objective C

Rif. progetto: #4799849

Info sul progetto