News

An XSD (XML Schema Definition) file can now optionally be specified in the XML Adapter Configurator. This XSD file is then checked against the specified XML file on the READ page before processing or on the WRITE page after the XML file has been generated. You can also specify whether processing is to be aborted if the check is not passed or whether only the warnings or error messages are to be output.

As of this version the BETA testing phase of the JSON Adapter is finished and the JSON Adapter can now be used with live data. Since the structure of JSON files requires some understanding, five detailed examples are provided to explain the special features of JSON processing with FlowHeater. In addition, a tutorial video is available that goes through these examples and demonstrates how easy it makes the conversion of JSON files. The examples only deal with converting JSON and CSV files, but this is simply for purposes of illustration. The same principles these demonstrate can of course be applied to JSON import and export to and from other FlowHeater Adapters, such as SQL databases or REST web service calls using the REST API Adapter.

Follow this link to the JSON examples: Examples of general JSON to CSV conversion

And follow this link to watch the video: General JSON processing video

Transform Date/Time valuesAs of this version you can now convert dates and time into different time zones and formats. The DateTime Convert Heater supports all available time zones. By default, your system’s time zone and UTC (Universal Time Coordinated) is assumed. Alternative settings in the DateTime Convert Heater also allow you to convert dates and times to Unix (also Linux) time. Unix time is expressed in the number of seconds that elapsed from Jan 1, 1970 until the date and time in question. With the DateTime Convert Heater you can easily convert back and forth between these different formats.