On 4/21/10 10:03 AM, "Chuck Pelto" <[log in to unmask]> wrote in whole or in
part:

> Is there a script that can translate XML to a FileMaker Pro database?


Chuck, what version of FMP?
There is an IMPORT grammar called FMPXMLRESULT. It's formatted *somewhat*
like a spreadsheet, because it has a list of the "Fields/column headers" and
then is followed by a series of ROWS with COLS/DATA elements.

There are many "flavors" of XML (often defined or validated by a DTD or XSD
- schema). What XML are you trying to import?

An XSLT needs to be used to translate (transform) your source XML into the
FMPXMLRESULT for import. There are some sample XSLT in your install of FMP.
However, these may not be sufficient. Your database structure will determine
the correct way to import. For example, if you have related data, then you
likely will need multiple imports (one into each table/table occurrence)
from the same XML source.

Beverly