It’s not sexy, but it is very useful: FileMaker Pro and XML

XML HANDLES DATA.  And makes it easily movable between different languages and computers and systems.  That’s what it does, and it does it well.

And FileMaker easily handles XML:

FileMaker Pro can import XML data into an existing FileMaker Pro file, or convert XML into a new FileMaker Pro file.

The XML can be a physical file, or the result of an HTTP request sent to a web server. For example, you could set up an Orders database to send tracking numbers to a package delivery company in the form of an HTTP request, and their web server could return the latest package tracking information in XML format, ready to be imported into the Orders database.

The XML that you import must conform to the FileMaker FMPXMLRESULT document type definition (DTD). If your XML is in a different format, you can apply an Extensible Stylesheet Language (XSLT) style sheet during import to transform your XML into the FMPXMLRESULT grammar. See XML FMPXMLRESULT grammar.

To import XML:

What you do first depends on whether you are importing XML into an existing FileMaker Pro file, or converting XML into a new FileMaker Pro file.

Do one of the following:

To import XML Do this

Into an existing FileMaker Pro file  Continue with step 2.

By converting the XML into a new FileMaker Pro file  Skip ahead to step 8.

The future belongs to the developers that make FileMaker work with the web.  Learn more about importing XML into FileMaker at the link.

via Importing XML data | FileMaker.


Liked Liked
Need FileMaker Development Help? Or to purchase FileMaker Software?
Contact FM Pro Gurus for help