Dynamic data import / export

datenbank

simply more productive
Up to 100,000 records can be processed with the freeware version!

New export option for the TextFile Adapter

Release notes for version 2.2.6 on April 10, 2012

 

New export option for the TextFile Adapter

The TextFile Adapter has supported appending to existing text files on the WRITE side (export) for some time. Until now column field names were never added a second time to an existing text file. As of this version you can specify, in the case of appending to an existing file, whether column headings should be suppressed or not.

Continue Reading

Calculations on date and time fields

Release notes for version 2.2.5 on January 30, 2012

 

Calculations on date and time fields
Calculations on date and time fields

New AddDays Heater

Using the AddDays Heater values can be added to date and time fields, or when negative, subtracted from them. Calculating with days, as suggested by the name of the Heater (function) is not all. By amending the default option in the configuration popup, you can also offset dates by years or months and times by hours, minutes or seconds.

Continue Reading

TextFile Adapter with optimized preview

Release notes for version 2.2.4 on January 16, 2012

 

TextFile Adapter with optimized preview function
TextFile Adapter with optimized preview function

TextFile Adapter with optimized preview function

A preview in the TextFile Adapter in the export mode on the WRITE side is only shown when this is explicitly confirmed as wanted (click in the preview area). This significantly speeds up the processing of large CSV database export Definitions. It prevents extra accesses to records on the READ side being needed, because these could result in additional maintenance of the database server.

Continue Reading

New Stop Heater/Function

Release notes for version 2.2.3 on January 02, 2012

 

Terminate a Import/Export definition
Terminate a Import/Export definition

Stop Heater for controlled termination of Definition execution

By making use of the new Stop Heater you can prematurely terminate an import/export run.

Two kinds of termination are possible:

  • normal termination after processing of a specified number of rows
  • immediate termination with a specified error message

 

IF-THEN-ELSE Heater additional checks

Release notes for version 2.2.2 on November 28, 2011

 

IF-THEN-ELSE Heater has additional checks
IF-THEN-ELSE Heater has additional checks

IF-THEN-ELSE Heater has additional checks

You can now check whether one of the following conditions applies to the incoming value when using the IF-THEN-ELSE Heater.

  • IsNull – checks whether the value is NULL or DBNULL
  • IsEmpty – checks whether the value is empty or has no content 
  • IsNumber – checks whether the value is numeric 
  • IsDateTime – checks whether the value contains a date and/or time

Continue Reading