DM FileMaker integration with Google Maps API

DM FileMaker integration with Google Maps API

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

DM InstallerHelper Tool

DM InstallerHelper Tool

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

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

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.

 

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

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

FMS WhistleBlower is finally here ! (BETA release)

FMS WhistleBlower is finally here ! (BETA release)

After 2 years in the making, we finally decided to release the first beta.

There will be a new version within 2-3 weeks, but we encourage you to start looking and testing this tool.

The History

At dotFMP in Berlin in 2016, we got to talk about the hassle of having to manage and monitor multiple FileMaker Servers and talked about how we could work on this. Basically, within a couple of hours, we cooked up the concept and started building the tool.

Since this has been a sparetime project, it has taken us some time. But we have been using the tool for our work the last almost 2 years, so we feel that it is pretty thoroughly tested.

As this tool was something we needed and we just want to share it with the community, it’s being released as Freeware/Open Source and we really like to have your input.

What is FMS WhistleBlower ?

It’s a monitoring tool, that will help you monitor and manage your FileMaker servers. It consist of 3 components; 

* WB Daemon/Service

This is something we developed and it’s a component you install on all the servers you want to monitor and manage. The daemon/service will collect log entries as well as CPU usage of FMS related processes and feed this information into the MySQL database.

* MySQL server

The database will have tables, which the daemon/service will write to. The reason for this choice is that we will be generating millions of records.

* FMS WhistleBlower FileMaker file

This file is the central point, where you can put in logics. Currently it provides an interface for viewing log entries directly from the MySQL, via ESS as well as providing a dashboard, that shows you the current status of all the server in the level of files, clients as well as whether each of the FMS specific processes are running and how much CPU each process takes up.

There is already a bunch of tools in this file, but the great thing is that it’s Open Source, so you can build your own modifications and tools.

One example that we’ve built, is a function that watch for whether the Script Engine has crashed. In that case, WhistleBlower will restart the Script Engine automatically.

How to set it up

* Download the file, which is a FileMaker file, which contains the bits you need.

* Upload the FileMaker file to a FileMaker server. (preferable your development server or server admin server)

* On the Dashboard screen, you’ll see an icon for installation. Press it and you’ find the SQL creation script for MySQL as well as WB Daemon/Service installers (MAC/WIN)

* Install or setup a MySQL server, where the servers you monitor, can access it via port 3306

* Run the SQL creation script, to create a database with the tables we need.

* Setup MySQL accounts for the daemon/service. You can create an account for each server you want to monitor, or just a shared account. Then create an account for the FileMaker file as well.

* Setup ODBC connection from your WB FileMaker server to the MySQL server. Also setup a connection from your local machine with the same DSN name. Only needed when you first setup the FileMaker file.

* Open the WB FileMaker file and make sure to connect your file in ESS using the DSN to your MySQL. Look through the scripts and look for import SQL steps and Execute SQL Query script steps and make sure to change them to use the DSN to your MySQL.

* Add servers as records. Use a serverID, which is what the system uses as unique identifier. Use a short serverID.

* Install the Daemon/Service on your Mac or Windows server. After installation, you’ll need to set it up. A screen will ask you to fill out the ServerID you created, the address to MySQL, database name, username and password. Follow the instructions and then the daemon/service will start feeding MySQL with information.

* Finally, create a server side scheduled script, that runs every minute. You should pick the script named “SRV || WB Master Serverside Script”. This script is fetching data from MySQL as well as requesting file and clients information from all the servers.

There is interfaces for FileMaker Pro, Go, WebDirect. We even built a screen that is specific for a WebDirect entrance from e.g. a Linux box, connected to a HD screen. We have such a screen in our office, which shows us the status, while we are working.

Currently we support FileMaker Servers from version 12 to 17 (as long as the daemon can run on the OS version. Mac OS 10.6 is not supported anymore) and we just put in support for FileMaker Cloud (some features) as well as FileMaker 17 via the admin REST API.

We know the above instructions are not at all complete documentation or description, but we know you are clever, so hopefully you’ll be able to get up and running. We are working on a release version right now and hope the community will want to contribute. With features, ideas and documentation.

On this site, you’ll be able to download the project, by providing your name and email address. We will only use your email address to notify you about updates and new releases.

Please check back at this site for news, as we are planning to create a wiki or forum thing and when that is in place, we’ll link from 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
FMS 17 Missing Admin Tool

FMS 17 Missing Admin Tool

FMS17Tool_MainImage

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


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