NEW! The Missing Admin Tool 2024-3

NEW! The Missing Admin Tool 2024-3

It is time for an updated version of our hugely popular free tool “The Missing Admin Tool”.

 

Updated August 2024 to version 2024-3 that is working with FileMaker 2024 and with updates to the Ubuntu install helper. Now with installation of Let’s Encrypt!

This version is named 2024 as it is being released in the start of 2024. There are several new features and new modular code. It is an update to the old version, so you will see many of the older features as well. However, this tool collects all the ways, you can interact with your FileMaker server in a single tool. Which is completely free and open for you to grab code and modify for your own needs and likings.
The tool is designed to access a single server at a time, but you can of course rebuild it to handle several servers at the same time.
In this version, there are one new feature; Helper tool to write a shell script to install FileMaker Server on Ubuntu.

The tool has these features:

  • Manage main features via admin API
  • See hosted files and clients
  • Read-only of all current endpoints in the admin API
  • NEW – CLI commands now features a navigational interface and contains all commands and help information from fmsadmin CLI
  • Log Viewer feature to view a log file in a nice viewer with filter feature
  • Web Admin Console – a web viewer from where you can access the web console of your FileMaker server
  • NEW – Ubuntu Install – a helper tool, that will write a shell script and Assisted Install.txt files that you upload and run on your Ubuntu server to install FileMaker server on Ubuntu.
  • SSL Certificate – a tool to write the CLI commands to request and install a SSL certificate
  • SSL info is links to info about FileMaker Server and SSL

The tool is tested with FileMaker server 19.4 – 20.3.
Note that it does feature PHP Settings, but that might not be available on your server. It is deprecated, but can exist on Mac or Windows servers – especially if you have upgraded them.

The file is password protected, but if you open the readme.txt file, then you get the credentials as well as more info.

8. August 2024 Claus Lavendt did a Live Stream with Richard Carlton about the Missing admin tool. You can watch the video here

 

 

Please provide your name and email address for your free* download.

Free means “Yes please, I´d like to receive up to four mails a year
with relevant information about TheBrainBasket universe.”
Distributed as-is; no warranty is given.Use of the material is at your own responsibility. If you use techniques from our solutions, you are welcome to credit DataManix (optional of course).
Free means “Yes please, I´d like to receive up to four mails a year with relevant information about TheBrainBasket universe.”
Your information stays with us!
I agree with the Terms & Conditions
Get Download Link

 

 

Please Note: The virtual table “VCFL_VirtualClientFile” only has 125 records. This means that it will not display all files and folders if you have more than ~120 files hosted on your server. In that case, please create more records and make sure the serial number will be sequential. Also, as this table is used for displaying clients as well, it will only display up to 125 clients, unless you add more records to the table.

NEW! The Missing Admin Tool 2024-3

Missing Admin Tool 2024.1

It is time for an updated version of our hugely popular free tool “The Missing Admin Tool”.

This version is named 2024 as it is being released in the start of 2024. There are several new features and new modular code. It is an update to the old version, so you will see many of the older features as well. However, this tool collects all the ways, you can interact with your FileMaker server in a single tool. Which is completely free and open for you to grab code and modify for your own needs and likings.
The tool is designed to access a single server at a time, but you can of course rebuild it to handle several servers at the same time.
In this version, there are one new feature; Helper tool to write a shell script to install FileMaker Server on Ubuntu.

The tool has these features:

  • Manage main features via admin API
  • See hosted files and clients
  • Read-only of all current endpoints in the admin API
  • NEW – CLI commands now features a navigational interface and contains all commands and help information from fmsadmin CLI
  • Log Viewer feature to view a log file in a nice viewer with filter feature
  • Web Admin Console – a web viewer from where you can access the web console of your FileMaker server
  • NEW – Ubuntu Install – a helper tool, that will write a shell script and Assisted Install.txt files that you upload and run on your Ubuntu server to install FileMaker server on Ubuntu.
  • SSL Certificate – a tool to write the CLI commands to request and install a SSL certificate
  • SSL info is links to info about FileMaker Server and SSL

The tool is tested with FileMaker server 19.4 – 20.3.
Note that it does feature PHP Settings, but that might not be available on your server. It is deprecated, but can exist on Mac or Windows servers – especially if you have upgraded them.

The file is password protected, but if you open the readme.txt file, then you get the credentials as well as more info.

 

 

Please provide your name and email address for your free* download.

Free means “Yes please, I´d like to receive up to four mails a year
with relevant information about TheBrainBasket universe.”
Distributed as-is; no warranty is given.Use of the material is at your own responsibility. If you use techniques from our solutions, you are welcome to credit DataManix (optional of course).
Free means “Yes please, I´d like to receive up to four mails a year with relevant information about TheBrainBasket universe.”
Your information stays with us!
I agree with the Terms & Conditions
Get Download Link

 

Please Note: The virtual table “VCFL_VirtualClientFile” only has 125 records. This means that it will not display all files and folders if you have more than ~120 files hosted on your server. In that case, please create more records and make sure the serial number will be sequential. Also, as this table is used for displaying clients as well, it will only display up to 125 clients, unless you add more records to the table.

FMS 17 Missing Admin Tool

FMS 17 Missing Admin Tool

FMS17Tool_MainImage

Claris has terminated the Admin API of FMS17 which means that this tool does not work as of September 27th, 2019. Please upgrade your FileMaker server to version 18 and download The Missing Admin Tool 18 from this site.

FileMaker, Inc. has just released the FileMaker 17 platform.

While we are excited about some of the new great features, the FileMaker 17 Server now features a new web admin console, that looks like the FileMaker Cloud Admin Console.

While the web console is nice looking, it lacks several features, that can be vitale in order to manage your FileMaker server.

Most features are not completely gone, but now you will need to use Command Line commands or use the new Admin REST API. For many Server admins, this new way of managing FileMaker Server, might be difficult to master all these interfaces.

In order to help our colleagues, we built this tool, that combines all the interfaces you will need in order to manage your FileMaker Server 17.

When you install FileMaker Server 17, you will need to install a Custom SSL Certificate. Unfortunately, the web admin console will no longer have a feature to generate a Certificate Signing Request, which you need in order to purchase your custom SSL certificate. In order to do so, you will need to do this via CLI commands.

The FMS 17 Missing Admin Tool has a feature to generate this command, so the process will be easier.

We also include a lot of information and links to videos, we’ve done with Richard Carlton in the past, in order to help you through this process.

The tool is completely free and completely unlocked, so you can dig in and learn from the code.

The only thing we ask of you, is your name and email address so we can send you an email, when we publish new helpful tools and articles.

If you like this tool, please let us know and let your colleagues know.

 

PLEASE NOTE THAT THE ADMIN API WILL CEASE WORKING ON SEPTEMBER 27, 2019.
THIS IS AN EXPIRATION SET BY FILEMAKER INC. IN THE FILEMAKER SERVER 17.
AFTER THIS DATE, THE FUNCTIONALITY OF THIS TOOL, THAT USES THE ADMIN API, WILL ALSO CEASE WORKING.
HOWEVER, THE OTHER PARTS WILL STILL FUNCTION AFTER THIS DAY.

FMS17Tool_image4

FMS17Tool_image3

FMS17Tool_image2

DM Migration Helper Tool

DM Migration Helper Tool

MigrationHelper_mainImage

FileMaker, Inc. has just released the FileMaker 17 platform.

We are very excited about the FMDataMigrator tool as it will allow us to do deployments of solutions much, much faster than in the past. This will reduce the argument to do development in live solutions drastically.

Since this new tool is a Command Line Interface tool, it means that you will need to write CLI commands to use it.

We wanted to build a tool, that will help us, using the tool. And so we decided to share it with our colleagues in the community.

The way we built it, is reflecting how most of our solutions are built. We use the data separation model and in several large solutions, we have multiple data files.

So we wanted to build a tool, that can do the data migration on several files in the same process.

This tool will loop through the files in the source and clone folders and do data migration on all these files.

However, if you only need to do data migration on a single data file, you can just place this in the folder.

Please read the informations in the tool, in order to understand how it works and the assumptions we make on filenames etc.

If you need the process to work differently, you can modify the code.

The tool is completely free and completely unlocked, so you can dig in and learn from the code.

The only thing we ask of you, is your name and email address so we can send you an email, when we publish new helpful tools and articles.

Please note that you will need to download the FileMaker Data Migration Tool from FileMaker directly, which requires a paid FDS membership. You can find it here: http://store.filemaker.com/product/FDS

If you like this tool, please let us know and let your colleagues know.

 

Please provide your name and email address for your free* download.

Free means “Yes please, I´d like to receive up to four mails a year
with relevant information about TheBrainBasket universe.”
Distributed as-is; no warranty is given.Use of the material is at your own responsibility. If you use techniques from our solutions, you are welcome to credit DataManix (optional of course).
Free means “Yes please, I´d like to receive up to four mails a year with relevant information about TheBrainBasket universe.”
Your information stays with us!
I agree with the Terms & Conditions
Get Download Link
Weighing scale demo

Weighing scale demo

Screen Shot 2017-03-02 at 01.35.26

Here is a short video on how you can integrate a weighing scale with your FileMaker App.

It is fairly simple and in the video I show you 2 ways of doing it.
One way is to use a serial plugin, another is by using a serial-to-bluetooth dongle.

The serial plugin way has the advantages that you can script all interactions. Basically, you are telling the plugin to listen for data from the weighing scale and run a particular script, whenever it receives any data. This script will then process the input from the weighing scale, which could be to put the weight into a field.

The serial-to-bluetooth dongle method is more simple as you just need to purchase the dongle, insert batteries and connect the bluetooth to either a computer or iOS device. Then it will work just as if you were typing on a keyboard, except that it will be the weighing scale, that types the weight. The downside of this method is that you will need to have the cursor active in a field and you will need to setup onObject trigger to format the content. Also, most scales do NOT send a return character, which makes this a bit more tricky than if you e.g. integrate with a barcode scanner.

You can download the FileMaker file below.

Have a lot of FileMaker fun!

 

 

Please provide your name and email address for your free* download.

Free means “Yes please, I´d like to receive up to four mails a year
with relevant information about TheBrainBasket universe.”
Distributed as-is; no warranty is given.Use of the material is at your own responsibility. If you use techniques from our solutions, you are welcome to credit DataManix (optional of course).
Free means “Yes please, I´d like to receive up to four mails a year with relevant information about TheBrainBasket universe.”
Your information stays with us!
I agree with the Terms & Conditions
Get Download Link
NEW V3 – Free Virtual Host Guide & Tool

NEW V3 – Free Virtual Host Guide & Tool

By popular demand, we have updated our Virtual Host guide and tool for FileMaker Server 13+ on Mac. The new guide will work with FileMaker Server 13.0v5 and higher. There are several new tips and tricks included in the “goodies” section. The new tool is now completely unlocked and does not use plugin anymore. Also new in this version is support for SSL.

This is the original description:

With FileMaker Server 13 we got a lot of great new stuff. However, the installation of FMS13 will take over the Apache webserver on a Mac OSX server, which will prevent you from using the built-in web tools in Mac OSX ServerAdmin. Many people will have a need to be able to create virtual hosts for especially CWP solutions. Please be aware that FMI strongly advice you to only use a dedicated machine for FMS.

As FMS13 takes over the Apache settings, there is no native way to configure Virtual Hosts, using GUI tools on Mac OS X. Due to this change, I have created a guide, with an accompanion FileMaker solution, that gives you the ability to configure Virtual Hosts. It can be used for a lot of things and also give you the ability to e.g. create an alias, that takes the user directly to a WD solution, without showing the WD homepage.
e.g. www.mycompany.com/wd can take the user directly to the WebDirect solution. It is also possibly to specify the web folder path, so it can e.g. be stored on another hard drive.

Using this guide, you can make the setup within 10 min.

In this version, SSL sites is not supported. This is due to some heavy re-write rules in the configuration, which I have not been able to find an easy way around yet. Feedback is greatly apprechiated, both here and via email.

This guide is not official supported by FMI, so any use is on your own risk.

 

Please provide your name and email address for your free* download.

Free means “Yes please, I´d like to receive up to four mails a year
with relevant information about TheBrainBasket universe.”
Distributed as-is; no warranty is given.Use of the material is at your own responsibility. If you use techniques from our solutions, you are welcome to credit DataManix (optional of course).
Free means “Yes please, I´d like to receive up to four mails a year with relevant information about TheBrainBasket universe.”
Your information stays with us!
I agree with the Terms & Conditions
Get Download Link