The newly released Troi Text Plug-in 4 for #FileMaker Pro 14 adds customizable (or is it customisable?) spelling functions per field. You can implement this from a calculation, for example in a script or in a calculation field. You can also ignore, learn and unlearn words, from a script.
If you regularly have to work with XML formatted data in FileMaker Pro®, getting the relevant parts of that data, and putting it into text fields can be a daunting task.
And you would probably say it is impossible to get a node of the XML out in one step as it would need a lot of script steps. But that is not the case if you use a plug-in.
Yes, it can be done!
It can be done if you install Troi Text Plug-in. This plug-in adds a function TrText_XML( ) to your arsenal of tools.
This function allows you to easily parse out a node from XML in one step! Here is the syntax of this function: TrText_XML ("-GetNode" ; Node_to_get ; XML_data )
The function has three parameters: the first parameter specifies the action to take, in this case to get a node from the XML. The second parameter specifies which node you want to get. Finally the third parameter is the XML data you want to parse. Continue Reading
If you want to meet FileMaker Plug-in makers in person: Troi Automatisering is going to the FileMaker Developer Conference in Las Vegas this year.
We will have a booth at the Product Showcase and hope to show you all the exiting new stuff we have with the Troi Plug-ins for FileMaker Pro. The FileMaker DevCon 2016 will be held July 18-21, 2016 at The Cosmopolitan of Las Vegas, Nevada.
We hope to see you there!
Today we released an updated version of Troi File Plug-in, our plug-in for manipulating external files and folders directly from FileMaker Pro. This is a maintenance update, which has a few bugfixes and improvements in the Search, GetDate and Metadata functions. Upgrading to version 8.0.1 is free for all users of version 8.0.
Today we released Troi File Plug-in 8.0, which adds support for 64-bit architecture with FileMaker Pro 14. We rewrote the plug-in so the TrFile_SelectFileDialog, TrFile_SelectFolderDialog and TrFile_SaveFileDialog functions are now available for you to use too.
With Troi Serial Plug-in you can receive data sent from an external device with a serial (RS232) interface in FileMaker Pro. You can have the plug-in start a script upon receiving in order to process the received data in your database.
Receiving the data
Assume you have an external serial device connected to a (virtual) serial port on your computer. You can use a serial-USB adapter to connect to a USB port on your computer, which will then act as a virtual serial port.
To receive data from this device, first open the (virtual) serial port on your computer using the Serial_Open function. Add this script step to a ScriptMaker script: Set Variable[ $ErrorCode; Serial_Open( "-Unused"; "COM1"; ) ]
This will open the COM1 port. Continue Reading
With Troi File Plug-in you can easily let a user select a file on disk, for example to get the contents into filemaker. With the plug-in you can also move or rename it, to indicate the file has been handled.
Selecting the file
Use the TrFile_SelectFileDialog function to open up a dialog which lets the user select a file. By default all the files can be selected. If you want the user to be able to select only files with a certain extension use the TrFile_SetDefaultType function first.
To let the user select any file add these script steps to a ScriptMaker script: Set Variable [$DontCare; TrFile_SetDefaultType( "-Unused"; "")]
Set Variable [$FilePath; TrFile_SelectFileDialog( "-Unused" ; "Please select a file.") ]
This will return the path to the file for example: MacHD:Users:John:Documents:FinancialReport2014.xlsx Continue Reading
Rob Salusbury wrote to us that he is using our Troi URL plug-in to make FileMaker Pro into an incredibly powerful web client, in particular for communicating with SQL databases.
He thinks we are sitting on a real game changer that potential customers might not be aware of. Combined with Troi File and Troi Encryptor it delivers the ability to create very fast (VERY fast), very secure SQL applications that provide a ton of extended capabilities over any browser-only based solutions.
Below we show how to display an input dialog with a popup, which displays the values of a second value list, while returning the chosen value from the first list.
This (simplified) example uses fixed text to build the dialog, normally you would fill the dialog with data from your database. In ScriptMaker you need to add script steps to a script, but you can of course copy the script from the example files in the download of Troi Dialog Plug-in.
Implementing the InputDialog
First set the values for the popup. For this popup we fill the optional last parameter, which holds a second value list (with item names). Continue Reading
You can adjust all of your cookie settings by navigating the tabs on the left hand side.
Strictly Necessary Cookies
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
3rd Party Cookies
This website uses Google Analytics to collect anonymous information such as the number of visitors to the site, and the most popular pages.
Keeping this cookie enabled helps us to improve our website.
Please enable Strictly Necessary Cookies first so that we can save your preferences!