We are sorry, information on this page is available only in Czech. Use Translator Switch to Czech

Monitor FileMaker Server Temperature with Bridge for Phidgets 4

Monitor FileMaker Server Temperature with Bridge for Phidgets 4 - Preview Image

Bridge for Phidgets 4 adds support not only for 13 new VINT sensors, but also for FileMaker Server. That means you can now use this plug-in to automate monitoring of your servers rack temperature, tracking access using RFID tags, unlocking doors, and anything else you can imagine, all that 24 hours a day without having to leave a dedicated FileMaker Pro client open all the time. See how easily you can use it to monitor your server temperature and automatically switch ventilation on and off as needed:

 

 

In the above video, we’ve used the Temperature Phidget to measure temperature, the Relay Phidget to switch the fan, and the PhidgetSBC4 to easily connect to both Phidgets over network.

 

Phidgets with fan setup

 

You can easily get the hardware (except for the fancy fan and the home-made interrupted USB charging extension) directly from Phidgets. You can even replace the Temperature Phidget with the Humidity Phidget which measures both humidity and temperature, or the single-relay Phidget with the 4 x Relay Phidget capable of switching up to 4 circuits via the same single VINT port (although it needs an extra power supply). What’s just slightly more complicated is making it work on the software side, so let’s take a closer look at that…

Installation

Before you can start controlling your Phidgets hardware from your FileMaker app, you have to install all the necessary components. This includes the latest Phidgets drivers, the 24UPhidgetManager helper app, and the Bridge for Phidgets plug-in itself.

 

Bridge for Phidgets 4.0 folder

 

On the client side you need the plug-in and the drivers in order to be able to write and read your scripts and calculations, but you don’t need them to use the solution if all the logic will be triggered on the server only.

The 24UPhidgetManager helper app goes only to the server. It will take care of talking to the Phidgets, so that FileMaker Server does not have to. The helper app will then talk back to FileMaker Server via FileMaker Data API when it has data records to create or FileMaker scripts to execute.

The plug-in itself needs to be installed in up to three places. One for server-side scripts, one for the FileMaker Data API, and another one for the web publishing engine (if you want to use it within WebDirect or the legacy PHP API).

 

FileMaker Server installation folders

 

You will also have to create the 24uPluginsAllowedFunctions.txt file and explicitly allow your solution to use the plug-in functions there. This is our “hosting friendly” security feature allowing you to safely use our plug-ins on FileMaker Server without exposing them to anyone who can use Perform Script on Server in at least some database hosted there.

Triggers

All the functionality of Bridge for Phidgets can be divided to two groups - on-demand functions, which you can use in scripts and calculations, and triggers, which get fired when certain events occur in the physical world sensed by the Phidgets devices.

The PhidgetServer example bundled with the plug-in will give you a good idea of what kinds of triggers you can configure on the server.

 

Phidget Server example with triggers

 

Server-side triggers use FileMaker Data API to do their job. A data trigger simply creates records in the defined table. This is the easiest and most efficient way to record sensor values and various other inputs for later processing. A script trigger will run a FileMaker script in your solution, and it’s up to you what you do in it. You can have both kinds of triggers fire either at a regular interval (every N seconds) or when a specific input/sensor value changes by more than specified amount (i.e. temperature changes by more than 1 degree).

 

Defining data trigger
Defining script trigger

 

In our example we define two triggers with the two scripts shown above. One to collect temperature at regular intervals and one to trigger a script when temperature changes by more than specified amount (so that we can catch when it exceeds defined maximum or drops below defined minimum), and turn the ventilator on or off, for instance.

This is the chart we can easily display thanks to recording the temperature every five minutes even if it has not changed:

 

24-hour chart

 

To activate the triggers on the server, we have to perform the scripts on server, obviously. We also connect to the SBC and configure its port 5 as digital output, so that we can control the relay with it.

 

Enabling monitoring by performing all the setup scripts on server

 

Last but not least (actually first) thing we do here is resetting the Data API account’s password to a randomly generated one, so that it cannot be used by a hacker to break into our solution. A bit paranoid but a nice trick you might appreciate using somewhere…

Controls

We didn’t want to invent a new scripting language just for our helper app, so any logic involving controlling relays, LEDs, motors and other outputs need to be done using scripts. Technically speaking, you could also use calculations evaluated as records are being created, but that could be very difficult to troubleshoot if it did not work as expected…

So we added the logic turning our fan on and off into a script that triggers when temperature changes by specified value step.

 

Logic triggered by temperature change

 

We also check whether the fan is already on (or off) before switching it, so that we don’t attempt to switch it and send/log an alert unnecessarily. In a real solution, you would probably have an extra level to watch for and produce a critical alert if the fan fails to cool the server down or if the temperature keeps dropping too much even after turning the fan off.

Don’t copy when you can steal

“Good artists copy, great artists steal” Pablo Picasso once said, at least according to Steve Jobs. Phil Schiller later clarified that by ‘stealing an idea’ Steve meant ‘figuring out what you like about it and what you want to incorporate into your idea, and taking it further and doing something new with it’. 

Why would you copy all the steps explained above, when you can save yourself the hassle and just grab a copy of the example already done? Don’t hesitate and do just that:

Download the example

It’s not only ready for you to install and use, but maybe you’ll also learn a few new FileMaker tricks from it, and hopefully also take it further and build something even better on top of it…

Please do let us know how you like it and what you’ve done with it. We look forward to hearing from you.

Call us Call
us

+420 608 301 880

Usually available on working days between 7am and 5pm GMT

We'll call you back if you call from a discoverable phone number and fail to reach us

Let us call you Let us
call you

By completing and sending the form you agree that 24U s.r.o., a company established under the laws of the Czech Republic, with its registered office: Zvole u Prahy, Skochovická 88, CZ-25245, registered in the Commercial Register with the Municipal Court in Prague, section C, inset 74920 will use your personal data contained in the form for the purpose of sending 24U’s news, updates and other commercial communications. Providing 24U with personal data for the said purpose is optional. Details on personal data processing and on your rights connected therewith are contained in 24U’s Privacy Policy.

Loader Image