EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS News & Events

All News & Events

05/16/2013
Advanced Data Import VCL version 3.8 released

We are pleased to announce the new minor version of Advanced Data Import VCL component. You can download the newest version from the download page.

What's new in Advanced Data Import 3.8?

  1. Added the support of Embarcadero RAD Studio XE4.
  2. Each value of the imported field can be processed using expressions in MS JScript. To the TQImportFieldFormat class the TqiStrings Script property containing the script code is added (for Delphi 7 and higher). To the TQImport3 basic class the ScriptEngine property of TQImport3ScriptEngine type is added (for Delphi 7 and higher). This property contains a reference to the component that will execute a script. The TQImport3ScriptEngine is the basic type, it sets the program logic and located in the QImport3ScriptEngine.pas module. It inherited the TQImport3JscriptEngine class, which works with the TScriptControl object from the QImport3MSScriptControlTLB.pas module in the context of MS JScript. You can also write your successor of the TQImport3ScriptEngine class to implement random script syntax. For TQImport3JscriptEngine the scrip execution result corresponds to the last variable value. If you want to use a filed value in the script, you need to specify the field name enclosed in percent signs -% in TQImportFieldFormat.Script. Below there is an example showing how to get a field value, convert it to number and increase on a numeric value of the current month:
    / / FieldName means a filed name
    R = %FieldName%;
    var D = New Date();
    k = parseInt(R) + D.getMonth() + 1;

    If a script for the field is set, it will have the highest priority in the field processing. I.e. the generator will not start, if it is set, etc. (for Delphi 7 and higher).
  3. Now, instead of the imported field value the following values can be substituted: current date, current time, current date and time, full name of the imported file, short name of the imported file. To the TQImportFieldFormat class the Functions property of TQImportFunctions = (ifNone, ifDate, ifTime, ifDateTime, ifLongFileName, ifShortFileName) type is added.
  4. QImport3HTML. Data from the files was not imported. Fixed now.
  5. If format masks correspond to system masks, they were not saved in the dfm file. Fixed now.
  6. QImport3Xlsx. The InlineStr cell values were not imported. Fixed now.
  7. QImport3ASCII. Some errors occurred while working with CSV files. Fixed now.
  8. Other improvements and bug fixes.

Hope you will enjoy working with our software!

twitterfacebook