Database Design Report XML Output Grammar

Database Design Report XML Output Grammar
This document describes the FileMaker® Pro 10 Advanced Database Design Report (DDR) XML output grammar.
The DDR XML format is useful for advanced users and developers who want to create tools that analyze or process
the structure of databases.
Table of Contents
Overview (Summary) Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
General Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
File Reference Section. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
BaseTable Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
Relationship Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15
ValueList Section. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17
Layout Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .18
Account Section. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .31
PrivilegeSet Section. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .32
ExtendedPrivilege Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .37
Custom Menu Set Section. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .37
Custom Menu Section. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .38
Custom Function Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .40
Script Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .41
Overview (Summary) Section
Tag Name Value Description
<FMPReport
— The top most parent node
type="Summary"
Can have one of the
following values:
1 Summary
1 Report
Stores the type of the XML report file. This
value is used by the XSL file to determine if we
are in summary mode or report mode.
version="10.0v1"
FMPro Advanced
version/vrev
Version/vrev of FileMaker Pro Advanced that
generated this report.
creationDate="1/1/2009"
Date string based on the
system's locale.
Contains the creation date of the report.
creationTime="2:00 pm">
Time string based on the
system's locale.
Contains the creation time of the report.
<FMPReport><File
— XML node that contains the information about
the database file report such as the original
filename, the path of the report directory and
the XML report filename.
name="testfile.fp7"
Valid filename based on the
OS platform.
No validation is performed in the text string
content. It is only used for display.
path="C:\test\"
Platform specific file path. Path of the XML report file of the database file.