Support

XML Overview

FileMaker Pro utilises open XML standards to exchange data.

Extensible Markup Language (XML) is a universal standard for sharing data between applications. Choose the product and feature that is right for what you want to do.

What do you want to do? Feature Name Product required

I want to import XML.

XML Data Source Import

FileMaker Pro or FileMaker Pro Advanced

I want to export XML as FMPXMLRESULT or FMPDSORESULT grammar on an ad hoc basis.

Export Records

FileMaker Pro or FileMaker Pro Advanced

I want to export XML as FMPXMLRESULT or FMPDSORESULT grammar on a regular basis.

Export Records script step

FileMaker Pro or FileMaker Pro Advanced

Using a URL, I want to submit a query and receive XML data using the FMPXMLRESULT or FMRESULTSET grammar.

Custom Web Publishing with XML

FileMaker Server

Which grammar should I use?

  • The FMPDSORESULT grammar is useful for exporting databases that you want to format with cascading style sheets or XSL. This grammar is compatible with the Microsoft XML Data Source Object.

  • TheFMPXMLRESULT grammar contains additional information about the database that is not in the FMPDSORESULT grammar, such as the number of records, field types, and field formats. Use the FMPXMLRESULT grammar if you require the metadata information provided by this grammar.

  • The FMRESULTSET grammar enables you to access fields by name and manipulate related set (portal) data.  It is optimised for XSLT stylesheet authoring and is more verbose than the FMPXMLRESULT grammar.

When would I use XML instead of ODBC/JDBC to exchange data?

XML allows you to leverage the structure of FileMaker Pro to access layouts, portals, and scripts. In addition, you can access all the data that exists on a particular layout, regardless of what table it is in.

Real-world use case examples

  • Data exchange with Photoshop, InDesign and other popular Creative Professional applications: Most design applications support XML. FileMaker Pro can be part of the creative workflow by using XML for data exchange.
  • Integration with enterprise systems: Many enterprise systems will allow queries that generate XML that can be imported into FileMaker Pro.
  • Interoperability with other web publishing frameworks: XML provides a way to connect to .NET.

Resources

Documentation and Notes

Search Knowledge Base

View a list of common XML questions and answers (US Website)

Get more from FileMaker!

View our web seminars.

Learn more

FileMaker Job Board

FileMaker Job Board

Totally free for employers and job seekers.

Find a job Post a job

Resources for IT Pros

Download free resources for IT professionals.

Learn more