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.
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.
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:
- FileMaker Seattle, June 10, 2014.
- Santa Clara - DIG-FM, June 12, 2014
- Los Angeles - FMDiSC, June 13, 2014
- FileMaker Portland, July 9, 2014
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.