File plug-in logo

Troi File Plug-in 7

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 Plug-ins for FileMaker Pro 12new July 25th, 2013 Today we released Troi File Plug-in 7. This updated file management plug-in for FileMaker Pro 12 lets you insert text in files and drag and drop mails in FileMaker. See the version history page for the complete list of changes.

Troi File Plug-in 7 for FileMaker Pro 11 and 12

The new Troi File Plug-in 7 further expands your file manipulation arsenal. This release adds several new key features and expands existing ones.

Insert text into a file at a specified position

Troi File Plug-in 7 improves on the manipulation of (text) files: with the new function TrFile_InsertContents, you can insert text into a file at a specified position. We added a new Insert example file to the download demonstrating this functionality.

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

New: present your image thumbnails in a grid

With Troi File Plug-in 7 you can create square thumbnails, which is great for presenting multiple images to a user in a compact grid. In this version we 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 mails into FileMaker Pro

We improved the drag and drop functionality by adding Mail Drop (Mac OS X only). You can now 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. We also updated the DragAndDrop example file to reflect the Mail Drop functionality with an extensive example demonstrating the handling of single and multiple Mail Drops.

Metadata enhancements

Troi File Plug-in already gave you the possibility to write metadata information to your image files. Version 7 adds two new switches to the TrFile_SetMetaData function: "-SetImageURL" and "-UTF8CharSet". By using the "-SetImageURL" switch you can set the Photoshop Image URL metadata (not part of the official IPTC specification). The new "-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.

Several other enhancements

Apart from the new features we fixed a few issues and made several improvements:

  • Rewrote the source code to make the plug-in more efficient and prevent possible errors.
  • Fixed a bug in the TrFile_ListFolder function and in the TrFile_MountDisk function on Mountain Lion which could lead to a crash. Also improved the MountDisk function on Mac OS X so that paths to SMB servers are now handled by improved and modern code.
  • Updated several example files and the user guide to reflect the new functionality of Troi File Plug-in 7.

Ready for Windows 8 and Windows 8.1 (preview)

Troi Plug-ins are Lion and Mountain Lion compatible

We tested and improved the compatibility of Troi File Plug-in 7 with Windows 8 and Windows 8.1 (preview version). This version is also compatible with Windows 7, Vista and XP.
Troi File Plug-in 7 is compatible with Mac OS X Lion and Mac OS X Mountain Lion with FileMaker Pro 12. It also runs natively with FileMaker Pro 10 and 11. The Mac OS X version is a Universal plug-in which runs natively on PowerPC and Intel Macs. On the version history page you can find the complete list of changes of this and previous versions.

Easy installing and updating

With FileMaker Pro 12 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.
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.

Powerful listing of folders and searching

Troi File Plug-in 7 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). We also improved the handling of Unicode characters in the TrFile_ListFolder and TrFile_Search functions.

Run as a server-side plug-in

Troi File Plug-in 7 is compatible to run under FileMaker Server: it can run as a server-side plug-in or as a plug-in used by 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.

Drag and Drop files!

Drag files onto a FileMaker window!

Drag and drop files and folders

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.

Use FileMaker styled paths

Troi File Plug-in 7 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.

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

Just substitute text in files on disk

With Troi File Plug-in 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.

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 works with FileMaker Pro 12, 11, and 10. The plug-in can also run with runtimes from FileMaker Pro Advanced 10, 11 and 12. The plug-in is available for Mac OS X (10.5.7 or later) and for Windows 8, Windows7, Windows Vista or Windows XP (Service Pack 3).

Licenses for Troi File Plug-in cost US$ 99 per user.
If you bought a license on or after January 1st, 2013 the upgrade is FREE! We will email all eligible customers a new registration string . Contact us if you have not received yours after July 27th, 2013.

If you bought a license before January 1st, 2013 you will need to upgrade to use the 7 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


© 2013 Troi Automatisering, all rights reserved.