Monkeybread Software - MBS FileMaker Plugin: WindowsML

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

MBS FileMaker Plugin Example Databases

WindowsML

All examples are included with download of MBS FileMaker Plugin.

WindowsML.fmp12

Overview
Tables	2
Relationships	0
Layouts	3
Scripts	7
Value Lists	0
Custom Functions	0
Custom Menus	0

File Options
Default custom menu set	[Standard FileMaker Menus]
When opening file
Minimum allowed version	12.0
Login using	Account Name; Account= Admin
Allow user to save password	Off
Require iOS passcode	Off
Switch to layout	Off
Hide all toolbars	Off
Script triggers
OnFirstWindowOpen	Script: Start Script
OnLastWindowClose	Off
OnWindowOpen	Off
OnWindowClose	Off
OnFileAVPlayerChange	Off
Thumbnail Settings
Generate Thumbnails	On; Temporary

Tables

Table Name	Statistics	Occurrences in Relationship Graph
WindowsML	9 fields defined, 1 record	WindowsML
Result	8 fields defined, 1000 records	Result

Fields

Table Name: WindowsML - 9 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: WindowsML Calculation: Get( UUID ) Validation: Only during data entry Not empty Unique Strict validation Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: Unicode Raw	Unique identifier of each record in this table
CreationTimestamp	Normal, Timestamp	Auto-Enter: Creation timestamp Validation: Only during data entry Strict data type: 4 digit year Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Date and time each record was created
CreatedBy	Normal, Text	Auto-Enter: Creation account name Validation: Only during data entry Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Account name of the user who created each record
ModificationTimestamp	Normal, Timestamp	Auto-Enter: Modification timestamp Validation: Only during data entry Strict data type: 4 digit year Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Date and time each record was last modified
ModifiedBy	Normal, Text	Auto-Enter: Modification account name Validation: Only during data entry Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Account name of the user who last modified each record
Model File Path	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		WindowsML		Select Model File Load Model Start Script
Image File Path	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		WindowsML		Select Image Evaluate Model Start Script
Model Description	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		WindowsML		Load Model Close Model Start Script
Result	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		WindowsML		Evaluate Model Show Results Start Script

Table Name: Result - 8 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
PrimaryKey	Normal, Text	Auto-Enter: Context table: Result Calculation: Get( UUID ) Validation: Only during data entry Not empty Unique Strict validation Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: Unicode Raw	Unique identifier of each record in this table
CreationTimestamp	Normal, Timestamp	Auto-Enter: Creation timestamp Validation: Only during data entry Strict data type: 4 digit year Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Date and time each record was created
CreatedBy	Normal, Text	Auto-Enter: Creation account name Validation: Only during data entry Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Account name of the user who created each record
ModificationTimestamp	Normal, Timestamp	Auto-Enter: Modification timestamp Validation: Only during data entry Strict data type: 4 digit year Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Date and time each record was last modified
ModifiedBy	Normal, Text	Auto-Enter: Modification account name Validation: Only during data entry Not empty Strict validation Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German	Account name of the user who last modified each record
Index	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		Result
Description	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Result
Probability	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Result		Show Results

Layout Objects: WindowsML

Regular Fields

Field Name: WindowsML::Model File Path

Layout Name:

WindowsML

Top: 81 pt
Left: 138 pt
Bottom: 102 pt
Right: 760 pt

Anchoring: Left and Right, 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: WindowsML::Image File Path

Layout Name:

WindowsML

Top: 535 pt
Left: 138 pt
Bottom: 556 pt
Right: 760 pt

Anchoring: Left and Right, Bottom

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: WindowsML::Model Description

Layout Name:

WindowsML

Top: 149 pt
Left: 138 pt
Bottom: 524 pt
Right: 760 pt

Anchoring: Left and Right, Top and Bottom

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: WindowsML::Result

Layout Name:

WindowsML

Top: 601 pt
Left: 138 pt
Bottom: 668 pt
Right: 609 pt

Anchoring: Left and Right, Bottom

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

Type:

Text: Select Model

Layout Name:

WindowsML

Top: 105 pt
Left: 616 pt
Bottom: 135 pt
Right: 760 pt

Anchoring: Right, Top

Perform Script [ “Select Model File” ]

Scripts:

Select Model File

Button Properties

Coordinates

Script/Script Step

Type:

Text: Select Image

Layout Name:

WindowsML

Top: 560 pt
Left: 616 pt
Bottom: 590 pt
Right: 760 pt

Anchoring: Right, Bottom

Perform Script [ “Select Image” ]

Scripts:

Select Image

Button Properties

Coordinates

Script/Script Step

Type:

Text: Evaluate Model

Layout Name:

WindowsML

Top: 613 pt
Left: 616 pt
Bottom: 643 pt
Right: 760 pt

Anchoring: Right, Bottom

Perform Script [ “Evaluate Model” ]

Scripts:

Evaluate Model

Button Properties

Coordinates

Script/Script Step

Type:

Text: Get the Model

Layout Name:

WindowsML

Top: 16 pt
Left: 616 pt
Bottom: 46 pt
Right: 760 pt

Anchoring: Right, Top

Open URL [ "https://github.com/microsoft/Windows-Machine-Learning/tree/master/SharedContent/models" ] [ No dialog ]

Layout Objects: Result

Regular Fields

Field Name: Result::Index

Layout Name:

Result

Top: 112 pt
Left: 8 pt
Bottom: 133 pt
Right: 87 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: Result::Description

Layout Name:

Result

Top: 112 pt
Left: 96 pt
Bottom: 133 pt
Right: 641 pt

Anchoring: Left and Right, 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: Result::Probability

Layout Name:

Result

Top: 112 pt
Left: 650 pt
Bottom: 133 pt
Right: 755 pt

Anchoring: Right, 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

Type:

Text: Back

Layout Name:

Result

Top: 16 pt
Left: 20 pt
Bottom: 46 pt
Right: 125 pt

Anchoring: Left, Top

Go to Layout [ “WindowsML” (WindowsML) ]

Layouts:

WindowsML

Next Script: [Select Image]

Script Name	Select Model File
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	WindowsML
Scripts that use this script
Script Definition
Script Steps	Go to Layout [ “WindowsML” (WindowsML) ] Set Variable [ $r; Value:MBS("FileDialog.Reset") ] Set Variable [ $r; Value:MBS("FileDialog.SetFilter"; "onnx"; "*.onnx"; "Model files") ] Set Variable [ $r; Value:MBS("FileDialog.SetPrompt"; "Pick model file:") ] Set Variable [ $r; Value:MBS("FileDialog.OpenFileDialog") ] If [ $r = "OK" ] Set Variable [ $count; Value:MBS("FileDialog.GetPathCount") ] If [ $count > 0 ] Perform Script [ “Close Model” ] Set Field [ WindowsML::Model File Path; MBS("FileDialog.GetPath"; 0) ] Perform Script [ “Load Model” ] End If End If
Fields used in this script	WindowsML::Model File Path
Scripts used in this script	Close Model Load Model
Layouts used in this script	WindowsML
Tables used in this script	WindowsML
Table occurrences used by this script	WindowsML
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Select Model File]

Next Script: [Load Model]

Script Name	Select Image
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	WindowsML
Scripts that use this script
Script Definition
Script Steps	Go to Layout [ “WindowsML” (WindowsML) ] Set Variable [ $r; Value:MBS("FileDialog.Reset") ] Set Variable [ $r; Value:MBS("FileDialog.SetFilter"; "png¶jpg"; ".PNG¶.JPG"; "PNG Files¶JPEG files") ] Set Variable [ $r; Value:MBS("FileDialog.SetPrompt"; "Pick image file:") ] Set Variable [ $r; Value:MBS("FileDialog.OpenFileDialog") ] If [ $r = "OK" ] Set Variable [ $count; Value:MBS("FileDialog.GetPathCount") ] If [ $count > 0 ] Set Field [ WindowsML::Image File Path; MBS("FileDialog.GetPath"; 0) ] End If End If
Fields used in this script	WindowsML::Image File Path
Scripts used in this script
Layouts used in this script	WindowsML
Tables used in this script	WindowsML
Table occurrences used by this script	WindowsML
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Select Image]

Next Script: [Close Model]

Script Name	Load Model
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script	Select Model File
Script Definition
Script Steps	Go to Layout [ “WindowsML” (WindowsML) ] Set Variable [ $WinMLRef; Value:MBS( "WindowsML.Open"; WindowsML::Model File Path ) ] If [ MBS("ISError") ] Show Custom Dialog [ Title: "Failed to load model"; Message: $WinMLRef; Default Button: “OK”, Commit: “Yes” ] Else Set Variable [ $$WinMLRef; Value:$WinMLRef ] Set Field [ WindowsML::Model Description; MBS("JSON.Colorize"; MBS( "WindowsML.Description"; $$WinMLRef )) ] End If
Fields used in this script	WindowsML::Model File Path WindowsML::Model Description
Scripts used in this script
Layouts used in this script	WindowsML
Tables used in this script	WindowsML
Table occurrences used by this script	WindowsML
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Load Model]

Next Script: [Evaluate Model]

Script Name	Close Model
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script	Select Model File
Script Definition
Script Steps	If [ Length ( $$WinMLRef ) > 0 ] Set Field [ WindowsML::Model Description; "" ] Set Variable [ $r; Value:MBS( "WindowsML.Release"; $$WinMLRef ) ] Set Variable [ $$WinMLRef; Value:"" ] End If
Fields used in this script	WindowsML::Model Description
Scripts used in this script
Layouts used in this script
Tables used in this script	WindowsML
Table occurrences used by this script	WindowsML
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Close Model]

Next Script: [Show Results]

Script Name	Evaluate Model
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	WindowsML
Scripts that use this script
Script Definition
Script Steps	Go to Layout [ “WindowsML” (WindowsML) ] If [ Length ( $$WinMLRef ) = 0 ] Show Custom Dialog [ Title: "No model loaded"; Message: "Please use Load Model script first."; Default Button: “OK”, Commit: “Yes” ] Exit Script [ ] End If Set Variable [ $r; Value:MBS( "WindowsML.BindImageFile"; $$WinMLRef; "data_0"; WindowsML::Image File Path) ] If [ MBS("ISError") ] Show Custom Dialog [ Title: "Failed to set image"; Message: $r; Default Button: “OK”, Commit: “Yes” ] Exit Script [ Result: $r ] End If Set Variable [ $Result; Value:MBS( "WindowsML.Evaluate"; $$WinMLRef) ] If [ MBS("ISError") ] Show Custom Dialog [ Title: "Failed to evaluate model"; Message: $Result; Default Button: “OK”, Commit: “Yes” ] Exit Script [ Result: $Result ] End If Set Field [ WindowsML::Result; $Result ] Perform Script [ “Show Results” ]
Fields used in this script	WindowsML::Image File Path WindowsML::Result
Scripts used in this script	Show Results
Layouts used in this script	WindowsML
Tables used in this script	WindowsML
Table occurrences used by this script	WindowsML
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Evaluate Model]

Next Script: [Start Script]

Script Name	Show Results
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script	Evaluate Model
Script Definition
Script Steps	Set Variable [ $list; Value:MBS( "JSON.GetObjectItem"; WindowsML::Result; "softmaxout_1"; 1) ] If [ MBS("IsError") = 0 ] Set Variable [ $count; Value:MBS( "JSON.GetArraySize"; $list) ] Set Variable [ $index; Value:0 ] If [ $index < $count ] Loop #your script steps here Set Variable [ $value; Value:MBS( "JSON.GetArrayItem"; $list; $index; 2) ] Set Variable [ $r; Value:MBS( "FM.ExecuteFileSQL"; ""; "UPDATE \"Result\" SET \"Probability\" = ? WHERE \"Index\" = ?" ; 9; 13; $value; $Index) ] #next Set Variable [ $index; Value:$index + 1 ] Exit Loop If [ $index ≥ $count ] End Loop End If Set Variable [ $r; Value:MBS( "JSON.Release"; $list) ] Go to Layout [ “Result” (Result) ] Show All Records Sort Records [ Keep records in sorted order; Specified Sort Order: Result::Probability; descending ] [ Restore; No dialog ] End If
Fields used in this script	WindowsML::Result Result::Probability
Scripts used in this script
Layouts used in this script	Result
Tables used in this script	Result WindowsML
Table occurrences used by this script	Result WindowsML
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Show Results]

Script Name	Start Script
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	Set Field [ WindowsML::Result; "" ] Set Field [ WindowsML::Model File Path; "" ] Set Field [ WindowsML::Image File Path; "" ] Set Field [ WindowsML::Model Description; "" ]
Fields used in this script	WindowsML::Result WindowsML::Model File Path WindowsML::Image File Path WindowsML::Model Description
Scripts used in this script
Layouts used in this script
Tables used in this script	WindowsML
Table occurrences used by this script	WindowsML
Custom Functions used by this script
Custom menu set used by this script

Download example: WindowsML

Used functions: