Quickly get a list of all fields on a FileMaker layout

Posted by simon 01/09/2015 at 11:51PM

Get sorted list of all fields on a FileMaker layout.

Working with JSON data in FileMaker

Posted by simon 12/21/2014 at 01:38AM

Encoding JSON from FileMaker.

Version 0.71 of bBox Now Available

Posted by simon 12/20/2014 at 08:09PM

This release includes improved Python list & set support, and allows additional parameters to shell commands.

Summarizing FileMaker Server Access.log data

Posted by simon 12/11/2014 at 11:28PM

Summarizing FileMaker database access using shell commands.

Version 0.63 of bBox Now Available

Posted by simon 11/06/2014 at 05:03AM

This release includes new file and Python functions.

Button Image Masks in FileMaker 13

Posted by vince 08/29/2014 at 10:03AM

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. Here's how I went about implementing Button Image Masks in FileMaker 13.

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

Older Articles