File plug-in logo

Troi File Plug-in 8.5

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.5: optimized for FileMaker 15

Troi Plug-ins for FileMaker Pro 15new May 10th, 2016 Today we released Troi File Plug-in version 8.5, which has been tested and made compatible with FileMaker 15. We further improved the multi-threading behavior of the plug-in when running in FileMaker Pro 15 and we added description and type-ahead information for all functions of the plug-in. This extra function description will be shown in FileMaker Pro 15 in the Specify Calculation dialog box when you type a function name and also as a text popup in the functions pane. The type-ahead information is used by the auto complete functionality of FileMaker Pro 15. In the calculation pane of the Specify Calculation dialog box you can now type a letter or two of the function name and instantly see a list of matching function names. For example when you type "ap", the auto complete functionality will suggest the TrFile_AppendContents function. You can also type a function name in the functions pane on the right: for example if you type "fold" you will see all the functions relevant to folders, like TrFile_CopyFolder.

Unzip and create alias

In addition to the ZIP function introduced in Troi File Plug-in 8.0, which lets you create a compressed archive of files and folders, you can now also expand ZIP files with the new UnZIP function. This function lets you specify the folder where the unzipped items need to be placed. The new ZIPInfo function lists the items (files and folders) inside a ZIP file. This allows you to check what's inside the ZIP file before you unzip it, so no unwanted overwriting of existing items occurs. We also created a new ZIPAndUnZIP example file which shows the new functionality.
An other addition is the CreateAlias function, which creates an alias file (on OS X) or shortcut (on Windows) from the source file or source folder.

Together with several improved example files and a new User Guide 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 other versions.

Runs on Windows 10 and OS X 10.11 (El Capitan)

Troi Plug-ins are El Capitan compatible

Troi File Plug-in 8.5 runs on Windows 10, 8.1, 8 and 7.
Troi File Plug-in 8.5 is compatible with 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 the plug-in with 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! This means you no longer need the AutoUpdate feature of FileMaker Server. In our download we have included an example file EasyInstallTroiPlugins.fmp12 which installs (and autoupdates!) our plug-ins with FileMaker Pro and FileMaker Server.
With version 8.5 we further improved the example file EasyInstallTroiPlugins, to provide more help when an installation error occurs. 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).
NOTE 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 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.5 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

68 Functions give you ample power

Troi File Plug-in adds 68 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:

Powerful listing of folders and searching

Troi File Plug-in 8.5 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. We added an Insert example file to the download demonstrating this functionality.

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 8.5 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?

Mount and unmount

With the powerful MountDisk function you can mount remote disks on a server. On Windows you can map a remote drive to a drive letter. On Mac OS X you can even mount AFP servers across the Internet! The UnmountDisk function is available on all platforms. It is all explained in the DiskMount.fmp12 example file in the download.

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.5 works with FileMaker Pro 15, 14, 13, and 12. The plug-in can also run with runtimes from FileMaker Pro Advanced 12, 13, 14 and 15. The plug-in is available for 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.5

If you bought a license on or after November 1st, 2015 the upgrade to version 8.5 is FREE! Eligible users will receive a new registration by email.

If you bought a license before November 1st, 2015, you will need to upgrade to use the 8.5 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.

LIMITED OFFER: If you bought a license between May 12th and November 1st, 2015, we offer you to buy an upgrade with 30% discount. This offer is good until August 1st, 2016 and requires that you use a discount code at the time of purchase. Eligible users will receive a discount code by email. Contact us if you have not received yours by 17th May, 2016.

Download Troi File Plug-in today


© 2016 Troi Automatisering, all rights reserved.