File plug-in logo

Troi File Plug-in 8.6.1

Troi File Plug-in is a very powerful tool for getting access to information outside the FileMaker Pro database. Any files stored on the rest of the computer can be accessed through the functions of the plug-in.

overview | download | details | screenshots | comments | buy-it

Troi File Plug-in 8.6.1: maintenance release

Troi Plug-ins for FileMaker Pro 15

new 23 January, 2017 Today we released Troi File Plug-in version 8.6.1, which adds improvements and fixes to several functions. The upgrade to version 8.6.1 is free and recommended for all users of versions 8.5 and 8.6.

This plug-in is a powerful toolbox no FileMaker developer can do without. Please see the version history page for the complete list of changes in this and earlier versions.

New in version 8.6: get file icons and create transparent thumbnails

In September 2016 we released Troi File Plug-in version 8.6, which added some new features and was tested and made compatible with macOS Sierra. In this version we added the GetIcon function, which gets the icon of a file. It can create icons in sizes varying from 16x16 to 1024x1024 pixels and with double resolution, which is great for retina screens. Another new feature is the possibility to make thumbnails in the PNG format, with an alpha channel. This means that the thumbnail will have the same transparent areas as the original image.

Runs on Windows 10 and macOS Sierra (OS X 10.12)

Troi Plug-ins are macOS Sierra compatible

Troi File Plug-in 8.6 runs on Windows 10, 8.1, 8 and 7 and is compatible with macOS Sierra, Mac OS X 10.11 (El Capitan), 10.10 (Yosemite), 10.9 (Mavericks), OS X 10.8 (Mountain Lion), OS X 10.7 (Lion) and 10.6.x (Snow Leopard).
You can use this version with FileMaker Pro 15, 14, 13 and 12.

Easy installing and updating

With FileMaker Pro 12 and later plug-ins can be installed directly from a container field. In our download we have included an example file EasyInstallTroiPlugins.fmp12 which installs (and autoupdates!) our plug-ins with FileMaker Pro and FileMaker Server. The example file supports the 64-bit version of FileMaker Pro 15 and 14. On Windows there are 2 plug-ins: Troi_File_Plugin.fmx (for 32-bit) and Troi_File_Plugin.fmx64 (for 64-bit).
FileMaker Pro 15 and 14 and FileMaker Server 15 and 14 as well as Filemaker Server 13 and FileMaker WebDirect are 64-bit processes and require the Troi_File_Plugin.fmx64 version to be installed. On Mac OS X the 32-bit and 64-bit version is a single universal plug-in.

If you use FileMaker Server 11, you can still use auto update to update plug-ins for FileMaker Pro clients. See also the AutoUpdate example on our AutoUpdate page.

Run as a server-side plug-in

Troi File Plug-in 8.6 is compatible to run under FileMaker Server: it can run as a server-side plug-in or as a plug-in used by WebDirect or the the web publishing engine when using FileMaker Server. This means that you can use the powerful file management functions in server-side scripts, opening up lots of new possibilities.

Suggested uses

Troi File Plug-in is a very powerful tool for getting access to information outside the FileMaker database. Any files stored on the rest of the computer can be accessed through the functions of the plug-in. All from within FileMaker you can:

  • get the data out of files on the disk of the computer and put it in FileMaker fields
  • create files anywhere on the hard disk and put data from FileMaker fields into it
  • manipulate files and folders on the disk, like creating, deleting, copying, moving, renaming
  • query detailed information of files and folders: the size on disk, creation and modification dates and much more
  • count the number of folders or files on a disk
  • get images and their metadata (IPTC, Exif, GPS, XML) inside your FileMaker database and write IPTC and Exif metadata too!

All functions of the plug-in can be used in a script enabling you to automate this power.
Also check out the Suggested Uses on the detail page.

"I really have to say, that Troi File Plug-in is a fantastic extension for Filemaker. Troi opens a wide range of possibilities to improve our database and helps us a lot, to make the photo-handling easier."
Daniel Stöckli, Switzerland

69 Functions give you ample power

Troi File Plug-in adds 69 functions to FileMaker Pro, giving you virtually limitless possibilities! Here we give you just some examples of what you can do with this plug-in:

Zip and unzip files and folders

The plug-in's CreateZip function lets you create a compressed archive of files and folders. Expanding ZIP files is easy with the UnZip function. You can specify the folder where the unzipped items need to be placed. The GetZipInfo function lists the items (files and folders) inside a ZIP file. This allows you to check what's inside a ZIP file before you unzip it, so no unwanted overwriting of existing items occurs.

Powerful listing of folders and searching

Troi File Plug-in lets you recursively list the contents of a folder with one call to the plug-in. The plug-in will return a list of all files and/or folders and all the subfolders contained in the folder you are listing. This makes processing all the items in a deeply nested folder very easy, like for example listing all the Word documents contained in a folder.
On OS X you can optionally even list the internal contents of a package folder (like for example an OS X app).

Insert text into a file

Troi File Plug-in can substitute text in and append text to an external (text) file. You can search for a text string in a file and substitute it with another text. You can substitute text and have the result saved in the same file! And you can use replace strings of up to 150,000,000 characters, making it possible to substitute tags with much longer replacements in template files.With the function TrFile_InsertContents, you can insert text into a file at a specified position.

Grid of square thumbnails created by Troi File Plug-in
click the image to enlarge

Present your image thumbnails in a grid

With Troi File Plug-in you can create thumbnails of your image files in any size, including square thumbnails, which is great for presenting multiple images to a user in a compact grid. We have added a grid view to the Thumbnail example file, which demonstrates (in a simplified way) how to do this. We also added the possibility to add a name when creating a thumbnail with the TrFile_CreateThumbnail function. The name is normally not visible, but will be used for example when you perform an Export Field Contents action later.

Writing metadata

With Troi File Plug-in you can write EXIF and IPTC metadata information to your image files. By using the "-SetImageURL" switch you can set the Photoshop Image URL metadata (not part of the official IPTC specification). The "-UTF8CharSet" switch can be used together with the "-SetIPTC" switch. This will write the IPTC data encoded as UTF-8 text and will set the CodedCharacterSet tag in the written image file (which indicates the encoding) to UTF-8.

Use FileMaker style paths

Troi File Plug-in is compatible with FileMaker style paths, like for example "filemac:/MacHD/folder/file.txt". Each function with a path parameter can be given a FileMaker style path. You can also still use the full path formats of previous versions of Troi File Plug-in, like for example "MacHD:folder:file.txt" on OS X and "C:\folder\letter.txt" on Windows.

Get the Type of an Item

The function TrFile_GetTypeOfItem provides an easy way to see if a path points to a folder or file.

Get and Set creation and modification dates of folders

The TrFile_GetDateCreated and TrFile_GetDateModified functions and their variants, like TrFile_GetTimestampModified, will also get the creation and modification date of a folder. Moreover, you can also set the creation and modification date of a folder, using the TrFile_SetTimestampCreated and TrFile_SetTimestampModified functions.

Drag your files and mails into FileMaker Pro

Drag and Drop files!

Drag files onto a FileMaker window!

Troi File Plug-in allows you to drag one or more files or folders on a FileMaker window or even a drop zone. The paths of the dropped items can then be handled by a triggered script, for example to put them in a container field. You can specify up to two drag destination rectangles (even on the same window), and each drag can trigger a different script.
The drag and drop functionality includes Mail Drop (OS X only). You can drag one or more emails from the Mail.app to the FileMaker window. Add the switch "-AllowMailDrops" to the switches parameter of TrFile_DragAndDrop function to enable this extra functionality. The DragAndDrop example file reflects the Mail Drop functionality with an extensive example demonstrating the handling of single and multiple Mail Drops.

Command your shell

With the TrFile_ExecuteShell function you can execute a command in the command shell of the operating system. On Mac OS X this will be a command executed in the UNIX Bash shell, and on Windows this is the Windows CMD shell.

Manage your mediaManage your images!

Troi File Plug-in allows you to retrieve extensive image and movie data like width, height and depth, and much more. While we were at it we also added an extensive example file ManageMedia.fmp12.
This example file combines some of the Troi File Plug-in's functions to create a powerful Media Manager for images ànd movies. It shows how to import one or multiple images from a folder.

It also retrieves a wealth of metadata like width and height, IPTC metadata (amongst others caption, description, keywords, copyright) and Exif metadata. Exif metadata is information about the time a photo was taken, aperture, shutter speed and the like. And did we mention the example file also works with movie files?

Extensive example files and user guide

We can not discuss everything here, that is why the demo is fully functional and comes with a 95-page user guide and 36 extensive example files demonstrating every functionality.

Try Troi File Plug-in before you buy

You are free and invited to test the program before you pay. You may also make copies of the original and complete package (including the Read Me file) and distribute it to customers, friends etc. However, you may not distribute a modified or registered version.

Troi File Plug-in 8.6.1 works with FileMaker Pro 12 to 15, including with runtimes from FileMaker Pro Advanced 12 to 15. The plug-in is available for Mac OS X (10.6.x or later) and for Windows 10, 8.1, 8 and 7.

Licenses for Troi File Plug-in cost US$ 99 per user.

Upgrading to version 8.6.1

Upgrading from version 8.5 and 8.6 is free: version 8.6.1 uses the same 8.5 registration code. If you bought a license on or after November 1st, 2015 the upgrade to version 8.6.1 is also free. Eligible users have been sent a new 8.5 registration code by email.

If you bought a license before November 1st, 2015, you will need to upgrade to use the 8.6.1 version. Upgrades are available from US$ 59 per user. For multi-user discounts and other more detailed price information see the Troi File Plug-in Details Page.

Download Troi File Plug-in today


© 2017 Troi Automatisering, all rights reserved.