There are sometimes problems with Containers as you see in various FileMaker forums. Well, the problem may be that FileMaker can do only previews on Mac as they don't include a PDF engine for Windows. So if you try and add files and check with Container.GetTypes what items are in the container, you get a table like this:
We have a couple of common types in the containers:
"PDF " is the PDF file data.
FILE is the content of a file.
JPEG if exists is the JPEG preview data.
PNGf if exists is a preview as PNG image file.
FNAM is the file name for the container.
SIZE is the preview image size.
Now you need to know that FileMaker can render PDF on Mac on the fly (without annotations!), but on Windows it needs the preview. Or for all platforms use a web viewer for the interactive container to let the web engine render the PDF using it's PDF plugin.
You can of course always use MBS functions to check if preview is missing and add it on the fly using both PDFKit and DynaPDF functions. This could even be done on a server with a scheduled script or on a helper machine. The MBS Plugin adds a JPEG preview and you can use Plugin.SetPreviewSize function to configure preview size.
If you like to go to a bigger conference in English, please join the Swedish one and make a trip to Stockholm!
We have a booth at the German conference and I will come for a visit to the Spanish conference.
As of now I am signed up for the XDC 2018 conference in next April. Hotel is reserved as reservation can be adjusted easily later when flights are booked. Now I am looking for things to do beside the conference. For example:
16th street, food walk area with lots of shops and restaurants
Capitol in Denver with the one mile high step.
Children's museum of Denver, if you come with family.
In the Rocky Mountains
Trail Ridge Road with 3713m high pass
Independence Pass with 3687m high
Loveland Pass with 3655m high
Frisco historic park, behind Loveland pass.
A trip to the north
Mount Rushmore National Memorial
Crazy Horse Memorial
Devils Tower National Monument
Scotts Bluff National Monument
West of Denver
Colorado Railroad museum
The Buffalo Bill Museum and Grave
Golden city with Golden History Museum and Clear Creek Historic Park Trail
Roxborough State Park
Anything else you can recommend or plan to visit?
If you come by airplane, you should know there is a train from airport, which brings you directly from the main building in the airport down to Union Station. It costs only $9 and you can walk to the conference hotel.
As you may know FileMaker 16 uses WebKit 2.x for the WebViewers and we had to rewrite a lot of plugin functions for FileMaker 16. But some are still missing like print to PDF or rendering images. We look forward to macOS 10.13 which should bring a couple of improvements there for the WKWebView class and so we can improve functions for the next macOS version.
As a lot of clients ask for the functionality they had in FileMaker 15 to work in FileMaker 16, I had a nice idea today: We skip FileMaker's WebView and create our own!
So here you see a WebKit 1.x WebView (the older one) with a website loaded:
You call WebView.Create to create a new web view on page. The plugin puts it right on the layout independent of all FileMaker controls. So it stays at the position and does not reload when you switch records. And this allows a lot of new possibilities for navigation and special controls!
Please try it in the next prerelease or email me for a copy to test sooner. Mac only of course.
Today we update our Xojo developer Kits for Updater, Bugreporter and Web Starter. The main point is the move to use Xojo 2017 everywhere and remove the example projects for Real Studio. And over the years we collected a few improvements and bug fixes, which now go in the release for everyone.
Over the weekend I added two new plugin parts which will come with next plugin release:
LibSndfile, an open source library to read and write sample data with various sound file formats.
We compiled it for all targets and it seems to work well so far. The website has a table for supported audio formats.
Our new SoundFileMBS class provides the generic interface and allows you to load the library, open or create files and read/write samples in various formats.
Due to being LGPL, you need to build yourself or get the libraries from us prebuilt. We can’t include GPL code in the plugin, but as it’s LGPL, you can load the library in your closed source app at runtime without problems.
TagLib, an open source library to read metadata from audio files, e.g. ID3 tags.
Now we first add the generic interface which works for all file formats supported. See new classes like TagLibTagMBS.
Later we can add specific classes for individual formats based on demand.
This library is available both with LGPL and MPL. As we have to statically link the library (it’s C++), we need to use the Mozilla Public License, which doesn’t restrict us like the GPL does.
Originally pointed to by Paul Lefebvre's tweet, I quickly subscribed as they talk about various topics for independent app developers and those episodes are very interesting. They face similar issues as myself and so I like to hear their solutions.
Thanks to David Smith and Marco Arment for their apps and the podcast.
And thanks to Xojo Inc. for supporting the shows. Xojo is sponsor for episodes #92 and #93. Coupon code is RADAR.
Now Xojo’s move to DirectDraw in 2016r4 and subsequent changes in 2017r1 and 2017r2, we had to adjust our plugins to keep working on Windows. So for next plugin version we include fixes to our SetPicture and GetPicture functions to correctly put a bitmap on the clipboard. Our plugin can get/set the bitmaps to the clipboard now in 32 and 64bit.
The clipboard can hold several data types and Windows defines a couple of standard formats. Beside the bitmap type, there is a DIB type for a device independent bitmap and Metafile Picture for vector graphics. Normally Windows should convert from DIB to BITMAP or back.
Still some applications like Excel or Word look for the DIB and the conversion from BITMAP doesn’t work well. So we added new SetDIB/GetDIB functions to put a Xojo picture on the clipboard in the DIB format. This should solve problems people may have with clipboard.
If you like to try the newer plugins, please do not hesitate to contact us.
If you try to run two SQL statements on one connection, you often see this error message:
"HY000 [Microsoft][SQL Server Native Client 11.0]Connection is busy with results for another command"
We regularly see the problem with Microsoft SQL Server, but it also happens with Sybase ASE and others.
To solve you can set the option "SQL_ATTR_CURSOR_TYPE" with the value "SQL_CURSOR_DYNAMIC" to get a server side cursor. This will tell the connection to use a dynamic cursor and you can have several of those.
In gerade mal zwei Monaten startet die FileMaker Konferenz in Salzburg.
So langsam füllt sich die Konferenz und inzwischen steht auch das Programm.
Vom 12. bis 14. Oktober 2017 treffen sich wieder ca. 200 Teilnehmer im Pitter in Salzburg. Die deutschsprachige FileMaker Entwickler treffen sich um Neuigkeiten zu FileMaker zu erfahren, mit den Mitarbeitern von FileMaker in Kontakt zu kommen und um alte Freundschaften zu pflegen.
Bitte bald anmelden um ein Ticket zu bekommen. Noch gibt es Konferenztickets zu kaufen.
Die Hotelzimmer im Pitter sind wohl vergriffen, aber es gibt noch freie Zimmer rund um den Salzburger Bahnhof.
Vom Flughafen kommt man übrigens mit der Buslinie 2 direkt zum Konferenzhotel.
Für die MBS Plugin Schulung am 11. Oktober sind noch Plätze frei. Nehmen sie sich einen Tag Zeit zu erfahren, was alles im MBS Plugin steckt, was dieses Jahr neu ist und probieren wir direkt einige Funktionen aus. Je nach den Wünschen der Teilnehmer bauen wir gerne neue Beispiele, die dann bestimmte Funktionen zeigen.
Handling URL schemes in both Mac and Windows can be tricky.
For Mac you need to define plist entry to declare the URL scheme and later handle the AppleEvent.
For Windows it is more difficult. First you edit registry to declare your URL scheme. Than you need to handle the URL as start parameter. But as a second copy of your app may be launched, you need to talk yourself to the first instance via IPCSocket and pass URL command to main app.
Robert Beier from Dibomedia GmbH in Leipzig recently implemented a helper class to handle this and put it on githup:
Quite a couple of FileMaker users and developers ask for help on implementing MBS Plugin functions in FileMaker solutions. So I'd like to start with a list of MBS aware consultants for FileMaker projects:
In general they can speak English and the local language of their country. For some projects, you may want to find someone nearby, but most times someone from anywhere could help. See also FileMaker's partner locator website.
For next plugin release 17.4, we will have some reorganization in the plugins. Some smaller plugins get merged, some older stuff dropped and some parts move to other plugins. There may some change needed for people who don't have the Complete license key.
As over 80% of our users have the Complete set instead of individual parts, we make a special offer to all users with individual parts:
Buy the Complete Update in August 2017 to go from whatever part you have to the complete set.
Depending on what part you have, you save up to 50% this way: Order now
We will not stop selling individual parts right now, but as of today we remove QuickTime, Controls, Lion & Leopard from the price list.
Please do not hesitate to contact us for questions.