FileMaker XSLT Library
XML data exchange is made possible by XSLT stylesheets, which present XML data in a language that FileMaker Pro can interpret, and you can use XSLT stylesheet to present your data in lots of great ways. Download free XSLT examples designed to help you take advantage of the XML features in FileMaker Pro.
XML Import and Export XSLT stylesheets that function correctly with FileMaker Pro 6 will continue to work with FileMaker Pro 8.5.
Contribute your own XSLT examples to our library. Have you created an XSLT example? Add it to our library.
This FMSA CWP demo shows how to set up an intelligent XML cache for predefined queries. The cache consists of XML cache control files with time stamp data and the cache files storing the fmresultset XML data retrieved from the database. To demonstrate how caching may improve FMSA CWP performance considerably, the predefined queries retrieve a list of several hundred or thousand words that start with a chosen letter. The functionality of your standard FMSA installation is used; no extensions such as Java or JavaScript programs or plugins are required.
Using an XSLT template file to retrieve data from a password protected Filemaker database | Download
This document explains how to use an XSLT file stored on an FMSA server to perform XML queries against a password protected database, with the authentication information stored on the server in the XSLT code. This is helpful for XML data retrieval from a remote application which is not designed to handle an authentication prompt and also in cases where user interaction to authenticate is not desirable.
If you use FileMaker to manage your company's events & to do's, then this FileMaker to vCal solution is what you need. Using FileMaker Server 7 Advanced, you can subscribe to your FileMaker data from products like iCal (Mac), Mozilla calendar (Win or Mac), or Sunbird (Win or Mac).
When it comes to XML import/export in FileMaker, one often forgets that FileMaker itself uses some XML configuration files. One Example is FileMaker Labels, another is FileMaker Themes. For themes try the excellent ThemeCreator from http://www.cincogroup.com, or for labels start with this file.
Use to translate FileMaker fields using Altavista Babelfish. This solution demonstrates a quick way to grab a web page via perl, filter any unwanted information and return the result to FileMaker via XSLT/http XML import.
Microsoft Excel 2003 for Windows supports an XML format for spreadsheets. This package contains two stylesheets that allow you to export FileMaker Pro data directly into Microsoft XML spreadsheet files. (Still hoping and waiting for Mac Office to support the Microsoft XML Spreadsheet format)
A basic proof of concept that demonstrates the creation of Microsoft Word 2003 documents using the new Word 2003 XML grammar. Microsoft Word 2003 is required to make full use of this example, although FileMaker Pro 6.0 (Macintosh or Windows) may be used to generate the Word 2003 documents.
Insert FileMaker data into MySQL. It creates the appropriate data structure from FileMaker METADATA and the INSERT statements.
This solution gets the official reference exchange rates for the Euro from the European Central Bank. I designed it to demonstrate the following techniques: - workaround the FM 6.04 bug not recognizing xsl:decimal-format - show to handle different date format with substring() - how to dynamically write xsl files out of FileMaker, protecting xsl source and even selectively import only some content of the file with xsl:if ...
The FileMaker to Keynote tool allows FileMaker customers to transform data contained within FileMaker Pro 6 databases into native presentations for Apple's Keynote presentation software. Version 1.1 contains changes to ensure compatibility with Keynote 1.1. Requires FileMaker 6.0v4, Keynote 1.1, and Mac OS X 10.2 or later.
Have you ever dreamed of being able to dynamically display web images and movies in FileMaker? Well - here is a solution. Simply put some pictures in the images folder, press import pix and off you go - sort of. There are some limitations - you have to click on the movie to activate. Imagine creating animated bar charts (using different regions) in SMIL, or creating an image map that links to different web addresses.... To explore further possibilities with QuickTime and SMIL, take a trip to Apple's QuickTime page. Simply click on the Quicktime logo to go there.
A simple example XML export that converts FileMaker Pro's FMPXMLRESULT to RSS (version 0.91).
This example shows how to import data into a portal. Using two separate imports from the xml document and using two separate style sheets.
Project TimeLine exports a simple gant chart as an .htm document that can be viewed by your web browser
This example is a collection of simple FileMaker Pro databases and XSLT stylesheets that connect to each of the four ServiceObjects web services offered in the developer trial access program (DOTSAddressValidate, DOTSPackageTracking, DOTSEmailValidate, DOTSShippingComparison). You will need to register at FileMaker XML Central to obtain your own free ServiceObjects license key.
This example contains two XSLT stylesheets to demonstrate the XML export function of FileMaker Pro 6 towards the XML Impression Language. XML Impression let's you automate QuarkXPress document construction based on XML files. Each of the stylesheets is associated with a separate script and accompanying button on the main layout of the example database.
A small example database and stylesheet that demonstrates how to access Amazon, Inc.'s web service. Provides a method to perform searches via keyword, author, and ISBN. You MUST have an Amazon Associates ID to use this stylesheet. You may apply for a free Amazon Associates ID at http://associates.amazon.com/exec/panama/associates/apply/.
Demonstrates how to auto-fill FileMaker data to a Acrobat PDF file. Auto-filled data can also be submitted from the Sample.pdf file back to the PDF_Filler.fp5 file. Both the PDF_Filler.fp5 and Sample.pdf files are unprotected. The author has only tested the package contents on the Windows platform. Another tester has reported that the files "worked well" on a Mac running OS 9.1.
This example demonstrates two methods of displaying portal data in an HTML table. This example also uses <xsl:if> to conditionally display the table with the parent data, only if there is related data
iTunes 3 now can export song library information in XML. This stylesheet is designed to import that XML song library information into a FileMaker database.
This solution demonstrates two FMPXMLRESULT to HTML conversion methods: 1. a basic export into an HTML file using a local XSL style sheet 2. a basic export into an HTML file using a remote XSL style sheet The purpose of these examples is to help those who are new to XML. The fact that nothing fancy is being done allows the XML "newbie" to more easily distinguish the necessary elements in the programming.
This sample database shows how you can use an existing web service that provides FedEx package tracking information in XML format in your FileMaker database
This simple FileMaker database shows how import XML can be used to update information within your database. It uses a simple style sheet to convert from the incoming XML format to FMPXMLRESULT grammar.
This example shows how you can export contact information out of FileMaker database and convert it into a VCF file, a popular file format used by PIM applications and Apple's iPod portable audio player to store contact information.
This example contains basic XSLT stylesheets that demonstrate the XML import and export capabilities of FileMaker Pro 6. There are three import stylesheets and five for export. Each of the stylesheets is associated with a separate script and accompanying button on the main layout. Sample output is provided for each of the export stylesheets. These examples make a good starting point for creating your own stylesheets.
The "fmp_to_ipod.xsl" style sheet is designed to transform information from the Contact Management.fp5 database to the iPod contact database.
Microsoft Excel 2002 (XP) for Windows supports an XML format for spreadsheets. This package contains two stylesheets that allow you to export FileMaker Pro data directly into Microsoft XML spreadsheet files.
Use this example database and collection of XSLT stylesheets to help you prepare your own submission package for the FileMaker XSLT Library.
A collection of short XSLT stylesheets based on the simple_table.xsl example provided with FileMaker Pro 6 that demonstrate the use of Cascading Style Sheets (CSS) with XSLT.
This example demonstrates several operations on numbers with XSLT, including methods for finding max, min, sums, and averages of columns.
This solution gives you an ability to grab a few news headlines (supplied via a XML standard called RSS 0.91) from the web and import them into FileMaker database seamlessly. It also gives you an ability to export the top stories into a formatted HTML file.
An XSLT stylesheet and supporting XML files that creates a sample RTF document including images.
This is a set of 2 files: a FileMaker file and a XSL stylesheet. These 2 files demonstrate how you can generate RTF files right out of FileMaker.
A collection of stylesheets that demonstrate the use of various string processing functions in XSLT.
This package demonstrates the use of some of the functions included in the excellent package "XSLT Standard Library Version 1.1" Copyright © 2001, by Steve Ball. You must be connected to the Internet for this stylesheet to function properly.
The style sheets in this package will obfuscate your FileMaker XML data using standard ROT 13 text encryption, and unscramble the obfuscated XML data (in FMPXMLRESULT grammar).
A stylesheet that produces a very simple bar chart with Scalable Vector Graphics (SVG) from FileMaker Pro data.