Listing hosted FileMaker files from the shell

Posted by simon 08/22/2014 at 04:19AM

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.

I could've easily used:

fmsadmin -u myaccount -p mypassword list files

However, this would require me to edit each copy of the script to include that server's credentials, update the credentials if they ever changed, and exposing them in my script. At least one alternative when run as the root user is this:

 lsof -u fmserver -Fn | grep "\.fmp12$" | cut -c 2- 

Or, a slightly simpler version that can be run as the fmserver user (on Mac OS, fmserver is the default account used to run system scripts in a FMS Schedule):

 lsof -Fn | grep "\.fmp12$" | cut -c 2- 

Next up is to determine how I can do the same on Windows.

Simon

hello San Antonio. hello FileMaker DevCon.

Posted by Jay G 07/28/2014 at 07:27AM

It’s FileMaker Developer Conference 2014 this week, 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!

Several members of Beezwax's development team are featured presenters, and several more are hosting and facilitating Unconference Workshop sessions.

FileMaker Go - Location in Depth [Events]

Posted by Jay G 06/10/2014 at 07:43AM

The location functions for FileMaker Go 13 enable users with iOS devices to know where they are. But there's more to building rich, location-aware applications than just knowing where you are: location functions, calculating distance and direction, geocoding, location-based finds, integration with iOS navigation.

Jeremy Bante will present on these topics, as he embarks on a tour this week of West Coast FileMaker Developer groups:

 

What Are Your Imports Waiting For? FileMaker 13 Perform Script on Server - Part II

Posted by Jay G 04/21/2014 at 07:40AM

This article demonstrates how to use Perform Script on Server (PSOS) to have FileMaker Server run imports. This frees up the FileMaker client to allow users to perform other tasks...without waiting for the import to finish. It is like having minions at your beck and call...exciting stuff. Plus, as an added bonus Donovan (one of our developers at Beezwax) has provided a little custom function that enables a spinner graphic to keep the user informed of the progress of your import.

100x Faster - Flight Testing FileMaker 13 Perform Script on Server - Part I

Posted by Jay G 04/04/2014 at 11:27PM

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.

Our d3.js Saturday - Beezwax at d3.unconf

Posted by Jay G 03/31/2014 at 11:55PM

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

Here's info about the conference, examples of how we use d3 at Beezwax, and pointers to learning more about d3.js.

Java Applet Issues with Java 7 Update 51

Posted by simon 03/25/2014 at 08:15PM

Working with older Java applets with Java 7 Update 51.

Older Articles