------home-purchasesupportnewsaboutliststipslinks-

 Troi Encryptor plug-in logo

Troi Encryptor plug-in 3.5
for FileMaker Pro 12 to 15

This plug-in adds encryption and encoding functions to FileMaker Pro. With Troi Encryptor plug-in you can make sure information can only be read by the persons you want. With it you can encrypt fields using the powerful 256-bit AES encryption scheme, so that your sensitive data is secure.

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

Troi Encryptor Plug-in 3.5 for FileMaker Pro 12, 13, 14 and 15

Troi Plug-ins for FileMaker Pro 15new July 5th, 2016 Today we released Troi Encryptor Plug-in 3.5. This version adds compatibility with FileMaker 15. We also added three new keychain functions, to help you store passwords that you use for encryption and decryption.

Please see the version history page for a complete list of changes in this and earlier versions.

List of features

Compatible with FileMaker Pro 12, 13, 14 and 15

Troi Encryptor Plug-in 3.5 is compatible with FileMaker Pro 12 through 15 on Windows and on OS X. In version 3.5 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 on the right. 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 type a letter or two of the function name and instantly see a list of matching function names. For example when you type "aes", the auto complete functionality will suggest the Encr_AES_EncryptUsingKey function. You can also type a function name in the functions pane on the right: for example if you type "Encry" you will see all the functions with Encrypt in the name, like Actr_EncryptRijndaelAES.

Encryption and decryption using 256 or 128 bit AES encryption scheme

With the Encryptor Plug-in you can encrypt fields using the powerful AES encryption scheme, so that your sensitive data is secure. This function will produce text that looks like this:

encrption sample text

So can you read this? =)

Exchange AES-encrypted data with other systems

To make sure encrypted data can be exchanged with other systems that use AES encryption (like for example PHP-mcrypt) we have added three separate functions to the plug-in. With the Encr_AES_CreateKeyAndIV function you can create an encryption key and initialization vector, which can be used for AES encryption or decryption in FileMaker as well as in other systems. The Encr_AES_EncryptUsingKey and Encr_AES_DecryptUsingKey make sure that you can encrypt and decrypt data using an encryption key and initialization vector supplied by you, to guarantee exchangeability with other systems.
To explain how this works we have added a PHP mcrypt script to the download of Troi Encryptor Plug-in. This demonstrates how to decrypt data in PHP that was encrypted with the EncryptAES.fmp12 example file in FileMaker.

Store passwords in the keychainnew

In version 3.5 we added three new keychain functions, to help you safely store passwords:

  • With the Encr_SavePasswordToKeychain function you save a password into the keychain, specifying the name of the account (or user) associated with this password. The keychain is unlocked when the user logs in to the operating system, so the password can later be retrieved from the keychain without the user needing to enter the (keychain) password. You can also specify an extra ID for this password, which will help you distinguish between different passwords for the same account. This can be for example the solution or database name, or even a field name and/or recordID (allowing for a very fine grained approach of giving access to a field on a per record basis).
  • The Encr_GetPasswordFromKeychain function retrieves a password from the keychain, which was previously stored for the specified account (and ID). You can now use this password to decrypt text in a field, for example with the Encr_DecryptRijndaelAES function.
  • The Encr_DeletePasswordFromKeychain function deletes a password from the keychain which was stored for the specified account (and ID).

Compress and decompress text

You can compress text using the ZLIB compression.

Send sensitive data via email

With the SafeAscii function you can create data that can be sent safely over internet, for example via email. It will convert fields that contain higher ASCII, into a format that contains lower ASCII only. For example the text: "•Günther and Børg" will be coded like this:

%Troi SafeAscii v1.0
.VG.Pnther-Pand-PB/>rg
%End SafeAscii v1.0

This can be decoded again, to recreate all the original higher ASCII characters. More importantly, if you use this function on encrypted text it will also be converted to a format that is safe to send over internet.

Export and import data without risk

The plug-in has a function ShortSafeAscii, which is a variant of the SafeAscii function. With this you can export any text field, including encrypted data, to an export file.

And more...

The plug-in has a generic code function, which makes it possible to encrypt a field with the key as the parameter. This opens up the possibility to decrypt without the need for a script. Below are all functions of the Encryptor plug-in:

Function name
Short description
Encr_AES_CreateKeyAndIV Creates an encryption key and initialization vector, which can be used for AES encryption and decryption
Encr_AES_DecryptUsingKey Decrypts the data using the AES algorithm using an encryption key and initialization vector
Encr_AES_EncryptUsingKey Encrypts the data using the AES algorithm using an encryption key and initialization vector
Encr_BinaryToNum Converts a binary number to its decimal representation
Encr_Checksum Sum of the ASCII values of the characters modulo 1024. ALL characters are counted, also non-printing characters like spaces and returns
Encr_Code Performs a encryption or decryption of the data field, depending on switches
Encr_Compress Compresses text using a ZLIB algorithm
Encr_DecodeBase64 Decodes a text formatted in Base64 to the original text
Encr_DecodeSafeAscii Decodes a text in the SafeASCII format to the original text
Encr_Decompress Decompresses text that was previously compressed
Encr_DecryptNewDES Decrypts text using a newDES algorithm and the current crypt key. Specify the correct key first with the function "Encr_SetCryptKey"
Encr_DecryptRijndaelAES Decrypts text using a the Rijndael AES algorithm and the password
Encr_DeletePasswordFromKeychain Deletes a password from the keychain for the specified account (and yourID)
Encr_EncodeBase64 Encodes a text to Base64 encoding. The result can be sent safely over internet without any characters being changed. This function formats the output so that it is better readable for email
Encr_EncodeSafeAscii Encodes a text to lower ASCII characters in the range 45...127. The result can be sent safely over internet without any characters being changed. This function formats the output so that it is better readable for email
Encr_EncodeShortSafeAscii Encodes a text to ASCII characters in the range 45...127. These character can be exported as tab separated text and also sent safely over internet.
Encr_EncryptNewDES Encrypts text using a newDES algorithm and the current crypt key. Specify a key first with the function "Encr_SetCryptKey"
Encr_EncryptRijndaelAES Encrypts text using a the Rijndael AES algorithm and the password
Encr_GetPasswordFromKeychain Gets a password from the keychain for the specified account (and yourID)
Encr_MakeDigest Generates a MD5 or SHA1 digest
Encr_NumToBinary Converts a number to its binary representation
Encr_Rotate13 Very simple coding of text. Shifts the character values by 13 to encrypt text stored in a FileMaker field. The field may be decrypted by using Rotate13 again
Encr_SavePasswordToKeychain Saves a password into the keychain for the specified account (and yourID)
Encr_SetCryptKey Specify which key is used to encrypt and decrypt a text
Encr_TextSignature Generates a signature of the characters that you can see. This means that only characters a-z, A-Z and 0-9 are used to generate the signature. So adding non-printing characters like spaces and returns doesn't change the signature
Encr_Version Use this function to see which version of the plug-in is loaded. Note: this function is also used to register the plug-in
Encr_VersionAutoUpdate Use this function to see which version of the plug-in is loaded, formatted for FileMaker Server's AutoUpdate function. Returns 8 digit number to represent an AutoUpdate version

User manual and extensive examples

We've added 14 example databases which show you how to implement the functions. And we've also included a user guide to the download. In the user guide you will find a function reference as well as the technical details of the encryption scheme that's used by Troi Encryptor Plug-in.

pdf icon

You can view the user guide online:
Troi Encryptor Plug-in 3.5 User Guide.pdf

What can you do with the Encryptor plug-in ?

Suggested uses of this plug-in are:

  • Make sure that confidential data stays confidential
  • Share medical data over internet, including pictures
  • Verify the correctness of important text
  • Compress large texts

Of course much more is possible. The best way to see if it can help you is to try it out. Please mail us if you have an interesting application of the Encryptor plug-in. We are always interested in what you can do with it.

What are the costs?Buy-it!

Below are the prices for new licenses (upgrades from previous versions: see below).

  • Single user license for OS X or Windows: US$ 79 per user
  • 10-user pack for OS X and Windows: US$ 299
  • 25-user pack for OS X and Windows: US$ 539
  • Developer license for OS X and Windows: US$ 539
  • Server/Web license for OS X and Windows: US$ 399

Upgrades from previous versions

If you bought a license on or after May 12th, 2015 the upgrade is free. Note: the 3.5 version needs a new registration string. We have emailed all eligible customers a new registration string. Contact us if you have not received yours after 7th July, 2016.

If you bought a license before May 12th, 2015 you will need to upgrade to use the 3.5 version:

  • Upgrade from single user license (OS X or Windows): US$ 39 per user
  • Upgrade from single platform developer license to cross platform developer license: US $299
  • Upgrade from cross platform developer license to cross platform developer license: US$ 229

    -> Buy Troi Encryptor Plug-in 3.5 online here

Developer License available

For the Encryptor plug-in we have a developer license specially intended for developers of databases. This license allows you to include the plug-in with ALL databases or FileMaker solutions that your company sells. See the Developer License page for more information.

 
Back to main Encryptor Plug-in page
 
 


© 2016 Troi Automatisering, all rights reserved.