MBS FileMaker Plugin Christian Schmitz Monkeybread Software MBS - - PowerPoint PPT Presentation

▶
mbs filemaker plugin
SMART_READER_LITE
LIVE PREVIEW

MBS FileMaker Plugin Christian Schmitz Monkeybread Software MBS - - PowerPoint PPT Presentation

Apr 14, 2023 254 likes •939 views

MBS FileMaker Plugin Christian Schmitz Monkeybread Software MBS FileMaker Plugin 4900 functions 648 new functions in 2015 852 new functions in 2016 635 new functions in 2017 already 500 example databases. MBS FileMaker Plugin One Plugin

slide-1
SLIDE 1

MBS FileMaker Plugin

Christian Schmitz

slide-2
SLIDE 2

Monkeybread Software

MBS FileMaker Plugin 4900 functions 648 new functions in 2015 852 new functions in 2016 635 new functions in 2017 already 500 example databases.

slide-3
SLIDE 3

MBS FileMaker Plugin

One Plugin file Easy to install & update supporting FileMaker 8.5 and newer FileMaker 16 fully supported since 7.2

slide-4
SLIDE 4

MBS FileMaker Plugin

FileMaker Pro, Advanced & Runtime FileMaker Server, Custom Web Publishing & Web Direct FileMaker Cloud with Linux FileMaker iOS SDK FileMaker Go only via Perform Script on Server

slide-5
SLIDE 5

One central MBS function First Parameter = Function Name Can be calculated or from field Check for errors using MBS("IsError") Reference parameters for objects

MBS FileMaker Plugin

slide-6
SLIDE 6

Overview

slide-7
SLIDE 7

CURL

HTTP, FTP, SFTP Up/Download SSL/TLS, Proxy & Authentication Sync, Async or Background transfers parallel transfers Custom Requests Delete & Rename files for FTP

slide-8
SLIDE 8

CURL & WebServices

SOAP, REST & others HTTPS with TLSv1.2 Custom HTTP headers JSON & XML functions Send form data

slide-9
SLIDE 9

CURL & Email

Send Emails Multiple attachments HTML & plain text Proper text encoding Batch email send example with parallel transfers & reusing connections

slide-10
SLIDE 10

CURL & Email

Receive email IMAP & POP3 Extract subject, recipients, text, html, attachments & headers IMAP delete/move email Detect duplicates

slide-11
SLIDE 11

PDF

PDFKit Mac only framework from Apple Limited to PDF features supported by Apple DynaPDF Cross platform PDF Library Extra license

slide-12
SLIDE 12

PDFKit & DynaPDF

Merge PDFs Split PDFs Render picture from pages Print: PDFKit on Mac, DynaPDF on Win Extract text

slide-13
SLIDE 13

DynaPDF

Create, Edit, Merge & Render PDFs Convert PDF to PDF/A & PDF/X Embed XML in PDF for invoices Create/Set/Query form fields Extract images, text in area Encrypt/Decrypt with password

slide-14
SLIDE 14

DynaPDF

Find & Highlight text Find & Replace text Use Tables for Layouts Add, query, remove & flatten annotations Add links to pages or URLs Digitally sign PDF file

slide-15
SLIDE 15

DynaPDF

Optimize PDF files Recreate structure to fix errors Scale down images & convert to JPEG Replace duplicate fonts and images with references Remove private data

slide-16
SLIDE 16

Styled Text in DynaPDF

Hello World red blue green

14 point 10 point

bold, italic, underline, strikethrough Arial bold italic Times bold italic Comic Sans bold italic

test

Hello World red blue green

14 point

10 point

bold, italic, underline, strikethrough Arial bold italic Times bold italic Comic Sans bold italic

test

DynaPDF 4.0

slide-17
SLIDE 17

Encryption & Hash

Elliptic Curve Digital Signatures RSA Signatures & Encryption AES & Blowfish Encryption SHA2 with up to 512 bit Encrypt & Hash container, files, texts HMAC & PBKDF2

slide-18
SLIDE 18

Data Structures

Global Variables Independent of database Dictionary: Assoziative Arrays Key ➜ Value Preserves data types QuickList Indexed list of text in memory

slide-19
SLIDE 19

Word Files

Open Word file (docx) Query Texts Replace Placeholders with Text Add table rows Write docx file e.g. for bulk letter

slide-20
SLIDE 20

AV Recording

Record Audio/Video for Mac to M4V file for Windows to AVI file List audio/video devices & select Show preview in layout Take snapshot

slide-21
SLIDE 21

Clipboard

Get & Set clipboard without field HTML, RTF & styled text File path/references Picture FileMaker XML Data formats Scripts, Layouts, Custom Functions…

slide-22
SLIDE 22

Addressbook

Access Contacts on Mac Sync to Exchange & Google Create, change and edit people/groups Search for contacts Open in Contacts.app Mac only.

slide-23
SLIDE 23

FileMaker SQL

Insert/Delete/Update records easily Preserves data types Insert Records via Query copy records to other table/file Insert Records from Tab/Return text Select containers & dates without text conversion

slide-24
SLIDE 24

SQL to others

Connect to other databases with native drivers. In Script & independent from ESS Oracle, Microsoft SQL Server, DB2, Sybase, SQL Anywhere, Informix, FireBird, InterBase, SQLBase, MySQL, MariaDB, PostgreSQL, ODBC and SQLite Copy records from/to FileMaker

slide-25
SLIDE 25

Schedules

Run script by name from any file. Schedule Start Script, Run SQL and Evaluate in time, at time, timestamp or on idle Query, cancel and modify schedules Logout user or leave field on idle MBS( "Schedule.StartScriptAfterDelay"; 10; Get(FileName); "testScript"; $param )

slide-26
SLIDE 26

File Functions

Copy, Move, Rename, Delete files/folders Query file information like size, dates, tags Mount/Unmount network volumes Query disk info, free disk space Check if file is in use

slide-27
SLIDE 27

Image Editing

Load images and convert formats Scale, Rotate, Compose & Mirror Draw vector graphics and text Find position of images Read EXIF/IPTC

slide-28
SLIDE 28

Hotkeys

Define Hotkeys Trigger script or evaluate on keydown Shift, Option, Command, Control + key Mac & Windows

slide-29
SLIDE 29

TouchBar

Create buttons for TouchBar with Text & Image TouchBar per window & per app Trigger script or evaluation Show/hide debugger & data viewer in FileMaker Switch TouchBars on layout change Only for macOS 10.12.2 or newer

slide-30
SLIDE 30

JSON & XML Import

Read JSON or XML file Detect records Create automagically tables & fields Import records Build your layouts / scripts after first import

slide-31
SLIDE 31

Webviewer

Run JavaScript in Webviewer Get current HTML & Text Query & fill form fields Read text, links & images Print web page Render image or PDF

slide-32
SLIDE 32

Sockets

TCP & UDP sockets Script trigger for incoming data UDP broadcast & multicast ServerSocket for incoming connections IPv6 & IPv4 SSL optional

slide-33
SLIDE 33

SerialPorts

Connect to serial ports USB to Serial adapters Trigger script for incoming data Line based reading Configure Data Bits, Stop Bits, Parity & Baud Rates DTR, DSR, CTS, RTS, XON

slide-34
SLIDE 34

Calendars / Reminders

Create, Query, Edit and Delete events & reminders Ask for permissions Add alarms & recurrence rules Synchronize to iPhone, Google, Exchange New Events functions for iOS & 64-bit Mac Old Calendar functions for 32 & 64-bit Mac

slide-35
SLIDE 35

Printing

List printers Control print dialog on Mac Print to PDF file Print on Windows with options (new in 6.5) Switch printer, paper, tray & more

slide-36
SLIDE 36

Utility

Change Dock icon & App Name Speak text on Mac & Win without crash Measure text width Detect right clicks Automatically generate database design report

slide-37
SLIDE 37

Utility

Query Windows Management Instrumentation Zip/Unzip files Send / listen for notifications Disable App Nap Login via SSH to other computer and run commands. LDAP / Active Directory

slide-38
SLIDE 38

Scan Documents

Flatbed & Document Feeders ImageCapture for Mac Windows Image Acquisition Twain for Mac & Win (deprecated) With or without dialog OCR to recognize text

slide-39
SLIDE 39

Java

Use any Java Version Create Java object from class Set/Query properties Call methods Automatic data type conversion Interface to existing Java code

slide-40
SLIDE 40

FileSystem Events

Monitor folder for changes DirectoryWatcher for Windows (new in 7.1) watch folder FSEvents for Mac watch folder or whole disk with history

slide-41
SLIDE 41

Menus

Show contextual menus Submenus With font styles With icons With color Trigger script on selection

slide-42
SLIDE 42

Scroll Elasticity

Scroll over edge Off, On or Auto for Layout and List

slide-43
SLIDE 43

Syntax Highlighting

Rule based calculation and script coloring Context Menus If/Loop block highlighting Relation Ship Graph search Script search GoTo Line All Mac only.

slide-44
SLIDE 44

Syntax Highlighting

slide-45
SLIDE 45

Contextmenu

slide-46
SLIDE 46

Contextual Menu

Jump to script via context menu

slide-47
SLIDE 47
slide-48
SLIDE 48

XML

Query subtrees Extract text values Set Variables based on XML List, query/set attributes List node names

slide-49
SLIDE 49

Version 7.2

Windows User Notifications Windows Registry CURL with system certificates Changes for FileMaker 16 Webviewer rewritten Syntax Highlighting adjusted MBS Script Step

slide-50
SLIDE 50

Windows MAPI

Send email via client on Windows Outlook, Thunderbird, … Add attachments Can do HTML Multiple recipients

slide-51
SLIDE 51

Windows MAPI

slide-52
SLIDE 52

Notifications

slide-53
SLIDE 53
slide-54
SLIDE 54

Version 7.3

Read/Write binary files Control AVPlayer on iOS Parse once & query often XML files Card Window mouse click trigger Dialog positions SQL.InsertOrUpdateRecords

slide-55
SLIDE 55

Social Message Dialog

slide-56
SLIDE 56

Email & Text Messages

slide-57
SLIDE 57

Version 7.4

CoreImage detection of faces, rectangles, texts & QRCodes iOS Keyboard show/hide triggers Import CSV Set or query values in XML by path WebViewer Copy, Cut & Paste AVPlayer trigger SerialPort pause/resume

slide-58
SLIDE 58

Core ML

slide-59
SLIDE 59

Image View

slide-60
SLIDE 60

Resizable field picker

slide-61
SLIDE 61

Resizable palettes

slide-62
SLIDE 62

Show Table & Field IDs

slide-63
SLIDE 63

Script IDs

slide-64
SLIDE 64

Version 7.5 beta

Replace Image in PDF with DynaPDF Evaluate JavaScript on iOS without Webviewer

slide-65
SLIDE 65

Replace images in PDFs

slide-66
SLIDE 66

Ressources

Website
 http://www.monkeybreadsoftware.com/filemaker/ Videos
 http://www.mbsplugins.com Blog
 http://www.mbs-plugins.com Mailing List
 http://www.monkeybreadsoftware.com/filemaker/ mailinglist.shtml

slide-67
SLIDE 67

Demo