Monkeybread Software - MBS FileMaker Plugin: AVAsset Tracks

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

MBS FileMaker Plugin Example Databases

AVAsset Tracks

All examples are included with download of MBS FileMaker Plugin.

AVAsset Tracks.fmp12

Overview
Tables	1
Relationships	0
Layouts	1
Scripts	1
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	Off
OnLastWindowClose	Off
OnWindowOpen	Off
OnWindowClose	Off
OnFileAVPlayerChange	Off
Thumbnail Settings
Generate Thumbnails	On; Temporary

Tables

Table Name	Statistics	Occurrences in Relationship Graph
AVAsset Tracks	5 fields defined, 38 records	AVAsset Tracks

Fields

Table Name: AVAsset Tracks - 5 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
InputFile	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1		AVAsset Tracks		CheckTracks
TrackIndex	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		AVAsset Tracks		CheckTracks
Key	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		AVAsset Tracks		CheckTracks
Value	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		AVAsset Tracks		CheckTracks
Fields	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		AVAsset Tracks		CheckTracks

Layout Objects: AVAsset Tracks

Regular Fields

Field Name: AVAsset Tracks::InputFile

Layout Name:

AVAsset Tracks

Top: 10 pt
Left: 757 pt
Bottom: 135 pt
Right: 1010 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

Field Name: AVAsset Tracks::TrackIndex

Layout Name:

AVAsset Tracks

Top: 187 pt
Left: 8 pt
Bottom: 208 pt
Right: 109 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: AVAsset Tracks::Key

Layout Name:

AVAsset Tracks

Top: 187 pt
Left: 113 pt
Bottom: 208 pt
Right: 366 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: AVAsset Tracks::Value

Layout Name:

AVAsset Tracks

Top: 187 pt
Left: 370 pt
Bottom: 208 pt
Right: 801 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: AVAsset Tracks::Fields

Layout Name:

AVAsset Tracks

Top: 143 pt
Left: 757 pt
Bottom: 164 pt
Right: 1010 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

Type:

Text: Check Tracks

Layout Name:

AVAsset Tracks

Top: 83 pt
Left: 17 pt
Bottom: 115 pt
Right: 164 pt

Anchoring: Left, Top

Perform Script [ “CheckTracks” ]

Scripts:

CheckTracks

Script Hierarchy

CheckTracks

Script Name	CheckTracks
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	AVAsset Tracks
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $fieldCount; Value:ValueCount ( AVAsset Tracks::Fields ) ] Delete All Records [ No dialog ] Set Variable [ $asset; Value:MBS( "AVAsset.OpenContainer"; AVAsset Tracks::InputFile ) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $asset; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ] Else #Loop over all tracks Set Variable [ $TrackCount; Value:MBS( "AVAsset.TrackCount"; $asset ) ] Set Variable [ $TrackIndex; Value:0 ] Loop #Loop over all fields Set Variable [ $fieldIndex; Value:1 ] Loop #Query value for this field Set Variable [ $key; Value:GetValue(AVAsset Tracks::Fields; $fieldIndex) ] Set Variable [ $value; Value:MBS( "AVAsset.TrackInfo"; $Asset; $TrackIndex; $key ) ] #Put into record New Record/Request Set Field [ AVAsset Tracks::TrackIndex; $trackIndex+1 ] Set Field [ AVAsset Tracks::Key; $key ] Set Field [ AVAsset Tracks::Value; $value ] Commit Records/Requests [ No dialog ] #next Set Variable [ $fieldIndex; Value:$fieldIndex + 1 ] Exit Loop If [ $fieldIndex > $fieldCount ] End Loop #next Set Variable [ $TrackIndex; Value:$TrackIndex + 1 ] Exit Loop If [ $TrackIndex ≥ $TrackCount ] End Loop #Cleanup Set Variable [ $r; Value:MBS( "AVAsset.Release"; $asset ) ] End If
Fields used in this script	AVAsset Tracks::Fields AVAsset Tracks::InputFile AVAsset Tracks::TrackIndex AVAsset Tracks::Key AVAsset Tracks::Value
Scripts used in this script
Layouts used in this script
Tables used in this script	AVAsset Tracks
Table occurrences used by this script	AVAsset Tracks
Custom Functions used by this script
Custom menu set used by this script

Download example: AVAsset Tracks

Used functions: