developer licenses FileMaker Pro    Plug-ins Activator Plug-in ClipSave Plug-in Coding Plug-in Dialog Plug-in File Plug-in Grabber Plug-in Graphic Plug-in Number Plug-in Ranges Plug-in Serial Plug-in Sesame Plug-in Text Plug-in URL Plug-in other software: Astro Tool OsErrrs database ProMaker Utils  ©2006  Troi Automatisering		Troi Text Plug-in 3.0 overview | download | details | comments | buy-it Troi Text Plug-in 3 is a very powerful tool for dealing efficiently with text in your FileMaker Pro database. It adds SumText, Set Creation, Lines and Word functions, XML Parsing and more! List of changes in version 3.0 Troi Text Plug-in 3.0, which adds compatibility with FileMaker Pro 8.5. The main changes are: Made compatible with FileMaker Pro 8.5. (Mac OS X) Converted to Universal plug-in which runs natively on PowerPC and Intel Macs! Updated the User Guide for version 3.0. We also improved the links in the table of contents, so the links now also work with the Preview application of Mac OS X. On the version history page you can find the complete list of changes for each version. All of the following functions are still present in version 3.0: the SumText function, which creates a dynamic field that concatenates all text from a field in a related file. To print out several files of related data at once, for example, it becomes necessary to "sum" that data up into its parent record. The SumText function will do just that: with some good scripting and calculation writing you can get very good related information in a text field in the parent file. Every time records get added to the related file the SumText is automatically updated. It is the text equivalent of the Sum() function the ANDText function, which returns all lines that are the same in 2 text fields the XORText function, which returns all lines that are different in 2 text fields the UniqueLines function, which returns all unique lines of a text field the UniqueWords function, which returns all unique words of a text field the SortLines function, which returns all lines in a text field sorted alphabetically the GetLine function, which returns the n-th line of a text field. No difficult calculations to get it, just ask for it it! Version 2.1.6 is compatible with older versions Troi Text plug-in 2.1.6 is fully compatible with earlier versions. You need to use this version if you work with FileMaker 5 through 6. You also need this version if you are using FileMaker 7 but you are using the 'classic' calls to the plug-in's functions in your scripts and calculations. These have the following format: 'External( "functionName" , "parameter")'. You can also mix both versions 3.0 and 2.1.6 and use them at the same time. Suggested uses of Troi Text Plug-in Present portal information horizontally Create an index for a book, which is updated automatically Find all addresses you want to send an email to, without sending sending duplicates Keep track of your client relations by generating a dynamic history of activities Receive client information in XML format and parse it easily into your database Create Dwindling Value Lists Advantages of Troi Text Plug-in (SumText) over Get(Valuelistitems) The Get(Valuelistitems) function of FileMaker Pro can be used to store the concatenated values of one of the fields in the related child records in a text field in the parent file. However, using the Sumtext function of Troi Text Plug-in for this has many advantages: When using the Valuelistitems function you'll need to also do some substitutes to change the return characters into commas.Using Troi Text Plug-in you can specify the delimiter to go between each of the items. The result of the SumText function won't break if you rename the value list. Troi Text Plug-in will retain the SORT settings specified for the relationship on which the summed text is based. Native FileMaker value lists are always sorted in alphabetic order. You can eliminate duplicates (with the TrText_UniqueLines function) or leave them in, sort in normal or reverse order (with the TrText_SortLinesEx function) and more.... Function names Below are all functions of Troi Text Plug-in 3.0: Function name Short description TrText_ANDText Returns all the lines that are both in text1 and text2. TrText_GetLine Returns the n-th line of the text. TrText_NOTText Returns all the lines in text1 that are NOT in text2. TrText_SortLines Returns all the lines from a text field sorted in alphabetical order. TrText_SortLinesEx Returns all the lines from a text field sorted in ascending or descending alphabetical order. TrText_SumTextCalc Use this function to define a sumtextCalc help field in a related file. TrText_SumTextResult Use this function to stop the SumText calculation and get the result. TrText_SumTextStart Use this function to start the SumText calculation. TrText_UniqueLines Returns all the unique lines from a text. TrText_UniqueWords Returns all the unique words of a text. TrText_Version Use this function to see which version of the plug-in is loaded and to register the plug-in. TrText_XML Returns the requested parts from text formatted as XML. TrText_XORText Returns all the lines that are NOT both in text1 and text2. What are the costs? Below are the prices for new licenses. 1-24 Single user license: US$ 39 per user 25-99 Single user license: US$ 25 per user 100 or more Single user license: US$ 9 per user Developer Distribution license (Mac OS): US$ 139 Developer Distribution license (Windows): US$ 139 Developer Distribution license (Mac and Windows): US$ 199   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. Upgrade from single user license (Mac OS or Windows): US$ 15 per user Upgrade from site or world wide license (Mac OS or Windows): US$ 9 per user Upgrade from cross-platform developer license to cross-platform developer license: US$ 89  Developer License available For Troi Text Plug-in we have a developer license specially intended for developers of databases. This license allows you to include our plug-in with ALL databases or FileMaker solutions that your company sells to organizations of up to 25 users. See the Text Plug-in Developer License page for more information. Example uses Dwindling Value Lists Sometimes when you pick an item from a list, you'd like that item to vanish from the list to avoid the possibility of double entry. Contributed by Kevin Frank Download it here Create a dynamic book index With Troi Text plug-in you can create an index for a book, which is updated automatically. This example is included in the download of the plug-in. See the Text plug-in download page for downloading Troi Text Plug-in. Example use: Dynamic History Jason Erickson of A.E Wood & Erickson (formerly www.aewood-erickson.com) uses Troi Text Plug-in to generate a dynamic history of activities in its RaDaDek product. Below a screenshot of this feature is shown. One of the benefits is that the result is one field, from which you can select text.   Related pages On these pages you find some information to help you. Currently we have these resources: FileMaker 6 conversion notes On this page you can find more information on how to convert databases, which use Troi Text, from FileMaker Pro 6 to later versions. Version history page On this page you can see which new features were added and what has changed with this and previous versions of Troi Text Plug-in. Text Plug-in FAQ On this page you can see a list of Frequently Asked Questions about Text Plug-in. Troi Plug-in FAQ On this page you can see a list of Frequently Asked Questions about Plug-ins in general. Auto update with FileMaker Server A page which describes how to start using the auto-update feature of FileMaker Server 7.   Back to main Text Plug-in page
www.troi.com/software		Products | Purchase | Support | Newsroom | About Troi | Mailing lists | Tips | Links