The new version of FileMaker 12 has greatly enhanced container field abilities in the FileMaker product lines. From images, PDFs, movies, to any file you want to store, all the files can now be easily stored in a directory outside of the database file, known as external storage. The focus of this article will primarily be on the new storage options and how they can be configured in the FileMaker 12 interface, along with how the files are referenced on FileMaker Server 12. Let's unravel all the new container/file management options available.
Managing File / Container Locations
A new menu is now available, File > Manage > Containers, which opens the window below, labeled Manage Containers. In Manage Containers, you have two options: 1) Storage Options, and 2) Thumbnail Options.
Storage Options
Under Storage, you can list locations where you wish to store files externally. You have four directory paths you can specify:
Relative Path using a sub-folder of the database location
Full Path using the Volume
Full Path using the Drive Letter, such as a mapped drive
Network Path (e.g. computerNameshareNamedirectoryName)
When using a Relative Path, you must specify one or more subfolder names; I like to use the folder name files.
Also, the New, Edit, and Delete buttons are disabled when the database is hosted on FileMaker Server. Thus, you can only edit the directories in Manage Containers when a file is in single-user mode.
Thumbnail Options
You can now optimize the performance of streaming thumbnails over the network.
The thumbnails are automatically generated and you have the option to store the thumbnails permanently, which uses both hard disk and RAM, or Temporary storage, which only uses RAM. Temporary storage is cleared when you close the database.
Transfer Data Button
In the Manage Containers window, you will see a Transfer Data button in the lower left. The Transfer Data button allows you to migrate your container data to your specified external directory. The Transfer Data button is greyed out above, but will become active once changes have been made at the field level to container fields that have not been transferred to their new location.
The Transfer Data button is similar to the Synchronize button. When you first set up your database to use external storage, you will need to move your container data. Or, if you have changed the external location of your container fields, this is your sync button.
The Transfer Data Button Functionality:
Requires Full Access to transfer data.
Allows data in container data to be transferred externally
Allows data externally stored to be transferred back into the container
Supports converting to Secure Storage and back to Open Storage
Allows moving data between base directories
Allows moving data when open storage calculation is changed
Does not transfer files that are stored by reference
Basically, when you change a container field option, you will need to transfer the data to the new location, and the button handles just about everything for you. Once completed, you will receive a Transfer Summary dialog, and a Transfer.log file will be generated for you to review.
Container Field Options
At the container field level under Storage, a new Containers option is now available. You can choose to store the data externally, specify where you wish to store it using the paths you have made available under Manage Containers, and select the type of storage. You have two types of container options available: 1) Secure storage; and 2) Open Storage.
Secure Storage
Secure storage container data is encrypted on the specified external path and can only be decrypted by FileMaker Pro. When testing, five randomly named subfolders are created, and a random file name is created, encrypted, and placed in the last folder. If you're storing data that is sensitive, then Secure Storage is the only way to store your data moving forward in FileMaker.
Open Storage
The Open Storage option stores the file exactly as it was when you saved it. To better organize your data, you are given additional options to define subfolders for each container field. You also have the calculation engine to your disposal to dynamically name subfolders for your container field data.
Container Data Transfer
When changing any of the container field-level options, you will receive a prompt to transfer your container field data to the new location. Changing the folder or the storage type will generate this prompt to transfer your container data. You can click Cancel, then go to Manage Containers and click the Transfer Data button, as previously discussed.
Duplicate File Names
If you insert two files of the same name, the previously stored file will be overwritten. This is where using container field options to automatically generate a unique subfolder based on the primary key or UID will prevent files with the same name from being overwritten. Make sure to test saving files with the same file in different records and ensure the files are not overwritten.
Insert File Dialog Options
The new Insert File Dialog Options script step is loaded with 4 new features:
Filter file types
Storage Options
Display Settings
Compression
All of these options are awesome and straightforward, so I will not go into much depth here, but the one that surprised me the most to see was compression.
Compression
Compression is only allowed if you have set Display Icon with filename. In addition, some file formats cannot be compressed further. The dialog mentions JPEG and MP3, but I have not seen a full list of omitted file types, since some video may not be compressed further. The overarching point, though, is that if you want to have things compressed and decompressed, you now have the option.
FileMaker Server Default Storage Locations
The path of least resistance will be to set up external storage on FileMaker Server using a relative path subfolder in Manage Containers. When you have your database hosted on FileMaker Server and use the relative path folder option, the data is stored in a subfolder of the actual database location. FileMaker Server then stores your container data natively in the following subfolders from the location of the database:
Your Database File.fmp12 -> RC_Data_FMS -> Your Database File Name -> Manage Container Sub Folder(s) -> Field Level, Open Storage Sub Folder(s) or Secure Storage Sub Folders.
If a field is selected to use Secure storage, a subfolder 'Secure' is created, and subfolders are auto-generated when data is stored.
Other folders may appear, including RC_Cache_FMS and RC_StreamingCache_FMS.
Note: You cannot store files outside the FileMaker Server folder, such as on an external drive. You will need to use a third-party product such as 360Works Supercontainer.
Backups
When backing up your FileMaker databases using FileMaker Server, any relative path container data will be included in the backup. This could lead to longer backup times if you are storing many files or large volumes of data. FileMaker 12 now has a new feature in FileMaker Server called Progressive Backups, which are essentially incremental backups. The first time you enable Progressive Backups, a full backup will occur, so be aware if you have large amounts of data. Progressive backups are ideal for those with large FileMaker databases and for those who store many files in FileMaker via containers.
Conclusion
Overall, FileMaker 12 is loaded with tons of new container features. Previously, you had to use third party plugins for these functions, but with the new container features, we can all now embrace natively the features in FileMaker Pro, Server, and Go. Abilities such as external data storage, encrypting data via Secure Storage, controlling file-type filtering via the Insert File dialog, and Progressive Backups that enable lightning-fast backups are just some of the awesome new features!
Finally, the ability to change a container field's external storage location and have the data automatically transfer is a huge time-saver for setting up external storage and managing your container data. We really think you will like the new external storage options, the flexibility now available natively, and the enjoyable user experience of containers in FileMaker 12 and beyond.
Did you know we are an authorized reseller for Claris FileMaker Licensing?
Contact us to discuss upgrading your Claris FileMaker software.