A giant step
Congratulations to FileMaker, Inc. on the release today of version 16 of the platform.
Continue Reading
Serial plug-in for FileMaker Pro 15 updated to v4.5.1
Our serial port plug-in that gives FileMaker Pro easy and powerful access to external devices with a serial interface was updated today.
Continue Reading
Updated scriptable dialog plug-in for FileMaker Pro 15 improves ListDialog function
Updated file management plug-in for FileMaker Pro 15 improves UnZIP, Metadata and several other functions
Updated text manipulation plug-in for FileMaker Pro 15 adds compatibility with FileMaker Cloud.
Continue Reading
Updated file management plug-in for FileMaker Pro 15 adds the creation of transparent thumbnails and getting file icons.
Continue Reading
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
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
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
