Category

FileMaker Plug-ins blog

Can you parse out XML data in FileMaker Pro in one step?

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

Plug-ins are going to Las Vegas

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!

Receive data from an external device in FileMaker Pro

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