Category: All

What happens at FileMaker DevCon…

by Jay Gonzales
Posted in All, Beezwax News, FileMaker, FileMaker 14, InspectorPro, News

The Beezwax Team will be in Las Vegas July 20-23, 2015 for the FileMaker Developers Conference, which is celebrating its 20th Anniversary. While we still hotly debate when best to double down at blackjack, and can only hope an Elvis impersonator will insist we stay off his blue suede shoes, there is one sure bet about DevCon: It’s the place to collect a jackpot of information by attending some of the more than 70 sessions and unsessions covering the latest trends in FileMaker development.

Continue reading “What happens at FileMaker DevCon…” →

FileMaker 14: Audio/Video Control Script Steps and Functions

by Darren Burgess
Posted in All, Design, FileMaker, FileMaker 14, News, Techniques

FileMaker 14 introduces new controls available in the mobile FileMaker Go app that help to bring the media player experience in FM Go more in alignment with iOS. These changes, compatible only with FileMaker Go 14, include 3 new script steps, 3 new script triggers and 1 new calculation function. In addition, the script step Insert Quicktime has been removed (developers should use the Insert Audio/Video script step, which we have had since FileMaker 12).

Continue reading “FileMaker 14: Audio/Video Control Script Steps and Functions” →

The Force “FIELD”

by Vincenzo Menanno
Posted in All, FileMaker, Techniques

For the longest time I thought field labels were something special and there was some sort of connection between the label and the field. So if you have ever created a new field and put that field on the layout with the label to the left of it. Then 10 seconds later you change your mind and decide to rename the field. Presto your label has also been renamed.

Continue reading “The Force “FIELD”” →

InspectorPro – Helping you find problems

by Vincenzo Menanno
Posted in All, FileMaker, InspectorPro

When you delete a field that calculations or scripts depend on, FileMaker provides great warnings.

Continue reading “InspectorPro – Helping you find problems” →

SystemVersion – When numbers are not what they seem!

by Vincenzo Menanno
Posted in All, FileMaker

I recently moved to OS X Yosemite, and once again repeated the annual cycle of wondering whether or not my existing solutions will be compatible with the new version. I’ve loved using AppleScript to trigger OS X Notifications from FileMaker since they were introduced in OS X Mavericks, but they stopped working as soon as I installed Yosemite.

Continue reading “SystemVersion – When numbers are not what they seem!” →

Facter Reporting for FileMaker Server

by Simon Brown
Posted in All, FileMaker, Server Administration, Techniques

Recently we’ve been thinking about how we can better monitor the collection of systems that we manage. These can be client servers with very diverse configurations, access, or functions. Additionally, we have our own array of systems, almost as diverse as our clients’.

Continue reading “Facter Reporting for FileMaker Server” →

Updated FileMaker Fail2ban Files

by Simon Brown
Posted in All, FileMaker, Server Administration, Tools & Add-ons

As an aid to improving the security of your server, Fail2ban is an open source component that checks for signs of abusive activity in your logs, and when these are detected, blocks an address (or possibly a subnet) for a given period of time. In May of  ’13 I blogged about how to set up Fail2ban rules to check the FileMaker Server event logs (http://buzz.beezwax.net/mVfrR7).

Continue reading “Updated FileMaker Fail2ban Files” →

NoSSR ( Not Only Sub-Summary Reports )

by Vincenzo Menanno
Posted in All, FileMaker, Techniques

To describe this next technique I came up with my own acronym, and I call it "NoSSR", which stands for Not Only Sub-Summary Reports. The goal of this blog post is to show you a way to build and deliver similar results but in a statically defined way. Another way to put it is to architect for performance, so let’s see what can be possible. This post also assumes you know how to build a FileMaker sub-summary report layout already.
Continue reading “NoSSR ( Not Only Sub-Summary Reports )” →

Working with JSON data in FileMaker

by Simon Brown
Posted in All, bBox, FileMaker, JavaScript, Techniques

There are a number of ways of working with JSON data in FileMaker. At least two typical ones are:

  • Custom Functions based parsing & encoding
  • using a WebViewer & JavaScript

Continue reading “Working with JSON data in FileMaker” →

Version 0.71 of bBox Now Available

by Simon Brown
Posted in All, bBox, Beezwax News, FileMaker, News, Tools & Add-ons

A new version of our free bBox FileMaker plug-in is now available.

Some of the changes since the last release are:

  • better support for Python results, in particular lists & sets
  • curl, sort, bash, and grep commands now allow up to 7 parameters
  • better handling of invalid parameters to FileRead and PasteboardGet functions
  • added the Python function fm.evaluate
  • more examples in the demo file

Continue reading “Version 0.71 of bBox Now Available” →

Summarizing FileMaker Server Access.log data

by Simon Brown
Posted in All, FileMaker, FileMaker Server, Server Administration, Techniques

Various times I’ve needed to do some quick summaries of how a given server and its databases were being used. On macOS and Linux we can use shell commands such as grep to get a quick summary of what’s happening on a server.

Continue reading “Summarizing FileMaker Server Access.log data” →

Version 0.63 of bBox Now Available

by Simon Brown
Posted in All, bBox, Beezwax News, FileMaker, Tools & Add-ons

A new version of our free bBox FileMaker plug-in is now available.

Some of the changes since the last release I blogged about are:

  • new fm.executesql Python function
  • additional types when converting to/from Python
  • new bBox_FileWrite, bBox_FileSymlink, and bBox_FileRead functions

Continue reading “Version 0.63 of bBox Now Available” →

Button Image Masks

by Vincenzo Menanno
Posted in All, Design, FileMaker, Techniques

Introduction

When you’ve been using FileMaker as long as I have, you know we’ve done all kinds of crazy things to get image masks to work on our buttons. For example, we would use a set of grouped native FileMaker line objects to cover an image just to get an ugly looking mask. I hope that not many developers suffered for too long using that technique.

Download Using Icons

Continue reading “Button Image Masks” →

Listing hosted FileMaker files from the shell

by Simon Brown
Posted in All, FileMaker, Server Administration, Techniques

As part of a shell script I’m cooking up, one of the required tasks is to list all currently hosted database files on a Mac OS based FileMaker server. This may get deployed over multiple servers, and I want to keep it as simple and trouble free as possible.

Continue reading “Listing hosted FileMaker files from the shell” →

hello San Antonio. hello FileMaker DevCon.

by Jay Gonzales
Posted in All, bBox, Beezwax News, Data Analytics, Design, FileMaker, InspectorPro, JavaScript, News, Tools & Add-ons

It’s FileMaker Developer Conference time, with 8 Beez in San Antonio for DevCon. We’re studying new development techniques from FileMaker Inc. and our industry peers, sharing a few methods of our own and even riding a few mechanical bulls at a real live cattle ranch!

Continue reading “hello San Antonio. hello FileMaker DevCon.” →

What Are Your Imports Waiting For? FileMaker Perform Script on Server – Episode II

by Vincenzo Menanno
Posted in All, FileMaker, FileMaker Server, Performance, Techniques

Introduction

I hope that since our previous blog post you have been exploring the possibilities created by FileMaker’s Perform Script on Server (PSoS). This article is a continuation of the PSoS discussion and includes more cool things you can do with it, specifically running database imports on FileMaker Server.

Continue reading “What Are Your Imports Waiting For? FileMaker Perform Script on Server – Episode II” →

100x Faster – Flight Testing FileMaker Perform Script on Server – Episode I

by Vincenzo Menanno
Posted in All, FileMaker, FileMaker Server, Performance, Techniques

Read the follow up to this blog post at What Are Your Imports Waiting For? FileMaker Perform Script on Server – Part II

Introduction

Since the release of FileMaker 13 we have been exploring a new feature called “Perform Script on Server” (PSoS) and trust me there are many cool things you can do with it. I’m going to describe how PSoS works, how it’s best implemented, and how our tests show PSoS can drastically improve database performance, more than 100x in some situations. However, there are also a number of considerations before you run wild and convert scripts to execute via PSoS. So, I’ll cover these as well.

Continue reading “100x Faster – Flight Testing FileMaker Perform Script on Server – Episode I” →

Our d3.js Saturday – Beezwax at d3.unconf

by Beezwax Team
Posted in All, Beezwax News, Data Analytics, Design, FileMaker, Front-end Development, JavaScript, Tools & Add-ons

Beezwax was a proud sponsor and participant in the first ever d3.unconf in San Francisco this weekend. This event was created as a one-day gathering of data visualization practitioners, centered on d3.js, a powerful and flexible JavaScript data visualization library.

As a participant-driven “Unconference”, d3.unconf allowed us to interact with other d3 devotees in sessions that ranged from “New to d3” through “Multivariate Data” and “Visualizing Neural Networks”.

Continue reading “Our d3.js Saturday – Beezwax at d3.unconf” →

Java Applet Issues with Java 7 Update 51

by Simon Brown
Posted in All, FileMaker, Techniques

Applets now are required to contain additional information in their .jnlp files to document the files used, either external or local. But if you are working with older code, such as the FileMaker 11 Server Admin Console, the required manifest information is missing and your applet will halt with an exception like this:

java.lang.SecurityException: Missing required Permissions manifest attribute in main jar: http://localhost:16000/admin-client-lib/admin-console-client.jar
    at com.sun.deploy.security.DeployManifestChecker.verifyMainJar(Unknown Source)
    at com.sun.deploy.security.DeployManifestChecker.verifyMainJar(Unknown Source)
    at com.sun.javaws.Launcher.doLaunchApp(Unknown Source)
    at com.sun.javaws.Launcher.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:744)

Continue reading “Java Applet Issues with Java 7 Update 51” →

Enable Logging of Client Usage Statistics in FileMaker Server

by Simon Brown
Posted in All, FileMaker, Server Administration, Techniques

I was looking for a way to monitor client usage of FileMaker Servers over time.

Continue reading “Enable Logging of Client Usage Statistics in FileMaker Server” →

1 … 9 10 11 12 13 … 15