FileMaker Meeting in Colonge

FileMaker Stammtisch Köln

5th March, 19:00 Uhr in the Pohlhof restaurant.

Pohlhofstr. 3, 50765 Köln, www.pohlhof.de

Let's talk about what's new in FileMaker. And who is going to San Antonio?

New universal Hash and Encrypt functions for MBS FileMaker Plugin

With latest prerelease we add two very universal hash and encryption functions:

MBS( "Hash.Digest"; Algorithm; InputType; InputData; InputEncoding; OutputType; OutputInfo )
and
MBS( "Encryption.Cipher"; Direction; Algorithm; KeyType; KeyData; KeyEncoding; InputType; InputData; InputEncoding; OutputType; OutputInfo; IVType; IVData; IVEncoding )

The Hash.Digest function can calculate hashes. For Algorithm we support MD4, MD5, SHA, SHA1, MDC2, RIPEMD160, SHA224, SHA256, SHA384 or SHA512. You pass input data and receive the hash in the requested output format.

The Encryption.Cipher function is a little bit more complex. First you pass direction which can be "encrypt" or "decrypt". Than you pass algorithm. We have a lot of combinations of algorithms, bit depths and block cipher mode as you below in the list. Finally you pass input data and receive the encrypted data in the requested output format.

Supported encryption algorithms:

AES-128-CFB, BF-CBC, BF-CFB, BF-ECB, BF-OFB, AES-128-CBC, id-aes128-CCM, AES-128-CFB1, AES-128-CFB8, AES-128-CTR, AES-128-ECB, id-aes128-GCM, AES-128-OFB, AES-128-XTS, AES-192-CBC, id-aes192-CCM, AES-192-CFB1, AES-192-CFB8, AES-192-CFB, AES-192-CTR, AES-192-ECB, id-aes192-GCM, AES-192-OFB, AES-256-CBC, id-aes256-CCM, AES-256-CFB1, AES-256-CFB8, AES-256-CFB, AES-256-CTR, AES-256-ECB, id-aes256-GCM, AES-256-OFB, AES-256-XTS, CAMELLIA-128-CBC, CAMELLIA-128-CFB1, CAMELLIA-128-CFB8, CAMELLIA-128-CFB, CAMELLIA-128-ECB, CAMELLIA-128-OFB, CAMELLIA-192-CBC, CAMELLIA-192-CFB1, CAMELLIA-192-CFB8, CAMELLIA-192-CFB, CAMELLIA-192-ECB, CAMELLIA-192-OFB, CAMELLIA-256-CBC, CAMELLIA-256-CFB1, CAMELLIA-256-CFB8, CAMELLIA-256-CFB, CAMELLIA-256-ECB, CAMELLIA-256-OFB, CAST5-CBC, CAST5-CFB, CAST5-ECB, CAST5-OFB, DES-EDE, DES-EDE-CBC, DES-EDE-CFB, DES-EDE, DES-EDE-OFB, DES-EDE3, DES-EDE3-CBC, DES-EDE3-CFB1, DES-EDE3-CFB8, DES-EDE3-CFB, DES-EDE3, DES-EDE3-OFB, RC2-40-CBC, RC2-64-CBC, RC2-CBC, RC2-CFB, RC2-ECB, RC2-OFB, RC4, RC4-40, RC4-HMAC-MD5, IDEA-CFB, IDEA-ECB, IDEA-OFB, IDEA-CBC, DES-CFB1, DES-CFB8, DES-CFB, DES-OFB, DES-ECB, DES-CBC or DESX-CBC.

Input data

For input, initial values or key, you pass input with type, data and info. Type can be one of several types: Text, Container, Image, Path, PDF, Data, base64 or Hex. For example you can pass type "text", the actual text with the data parameter and the text encoding to use with the info parameter. If you prefer to pass in a hex string as data, than please pass "hex" as type. You can also pass a file path if type is "path" to read a file. Finally you can pass container values. As type you can pass "Data" to read main stream of container, "Image" to accept any image in the container or "FILE", "PDF", "JPEG", "PNG", "TIFF" or "GIF" for a specific stream in container. If you pass "Container" as type, the container is packed and passed with all streams, so after decrypting you will have the same container back.

For output you can select between various formats: Base64, Hex, Text, File, Path, GIF, TIFF, PNG, PDF, JPEG or Container. So if you encrypted something you can output it to a file on disk (type path), as base64 or hex encoded text or as a container with a FILE stream. After decrypting the data you can return it as text with a specific encoding, write it to a file (type path) or return as container with a specific stream, FILE stream or an unpacked container.

Examples

Calculate MD5 from text:
MBS( "Hash.Digest"; "MD5"; "Text"; "Hello World"; "UTF-8"; "Hex"; "" )

Calculate SHA512 from image in container and encode it as base64:
MBS( "Hash.Digest"; "SHA512"; "Image"; MyTable::MyContainer; ""; "Base64"; "" )

Encrypts some text with AES:
MBS( "Encryption.Cipher"; "encrypt"; "AES-128-CFB"; "Text"; "Test Key"; "UTF-8"; "Text"; "Hello World"; "UTF-8"; "Hex"; "" )

Encrypts a container:
MBS( "Encryption.Cipher"; "encrypt"; "AES-256-ECB"; "Hex"; "1234567812345678"; ""; "Container"; MyTable::MyContainer; ""; "FILE"; "data.dat" )

and decrypt the container:
MBS( "Encryption.Cipher"; "decrypt"; "AES-256-ECB"; "Hex"; "1234567812345678"; ""; "FILE"; MyTable::MyEncryptedContainer; ""; "Container"; "" )

MBS Filemaker Plugin, version 4.1pr2

New in this prerelease of the 4.1 plugins:

• Added new functions Encryption.Cipher and Hash.Digest with a lot of options.
• Fixed a build problem on Windows where some parts where not probably recompiled for 4.0 release (plugin still reported version 3.5).
• Added Dialog functions for showing message dialogs.
• Improved Form Utility. New menu command to open file. If field or form names are not unique, we use index, not name. Retina is now supported and last 10 URLs are saved in preference file.

Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Plugin Decision Graph

Just created a plugin decision graph for which plugin file to use for which FileMaker version for Pro or Server.

The rules are here:

• For FileMaker Pro you need the 32bit version.
• For FileMaker Server 12 with WebPublishing and for Filemaker 13, you need 64bit plugin.
• For FileMaker Server 12 with scheduled scripts you need 32 bit plugin.
• But for FileMaker Server 11 you need 32bit version.

Now as you know which you need, you can pick the right plugin from our archive.

For Mac the plugin in the server folder has 64bit and 32bit code, so you can use it for all FileMaker versions on Mac with Pro and Server.
For Windows, you either need the fmx file or the fmx64 file.

Download image: plugindecision.jpg

MBS Filemaker Plugin, version 4.1pr1

New in this prerelease of the 4.1 plugins:

• Fixed bug with Mac file path handling for our text functions. String.ReadTextFile for example failed.
• Fixed problem with DynaPDF.OpenPDFFromContainer crashing if you passed empty container.
• Changed Trace command to no longer show serial number.
• Added WebViewer functions to zoom page or text.
• Added DynaPDF.FindText function.
• Fixed caching issue with calendar and addressbook script notifications.

Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

MBS FileMaker Plugin 4.0 for OS X/Windows - More than 2200 Functions In One Plugin

Nickenich, Germany - MonkeyBread Software today is pleased to announce MBS FileMaker Plugin 4.0 for Mac OS X or Windows, the latest update to their product that is easily the most powerful plugin currently available for FileMaker Pro. As the leading database management solution for Windows, Mac, and the web, the FileMaker Pro Integrated Development Environment supports a plugin architecture that can easily extend the feature set of the application. MBS FileMaker Plugin 4.0 has been updated and now includes over 2200 different functions, and the versatile plugin has gained more new functions:

• For PDFKit on Mac OS X we added functions to print PDFs directly without dialogs to a printer. If that printer is a fax, you may also be able to fax the PDF. Various options can be controlled like the target printer, page format or the fax number.
• With new functions for QuickTime on Mac OS X you can open movie files, query metadata and create preview pictures. Also you can play sound files directly.
• For Mac OS X we have a new function for the webviewer. You can directly print the current website to a PDF file and archive it.
• For DynaPDF, our cross platform PDF engine, we have new functions related for form fields. You can query field information, get and set form values. Functions for bookmarks help you manage the list of content. You can add clickable link areas in your PDF to point to a website (URL) or to a page of your current PDF. For Windows we can generate previews for PDF files for showing them in a container. Our text highlighting function got improvements to handle case insensitive searches and ignore accents for better search results. Finally we have parse content function so you can extract the commands needed to draw a page.
• The CURL functions for upload, download or email sending can now handle PDFs much easier. The function Process.IsRunning can check if a certain application is running. For our global variables defined by the plugin you can now get the list of all variables.
• New JSON functions allow the querying of objects much easier. You can now create SHA512/256 HMAC hashes much easier, often used for passwords on web services.

More details in the release notes. Please take the time to check our 200 example databases and check where you can use our plugin features in your solutions.