Help

Saving, importing, and exporting data
F
ILEMAKER PRO HELP 536
Each ROW element in the exported FMPDSORESULT grammar contains a number of FIELD
elements that correspond to the field names that you export.
Spaces or single colons in field names are converted to underscores in the element names (for
example,
<FIRST_NAME>). Double colons in portal fields are converted to periods (for example,
<PHONE.PHONE_NUMBER>). This is done because colons are reserved in XML for specifying
namespaces, and spaces are not allowed in XML element names.
For repeating and related fields, each FIELD element will contain a DATA element that corresponds
to each repetition or portal record.
XML export does not support exporting container field data.
Due to XML limitations, only one record from each related field is exported.
For more information, search the FileMaker Knowledge Base available at http://help.filemaker.com.
Sample XML data in the FMPDSORESULT grammar
The following is an example of XML in the FMPDSORESULT grammar. For complete details on the
document type definition (
DTD) for the grammar, see the fmpdsoresult_dtd.htm file, which
you can download at http://www.filemaker.com/downloads.
<?xml version="1.0" encoding="UTF-8"?>
<FMPDSORESULT xmlns="http://www.filemaker.com/fmpdsoresult">
<ERRORCODE>0</ERRORCODE>
<DATABASE>PhoneList.fp5</DATABASE>
<LAYOUT>Web Layout</LAYOUT>
<ROW MODID="23" RECORDID="3">
<FIRST_NAME>John</FIRST_NAME>
<LAST_NAME>Smith</LAST_NAME>
<PHONE.PHONE_NUMBER>
<DATA>555-444-3333</DATA>
<DATA>555-222-9999</DATA>
</PHONE.PHONE_NUMBER>
</ROW>
<ROW MODID="32" RECORDID="6">
<FIRST_NAME>Barbara</FIRST_NAME>
<LAST_NAME>Jones</LAST_NAME>
<PHONE.PHONE_NUMBER>
<DATA>555-666-7777</DATA>
<DATA>555-333-0000</DATA>
<DATA>555-111-7654</DATA>
</PHONE.PHONE_NUMBER>
</ROW>
</FMPDSORESULT>
XML FMPXMLRESULT grammar
The FMPXMLRESULT 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. These
elements and attributes are necessary for the
XML to validate properly.
Use the FMPXMLRESULT grammar if you require the METADATA information provided by this
grammar. Because FileMaker
Pro supports both importing and exporting in the FMPXMLRESULT
grammar, this can be a useful format for transferring data between FileMaker
Pro files.
Note The FMPXMLRESULT grammar is not well suited for use with cascading style sheets (CSS).
Use the FMPDSORESULT grammar if you want to use CSS with your XML data.