Author: Justin Hesser

CT FileMaker Developer Group – System Notifications with FMP 2024

Posted on by Justin Hesser

8/21/2024 – This month, Robert Naud will take a look at a feature which, although first introduced for FileMaker Go, FileMaker 2024 now makes available to FileMaker Pro. We’re talking about system notifications! Even though we’ve managed to do without them for a long time, they offer us interesting opportunities to interact with the users of our applications. We look forward to seeing you there!

 

CT FileMaker Developer Group – What’s New in FileMaker 2024?

Posted on by Justin Hesser

7/17/2024 – This month, Douglas Wallis, Product Manager at Claris, will be joining us to present the new features included in the recent release of FileMaker 2024. In addition, Steven Blackwell will be showing the group a couple major security issues that the FileMaker 2024 release has resolved.

 

CT FileMaker Developer Group – AI in FileMaker

Posted on by Justin Hesser

5/29/2024 – This month, we will be discussing the topic of AI in FileMaker. Please come prepared to discuss your experience with AI in FileMaker and to present any AI integrations you may have come up with.

 

CT FileMaker Developer Group – Engage Presentations Recap & Discussion

Posted on by Justin Hesser

4/24/2024 – This month, we will be recapping and discussing our favorite Claris Engage presentations. Please come prepared to discuss the presentations you found most interesting and enlightening.

 

CT FileMaker Developer Group – Webmin Server GUI Tool

Posted on by Justin Hesser

4/19/2023 – This month, Oliver Reid will be presenting the Webmin GUI tool for Claris Server on Linux. Webmin provides all tools needed managing a Claris (or FileMaker) Linux server. Those who have becomes used to a Mac or Windows GUI will find Webmin as easy, if not easier, to use to upload, download and organize files for a Claris Server, set up OS level cron jobs, set ownership and permission for files and folders, and install ODBC drivers to support ESS, and more.

 

CT FileMaker Developer Group – KyoSync II & Engage Recap

Posted on by Justin Hesser

3/27/2024 – This month, John Mathewson of Kyo Logic will be sharing KyoSync II, which was unveiled at Claris Engage. John will relate how his team reliably syncs two FileMaker systems, even when one server is remote and has limited access. You’ll also get an inside look at KyoSync II, the technology that made this all possible.

In addition, we will also be reviewing Claris Engage and discussing the new ideas and trends that came out of the event.

 

CT FileMaker Developer Group – Admin API Server Monitoring

Posted on by Justin Hesser

9/20/2023 – This month, Robert Naud we will take us through an Admin Api demo file published by Soliant, and discuss possible use cases and customization ideas. We will also discuss some things to know about the API itself, especially concerning the authentication, and will look at the available documentation. Meet with us and add yet another tool to your toolbox!

 

Plowshare

Posted on by Justin Hesser

Plowshare

Location
Nationwide
Time Frame
20+ Years
Industry
Media & Communications
Contact Us

Overview

Plowshare, a subsidiary of Publicis, is a media placement & communications agency . What makes them special isn’t just their offerings, it’s their clients. Plowshare works exclusively with the federal government and nonprofits, seeking out and supporting clients that work to drive social good and meaningful change. They’ve worked with dozens of impactful clients, including the Wounded Warrior Project, Girl Scouts of USA, March of Dimes, The US Marines, and the Special Olympics.

The Challenge

For the past 20+ years, Plowshare have worked tirelessly to get their clients ad time for a fraction of the traditional cost. This meant either leveraging the cause and finding broadcasting networks that wanted to champion that particular nonprofit, or finding blocks of unpurchased ad space and negotiating a reduced or a free “donated” rate.
Given the nature of the clients, stretching media budgets is crucial . And in instances where it isn’t, money saved on marketing and ad purchases can be used for great causes elsewhere. While Plowshare had found tremendous success with their current processes and models, there were opportunities to optimize data sets– media monitoring, campaign tracking, and data analysis services would provide more value for client’s media budgets. Furthermore, it would mean lower overall costs, higher efficiency, and faster results. While Plowshare recognized the benefits of implementing these practices, they didn’t have a path forward with their current toolset and infrastructure.

The Task

Plowshare contacted us to see how customized tools could help streamline and optimize their media monitoring & campaign performance measurement processes. New technology is critical in their space, and any kind of new offerings, particularly in tracking ad placements, would give them an edge.

Our Process

We worked very closely with internal teams to identify needs, pain points, and potential blind spots. Over the course of development, we shared progress with the Plowshare team to allow them the opportunity to give input and redefine goals as needed. This iterative process allowed them to continuously shape the direction of the project as new needs were identified.

Impact

Not only were we able to streamline their processes, we created a new system that automated virtually all of their back-office performance reporting & campaign tracking work synchronizing fresh data to the web on a weekly basis. On top of this, it allowed clients real-time access to previously unavailable data. This powerful system ensured that their clients were always receiving up-to-date reporting on the success of their resources. This system was, in part, what led them to be acquired by the media giant Publicis in 2017.The system continues to be used to this day and is a backbone of their offering.

Real-Time Access

to campaign results data

Full Automated

web synchronization

Company Success

purchased by Publicis in 2017

Plowshare Group was only successful because of the technology tools Kyo Logic developed. In our industry, we need to keep up with the times, report live, and constantly develop things no one else is doing. Our biggest clients have stayed with us because we have maintained this standard.

Tom Derreaux
Executive Vice President, Plowshare

Haccah

Posted on by Justin Hesser

Haccah

Location
Nationwide
Time Frame
6 Months
Industry
Education
Contact Us

Overview

Haccah provides testing, analysis, and organization applications for professional psychology, therapy, and psychiatry practices. Their testing, typically behavioral testing, is administered to end patients by teachers, agencies, or psychologists.
Haccah’s application gathers these tests and assesses the applicants against specific diagnoses, analyzing them in large data sets and ultimately producing an output with detailed feedback.
Haccah uses a central FileMaker system to store test results and assess patients against specific diagnoses. The system leverages large data sets to produce test outputs with detailed feedback.
This application supports several hundred tests that cover a broad range of behavioral testing, including psychological, academic, medical, and more.

The Challenge

Haccah’s clients needed additional utility from the platform: More tests, forms, and responses. Unfortunately, the system was not designed for such an expansive suite of options and ran slowly.
The application itself took several minutes to open. It would often freeze during use and be prone to crashing. Clients expressed concern about the application’s performance: the content was valuable, but the system needed a revamp.
Haccah considered replacing the entire system at a significant cost and major disruption to their business. The system incorporated thousands of hours of accumulated knowledge and expertise and had significant business value if saved.

The Task

Before creating a new system from scratch, Haccah tasked Kyo Logic with reviewing and, if possible, overhauling the existing platform to improve performance and preserve their valuable data.

Our Process

Kyo Logic’s initial analysis showed that the existing system structure incorporated too many internal dependencies for Haccah’s older FileMaker system to handle at scale. Every change in the system caused a cascade of internal recalculations amounting to tens of thousands of real-time updates. These recalculations created major performance bottlenecks.
Luckily, fixing the internal dependencies would cost a fraction of replacing the entire system and could be completed in a few hundred hours of work. After demonstrating how dependency fixes could reduce load time from minutes to seconds, the Kyo Logic team worked on 4 – 5 high-impact change areas.
The focus was first to tackle the most used sections of the application. This process showed immediate results and improved the application to a point where results were apparent internally and with end clients.

Impact

 
With the recommended changes, the time to output final reports was reduced from 7 minutes to 17 seconds – a 1400x improvement. The time to open the application was reduced from over 1.5 minutes to 5 seconds.
 
Haccah saved their application and core business at a fraction of the cost of developing a new database application.
 
Working with a skilled internal team allowed Haccah to make required large-scale changes rapidly. Significant impact was experienced quickly by focusing on the most trafficked areas first.
 
Moving forward, the Kyo team looks forward to optimizing Haccah’s system and leveraging the power of Claris’ newer suite of tools to offer even more powerful functionality, ease of use, and value.

1400x Speed Increase

7 minutes to 17 seconds

1.5 Minutes to 5 Seconds

Time Taken to Open Application

6 Months Training

From Project Start to Launch

I don’t know of another program that can integrate quite like FileMaker does.

Kyo is very pleasant to deal with, listens well and communicates at a level that meets each person’s (client’s users) level of understanding.

Dr. James R. Harrison
Clinical Director

OceanX

Posted on by Justin Hesser

OceanX

Location
Worldwide
Time Frame
4 Years
Industry
Marine Science
Contact Us

Overview

 
OceanX is a nonprofit organization with an admirable mission: explore the world’s oceans, and bring their findings back to the world. Of course, this incredibly talented teams working both on the mainland and in vessels. Their OceanXplorer is one of the most advanced marine vessels ever constructed, equipped with cutting-edge research and multimedia equipment. Among other accomplishments, OceanX was the first to explore the deep Antarctic sea, the first to film a giant squid in the deep, and their crew discovered the Galapagos catshark.
 

The Challenge

 
The OceanXplorer is an advanced science vessel crewed by incredibly talented people doing very important research. However, this research effectively mandates the crew be isolated hundreds of miles into the ocean, far away from their fellow OceanX teammates… and just as far away from a reliable internet signal. The OceanXplorer needed to be able to send critical information back to home base. Just as importantly, the servers on the vessel and the servers at headquarters needed to have their data synced.
 

The Task

 
Develop a sophisticated application that collects and manages vital logistics information on land and synchronizes this information with an identical system collecting real-time information at sea. Capture this information and allow the two systems to synchronize their data via satellite. Deploy this system in a manner that the ship’s crew could manage communication with minimal effort and complete accuracy.
 

Our Process

 
Through a detailed, collaborative process, Kyo Logic developed a method to accurately sync the two servers using native Claris FileMaker technology— near real-time ship to shore communication via satellite. It was critically important that the Kyo Logic team gain a deep understanding of the needs of the OceanX team and visiting scientists. This knowledge allowed Kyo Logic to build a platform that addressed all of OceanX’s needs.
 
Claris FileMaker’s flexibility and raw power allowed Kyo Logic to create a system that made the syncing of these remote servers virtually seamless. You can learn more about how Kyo Logic harnessed the power of Claris’s FileMaker to solve this problem in the video below.

Impact

We were able to create the world’s-first custom solution that could ensure everyone was working within the same information, even when the OceanXplorer was out of internet range. While we can’t share the details of how the system operates, it’s been able to save employees hundreds of hours, minimize risk, and ensure accuracy. It’s all thanks to the power of one custom application.

90% Increase

in reporting accuracy

100s of Hours

saved on work processes

Synchronized Data

across thousands of sea miles 

We needed to organize our information and data to run our operations in a more effective way. We now spend less time working on specific tasks and our operations and communication are more efficient. Kyo Logic was excellent with their level of flexibility and support, and their response times have been great. This felt like a real partnership.

Vincent Pieribone
Vice Chairman