bzPython-FM performs Python for your FileMaker apps

bzPython-FM easily performs Python code within FileMaker, using the bBox plugin.

There are literally thousands of Python packages out there, for AI and Machine Learning, data analysis, data science and IT automation — now at your fingertips from within FileMaker.

Continue reading “bzPython-FM performs Python for your FileMaker apps”

Leveraging pandas with Python to Analyze FileMaker Data Sets

The pandas library for Python has become a go-to tool for many data scientists and analysts. In this blog post, we’ll examine one strategy for leveraging the highly powerful tools within pandas to enhance data analysis capabilities using the Claris FileMaker platform. We’ll do this by calling the bBox plugin and its built-in Python functions.

Continue reading “Leveraging pandas with Python to Analyze FileMaker Data Sets”

bBox v0.99 Integrates Claris FileMaker with JavaScript, Python 3 and Supports M1 Apple Silicon

We are pleased to release bBox version 0.99 for Claris® FileMaker® on macOS and Linux with new NodeJS and Python 3 integration, and M1 Apple silicon support for GraphicsMagick image processing and JQ JSON parsing functions.

About bBox Plug-in For FileMaker

bBox is a free utility plug-in to extend Claris FileMaker solutions to easily use macOS and Linux code libraries and functions from Python, JavaScript, PHP, Ruby, AppleScript, C/C++, Bash/sh, XPath, and SQLite. Also included is a demo file with more than 210 examples of how you can put bBox functions to work for you.

bBox is available on macOS and Linux, and runs with either FileMaker Pro or FileMaker Server. Here’s what FileMaker Magazine had to say about bBox version 0.99:

Continue reading “bBox v0.99 Integrates Claris FileMaker with JavaScript, Python 3 and Supports M1 Apple Silicon”

bBox for FileMaker v0.98 with M1, GraphicsMagick & Sips

We are pleased to release bBox version 0.98, with with new image file functions and M1/Apple Silicon support.

bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries and macOS-based functions from Python, JavaScript, PHP, Ruby, AppleScript, C/C++, Bash/sh, XPath, and SQLite. Also included is a demo file that has over 220 examples of how you can put bBox functions to work for you.

Some of the changes in version 0.98 are:

  • M1/Apple Silicon binary
  • Ubuntu compatible version (in addition to CentOS)
  • updated to libxml2 version 2.9.12
  • added bBox_GraphicsMagick function & script step
  • added bBox_Sips function & script step
  • modifications to several functions & script steps to add parameters
  • fixed template text used in several functions & script steps to better describe parameters
  • limit POSIX commands to 3 cores
  • new mode to combine stderr with stdout

Continue reading “bBox for FileMaker v0.98 with M1, GraphicsMagick & Sips”

bBox for FileMaker v0.96 with JSON processing, Python 3 and more

We are pleased to release bBox version 0.96, with JSON processing via jq, Python 3 compile/run,  and improvements supporting Zsh, cURL and Ruby.

bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries and macOS-based functions from Python, JavaScript, PHP, Ruby, AppleScript, C/C++, Bash/sh, XPath, and SQLite. Also included is a demo file that has over 210 examples of how you can put bBox functions to work for you.

Continue reading “bBox for FileMaker v0.96 with JSON processing, Python 3 and more”

bBox for FileMaker v0.95 Now Available

We are pleased to release bBox version 0.95. bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries and macOS-based functions from Python, JavaScript, PHP, Ruby, AppleScript, Bash/sh, XPath, and SQLite. Also included is a demo file that has over 210 examples of how you can put bBox functions to work for you.

Continue reading “bBox for FileMaker v0.95 Now Available”

bBox for FileMaker v0.93 Now Available

We are pleased to release bBox version 0.93, including new FileMaker script steps and web viewer functions. bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries and macOS-based functions from Python, JavaScript, PHP, Ruby, AppleScript, Bash/sh, XPath, and SQLite. Also included is a demo file that has over 210 examples of how you can put bBox functions to work for you.

Continue reading “bBox for FileMaker v0.93 Now Available”

bBox for FileMaker v0.90 Now Available

We are pleased to release bBox version 0.90. bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries and macOS-based functions from Python, JavaScript, PHP, Ruby, AppleScript, Bash/sh, XPath, and SQLite. Included is a demo file that has over 200 examples of how you can put bBox functions to work for you.

Continue reading “bBox for FileMaker v0.90 Now Available”

Overcoming TLS Frustrations with Python and macOS Sierra

The short version of this is that you probably want to upgrade to High Sierra (macOS 10.13) if you need to do much of anything with the built-in macOS version of Python and any network tasks.
Continue reading “Overcoming TLS Frustrations with Python and macOS Sierra”

JavaScript for FileMaker with bBox

In 2017, we released several new versions of bBox plugin. In the spirit of yearly retrospective, let’s highlight perhaps the most exciting new bBox feature: JavaScript for FileMaker. The new JavaScript for FileMaker functions in bBox are great for heavy duty JSON processing tasks, repurposing JavaScript code for use in FileMaker, or other computation intensive processing. Here’s a recap…

Continue reading “JavaScript for FileMaker with bBox”

FileMaker Server 16 Gotcha: Get ( SystemDrive ) and Friends

FileMaker 16 has been out for several months, however we wanted to call attention to a change that can effect your application’s use of server side scripting. Recently, we upgraded a client project to FileMaker Server 16, and found that critical functionality had mysteriously broken. After a bit of sleuthing and gnashing of teeth, we found that changes to the output of Get(SystemDrive), when executed server-side (PSOS or via a scheduled script), was the culprit.

Continue reading “FileMaker Server 16 Gotcha: Get ( SystemDrive ) and Friends”

bBox 0.88 for FileMaker Now Available

We are pleased to release bBox version 0.88. bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries and macOS-based functions from Python, JavaScript, PHP, Ruby, AppleScript, Bash/sh, XPath, and SQLite. Included is a demo file that has over 180 examples of how you can put bBox functions to work for you.

Continue reading “bBox 0.88 for FileMaker Now Available”

bBox for FileMaker v0.86 Now Available

We are pleased to release bBox version 0.86. bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries and macOS-based functions from Python, JavaScript, PHP, Ruby, AppleScript, Bash/sh, XPath, and SQLite. Included is a demo file that has over 180 examples of how you can put bBox functions to work for you.

Continue reading “bBox for FileMaker v0.86 Now Available”

Version 0.84 of bBox for FileMaker Now Available

Optimized for FileMaker 15, the new version of bBox includes 160 examples

We are pleased to release another update to bBox, v0.84 of our free utility plug-in to extend FileMaker solutions to other programs, code libraries, and OS X functions including Python, Ruby, AppleScript, Perl, Bash/sh, XPath, and SQLite.

Continue reading “Version 0.84 of bBox for FileMaker Now Available”

Version 0.83 of bBox Now Available

Optimized for FileMaker 15, the new version of bBox includes 160 examples

We are pleased to release another update to bBox, v0.83 of our free utility plug-in to extend FileMaker solutions to other programs, code libraries, or OS X functions (Python, Ruby, AppleScript, Perl, Bash/sh, XPath, SQLite).

Continue reading “Version 0.83 of bBox Now Available”

Excel formatting and charts from FileMaker using XlsxWriter

If you’ve developed solutions with FileMaker for any length of time, you’ve almost certainly created files using FileMaker’s native Excel exports. Although quite useful, this feature gives almost no control over the formatting, and definitely no way to set formulas, charts, or even text formatting.

Continue reading “Excel formatting and charts from FileMaker using XlsxWriter”

JavaScript-driven PDF Reports in FileMaker using AngularJS

Introduction – Extending FileMaker with JavaScript

Using a combination of AngularJS, HTML5, CSS, WKHTMLTOPDF, PDFtk, bBox and FileMaker scripting, we can create PDF reports from a FileMaker solution, taking advantage of the design and development flexibility afforded by using JavaScript and web tools to accomplish the task.

Continue reading “JavaScript-driven PDF Reports in FileMaker using AngularJS”

Installing xhtml2pdf on OS X

Xhtml2pdf is a cross-platform Python module that allows easy conversion of HTML or XML to PDF files. Its dependencies, ReportLab & Pisa, also have a host of very useful functions, including programmatically creating or modifying PDF content & creating barcodes.

Continue reading “Installing xhtml2pdf on OS X”

Run PHP code with FileMaker & bBox

For quite a while, the documentation and product information for bBox has mentioned it as a way to run PHP scripts, but I only just recently realized that we never had any examples of how to do this.

Here are two methods to try.

Continue reading “Run PHP code with FileMaker & bBox”

1 2