Softpedia >Windows >Programming >Components & Libraries >Advanced Data Import for RAD Studio VCL >  Changelog

Advanced Data Import for RAD Studio VCL Changelog

What's new in Advanced Data Import for RAD Studio VCL 3.13.0.0

Sep 29, 2021
  • Support for RAD Studio 11 Alexandria implemented.
  • End of support for RAD Studio 2009 and older versions.
  • The Range out of bounds error fixed in TfmQImport3Editor editor on calling a Map... menu item.
  • Lines from CSV files were sometimes mixed up. Fixed now.
  • Encoding for XML package files added to the TQImport3Wizard dialog.
  • A ReadToEnd method added to the TQImport3Encoding class to read and encode large files at better performance.
  • Drawing issues occurred on vertical scrolling in TQImport3TXTViewer. Fixed now.
  • An error occurred when reading XML data packet with UTF-8-BOM encoding with TEncodedReadStream.ReadToEnd method. Fixed now.
  • XML Access parser improved to view data in a grid.
  • TQImport3ASCII in text mode did not correctly process control characters, such as TAB. Fixed now.
  • Images are now imported correctly from XML files.
  • Other fixes and improvements.

New in Advanced Data Import for RAD Studio VCL 3.92 (Dec 10, 2014)

  • Added support of RAD Studio XE7.
  • Now it is possible to hide invisible fields of the binded dataset or DBGrid in component editors. "SkipInvisibleColumns" property was implemented in TQImport3 class.
  • Now it is possible to hide invisible fields of the binded dataset or DBGrid in TQImport3Wizard component. "SkipInvisibleColumns" property was implemented in TQImport3Wizard class.
  • Now the active import component is passed as sender into some TQImport3Wizard events that are triggered during import process. This should simplify obtaining extra info about import process in event handlers.
  • New error event "OnError" was added into import components. This event is triggered with exceptions on any stages of the import process and provides an info about the current stage as well as an error message text.
  • Some bug fixes.

New in Advanced Data Import for RAD Studio VCL 3.91 (Dec 10, 2014)

  • Added support of RAD Studio XE6.

New in Advanced Data Import for RAD Studio VCL 3.90 (Dec 10, 2014)

  • Added support of RAD Studio XE5.
  • QImport3XML. Added import from MS Access XML format files.
  • Qimport3Docx. Added BLOB fields import.
  • 4. Other improvements and bug fixes.

New in Advanced Data Import for RAD Studio VCL 3.80 (Dec 10, 2014)

  • 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. To the TQImport3 basic class the ScriptEngine property of TQImport3ScriptEngine type is added. 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.
  • 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;
  • QImport3HTML. Data from the files was imported. Fixed now.
  • If format masks correspond to system masks, they were not saved in the dfm file. Fixed now.
  • QImport3Xlsx. The InlineStr cell values were not imported. Fixed now.
  • QImport3ASCII. Some errors occurred while working with CSV files. Fixed now.
  • Other improvements and bug fixes.

New in Advanced Data Import for RAD Studio VCL 3.70 (Dec 10, 2014)

  • Added support of RAD Studio XE3.
  • Reading multi-byte encoding files caused data corruption. Fixed now.
  • QImport3Xlsx. When importing some files, an Access Violation error occurred. Fixed now.
  • QImport3Xlsx. When reading data in cells containing non-printable characters, an error occurred. Fixed now.
  • QImport3Xlsx. The Date/Time datatypes were displayed incorrectly. Fixed now.
  • QImport3Wizard. Import from CSV. When setting a MAP property, file data contained line break characters in the field values were displayed incorrectly. Fixed now.
  • QImport3Wizard. When importing from CSV and TXT, incorrect default encoding applied. Fixed now.
  • QImport3Wizard. Import from TXT. When loading a template in the MAP property settings, values of the block position and size were reversed. Fixed now.
  • QImport3Wizard. Even if the import process is fully complete, ProgressBar did not show 100% completion for some types of import. Fixed now.
  • Other improvements and bugfixes.

New in Advanced Data Import for RAD Studio VCL 3.60 (Dec 10, 2014)

  • Added the “Functions” property (TQImportFunctions = (ifNone, ifDate, ifTime, ifDateTime, ifLongFileName, ifShortFileName) to the TQImportFieldFormat class. This property allows to replace the imported value to the corresponding current date, current time, current date and time, the full name of the imported file, the short name of the imported file.
  • QImport3Xlsx. Restored the compatibility with the old-format config-file.
  • QImport3Xlsx. When setting a custom data format for numbers in an Excel cell, the date format was applied to the imported values. Fixed now.
  • ADO_QImport3Access. The Blob data were not imported. Fixed now.
  • QImport3Xlsx. The first empty cell caused stopping the data import from the column. Fixed now.
  • QImport3Xlsx. When specifying column X1 in the Map, the data were imported from column A1. Fixed now.
  • QImport3Xlsx. If the date data format did not match the system format, an error occurred. Fixed now.
  • QImport3Xls. The absence of data in a column or in a row caused the error. Fixed now.
  • Other improvements and bugfixes.

New in Advanced Data Import for RAD Studio VCL 3.50 (Dec 10, 2014)

  • TQImport3XML. Unicode support is added.
  • TQImport3Xlsx. The parsing logic of the Map property has been changed, now it is possible to specify the following parameters:
  • - range of cells in the row or column - A1-F1, B1-B12, C1-ROWFINISH, 4-COLFINISH;
  • - sheet name - [Sheet2]B1-B6;
  • - sheet number - [:3]D4-D9;
  • - several cellsets for the same field - [Sheet2]C12-2[:1]A1-A8;
  • Added the AutoTrimValue property. When AutoTrimValue = True, the Trim function will be applied to each string value.
  • Added the ImportEmptyRows property. When ImportEmptyRows = False, the empty strings will not be imported.
  • When importing from Excel 2003 a formula was calculated incorrectly. Fixed now.
  • TQImport3Wizard. Fractional numbers were always separated by a point, regional settings were discarded. Fixed now.
  • Importing from CSV format caused the program hang-up. Fixed now.
  • TQImport3Wizard. XML files were imported with empty strings. Fixed now.
  • TQImport3Wizard. Strings longer than 8 KB were displayed incorrectly. Fixed now.
  • TQImport3Wizard. Now it is possible to resize the window of the wizard.
  • Other improvements and bugfixes.

New in Advanced Data Import for RAD Studio VCL 2.40 (May 23, 2009)

  • Fixed the bug with XML Import editor – file filtering in Open File Dialog was incorrect: .dbf instead of .xml
  • ADO_Import2Wizard. The SkipLines value was neither saved nor restored when importing from TXT file. Fixed now.
  • Import2Wizard and ADO_Import2Wizard. With the Show Error Log after import flag on the error log file was not shown. Fixed now.
  • Import2Wizard è ADO_Import2Wizard. The repeated load of the template
  • file (without closing the ImportWizard) caused the duplication of the values in the Replacements list. Fixed now.
  • Import2Wizard and ADO_Import2Wizard. With AutoLoadTemplate and
  • AutoSaveTemplate options on there were some problems with loading and
  • writing of the template. Fixed now.
  • Now it is possible to log the errors caused by incorrect field formats.
  • QImport2XLS. When not all fields were mapped it caused error "List Index out of bounds" during opening the Map component editor in design time mode. Fixed now.
  • QImport2DBF. When importing from DBF using an FPT file, the lengths of MEMO type fields were calculated incorrectly.
  • The new custom date-string parser allows to recognize dates in any format including the initial zeros, i.e. either 7/3/2000 or 07/03/2000.
  • 10. Significant improvements related to working with TQImportFieldFormat.NullValue and TQImportFieldFormat.DefaultValue options, including the correct saving of them into a template file.
  • Added new AllowDuplicates feature that optionally allows to create duplicates during the import modes: Insert All, Update or Insert, Delete or Insert.
  • Delphi 2006 support.
  • EMS Quick Import Component Suite renamed to EMS Advanced Import Component Suite!