Handling Historical Data with FileMaker and AWS Athena, S3 & Serverless

In this blog post, we will explore a solution for optimising a FileMaker app that handles large amounts of data. We will address the challenges of data storage, file corruption, and performance degradation when dealing with historical data.

By leveraging cloud storage and serverless computing, we can offload and query this data efficiently, ensuring better performance and scalability.

Continue reading “Handling Historical Data with FileMaker and AWS Athena, S3 & Serverless”

FM-DiSC: Handling Historical Data with FileMaker, AWS Athena, S3, Serverless

Fabio Bosisio from Beezwax demonstrates handling historical data in a Claris® FileMaker® solution, utilizing a combination of AWS services including AWS Serverless, AWS S3, and Amazon Athena’s Interactive SQL. Use cases include archiving, data mining, and reporting.

Continue reading “FM-DiSC: Handling Historical Data with FileMaker, AWS Athena, S3, Serverless”

demystify FileMaker and JavaScript [FM-JS]

You’re invited to explore this demystify(FM-JS) blog post and download this demo file – as you embark on expanding your Claris® FileMaker® solutions into the vast and captivating realm of JavaScript.

Continue reading “demystify FileMaker and JavaScript [FM-JS]”

dotfmp: Python + Claris® FileMaker® | Historical Data & AWS Athena/SQS/S3 | UX & DX for Great Solutions

Christos Savva, Fabio Bosisio and Vince Menanno from Beezwax present at dotfmp Berlin, 2023.

This week we’re in Berlin… one of the stops on the Road to Claris Engage 2024 …gathering with the developer community, and highlighting innovation for the Claris FileMaker platform development. As conference speakers at dotfmp Berlin (June 1-3), Christos Savva, Fabio Bosisio and Vince Menanno from Beezwax present three sessions:

  • Enhancing FileMaker with Python
  • What do you do with all this historical data in your app? [AWS Athena Interactive SQL / Serverless / S3 with FileMaker]
  • Elements for Building Great Solutions [FileMaker UX & DX]
Continue reading “dotfmp: Python + Claris® FileMaker® | Historical Data & AWS Athena/SQS/S3 | UX & DX for Great Solutions”

End to End Web Integration for Claris® Platforms

Alec Gregory from Beezwax presents at the Claris Beyond Meetup.

Let’s talk about building web UIs, JavaScript functions and new integrations for Claris FileMaker and Claris Pro. Learn how you can manage various stages of the web integration process with the open source bzBond.

Continue reading “End to End Web Integration for Claris® Platforms”

Web UI and JavaScript with Claris® FileMaker®

Alec Gregory from Beezwax presents at DIGFM & Bay Area FileMaker Developer Meetup.

Let’s talk about building web UIs and JavaScript functions using Claris FileMaker.

Continue reading “Web UI and JavaScript with Claris® FileMaker®”

Data Visualization in FileMaker Web Viewer

Alec Gregory from Beezwax presents at the Claris FileMaker for Research User Group.

Let’s talk about Claris® FileMaker® and data visualization with FileMaker 19 web viewer, and developing with open source tools!

Continue reading “Data Visualization in FileMaker Web Viewer”

Panel & Networking: How Technology Can Lead The Way For Digital Transformation

As each of our clients weathers unique challenges, “digital transformation” comes to mind as something that exists in different stages. Some organizations are long-since transformed by technology, while others shifted more recently toward work dominated by the distributed as well as the digital.

In building custom applications to automate workflows, streamline operations and leverage technical advantages through innovation, we harness the power of digital transformation. We’re helping many organizations maintain existing momentum to position themselves for positive upswings, and others to recover from economic downturns, overcome turbulence in operations, or head off uncertainty about technical resources.

Digital transformation supports organizational transformation. And it can also lead this transition.

Continue reading “Panel & Networking: How Technology Can Lead The Way For Digital Transformation”

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”

Apple WWDC 2022 and beyond

The 2022 Apple Worldwide Developers Conference (WWDC) highlighted new ways for developers to build with APIs, introducing updates to Swift® and Safari®, revealing improvements in accessibility, and uncovering a mountain of innovative product upgrades and releases. We’re sharing a summary of news and resources we collected from WWDC 2022 sessions, along with an ongoing series of updates to this blog post.

Continue reading “Apple WWDC 2022 and beyond”

The Metadata-verse: FileMaker Server Save as XML

As Claris gets further into an Agile groove, there are product releases more often, always with new features and improvements. Claris FileMaker 19.5 is no exception. It includes many new features, expanded extensibility, performance enhancements, and reliability improvements. I want to bring attention to one simple thing that promises to change the world for many of us in the FileMaker developer community: Save a Copy as XML…and the performance improvements running this on FileMaker Server.

Continue reading “The Metadata-verse: FileMaker Server Save as XML”

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 [Xodo Sign], FileMaker and more

Let’s talk about Claris Connect as the way to orchestrate data-driven workflows involving Xodo Sign (formerly 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 [Xodo Sign], 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”

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”

Integrating FileMaker’s Data API and Ruby with the fmrest-ruby gem

We often work on projects that intersect two technologies near and dear to us: FileMaker and Ruby. This allows us to build robust web applications in Ruby on Rails, integrated with data sources from FileMaker solutions. When Claris introduced the FileMaker Data API we were naturally curious to try it out. At the time there was no off-the-shelf Ruby library for us to simply gem install, so we decided to roll up our sleeves and build one. Thus, fmrest-ruby was born.

This article will walk you through setting up and using fmrest-ruby in a Ruby on Rails project. Some level of familiarity with Ruby/Rails and FileMaker’s Data API is advised, although much of the content covered here is applicable to any Ruby project, Rails or not.

Continue reading “Integrating FileMaker’s Data API and Ruby with the fmrest-ruby gem”

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’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’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”
1 2 3