File plug-in logo

Troi File Plug-in 7.6

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 7.6 for FileMaker Pro 11, 12 and 13

Troi Plug-ins for FileMaker Pro 12new January 20th, 2015 Today we released Troi File Plug-in 7.6. In this version we introduce a new implementation for the TrFile_Search function, which allows you to find files and folders on disk. This implementation works on Mac OS X and is based on modern technology and gives a more accurate enumeration of the found items. You can choose this implementation by using the switch "-exhaustive" with the Search function.

What was new in version 7.5.x?

This update of our file management plug-in for FileMaker Pro 13 added support for 64-bit architecture on Mac OS X and Windows, which is required for running the plug-in on FileMaker Server 13 and WebDirect. For this we rewrote most parts of the plug-in. Furthermore we improved Getting Metadata from images and movies in this version and made several improvements and fixes in other functions. See the version history page for the complete list of changes in this and other versions.

Troi File Plug-in 7.6 further expands your file manipulation arsenal. Here we give you just some examples of what you can do with this plug-in:

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.

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 (Mac 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.

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.

Powerful listing of folders and searching

Troi File Plug-in 7.6 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 Mac OS X you can optionally even list the internal contents of a package folder (like for example a Mac OS X app).

Use FileMaker styled paths

Troi File Plug-in 7.6 is compatible with FileMaker styled paths, like for example "filemac:/MacHD/folder/file.txt". Each function with a path parameter can be given a FileMaker styled path. You can also still use all the FileSpec formats of previous versions of Troi File Plug-in, like for example "MacHD:folder:file.txt" on Mac 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.

Runs on Windows 8.1 and Mac OS X 10.9 (Mavericks) and Mac OS X 10.10 (Yosemite)

Troi Plug-ins are Yosemite compatible

We tested the compatibility of Troi File Plug-in 7.6 with Windows 8.1. This version is also compatible with Windows 8, 7 and Vista.
Troi File Plug-in 7.6 is compatible with Mac OS X 10.10 (Yosemite) and 10.9 (Mavericks). It also runs on Mac OS X OS X 10.8 (Mountain Lion), Mac OS X 10.7 (Lion) and 10.6.x (Snow Leopard).
You can use the plug-in with with FileMaker Pro 13, 12 and 11.

Easy installing and updating

With FileMaker Pro 12 and 13 plug-ins can be installed directly from a container field! this means you no longer need the AutoUpdate feature of FileMaker Server. In our downloads formatted for FileMaker Pro 12 (.fmp12 format) we have included an example file EasyInstallTroiPlugins.fmp12 which installs (and autoupdates!) our plug-ins with FileMaker Pro 12.
With version 7.5 we improved the example file EasyInstallTroiPlugins, to be able to also install plug-ins for 64-bit and running under WebDirect.

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 7.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.
In version 7.5 we added support for 64-bit architecture: on Windows there are now 2 plug-ins: Troi_File_Plugin.fmx (for 32-bit) and Troi_File_Plugin.fmx64 (for 64-bit). NOTE Only 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.

Powerful functions!

Together with several improved example files and a new User Guide this plug-in is a powerful toolbox no FileMaker developer can do without.

On the version history page you can find the complete list of changes of this and previous versions.

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.
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

64 Functions give you ample power

Troi File Plug-in adds 64 functions to FileMaker Pro, giving you virtually limitless possibilities! Below you find a bit more detail on some of the functions:

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(/.fp7).
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(/.fp7) 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 96-page user guide and 34 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 7.6 works with FileMaker Pro 13, 12, and 11. The plug-in can also run with runtimes from FileMaker Pro Advanced 11, 12 and 13. The plug-in is available for Mac OS X (10.6.x or later) and for Windows 8.1, Windows 8, Windows 7 or Windows Vista.

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

Upgrading to version 7.6

If you bought a license on or after January 1st, 2014 the upgrade to version 7.6 is FREE! We have emailed all eligible customers a new registration string. Contact us if you have not received yours.

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

Download Troi File Plug-in today


© 2015 Troi Automatisering, all rights reserved.