Monkeybread Software - MBS FileMaker Plugin: Swiss Post Addresscheck V4-02-00

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

MBS FileMaker Plugin Example Databases

Swiss Post Addresscheck V4-02-00

All examples are included with download of MBS FileMaker Plugin.

Swiss Post Addresscheck V4-02-00.fmp12

Overview
Tables	1
Relationships	0
Layouts	1
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
Test	14 fields defined, 1 record	Test

Fields

Table Name: Test - 14 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
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		Test		Run
Text	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Test		Run
Debug	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Test		Run
XML Template	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		Test		Run
Username	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Test		Run
Passwort	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Test		Run
Names	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Test		Run
Street	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Test		Run
Number	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Test		Run
Zip	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Test		Run
Town	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Test		Run
OutputStreetFormatted	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Test		Run
OutputTown	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Test		Run
OutputZip	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		Test		Run

Layout Objects: Test

Regular Fields

Field Name: Test::Result

Layout Name:

Test

Top: 78 pt
Left: 138 pt
Bottom: 92 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: Test::Text

Layout Name:

Test

Top: 96 pt
Left: 138 pt
Bottom: 224 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: Test::Debug

Layout Name:

Test

Top: 228 pt
Left: 138 pt
Bottom: 524 pt
Right: 547 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: Test::XML Template

Layout Name:

Test

Top: 565 pt
Left: 138 pt
Bottom: 579 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

Field Name: Test::Username

Layout Name:

Test

Top: 79 pt
Left: 636 pt
Bottom: 93 pt
Right: 889 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: Test::Passwort

Layout Name:

Test

Top: 97 pt
Left: 636 pt
Bottom: 111 pt
Right: 889 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: Test::Names

Layout Name:

Test

Top: 145 pt
Left: 636 pt
Bottom: 159 pt
Right: 889 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: Test::Street

Layout Name:

Test

Top: 181 pt
Left: 636 pt
Bottom: 195 pt
Right: 889 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: Test::Number

Layout Name:

Test

Top: 199 pt
Left: 636 pt
Bottom: 213 pt
Right: 889 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: Test::Town

Layout Name:

Test

Top: 217 pt
Left: 636 pt
Bottom: 231 pt
Right: 889 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: Test::Zip

Layout Name:

Test

Top: 235 pt
Left: 636 pt
Bottom: 249 pt
Right: 889 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: Test::OutputStreetFormatted

Layout Name:

Test

Top: 295 pt
Left: 636 pt
Bottom: 309 pt
Right: 889 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: Test::OutputTown

Layout Name:

Test

Top: 313 pt
Left: 636 pt
Bottom: 327 pt
Right: 889 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: Test::OutputZip

Layout Name:

Test

Top: 331 pt
Left: 636 pt
Bottom: 345 pt
Right: 889 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: Test::XML Template

Layout Name:

Test

Top: 409 pt
Left: 647 pt
Bottom: 423 pt
Right: 900 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: Run Query

Layout Name:

Test

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 102 pt
Left: 408 pt
Bottom: 127 pt
Right: 541 pt

Anchoring: Left, Top

Perform Script [ “Run” ]

Scripts:

Button Properties

Coordinates

Script/Script Step

Type:

Text: Trace on

Layout Name:

Test

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 534 pt
Left: 12 pt
Bottom: 559 pt
Right: 145 pt

Anchoring: Left, Top

Set Variable [ $result; Value:MBS("Trace") ]

Script Hierarchy

Run

Script Name	Run
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	Test
Scripts that use this script
Script Definition
Script Steps	Set Variable [ $curl; Value:MBS("CURL.New") ] Set Variable [ $result; Value:MBS("CURL.SetOptionURL"; $curl; "https://webservices.post.ch/IN_ADRCHECKERxV4xEXTERNE/V4-02-00") ] Set Variable [ $xml; Value:Test::XML Template ] Set Variable [ $xml; Value:Substitute($xml; "$$CallUser$$"; MBS("Text.EncodeToXML"; Test::Username)) ] Set Variable [ $xml; Value:Substitute($xml; "$$Names$$"; MBS("Text.EncodeToXML";Test::Names)) ] Set Variable [ $xml; Value:Substitute($xml; "$$Street$$"; MBS("Text.EncodeToXML"; Test::Street)) ] Set Variable [ $xml; Value:Substitute($xml; "$$Town$$"; MBS("Text.EncodeToXML"; Test::Town)) ] Set Variable [ $xml; Value:Substitute($xml; "$$Zip$$"; MBS("Text.EncodeToXML"; Test::Zip)) ] Set Variable [ $xml; Value:Substitute($xml; "$$HouseNbr$$"; MBS("Text.EncodeToXML";Test::Number)) ] Set Variable [ $r; Value:MBS("CURL.SetOptionPostFields"; $curl; $xml) ] Set Variable [ $r; Value:MBS("CURL.SetOptionUserName"; $curl; Test::Username) ] Set Variable [ $r; Value:MBS("CURL.SetOptionPassword"; $curl; Test::Passwort) ] Set Variable [ $r; Value:MBS("CURL.SetOptionHTTPHeader"; $curl; "SOAPAction: \"http://post.ch/AdressCheckerExtern/V4-02-00\""; "Expect:"; "Content-Type: text/xml; charset=\"utf-8\"") ] Set Field [ Test::Result; MBS("CURL.Perform"; $curl) ] Set Field [ Test::Text; MBS("CURL.GetResultAsText"; $curl; "UTF8") ] Set Field [ Test::Debug; MBS("CURL.GetDebugMessages"; $curl) ] Set Field [ Test::OutputStreetFormatted; MBS( "XML.Query"; Test::Text; "//[local-name()='StreetFormatted']/text()"; ""; 2 ) ] Set Field [ Test::OutputTown; MBS( "XML.Query"; Test::Text; "//[local-name()='Town27']/text()"; ""; 2 ) ] Set Field [ Test::OutputZip; MBS( "XML.Query"; Test::Text; "//*[local-name()='Zip']/text()"; ""; 2 ) ] Set Variable [ $result; Value:MBS("CURL.Cleanup"; $curl) ]
Fields used in this script	Test::XML Template Test::Username Test::Names Test::Street Test::Town Test::Zip Test::Number Test::Passwort Test::Result Test::Text Test::Debug Test::OutputStreetFormatted Test::OutputTown Test::OutputZip
Scripts used in this script
Layouts used in this script
Tables used in this script	Test
Table occurrences used by this script	Test
Custom Functions used by this script
Custom menu set used by this script

Download example: Swiss Post Addresscheck V4-02-00

Used functions: