NEW! The Missing Admin Tool 2024-3

NEW! The Missing Admin Tool 2024-3

by | Aug 7, 2024 | FileMaker, FileMaker Server, Technical

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

by | Jan 28, 2024 | FileMaker, FileMaker Server, Technical

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.

DM InsertText Helper Tool

DM InsertText Helper Tool

by | Jun 5, 2020 | FileMaker

With the release of FileMaker 19 we get much better integration between File
So with the increasing interest and popularity of embedding HTML/JavaScript widgets and features, we now find ourself in need of a good method to include the JS, CSS and other files within our solutions.
Multiple fields could work, but that adds to schema and it takes time.
You could use text objects, but then you are dependent on layouts and context.
And if you load them into global variables, you find yourself with a really slow data viewer, which you might need for other stuff.

Using the InsertText script step is a nice way to get text like the content of a JS or CSS file into a variable.
However, if you try to paste the content of such files into the dialog, you will get a FileMaker error saying that there is a limit of 30.000 characters.
The great thing is that this limit only apply to the dialog chrome – not the actual script step.
Now we just need to find a way to get our file content into the script step.

This is where this tool will help you.
Simply paste the content into the field, click the button and write the variable name you want to target.
Now the script step is on your clipboard and ready to paste into the script in your solution.

Simple, right ?

And now you have everything you need in the script, which makes your code more portable.
If you also targeted a local variable, your data viewer is not dying from the content.
We hope you like this little tool – which is completely open.

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

This code is beerware; if you see me (or any other DataManix employee) at the local, and you’ve found our code helpful, please buy us a round!

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).

DM FileMaker integration with Google Maps API

DM FileMaker integration with Google Maps API

by | Jun 4, 2019 | FileMaker

That litterally anything can be done with FileMaker is already common knowledge. So why not integrate a map to form the necessary overview of departments, customers, locations, events and the like?

This file is a hands-on standalone file which you can use as inspiration or copy/paste from, to your own solution.
As standalone file, all you need to add is your own Google Maps API key.
You can view existing SITE records, edit existing SITE records, add new SITE records and finally you can also delete SITE records.
 
Credentials:
Username: admin
Password: [empty]

Happy mapping 😉

We have identified a bug in the first released version, which prevented the maps to load on a Windows computer. This bug has now been fixed and the file on this download has been updated. If you previously downloaded this example file, please download again.

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

DM InstallerHelper Tool

DM InstallerHelper Tool

by | May 22, 2019 | FileMaker

Now that you have developed a great custom app and deployed to a FileMaker Server or FileMaker Cloud, you are ready to share it with colleagues. Or maybe you have built it for another organization, and now you need to give the end users access
 
How will you do that ?

You could explain to the end users, how to open FileMaker Pro Advanced and create a new favourite host – by entering the Fully Qualified Domain Name… and then instruct them to enter credentials, so they can see the file(s) they can add to their favourite apps in the FileMaker Launch Center – and then they can open that file and enter credentials once again… Sounds like a bit of a hassle – especially if you have many endusers.
We have advocated for a long time, that we got an ability to customise the FileMaker Launch Center and be able to setup links to custom apps for end users. However, this is a delicate balance for FileMaker Inc. since they need to balance the needs of both the professional and citizen developers as well as end users.

So they came up with something even better !

For years we have been able to fill out some options and license information into the Assisted Install.txt file, that sits next to the FileMaker Installer. This is a great way to make the installation process nice and smooth for end users, so they don’t have to input license information etc.

With FileMaker 18, there is now a new option in this file; AI_LAUNCH_CUSTOMAPP setting. You can now fill in the path (local or hosted) to a launch file of your own. That means that you can design a Launch Center for your end users in a FileMaker file, which can open your custom app. In other words, you can now create a nice looking – with your brand and your information – Launch Center experience for end users, where they don’t need to worry about anything other than using your custom app.

The best thing is that when the end user have installed FileMaker Pro Advanced 18 with the Assisted
Install.txt – every time they open FileMaker, it will open your custom launch app.
– or you could also just enter the path to the main custom app, so it will open directly.

While you can just go and fill out the information in this Assisted Install.txt file, we created a small, free and completely open FM App, where you can set the different options and create these setup files from. If you have more than one customer, you are able to use the file as database with Assisted Install options. We also included a custom launch app example for you to get inspired by.

We hope you like this new feature and find the video and tools helpful.

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

This code is beerware; if you see me (or any other DataManix employee) at the local, and you’ve found our code helpful, please buy us a round!

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).

The Missing Admin Tool for FileMaker Server 18

The Missing Admin Tool for FileMaker Server 18

by | May 22, 2019 | FileMaker

FileMaker Inc. has just released the FileMaker 18 platform. 

While we are happy to see new features, we still have the challenge that you need 3 interfaces in order to manage your FileMaker Server 18. To solve that, we have created a new version of our highly popular free tool: The missing Admin Tool for FileMaker Server – now for version 18. FileMaker has completely rebuilt the admin API into a version 2. This also means that we have had to rebuild our tool to utilise the new endpoints, options and new features of the admin API v.2.

If you liked our tool for FileMaker Server 17, I am sure you’ll love this new version. You can still get the tool for FileMaker Server 17, if you want. 

The tool is Beerware* and completely open for you to modify, explore the code and build upon. The only thing we ask is that you modify for your own use.

What is this tool?

The FileMaker Server web console was built from scratch for FileMaker Server 17 and has minor enhancements for FileMaker Server 18. While this is a very welcome change with a new and much more stable web console, it also had the consequence that features, we were used to have in the old web admin console of FileMaker Server 16 is now gone from the web admin console. They did not disappear completely. Most have been moved to either the admin API or Command Line Interface.

However, that also means that now you need to use 3 different interfaces in order to manage your FileMaker server. For many people, this is inconvenient and some are not comfortable coding agains the admin API or use Command Line commands. So in order to help our colleagues in the community, we built this tool, that combines all 3 interfaces and some more information on SSL as well.

Speaking of SSL – this is VERY important now. While it is now common knowledge that you should install a custom SSL certificate on your server, with FileMaker Server 17 and 18 this has become even more important. When you install the server, you have 2 options; install a custom SSL certificate or to turn off SSL. That’s right, if you do not install a certificate, all traffic between your server and clients will then be UNENCRYPTED.

In previous versions of the FileMaker Server, FileMaker offered a default certificate for testing purposes. Meaning that you could use that and the traffic was encrypted, though the certificate was un-trusted.

I highly encourage you to watch the videos we have created on the SSL topic and use our free tools to get your custom SSL certificate up and running. This is really important.

We really hope that you enjoy our tool and wish you the best of luck with your development on the great FileMaker platform.

We also have a pro version in the making that will be released shortly, so keep an eye on the page.

 

Known Bug:

There’s a known bug in the   API || Login    script (which is also pointed out in the comments below)

On line 19 – Set Variable ( $curl ; value ) – replace with this line;

“-X POST -H \”Content-type: application/json\” -d {} -H \”Authorization: Basic ” & $basicLogin  & “\” -H \”Content-Length: 0\” -D $ResponseHeaders –show-error”

 

FileMaker 19+

Even though this tool is named FMS18, it works for later versions as well.

It works as-is for FileMaker Server 19.0.1.

For FileMaker Server 19.1+ you will need to modify a script;

API || Update General Config

 

On line 21 – Set Variable ( $data ; value…) you need to disable one line in the json calc;

 

// startup restoration is not awailable in FMS19.1.2

//[ “startupRestorationEnabled” ; INTE_Interface::startupRestorationEnabled ; JSONBoolean ] ;

 

Also be aware that Claris keeps adding new features to the Admin API – which means that you might want to add some of those as well to the tool.

Look into the documentation of your server to see what features are available for your server version. The documentation can be found here;

https://{{yourServerUrl}}/fmi/admin/apidoc/

Please note that it looks like there’s a bug in this documentation in the currently shipping version of FMS19.1.2 – it looks like the documentation for the Admin API has not been updated for this version.

 

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

* This code is beerware; if you see me (or any other DataManix employee) at the local, and you’ve found our code helpful, please buy us a round!

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).