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”

Videos: Improving Your FileMaker Code with InspectorPro 7

Illustration of a man sitting on a sofa

Five Ways InspectorPro 7 Can Improve Your FileMaker Code

Want better collaboration, performance and insight for your FileMaker development teams? With InspectorPro you can leverage advanced diagnostics, perform in-depth analysis, and gain insights with new visualizations.

Check out these videos from InspectorPro creator & Beezwax Chief Innovation Officer, Vince Menanno.

 

 

Problem Reports Dashboard

Track your progress while reducing problem code, and reducing technical debt.

 Watch now 

 

 

 

Script Monitor

Create a visual and interactive representation of your script interactions, where you can monitor them and stay aware of their activities.

 Watch now 

 

 

 

Search with LOgiCATOR

Locate InspectorPro 7 data with logical precision, including constrained and unconstrained finds within your solution analysis.

 Watch now 

 

 

 

Security Perspective

Identify the privileges and security levels assigned to various user roles for each script.

 Watch now 

 

 

 

Advanced Information

Identifying indirection, scripts states and more.

 Watch now 

 

 

 

Special Offer

Book an InspectorPro consultation at a special rate.

 Book now 

 

 

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”

AD-bound macOS systems not authenticating? Restart opendirectoryd

We support quite a few macOS systems that are bound to an AD (Active Directory) domain. Occasionally, one, two, or perhaps several would lose the ability to authenticate users with AD credentials. Often this was with one of the FileMaker Servers, where external authentication was being used for either user access or FMS Admin Console access. I’ve explored ways to fix this, without restarting or disrupting other services.

Continue reading “AD-bound macOS systems not authenticating? Restart opendirectoryd”

Azure AD (Active Directory) Authentication with FileMaker

In addition to the more typical external authentication methods, FileMaker supports client authentication using OAuth accounts from Google, Amazon, and Microsoft. In this instance, I needed to set up a FileMaker Cloud server to use a company’s directory accounts, which were hosted at Azure. In order to set this up I hit a couple of minor complications, which I’m going to cover here.

Continue reading “Azure AD (Active Directory) Authentication with FileMaker”

Logging PSoS Activity: Episode III – Return of the JSON

In looking back at our initial approach to logging FileMaker PSoS (Perform Script on Server) activity, I reflect back on a number of times where this has been extremely helpful. If you have come to rely on the benefits of PSoS then you also know some of its challenges — one of the biggest is debugging and monitoring how long sessions take.

Since FileMaker 16 introduced JSON, in new systems we’ve switched over to using JSON as the main way of exchanging data for parameters. Because we also use PSoS in new systems, we updated our method for PSoS Logging and this blog entry talks about the changes we made there and also restates the usefulness of this log.
Continue reading “Logging PSoS Activity: Episode III – Return of the JSON”

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”

Use Amazon OpenID authentication with FileMaker Cloud

Here we’ll list the steps you’ll need to enable authentication using Amazon accounts with FileMaker Cloud.

If you’ll be having more than a few different people logging in to the Admin Console of your FileMaker Cloud server, it’s generally good practive to avoid having everyone use the same credentials. By enablling an additional authentication mechanism, you can easily add or remove administrative access to a server,  and user’s get to use their own own credentials.

Continue reading “Use Amazon OpenID authentication with FileMaker Cloud”

SSL Certificates with FileMaker

Intro: SSL Basics

SSL certificates are a very common way to secure client/server network connections, and the FileMaker platform has made use of them for many years. Starting with version 15 however, FileMaker introduced a number of security changes, in handling SSL and certificates, on both the server and the clients. But where do they come into play, and how might this affect your deployments?

Continue reading “SSL Certificates with FileMaker”

Mask Data with Concealed Edit Boxes in FileMaker 15

Solving an Old Problem

When you consider how to keep information safe, you might first imagine a team of hackers in a dank basement typing and clicking their way into your bank account.

Continue reading “Mask Data with Concealed Edit Boxes in FileMaker 15”