List of Improved Functions

A list of functions improved in DataMagic Ver.3 is given in this section. For the details of each function, refer to the 2.2 section.

Icons Shown in the Column 'Available in'

  • The improved function with below icon means the function is available in the shown product version or higher. For example, the function with the icon below is available in DataMagic Ver.3.0.0 or higher.

    Magic

    3.0.0

Improved Functions

Function

Available in

Batch conversion of parameter files in HULFT-DataMagic Ver.1

Magic

3.0.0

Switching language

Magic

3.0.0

Switching the date display format

Magic

3.0.0

Migrating from the trial version to the product version and adding optional products by updating the product key

Magic

3.0.0

Support for the manager connection option (unlimited)

Magic

3.0.0

Changes in names of environment variables used in DataMagic (for UNIX/Linux only)

Magic

3.0.0

Multi-line specification of functions

Magic

3.0.0

Extending the scope of application of functions

Magic

3.0.0

New functions (FORMAT_DATE, FORMAT_NUM, and TO_INCODE) and an improved SUBSTR function

Magic

3.0.0

Specifying an analysis method for line break codes and enclosure characters in CSV files

Magic

3.0.0

Enclosing numeric data for output in CSV format

Magic

3.0.0

Specifying schemas within the simple specification of database table information

Magic

3.0.0

Improvement on simple specification of database table information

Magic

3.0.0

Using negation in logical formulas

Magic

3.0.0

Specifying fixed values as control characters

Magic

3.0.0

Specifying the handling of NULL characters inside Format data

Magic

3.0.0

Outputting log information to external files

Magic

3.0.0

Obtaining format information and database table information in the CSV- Detailed Information screen

Magic

3.0.0

Specifying comments for individual fields of management information

Magic

3.0.0

Adding methods to specify IDs when exporting management information

Magic

3.0.0

Specifying operations to be performed when duplicate IDs are found during import

Magic

3.0.0

Added Separate settings to key setting type of Multi format

Magic

3.1.0

Improved read processing speed from SQL Server

Magic

3.1.0

FileMaker accessible via ODBC

Magic

3.1.0

Extended Excel output settings

Magic

3.1.0

Input in Excel 97-2003 (.xls)

Magic

3.1.0

Specifying the kanji code type of export file

Magic

3.1.0

Display explanation about the specified value on Output Information Settings screen

Magic

3.1.2

Added a function for extending Japanese calendar era names

Magic

3.1.5

Error Skip Data function

Magic

3.1.6

Using dynamic specification for SQL statements in database table information

Magic

3.1.6

Extension of Error Skip Data function

Magic

3.1.7

Extension of Japanese calendar date format

Magic

3.1.7

Function extension of SEQNO function

Magic

3.1.7

Input/Output of Excel 2007 and later formats (.xlsm)

Magic

3.1.7

Added "Restore in case of error" to the options when executing data processing

Magic

3.2.0

Enhanced the communication security between DataMagic Manager and DataMagic Server

Magic

3.2.0

Improved specification method for selecting operation logs

Magic

3.2.0

Added "Do not output" to the options for "Standalone declaration" when outputting data in XML format

Magic

3.2.0

Added "Total number of output records" to the data processing logs that are output when executing "Output to External File"

Magic

3.2.0

Significantly improved the data processing speed when inputting data in XML format

Magic

3.2.1

Changed driver to enhance security when connecting to SQL Server

Magic

3.2.2

Countermeasure against vulnerability in communication between DataMagic Manager and DataMagic Server

Magic

3.2.2