New Heater “DateTime Convert” transforms date and time formats

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.

Release notes for version 4.4.3 on August 24, 2024

LastKnown Heater renamed to LastValue Heater

The former LastKnown Heater is now labelled the LastValue Heater and offers an alternative mode that "persistently" returns the value of the last record or row processed. In addition, a freely configurable "initial value" can be specified for the first record or row.
The functionality of the former LastKnown Heater is retained as an optional mode. When older Definitions that used the LastKnown Heater are opened, the Definition is automatically converted to use the “Last Known” mode of new LastValue Heater. No manual changes are required.

String Trim Heater functionality expanded

Previously only what is termed whitespace, characters that include spaces as well as other invisible characters such as tabs and line breaks, could be trimmed using the String Trim Heater at the beginning and/or end of a character string. As of this version, the String Trim Heater can alternatively be used to trim a list of freely defined characters from the beginning and/or end of a string.

REST API Adapter with user-defined fields

Fields of type "undefined" in the REST API Adapter can now be specified which are solely used for further internal processing. This allows upstream REST web service calls to be reassigned later, for example, via a unique ID.

Further enhancements

• Der X-Value Heater now also allows tabs when entering the static value
  
  
• In FlowHeater Server the transfer of console outputs after execution has been optimized
  
  
• The 64-bit version of the JSON Adapter can now process files of over 2 GB in length.

Corrections (bug fixes)

• TextFile Adapter: Problems with column headers fixed when using Definitions with multiple Adapters
  
  
• MySQL Adapter: "Bad Handshake" error was previously reported sporadically when establishing the connection
  
  
• Database Adapters: It was previously not possible to configure transaction behavior
  
  
• SQLite Adapter: Problems with the import of large binary objects (BLOB fields) corrected
  
  
• Excel Adapter: Worksheets that contain a space at the beginning or end of their name can now be processed
  
  
• FlowHeater Server: Calculation of the next run time for daily execution with individual repetitions has been corrected