Thanks for your response.
One of the problems with the FileMaker Pro tab-delimited export is that it doesn't include a header line of field names so that has to be added manually. The XML exports have the advantage of containing the field name (as well as other) data.
I've created two XML samples that correspond to the two kinds of XML formats that FMP can export (FMPXMLRESULT
). To make the sample files more manageable I created exports that only represent books in my database that have authors whose last names begin with "Y" (17 records instead of 5393). Also, only 13 of the 52 total FMP database fields are included in the exports.
The files are named fmpxmlresult.xml
but I don't see any obvious way to send them to you. Let me know how and I will do so.
According to FMP's documentation the FMPXMLRESULT format is best if metadata information about the database is desired whereas the FMPDSORESULT format works better if it is desired to use CSS (cascading style sheets) with the XML data.
Here's a small excerpt from their documentation (available with FMP and also online) describing XML exporting:
FileMaker Pro can export XML in two grammars: FMPXMLRESULT and FMPDSORESULT. You can apply an XSLT style sheet during export to transform either of the grammars into a different XML format, or into a different format such as HTML or plain text. For example, with XML export, you can create a data-driven Web page, or a text file of data that uses a custom field delimiter.
Note The XML import and export features in FileMaker Pro use an XML parser called Xerces and an XSLT style sheet processor called Xalan. As you develop XML and XSL, you may want to test your XML and XSLT with Xerces- and Xalan-based parsers and processors, available at http://xml.apache.org
and other third-party locations.