New option in AutoID Heater to increment "only every X records"
AutoID Heater that only increments when a specified number of records/rows have been processed. This makes it relatively straightforward to handle very large exports, for example, where the output must be split into multiple CSV files (every X records start a new export file). Naturally this option supports the use of FlowHeater Parameters. This way the maximum number of rows in a CSV export file can be dynamically set by a runtime parameter in Batch Mode.
As of this version of FlowHeater you are able to establish a counter using thee.g. FHBatch.exe /SetParameter MAX-REC=10000 export-csv.fhd
In order for this to function properly the counter generated must of course be saved in another FlowHeater Parameter and this Parameter is then used as a placeholder in the output filename of the TextFile Adapter.
e.g. export$FILEID$.csv
This will trigger the Textfile Adapter to output a new file automatically each time the AutoID counter value is incremented.
There is a short video example of this included in the AutoID Heater documentation.
Release notes for version 4.1.1 on January 27, 2018
Further changes
FlowHeater Server: optimization of file monitoring
FlowHeater Server supports the monitoring of folders (directories) for additions of new files. Whenever a new file is detected in a folder registered for monitoring it triggers the FlowHeater Server to commence running a defined task and works through this step by step. When this only consisted of one step it was not a problem, as FlowHeater Server hands the filename with path specification over to the program to be executed. It only became a problem when several steps were to be executed in sequence. FlowHeater Server handed the filename over to every task executed and in some cases this was undesirable. As of this version it is possible to define whether or not the filename should be handed over for each step.
In addition, FlowHeater Server now makes it possible to use the “%CURRENT-FILENAME%” server variable to define the form in which the parameter is handed over to the program to be executed. The current filename is otherwise passed as the last parameter to the program to be executed, when the respective option below is checked.
SQLServer Adapter -> MS SQL Server 2017 ready
The SQLServer Adapter has now been rigorously tested with MS SQL Server 2017, as released by Microsoft towards the end of last year. Of course, the SQLServer Adapter can also communicate with and import, export and update data held in SQL Server databases installed on Linux servers.
Upgrades of third-party database engines
The underlying third-party database driver software in FlowHeater Adapters for MySQL, Oracle, PostgreSQL and SQLite has been updated.
Website improvements
To better protect the privacy of visitors the website has been converted from http to https (SSL or TLS). All web services now use encrypted protocols. There is no automatic “fall back” to http anymore. The manual selection of an unencrypted http connect is now solely available for offline activation.
Moreover, the support forums are now located in special subdomains. There are two subdomains available, one each for German and English speaking users. You can reach the German support forum at https://flowheater.de/forum and the English support forum at https://flowheater.net/forum
The relatively wide thematic structure of the support forum is now more finely classified. There are special thematic areas available for practically every Adapter as well as the broader topics of Batch Processing, FlowHeater Server, Licensing, etc.
The layout of the forums and the main website will undergo further improvements and be placed on a new footing over the course of 2018.
Bug fixes
TextFile Adapter: Reading of field names in line-based text files
When a line-based text file (where one record consists of several lines) with field names was processed by the Textfile Adapter, the field names were lost among the field content. The field content then required a laborious workaround using Heaters/Functions to eliminate the problem. As of this version the problem is fixed.
Release notes for version 4.1.1.1 on February 24, 2018
- AutoID Heater is extended with a further option “Group change”.
- Batch module with improved return code handling.
- BugFix in the MySQL Adapter: Error reported when establishing a connection to the MySQL database with passwords that contained double quotes or apostrophe characters.