In order to more easily work with XML data, I’ve added the libxml2 library to version 0.54 of the bBox plug-in.
Among other things, libxml2 provides support for XPath 1.0 queries, which can be used to easily extract or set values from XML data, so XPath was my first choice. Although XML has lost a bit of its shine as JSON has come into vogue, XML is still integral to many systems, including FileMaker. Also, the XPath routines can be used for similar syntaxes, so for instance, you might find it helpful for scraping data from a HTML page.
Continue reading “XML Parsing with FileMaker and bBox”
It’s hard to believe it’s been only a few months since SQL was introduced as part of FileMaker 12.
Continue reading “FileMaker 12 SQL: Crafting Structural Beauty”
You gotta love FileMaker Go. Go’s ability to effortlessly create data-driven mobile apps and extend existing desktop data applications to mobile users is transformative. But sooner or later, almost all of us run up against one of Go’s core limitations: its lack of native plugins.
I wanted to do some conditional formatting, such that when a global field had a certain value the label would change its appearance. For example, if my sort column was “address”, then I wanted the column header containing the text “Address” to highlight.
Continue reading “Getting a FileMaker label’s text in a conditional formula”
I’ve been looking for a way to interface with some Cocoa classes in the Mac OS X API from FileMaker for a while. My initial target was PDFDocument, part of the PDF Kit suite of classes. For more information on Cocoa’s PDF Kit see here: Introduction to PDF Kit Programming Guide
Continue reading “Using Cocoa’s PDFDocument class from FileMaker”
There’s been plenty of discussion on FileMaker’s developer forums about the implications of using CSS to style layouts in FileMaker 12. In case you weren’t aware, FileMaker 12 introduced a new layout design surface whose styling is based on CSS. It’s a powerful new feature that hints at an exciting roadmap for the FileMaker product line. I’m not going to indulge in any details on this topic, however, because FileMaker has yet to officially expose the CSS styling to developers.
But say you were curious, for educational purposes, about what that styling looks like…
Continue reading “Freebie: Grab CSS From FileMaker 12 Layout Objects”
One of the most exciting aspects of the newly-released FileMaker 12 product line upgrade is a major redesign to the product’s UI. A new Design Surface modernizes FileMaker Pro layouts and updates every built-in control, giving developers and designers powerful new tools for designing better interfaces.
But as great as Design Surface is, why just stay on the surface?
Continue reading “Native Web 2.0 Controls in FileMaker 12 Layouts”
FileMaker Server Advanced allows external systems to connect to its hosted database files via ODBC and JDBC. The remote systems can then run SQL commands against the hosted databases. Often the hard part is getting all the infrastructure ready for this. That includes the correct extended permissions on the FileMaker database file, needed drivers, firewall settings, etc.
Continue reading “Recipe for testing JDBC connection to FileMaker Server”
Here’s a fun little challenge for your Friday afternoon. You can do it at home, in a bar, or hopefully even at work. Best of all, it’s technical and creative. Your task, should you choose to accept it, is to produce the lyrics to 99 Bottles of Beer in your favorite programming language. I chose to do the solution below in FileMaker. See 99-bottles-of-beer.net for the official challenge details. Continue reading “99 bottles of beer”