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”

Q Foundation – Increased Agility For Social Services

Beezwax helped the Q Foundation get ahead of a persistent pandemic and quickly pivot to decentralized operations to support a remote workforce.

Continue reading “Q Foundation – Increased Agility For Social Services”

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!”

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”

Show me external vs. embedded containers in FileMaker

Dear InspectorPro: Can you show me a report on the container fields used in my FileMaker solution, with a list of all externally-referenced vs. internally-stored (“embedded”) fields? Sincerely, Thanks in Advance-d.

Continue reading “Show me external vs. embedded containers in FileMaker”

Using Siri with FileMaker, via iOS Shortcuts

“Hey Siri…Ask FileMaker…”

This story started when we explored iOS Shortcuts to the FileMaker Data API. As we continue to automate tasks by mixing together iOS apps, content on mobile devices and web APIs plus FileMaker, let’s add to our workflow using one of the most powerful functions available to iPhone and iPad users: Siri.

Continue reading “Using Siri with FileMaker, via iOS Shortcuts”

Creating Your Own SSL Certificates For FileMaker

Typically, you buy an SSL certificate for a server from a SSL vendor. However, some companies may decide that they want to issue their own SSL certificates. Often this is because the domain is only used internally, and most vendors don’t easily allow (if at all) the signing of server certificates for non-public domains. Additionally, issuing your own certificates can remove complications caused by the certificate verification process used by most vendors, and there are no fees needed for each certificate.

Continue reading “Creating Your Own SSL Certificates For FileMaker”

Speeding FileMaker Performance with Truncate Table

Managing Data You Use and Throw Out

We develop FileMaker applications because we want a place to store information for the long term. We track events, tasks, contacts, finances—FileMaker can track almost anything. To update information, the application might ingest a spreadsheet.

Continue reading “Speeding FileMaker Performance with Truncate Table”

Run PHP code with FileMaker & bBox

For quite a while, the documentation and product information for bBox has mentioned it as a way to run PHP scripts, but I only just recently realized that we never had any examples of how to do this.

Here are two methods to try.

Continue reading “Run PHP code with FileMaker & bBox”

bBox 0.80 Now Available

Its been almost a year since we’ve mentioned bBox on this venue, but we are now pleased to announce that version 0.80 is publicly available.

Continue reading “bBox 0.80 Now Available”

fmsadmin: where did you go?

I have a few scripts, including some Facter reporting “facts”, that make heavy use of FileMaker Server’s fmsadmin command. After a 14.0v4 on install on Yosemite I was puzzled to discover that one of the scripts wasn’t working.

Continue reading “fmsadmin: where did you go?”

FMAjax and FileMaker Web Viewers

With everything that we’ve learned with our last post, Communicating with a Web Viewer in FileMaker, it makes sense to wrap up the functionality into a FileMaker module and JavaScript library.

Continue reading “FMAjax and FileMaker Web Viewers”

Communicating with a Web Viewer in FileMaker

Beezwax has always been active in the FileMaker community regarding advanced use of Web Viewers. Check out these earlier posts if you’d like to learn more:

  1. Native Web 2.0 Controls in FileMaker 12 Layouts
  2. Go, JavaScript Go!
  3. Enable WebKit debugger in FileMaker Web Viewer

Continue reading “Communicating with a Web Viewer in FileMaker”

Enable WebKit debugger in FileMaker Web Viewer

If you are having difficulty getting your HTML, CSS, or JavaScript to render in a FileMaker Web Viewer, you may have a struggle ahead of you trying to find the problem, and no good way to debug it. In comparison, most web browsers have debug facilities that can help developers find problems in their code.

Continue reading “Enable WebKit debugger in FileMaker Web Viewer”

FileMaker 14: Field Placeholder Text

FileMaker Pro 14 includes a new feature to add placeholder text to fields on a layout. What is placeholder text? Simply put, it is a way to put text inside a field when it is empty. This feature is useful for mobile, web and desktop users alike.

Continue reading “FileMaker 14: Field Placeholder Text”

Using InspectorPro 5 with FileMaker Pro Advanced 14

FileMaker 14 is here, and while the Database Design Report (DDR) hasn’t changed, here’s a “Getting Started’ walkthrough for using InspectorPro with the latest version of FileMaker Pro Advanced.

Continue reading “Using InspectorPro 5 with FileMaker Pro Advanced 14”

1 2