The New Horizon: Script Transactions in Claris® FileMaker®

Script transactions in Claris FileMaker are finally here, but wait! Haven’t we done “transactions” in FileMaker for a long time? Yes and Yes. But script transactions are different and the main advantages, that I see, are the possibilities of simplifying code and improving solution performance. I’ll elaborate on these in this post. And, of course, there is also the inherent benefit of doing things transactionallyall or nothing is the law of the data.

Continue reading “The New Horizon: Script Transactions in Claris® FileMaker®”

Finer Faster FileMaker Precision: Measuring How Long It Takes

I often like to measure performance, because I am curious if some small change can lead to subtle, or maybe not so subtle, improvements. For the longest time my Swiss Army knife for measuring Claris® FileMaker® performance has been:

Get ( CurrentTimeUTCMilliseconds )

Continue reading “Finer Faster FileMaker Precision: Measuring How Long It Takes”

DIGFM December 2022 – Script Transactions in Claris FileMaker

Vince Menanno from Beezwax presents at DIGFM.

Let’s talk about Claris® FileMaker® and script transactions in FileMaker 19.6!

Continue reading “DIGFM December 2022 – Script Transactions in Claris FileMaker”

Beezwax Sponsors EngageU: The Biggest Claris® FileMaker® Developer Conference

Christos Savva and Vince Menanno Present Rapid Serverless Integrations and FileMaker Native Script Transactions

This week, Nov 13-15, we’re in Malmö, at EngageU. It’s the biggest Claris / FileMaker Developer community event worldwide in 2022. In fact, EngageU promises to be the largest in-person Claris Community event in Europe, ever!

Continue reading “Beezwax Sponsors EngageU: The Biggest Claris® FileMaker® Developer Conference”

Rome FileMaker® Week: Docker, Node-RED, Native Script Transactions and a Chatbot

Vincenzo Menanno and Fabio Bosisio from Beezwax present at Rome FileMaker Week.

This week we’re in Italy… formazione, condivisione e ancora divertimento [training, sharing and more fun] …with the focus on innovations in Claris® FileMaker platform development. As realtori [conference speakers] at Rome FileMaker Week (October 6-8), Vince Menanno and Fabio Bosisio from Beezwax present three sessions:

  • Local FileMaker Development with Docker and Node-RED
  • The New Horizon: Native Script Transactions in FileMaker
  • Chatbot
Continue reading “Rome FileMaker® Week: Docker, Node-RED, Native Script Transactions and a Chatbot”

CQDF Montreal 2022 – Claris FileMaker

La 7e Conférence québécoise des développeurs FileMaker (CQDF) 2022: les 15 et 16 Septembre 2022 à l’Auberge Saint-Gabriel, Montreal. Vincenzo Menanno, Beezwax, présente “Le nouvel horizon | Transactions de script natif” avec Claris (FileMaker) Pro.

Continue reading “CQDF Montreal 2022 – Claris FileMaker”

dotfmp.berlin Conference 2022

BERLIN, Germany – Our senior developer Christos Savva attended the dotfmp.berlin 2022 “Unconference” held in June in Berlin. The conference was the first in-person opportunity in over two years for leading Claris FileMaker developers across Europe to meet, share their work, and explore what’s happening in the developer community.

At dotfmp.berlin 2022, more than 70 developers from eighteen countries talked through tools and techniques from their Claris playgrounds. Adding to that excitement was participation by Claris’s engineering and product management teams.

Continue reading “dotfmp.berlin Conference 2022”

bBox v0.99 Integrates Claris FileMaker with JavaScript, Python 3 and Supports M1 Apple Silicon

We are pleased to release bBox version 0.99 for Claris® FileMaker® on macOS and Linux with new NodeJS and Python 3 integration, and M1 Apple silicon support for GraphicsMagick image processing and JQ JSON parsing functions.

About bBox Plug-in For FileMaker

bBox is a free utility plug-in to extend Claris FileMaker solutions to easily use macOS and Linux code libraries and functions from Python, JavaScript, PHP, Ruby, AppleScript, C/C++, Bash/sh, XPath, and SQLite. Also included is a demo file with more than 210 examples of how you can put bBox functions to work for you.

bBox is available on macOS and Linux, and runs with either FileMaker Pro or FileMaker Server. Here’s what FileMaker Magazine had to say about bBox version 0.99:

Continue reading “bBox v0.99 Integrates Claris FileMaker with JavaScript, Python 3 and Supports M1 Apple Silicon”

Claris Connect integrates Eversign, FileMaker and more

Let’s talk about Claris Connect as the way to orchestrate data-driven workflows involving Eversign digital signatures, Claris FileMaker, Slack and a range of other possible platforms! Fabio Bosisio from Beezwax will walk through details for setting up these types of integrations.

Continue reading “Claris Connect integrates Eversign, FileMaker and more”

A fast, flexible Tableau Connector for FileMaker

Building a custom Tableau® Connector for Claris® FileMaker® enables faster, more reliable and more flexible connections between Tableau and FileMaker datasources, compared with the legacy Web Data Connector.

For a number of Beezwax client projects, we’ve installed and deployed a Tableau Connector (aka “TACO”) for FileMaker. The TACO was built using the Tableau Connector SDK (provided by Tableau) to connect to datasources on FileMaker Server. The TACO method uses JDBC rather than the FileMaker Data API for the connection between FileMaker and Tableau, and in our testing the performance of data extracts was up to 10 times faster.

Continue reading “A fast, flexible Tableau Connector for FileMaker”

The Value and Benefits of Transactions with Claris FileMaker

Let’s talk about Claris® FileMaker® and transactions! Vincenzo Menanno discusses what transactions are, how they relate to FileMaker data operations (creating, updating, and deleting records), database normalization, and how to use transactional concepts to improve FileMaker performance, especially over a wide area network (WAN).

Continue reading “The Value and Benefits of Transactions with Claris FileMaker”

bBox for FileMaker v0.98 with M1, GraphicsMagick & Sips

We are pleased to release bBox version 0.98, with with new image file functions and M1/Apple Silicon support.

bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries and macOS-based functions from Python, JavaScript, PHP, Ruby, AppleScript, C/C++, Bash/sh, XPath, and SQLite. Also included is a demo file that has over 220 examples of how you can put bBox functions to work for you.

Some of the changes in version 0.98 are:

  • M1/Apple Silicon binary
  • Ubuntu compatible version (in addition to CentOS)
  • updated to libxml2 version 2.9.12
  • added bBox_GraphicsMagick function & script step
  • added bBox_Sips function & script step
  • modifications to several functions & script steps to add parameters
  • fixed template text used in several functions & script steps to better describe parameters
  • limit POSIX commands to 3 cores
  • new mode to combine stderr with stdout

Continue reading “bBox for FileMaker v0.98 with M1, GraphicsMagick & Sips”

FileMaker Performance on Apple M1 | Astounding!

When the Apple silicon Macs with M1 chips came out, I read and watched many of the reviews. Most of them had great things to say about the promise of Apple’s new M1 chip…I was impressed. When I finally received my Apple M1 MacBook Pro, and started to use it…I was amazed.

Back in 2020, FileMaker Pro 19.2 wasn’t optimized yet for Apple silicon processors, but ran fine under Rosetta emulation. On my M1 MacBook Pro, it already felt much faster than running FileMaker “natively” on an Intel-based MacBook…I was astonished.

Today, I’m running the just-released Claris FileMaker® 19.3, with native support for Apple’s M1 chip, on a new MacBook Pro. It is, in a word: Astounding!

Continue reading “FileMaker Performance on Apple M1 | Astounding!”

InspectorPro 7.2 for FileMaker – Faster on M1!

Everything about the M1 Apple silicon leaves you simply delighted and surprised. It’s like the first time you drive a super-charged Tesla and feel the rush of powerful acceleration OR I imagine it’s like when Han Solo first blasts the Falcon into light speed: it must be experienced to be believed.

Continue reading “InspectorPro 7.2 for FileMaker – Faster on M1!”

OData for FileMaker – Examples, Tips and Nuances

This blog post is the second of a three-part series about the FileMaker OData API, introducing a demo file with more than 40 examples plus helpful tips, along with Q&A. Part one of the series highlighted some of the key features of the API which make it an exciting addition to the FileMaker platform. As a follow-up, this post will cover the basics and dig into the nuances of using OData with Claris FileMaker.

Continue reading “OData for FileMaker – Examples, Tips and Nuances”

OData for FileMaker – New Player in an Old Game

This blog post is the first in a three-part series about the FileMaker OData API, highlighting key features that make it an exciting addition to the Claris FileMaker platform.

Continue reading “OData for FileMaker – New Player in an Old Game”

Using REST and cURL with FileMaker 19’s Data API

FileMaker 19 introduced a couple of important new features related to using the FileMaker Data API. Here, we’ll cover an overview of the new authorization endpoint, Validate Session, API versioning updates, as well as a new script step, Execute FileMaker Data API.

At the end of this article, you’ll find the demo file for learning more and trying out various REST and cURL functionality with FileMaker’s Data API. Enjoy!

Continue reading “Using REST and cURL with FileMaker 19’s Data API”

Connect FileMaker Server to Oracle Server and Oracle Cloud Using ODBC and TCPS

A longtime enterprise client recently asked us to integrate a FileMaker Server with an Oracle server. No problem, right? This task requires some development to optimize the database schema and script the data sync, but using FileMaker and an ODBC driver to connect to Oracle is straightforward.

Continue reading “Connect FileMaker Server to Oracle Server and Oracle Cloud Using ODBC and TCPS”

How to enable WebKit and JavaScript debugging in FileMaker Web Viewers

FileMaker supports bidirectional communication between a web viewer and data or scripts. So, you may find yourself doing more development using plenty of web code and JavaScript integrations.

If you’re having difficulty getting your HTML, CSS, or JavaScript to render in a FileMaker web viewer, there’s a great way to help inspect and fix it. You just need to know the hidden option to enable WebKit debugging in FileMaker web viewers.

Continue reading “How to enable WebKit and JavaScript debugging in FileMaker Web Viewers”

bBox for FileMaker v0.95 Now Available

We are pleased to release bBox version 0.95. bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries and macOS-based functions from Python, JavaScript, PHP, Ruby, AppleScript, Bash/sh, XPath, and SQLite. Also included is a demo file that has over 210 examples of how you can put bBox functions to work for you.

Continue reading “bBox for FileMaker v0.95 Now Available”

1 2 3