MBS FileMaker Plugin Example Databases

JSON Import

All examples are included with download of MBS FileMaker Plugin.

JSON Import.fmp12

Overview
Tables3
Relationships0
Layouts2
Scripts1
Value Lists0
Custom Functions0
Custom Menus0
File Options
Default custom menu set[Standard FileMaker Menus]
When opening file
Minimum allowed version12.0
Login usingAccount Name; Account= Admin
Allow user to save passwordOff
Require iOS passcodeOff
Switch to layoutOff
Hide all toolbarsOff
Script triggers
OnFirstWindowOpenOff
OnLastWindowCloseOff
OnWindowOpenOff
OnWindowCloseOff
OnFileAVPlayerChangeOff
Thumbnail Settings
Generate ThumbnailsOn; Temporary

 

Tables

Table Name
Statistics
Occurrences in Relationship Graph
JSON Import
1 field defined, 1 record
JSON Import
ImportJson
5 fields defined, 1 record
ImportPeople
5 fields defined, 3 records

Fields

Table Name: JSON Import - 1 Fields
Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
JSONNormal, TextAuto-Enter:
  • Allow editing
Validation:
  • Only during data entry
Storage:
  • Repetitions: 1
  • Indexing: None
  • Automatically create indexes as needed
  • Index Language: German

      Table Name: ImportJson - 5 Fields
      Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
      _RecordUUIDNormal, TextAuto-Enter:
      • Allow editing
      Validation:
      • Only during data entry
      Storage:
      • Repetitions: 1
      • Indexing: None
      • Automatically create indexes as needed
      • Index Language: German
              _CreationTimeStampNormal, TimestampAuto-Enter:
              • Allow editing
              Validation:
              • Always Validate
              • Strict data type: 4 digit year
              Storage:
              • Repetitions: 1
              • Indexing: None
              • Automatically create indexes as needed
              • Index Language: German
                      _ParentRecordUUIDNormal, TextAuto-Enter:
                      • Allow editing
                      Validation:
                      • Only during data entry
                      Storage:
                      • Repetitions: 1
                      • Indexing: None
                      • Automatically create indexes as needed
                      • Index Language: German
                              peopleNormal, TextAuto-Enter:
                              • Allow editing
                              Validation:
                              • Only during data entry
                              Storage:
                              • Repetitions: 1
                              • Indexing: None
                              • Automatically create indexes as needed
                              • Index Language: German
                                      countNormal, TextAuto-Enter:
                                      • Allow editing
                                      Validation:
                                      • Only during data entry
                                      Storage:
                                      • Repetitions: 1
                                      • Indexing: None
                                      • Automatically create indexes as needed
                                      • Index Language: German

                                              Table Name: ImportPeople - 5 Fields
                                              Field NameTypeOptionsCommentsOn LayoutsIn RelationshipsIn ScriptsIn Value Lists
                                              _RecordUUIDNormal, TextAuto-Enter:
                                              • Allow editing
                                              Validation:
                                              • Only during data entry
                                              Storage:
                                              • Repetitions: 1
                                              • Indexing: None
                                              • Automatically create indexes as needed
                                              • Index Language: German
                                                      _CreationTimeStampNormal, TimestampAuto-Enter:
                                                      • Allow editing
                                                      Validation:
                                                      • Always Validate
                                                      • Strict data type: 4 digit year
                                                      Storage:
                                                      • Repetitions: 1
                                                      • Indexing: None
                                                      • Automatically create indexes as needed
                                                      • Index Language: German
                                                              _ParentRecordUUIDNormal, TextAuto-Enter:
                                                              • Allow editing
                                                              Validation:
                                                              • Only during data entry
                                                              Storage:
                                                              • Repetitions: 1
                                                              • Indexing: None
                                                              • Automatically create indexes as needed
                                                              • Index Language: German
                                                                      firstNormal, TextAuto-Enter:
                                                                      • Allow editing
                                                                      Validation:
                                                                      • Only during data entry
                                                                      Storage:
                                                                      • Repetitions: 1
                                                                      • Indexing: None
                                                                      • Automatically create indexes as needed
                                                                      • Index Language: German
                                                                              lastNormal, TextAuto-Enter:
                                                                              • Allow editing
                                                                              Validation:
                                                                              • Only during data entry
                                                                              Storage:
                                                                              • Repetitions: 1
                                                                              • Indexing: None
                                                                              • Automatically create indexes as needed
                                                                              • Index Language: German

                                                                                      Layout Objects: JSON Import

                                                                                      Regular Fields

                                                                                      Field Name: JSON Import::JSON
                                                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                      • Top: 66 pt
                                                                                      • Left: 418 pt
                                                                                      • Bottom: 318 pt
                                                                                      • Right: 1001 pt
                                                                                      • Anchoring: Left, Top
                                                                                      Field Format:
                                                                                      • Edit Box
                                                                                      Field Behavior:
                                                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                                                      • Touch keyboard type: Default for Data Type
                                                                                      • Go to next field using: Tab key
                                                                                      Yes

                                                                                      Layout Objects: Test

                                                                                      Regular Fields

                                                                                      Field Name: <Missing Field>
                                                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                      • Top: 61 pt
                                                                                      • Left: 140 pt
                                                                                      • Bottom: 82 pt
                                                                                      • Right: 393 pt
                                                                                      • Anchoring: Left, Top
                                                                                      Field Format:
                                                                                      • Edit Box
                                                                                      Field Behavior:
                                                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                                                      • Touch keyboard type: Default for Data Type
                                                                                      • Go to next field using: Tab key
                                                                                      Yes

                                                                                      Field Name: <Missing Field>
                                                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                      • Top: 84 pt
                                                                                      • Left: 140 pt
                                                                                      • Bottom: 105 pt
                                                                                      • Right: 381 pt
                                                                                      • Anchoring: Left, Top
                                                                                      Field Format:
                                                                                      • Edit Box
                                                                                      Field Behavior:
                                                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                                                      • Touch keyboard type: Default for Data Type
                                                                                      • Go to next field using: Tab key
                                                                                      Yes

                                                                                      Field Name: <Missing Field>
                                                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                      • Top: 107 pt
                                                                                      • Left: 140 pt
                                                                                      • Bottom: 128 pt
                                                                                      • Right: 393 pt
                                                                                      • Anchoring: Left, Top
                                                                                      Field Format:
                                                                                      • Edit Box
                                                                                      Field Behavior:
                                                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                                                      • Touch keyboard type: Default for Data Type
                                                                                      • Go to next field using: Tab key
                                                                                      Yes

                                                                                      Field Name: <Missing Field>
                                                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                      • Top: 130 pt
                                                                                      • Left: 140 pt
                                                                                      • Bottom: 151 pt
                                                                                      • Right: 393 pt
                                                                                      • Anchoring: Left, Top
                                                                                      Field Format:
                                                                                      • Edit Box
                                                                                      Field Behavior:
                                                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                                                      • Touch keyboard type: Default for Data Type
                                                                                      • Go to next field using: Tab key
                                                                                      Yes

                                                                                      Field Name: <Missing Field>
                                                                                      Field PropertiesCoordinatesField FormatField BehaviorQuick Find
                                                                                      • Top: 153 pt
                                                                                      • Left: 140 pt
                                                                                      • Bottom: 174 pt
                                                                                      • Right: 393 pt
                                                                                      • Anchoring: Left, Top
                                                                                      Field Format:
                                                                                      • Edit Box
                                                                                      Field Behavior:
                                                                                      • Allow field to be entered: In Find mode, In Browse mode
                                                                                      • Touch keyboard type: Default for Data Type
                                                                                      • Go to next field using: Tab key
                                                                                      Yes

                                                                                      Script Hierarchy

                                                                                      Import

                                                                                      Script NameImport
                                                                                      Run script with full access privilegesOff
                                                                                      Include In MenuYes
                                                                                      Layouts that use this script
                                                                                        Scripts that use this script
                                                                                          Script Definition
                                                                                          Script Steps
                                                                                          Fields used in this script
                                                                                          Scripts used in this script
                                                                                            Layouts used in this script
                                                                                            Tables used in this script
                                                                                            Table occurrences used by this script
                                                                                            Custom Functions used by this script
                                                                                              Custom menu set used by this script

                                                                                                Download example: JSON Import

                                                                                                Used functions:




                                                                                                Links
                                                                                                MBS Xojo Plugins