Monkeybread Software - MBS FileMaker Plugin: AVAsset Test

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

MBS FileMaker Plugin Example Databases

AVAsset Test

All examples are included with download of MBS FileMaker Plugin.

AVAsset Test.fmp12

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

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 Test	2 fields defined, 0 record	AVAsset Test
Images	3 fields defined, 0 record	Images
Metadata	3 fields defined, 0 record	Metadata

Fields

Table Name: AVAsset Test - 2 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
File	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		AVAsset Test		Analyze
ID	Normal, Number	Auto-Enter: Allow editing Serial: Generate: On creation, Next value: 1150, Increment: 1 Validation: Only during data entry Storage: Repetitions: 1 Indexing: All Index Language: German		AVAsset Test	AVAsset Test=Images AVAsset Test=Metadata	Analyze

Table Name: Images - 3 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
Image	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		AVAsset Test Images		Analyze
Time	Normal, Number	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		AVAsset Test Images		Analyze
MovieID	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German			AVAsset Test=Images	Analyze

Table Name: Metadata - 3 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
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 Test Metadata		Analyze
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 Test Metadata		Analyze
MovieID	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		Images Metadata	AVAsset Test=Metadata	Analyze

Relationship: AVAsset Test=Metadata

Table Occurrence	AVAsset Test		Metadata
Field	ID	=	MovieID
Source Table	AVAsset Test		Metadata
Source File	AVAsset Test.fmp12		AVAsset Test.fmp12
Allow creation of records via this relationship	Off		Off
Delete related records in this table when a record is deleted in the other table	Off		Off
Sort records	Off		Off

Layout Hierarchy

Save record changes automatically

Show field frames when record is active

Show field frames only on current record

Show current record indicator in List View

6 Regular Fields
1 Group Buttons
2 Portals

3 Regular Fields

Images

Off

Analyze

[File Default]

Metadata

Yes

3 Regular Fields

Metadata

Off

Analyze

[File Default]

Layout Objects: AVAsset Test

Regular Fields

Field Name: AVAsset Test::File

Layout Name:

AVAsset Test

Top: 42 pt
Left: 6 pt
Bottom: 155 pt
Right: 295 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Field Name: Metadata::Key

Layout Name:

AVAsset Test

Top: 187 pt
Left: 7 pt
Bottom: 201 pt
Right: 132 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Metadata::Value

Layout Name:

AVAsset Test

Top: 187 pt
Left: 133 pt
Bottom: 201 pt
Right: 293 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Images::Image

Layout Name:

AVAsset Test

Top: 43 pt
Left: 301 pt
Bottom: 129 pt
Right: 522 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Field Name: Images::Time

Layout Name:

AVAsset Test

Top: 43 pt
Left: 523 pt
Bottom: 57 pt
Right: 587 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: AVAsset Test::ID

Layout Name:

AVAsset Test

Top: 162 pt
Left: 20 pt
Bottom: 176 pt
Right: 111 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Type:

Text: Analyze

Layout Name:

AVAsset Test

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 156 pt
Left: 210 pt
Bottom: 181 pt
Right: 295 pt

Anchoring: Left, Top

Perform Script [ “Analyze” ]

Scripts:

Analyze

Table:

Metadata

Layout Name:

AVAsset Test

Top: 186 pt
Left: 6 pt
Bottom: 475 pt
Right: 295 pt

Anchoring: Left, Top

Field Objects

Metadata::Key at (187, 7, 201, 132)
Metadata::Value at (187, 133, 201, 293)

Sort records: Off
Filter calculation: None
Initial Row: 1
Number of Rows: 18

Table:

Images

Layout Name:

AVAsset Test

Top: 42 pt
Left: 300 pt
Bottom: 483 pt
Right: 589 pt

Anchoring: Left, Top

Field Objects

Images::Image at (43, 301, 129, 522)
Images::Time at (43, 523, 57, 587)

Sort records: Off
Filter calculation: None
Initial Row: 1
Number of Rows: 5
Show vertical scroll bar

Layout Objects: Images

Regular Fields

Field Name: Images::Image

Layout Name:

Images

Top: 24 pt
Left: 138 pt
Bottom: 233 pt
Right: 553 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Field Name: Images::Time

Layout Name:

Images

Top: 234 pt
Left: 138 pt
Bottom: 248 pt
Right: 217 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Metadata::MovieID

Layout Name:

Images

Top: 234 pt
Left: 300 pt
Bottom: 248 pt
Right: 553 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Layout Objects: Metadata

Regular Fields

Field Name: Metadata::Key

Layout Name:

Metadata

Top: 24 pt
Left: 138 pt
Bottom: 38 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Metadata::Value

Layout Name:

Metadata

Top: 42 pt
Left: 138 pt
Bottom: 56 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: Metadata::MovieID

Layout Name:

Metadata

Top: 59 pt
Left: 138 pt
Bottom: 73 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Script Hierarchy

Analyze

Script Name	Analyze
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	AVAsset Test
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $MovieID; Value:AVAsset Test::ID ] #open from container Set Variable [ $asset; Value:MBS("AVAsset.OpenContainer"; AVAsset Test::File) ] If [ MBS("iserror") ] Show Custom Dialog [ Message: "Failed to load video." & ¶&¶ & $asset; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ] Exit Script [ Result: 0 ] End If Pause/Resume Script [ Duration (seconds): ,2 ] #check duration Set Variable [ $duration; Value:MBS("AVAsset.Duration"; $asset) ] Show Custom Dialog [ Title: "Loaded video"; Message: "Duration: " & $duration; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ] #check metadata Set Variable [ $formats; Value:MBS("AVAsset.AvailableMetadataFormats"; $asset) ] Set Variable [ $keys; Value:MBS("AVAsset.MetadataKeys"; $asset) ] Set Variable [ $count; Value:ValueCount ( $keys ) ] Set Variable [ $index; Value:1 ] Go to Layout [ “Metadata” (Metadata) ] Delete All Records [ No dialog ] If [ $count > 0 ] Loop #show key Set Variable [ $key; Value:GetValue($keys; $index) ] Exit Loop If [ $key = "" ] Set Variable [ $value; Value:MBS("AVAsset.Metadata"; $asset; $key) ] New Record/Request Set Field [ Metadata::Key; $key ] Set Field [ Metadata::Value; $value ] Set Field [ Metadata::MovieID; $MovieID ] Commit Records/Requests [ Skip data entry validation; No dialog ] #next Set Variable [ $index; Value:$index + 1 ] Exit Loop If [ $count = $index ] End Loop End If Go to Layout [ original layout ] #get some pictures Set Variable [ $offset; Value:10 ] Set Variable [ $duration; Value:$duration - 20 ] Go to Layout [ “Images” (Images) ] Delete All Records [ No dialog ] If [ $Duration > 10 ] Set Variable [ $index; Value:0 ] Loop #show key Set Variable [ $time; Value:$index * $duration / 10 + $offset ] Exit Loop If [ $time > $duration ] Set Variable [ $image; Value:MBS("AVAsset.Image"; $asset; $time; "png"; "preview.png") ] New Record/Request Set Field [ Images::Image; $image ] Set Field [ Images::Time; $time ] Set Field [ Images::MovieID; $MovieID ] Commit Records/Requests [ Skip data entry validation; No dialog ] #next Set Variable [ $index; Value:$index + 1 ] End Loop End If Go to Layout [ original layout ] #cleanup Set Variable [ $r; Value:MBS("AVAsset.Release"; $asset) ]
Fields used in this script	AVAsset Test::ID AVAsset Test::File Metadata::Key Metadata::Value Metadata::MovieID Images::Image Images::Time Images::MovieID
Scripts used in this script
Layouts used in this script	Metadata Images
Tables used in this script	AVAsset Test Images Metadata
Table occurrences used by this script	AVAsset Test Images Metadata
Custom Functions used by this script
Custom menu set used by this script

Download example: AVAsset Test

Used functions: