mbs filemaker plugin
play

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

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


  1. MBS FileMaker Plugin Christian Schmitz

  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.

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

  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

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

  6. Overview

  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

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

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

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

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

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

  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

  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

  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

  16. Styled Text in DynaPDF DynaPDF 4.0 Hello World Hello World red blue green red blue green 14 point 14 point 10 point 10 point bold , italic , underline, strikethrough bold , italic , underline, strikethrough Arial bold italic Arial bold italic Times bold italic Times bold italic Comic Sans bold italic Comic Sans bold italic test test

  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

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

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

  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

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

  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.

  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

  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

  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 )

  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

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

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

  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

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

  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

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

  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

  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

  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

  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

  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

  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

  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

  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

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

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

  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.

  44. Syntax Highlighting

  45. Contextmenu

  46. Contextual Menu Jump to script via context menu

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

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

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

  50. Windows MAPI

  51. Notifications

  52. 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

  53. Social Message Dialog

  54. Email & Text Messages

  55. 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

  56. Core ML

  57. Image View

  58. Resizable field picker

  59. Resizable palettes

  60. Show Table & Field IDs

  61. Script IDs

  62. Version 7.5 beta Replace Image in PDF with DynaPDF Evaluate JavaScript on iOS without Webviewer

  63. Replace images in PDFs

  64. 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

  65. Demo

Download Presentation
Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

Recommend


More recommend