FileMaker Pro 11 Advanced ® Database Design Report XML Output Grammar
© 2007–2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker and Bento are trademarks of FileMaker, Inc. registered in the U.S. and other countries. The file folder logo and the Bento logo are trademarks of FileMaker, Inc. All other trademarks are the property of their respective owners. FileMaker documentation is copyrighted.
Database Design Report XML Output Grammar This document describes the FileMaker® Pro 11 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 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
FileMaker Pro Advanced Database Design Report XML Output Grammar Tag Name Value Description Valid filename based on the OS platform. Contains the XML detail report filename. Any numeric value. Shows the number of base tables found in the database referenced under attribute. Any numeric value. Shows the number of tables (occurrences) found in the database referenced under attribute.
| General Section 5 General Section Tag Name Value Description
FileMaker Pro Advanced Database Design Report XML Output Grammar File Reference Section All nodes below start with Tag Name Value Description — XML node for catalog of file references and data sources. PAGE 7| BaseTable Section 7 Tag Name Value Description
FileMaker Pro Advanced Database Design Report XML Output Grammar Tag Name Value Description catalogName="catalog" Any valid string. The name of the remote table's catalog in the ODBC data source. schemaName="schema" Any valid string. The name of the remote table's schema in the ODBC data source. tableName="table"> Any valid string. The name of the remote table's table name in the ODBC data source.
| BaseTable Section 9 Tag Name Value Description — XML node for a calculation. This XML node is for display purposes only. Basically, it breaks a calculation into sequential chunks. Can have one of the following values: 1 FunctionRef 1 FieldRef 1 NoRef 1 CustomFunctionRef Chunk type. FunctionRef indicates that the chunk is a calculation function. FieldRef indicates that the chunk is a field.
FileMaker Pro Advanced Database Design Report XML Output Grammar Tag Name Value Description name="Field2" Valid field name. — id = "2" Internal unique positive integer value indicating creation order. — shadowType="Supplemental"> Can have one of the following values: 1 Shadow 1 Supplemental Specifies the shadow field type. Only available if the parent BaseTable's "shadow" attribute is "True.
| BaseTable Section Tag Name 11 Value Description calculation="True" Can have one of the following values: 1 True 1 False Attribute indicates if the auto-enter calculation is applicable. lookup="True" Can have one of the following values: 1 True 1 False Attribute indicates if the auto-enter lookup information is applicable. furigana="True" Can have one of the following values: 1 True 1 False Attribute indicates if the furigana information is applicable.
FileMaker Pro Advanced Database Design Report XML Output Grammar Tag Name Value Description Table occurrence XML node. Represents the context table occurrence of the lookup. Internal unique positive integer value indicating creation order. — XML node for a field. name="Field2" Valid field name. — id = "2" Internal unique positive integer value indicating creation order.| BaseTable Section Tag Name 13 Value Description maxLength="True" Can have one of the following values: 1 True 1 False Indicates if the validation maximum of character option is applicable. message="True"> Can have one of the following values: 1 True 1 False Indicates if the validation error message option is applicable.
FileMaker Pro Advanced Database Design Report XML Output Grammar Tag Name Value Description — —
| Relationship Section 15 Relationship Section All nodes below start with Tag Name Value Description — — — — Can have one of the following values: 1 True 1 False —
FileMaker Pro Advanced Database Design Report XML Output Grammar Tag Name Value Description Can have one of the following values: 1 True 1 False — Can have one of the following values: 1 Ascending 1 Descending 1 Custom — Child node is a field element.
| ValueList Section Tag Name Value Description name="T" — — color = "#fffffff" — — id="1" — — baseTable = "TName" — — — — name="file reference name" — — id="1" > — — Value Description 17 baseTableId = "32345"> Tag Name — — — Can have oFileMaker Pro Advanced Database Design Report XML Output Grammar Tag Name sort = "False" show = "False"> resortLanguage ="Finnish" > Value Description Sort can have one of the following values: 1 True 1 False The sort attribute indicates that the field contents are sorted. The show attribute indicates that the field contents are included in the value list. The resortLanguage indicates the language re-sort is based on.
| Layout Section 19 Layout Section All nodes below start with A node with its children may be attached to a layout or to individual layout objects.
FileMaker Pro Advanced Database Design Report XML Output Grammar Tag Name Value Description name="FieldObj1" A valid layout object name string — flags = "123" — Bit flag value to indicated the following settings: 0x00000001 - Object has conditional formatting 0x00000002 - Locked on layout 0x00000010 - Marked for sliding up 0x00000020 - Marked for sliding left 0x00000200 - Don't image when printing 0x00004000 - Object has associated tooltip 0x00010000 - Show "hand over button" cursor 0x01000000
| Layout Section Tag Name 21 Value Description op="1"> — Identifier of a string in the localized string table, which describes a preset operation (e.g. "Less than or equal to")
FileMaker Pro Advanced Database Design Report XML Output Grammar Tag Name inputMode="0" Value Description Values can be: 128 - 135 Meaning of the numbers: 128 : Synch Field Font 129 : Japanese Active 130 : Japanese Direct 131 : Hiragana 132 : Full-Width Katakana 133 : Full-Width Alpha 134 : Half-Width Katakana 135 : Half-Width Alpha displayType="0" Values can be: 0 to 6 Meaning of the numbers: 0 : Edit Box 1 : Drop-down List 2 : Pop-up Menu 3 : Checkbox Set 4 : Radio Button Set 6 : Calendar pop
| Layout Section 23 Tag Name Value Description
FileMaker Pro Advanced Database Design Report XML Output Grammar Tag Name Value Description
FileMaker Pro Advanced Database Design Report XML Output Grammar Tag Name Value Description
