Dynamic data import / export

datenbank

simply more productive
Up to 100,000 records can be processed with the freeware version!
  • Home
  • News
  • New option in AutoID Heater to increment "only every X records"

New option in AutoID Heater to increment "only every X records"

Increment only every X recordsIncrement only every X recordsAs of this version of FlowHeater you are able to establish a counter using the 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.

e.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 - hand over current filenameFlowHeater Server - hand over current filenameFlowHeater 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://forum-de.flowheater.net and the English support forum at https://forum.flowheater.net
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.