Troi Text Plug-in™ 3.0.1

Troi Text Plug-in is copyright 1998-2006 of Troi Automatisering. All rights reserved (October 12th, 2006).
 
Thank you for your interest in the Troi Text Plug-in. This FileMaker Pro™ plug-in adds several external functions to FileMaker Pro 7 , 8 or 8.5: parsing out incoming XML data in FileMaker Pro and the SumText function to concatenate all text from a field in a related file. Also adds text manipulation functions like GetLine which returns the n-th line of a text field, ANDText, XORText, NOTText, UniqueLines, UniqueWords and SortLines.

NOTE Version 3.0 uses the plug-in API introduced with FileMaker Pro 7, which is using the FunctionName(parameter1 ; parameter2) format. This means that Unicode is supported and more.

NOTE 2 With the the release of the update of FileMaker Pro 8.0v2 the original syntax of the SumText calculation is now again working properly. As the original syntax is more general we strongly recommend to use this syntax. Please read the SumText section of the FileMaker 8 Conversion Note, which explains this in detail.

See our web site for Text Plug-in 2.1.6 which is using the 'classic' plug-in API which is using the External( "functionName" , "parameter") format. The 2.1.6 version also runs on FileMaker 6 and 5.x.

This cross-platform plug-in is compatible with FileMaker Pro 7 and FileMaker 8 and enhances their functions. Finally you can do things you thought were still impossible to do with FileMaker Pro. Now you can create powerful databases by using this plug-in!

Recommended reading

Please read the FileMaker 8 Conversion Note, which explains how to convert from FileMaker Pro 6 and 7 databases.

INSTALLATION INSTRUCTIONS

INSTALLING A (TROI) PLUG-IN FOR THE FIRST TIME.

• For Macintosh: put the file "Troi_Text.fmplugin" from the folder "Mac OS Plug-in" into the "Extensions" folder in the FileMaker Pro 8.5 folder (or the FileMaker Pro 8 or 7 folder). If you have installed previous versions of this plug-in, you must remove them.
• For Windows: put the file "Troi_Text_Plugin.fmx" from the directory "Windows Plug-in" into the "Extensions" subdirectory in the FileMaker Pro 8.5 directory (or FileMaker Pro 8 or 7 directory). If you have installed previous versions of this plug-in, you must remove them.

You may want to install other plug-ins before proceeding. Then (re)start FileMaker Pro. Troi Text Plug-in will display a dialog box, indicating that it is loading and showing the registration status. You can now open the file "All Text Examples.fp7 " to see how to use the plug-in's functions
There is also a function overview file: Overview.fp7.

What Troi Text Plug-in can do for you

Troi Text Plug-in is a very powerful tool for dealing efficiently with text in your FileMaker Pro database. It will let you create a dynamic field that concatenates all text from a field in a related file, find all lines that are the same in 2 text fields or all lines that are different in 2 text fields. Additional functions let you find all lines that are in the first text field but not in the second, all unique lines of a text field or all unique words of a text field. Other manipulations include finding all lines in a text field sorted alphabetically, getting the n-th line of a text field and easily parsing out your incoming XML data files into FileMaker fields.

Who wrote it?

Troi Text Plug-in was designed and implemented by Peter Baanen of Troi Automatisering. You can visit the Troi web site at: http://www.troi.com/ for additional information.

Troi may also be reached by postal mail at:

Troi Automatisering
Vuurlaan 18
2408 NB Alphen aan den Rijn
The Netherlands

Tel: +31 172-42 66 06
Fax: +31-172-47 05 39
Email: info@troi.com

Note that due to spam we have to filter incoming email. It might happen that non-spam email is filtered out too. If you have sent an email and you don't get an answer, try to send another email, slightly differently formulated and include the word "FileMaker" in the body text.

Where can I get the latest version and more information?

The latest versions of our software are available for downloading at our web site:
http://www.troi.com/
You can also download the OSErrrs database, which lists all Operating System error codes for Macintosh and Windows, some of which the plug-in may return. The web site is also your source for late breaking information, company information, FileMaker tips and more.

System requirements

System requirements Mac

Mac OS X 10.3.9 for PowerPC-based Macs or Mac OS X 10.4.5 for Intel-based Macs

System requirements Windows

Intel-compatible computer, Pentium III 500MHz or higher
Windows 2000 (Service Pack 4), or Windows XP (Service Pack 2)

FileMaker requirements

FileMaker Pro 7 or FileMaker Developer 7.
FileMaker Pro 8 or FileMaker Advanced 8 or higher.
FileMaker Pro 8.5 or FileMaker Advanced 8.5 or higher.

Troi Text Plug-in version 3.0 does NOT run on versions prior to FileMaker Pro 7. If you need to run on versions prior to FileMaker Pro 7: see our web site for the Troi Text Plug-in 2.1.6, which runs on FileMaker 6, 5.x and 4.x.

Troi Text Plug-in is a commercial product

You can try-before-you-buy. This means that you are free and invited to test the plug-in 30 days before you pay. You may also make copies of the original and complete package (including this Read Me file) and distribute it to customers, friends etc. However, you may not distribute a modified or licensed version.

Use Troi Text Plug-in at your own risk

Although Troi Text Plug-in was tested carefully, we can not be responsible for any damages resulting from using this software. Also please try it out on a test database. Your system may be using an extension (unknown to us) that interferes with the proper functioning of Troi Text Plug-in.

We like to hear feedback on the benefits and shortcomings of the plug-in. Please include the platform and operating system in your suggestions and comments.

What are the costs?

Troi Text Plug-in 3.0 has the following pricing:

Note: if you still develop in FileMaker 6: the registration won't work in the 2.1.6 version. However with your purchase of a 3.0 license, we can provide a free license for the 2.16 version. Please request this by email.

Upgrades from previous versions

You need to use a new 3.0 version of the registration. If you bought a license for Troi Text Plug-in on or after February 15th, 2005 the upgrade is FREE! Note: the 3.0 version needs a new registration string. We will email all eligible customers a new registration string. Contact us if you have not received yours after August 22nd, 2006.

If you bought a license for Troi Text Plug-in before February 15th, 2005 you will need to upgrade to use the Text Plug-in version 3.0.

All Troi Plug-ins are available for Macintosh and Windows. When ordering please indicate for which platform you are ordering.

How to pay?

Paying for a license is easy. We have several ways to pay. More information on this can be found on the order page on our web site: http://www.troi.com/software/order.html. You can pay online via credit card or via Kagi, who also accept checks and cash.

Protection and unlocking the application

Troi Text Plug-in has a protection scheme. After you pay Troi Automatisering will tell you how to indicate to Troi Text Plug-in that you have paid the license fee.

If you do not have an e-mail address, please enter your complete postal address and remember, we do not know what country you live in so please enter that into the postal address also.

After you've supplied the payment data the following is changed:

• the not registered warning is replaced by your name.
• the flash screen that shows at the first time the plug-in is used is removed. Of course also the delay (which is longer after 30 days of use) will be removed.

Bug reports and Wish list

If you find a bug, please report this by e-mail: info@troi.com. If you have any comments or other functions that you think need to be added, please notify us! We have a lot of ideas for this plug-in, so be sure to check our web site for new plug-ins and improved versions.

And please pay for software you keep using, so that the wish list becomes reality.

Versions

You can find what has been changed in this and previous version of Troi Text Plug-in in the separate file: Release_notes.htm.

Thanks for supporting our software!

Peter Baanen