silkcas.blogg.se - Filemaker pro 14 demo

If you have not done so already, you should download the fully functional demo version of the plug-in and play with it to see how easy it makes parsing XML. Below you can see the example file ParseXML.fmp12, with the data of our example: The Troi Text Plug-in comes with multiple example files, which demonstrate the functionality of all functions of the plug-in. Not all XML data has attributes, but in this case it does, and in the Attribute_data field the attribute data “ version=3.5” is returned.Īnd the advantage of this implementation is that it always works: when the XML_data field changes, the calculation will automatically update and the result will show correctly on the layout. If you enter this node path in the Node_to_get field the TrText_XML function returns: “ Super Plug-in”. In the field Node_to_get you can now specify the nodes and sub-nodes separated by a slash, like “ main node/sub node/subsub node”.Īssume that in this example you are interested in this node path: See also below a screenshot of the defined field for this FileMaker database: Now let’s parse XML!Īfter you have put the fields on a layout you can parse the XML. = TrText_XML (“-GetAttributes” Node_to_get XML_data ) = TrText_XML (“-GetNode” Node_to_get XML_data )įor Attribute_data specify this calculation:

Attribute_data, a calculation field (optionally, if you need attribute data).

Let’s make this concrete: assume your database already contains a text field XML_data, in which the XML formatted text is stored. You may not realize this, but you can also put this function in a calculation field: this will make the function recalculate automatically if one of the parameters changes, always giving the right result. You can use this function in a script, for example in a Set Variable step. The result of the TrText_XML function will be the text of the node you are interested in.

Finally the third parameter is the XML data you want to parse.

The second parameter specifies which node you want to get. The function has three parameters: the first parameter specifies the action to take, in this case to get a node from the XML. TrText_XML (“-GetNode” Node_to_get XML_data ) This function allows you to easily parse out a node from XML in one step! Here is the syntax of this function: It can be done if you install Troi Text Plug-in. This plug-in adds a function TrText_XML( ) to your arsenal of tools. 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.Īnd 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.