Benetl Changelog

What's new in Benetl 5.8.0

Jan 4, 2024
  • This version uses Java 17 and has been tested with postgreSQL 16.loading and MySQL 8.loading.
  • This version brings great code improvements (code quality) and a better unit tests coverage (over 71% code coverage).
  • Correcting a small problem in createFunctionIntervalDate database function.
  • Updating etltool.sh with JDK-17 path.

New in Benetl 5.7.0 (Nov 24, 2023)

  • This version uses Java 17 and has been tested with postgreSQL 16.loading and MySQL 8.loading.
  • This version brings code improvements (code quality) and a better unit tests coverage (over 60%).
  • Correcting one regression with "Managing Entities".

New in Benetl 5.6.0 (Aug 26, 2022)

  • This version brings some code improvement and a better unit tests coverage.

New in Benetl 5.5.0 (Feb 21, 2022)

  • This version is a security update: uses log4j 2.17.1. It brings some code improvement and a better unit tests coverage.

New in Benetl 5.4.0 (Dec 20, 2021)

  • Security version, log4j updated

New in Benetl 5.3.0 (Jul 31, 2021)

  • This versions brings support of Java Runtime 11.

New in Benetl 5.2.0 (Nov 1, 2020)

  • This versions is correcting two problems:
  • entities management was previously failing with MySQL
  • data lines unicity was not kept if the EtlTool table was deleted and recreated through out etltool.bat / etltool.sh instead of etltool_gui.bat / etltool_gui.sh
  • EtlRun logs are improved also.
  • Some new tests have been implemented.
  • Quality code improvement.

New in Benetl 5.1.0 (Aug 9, 2020)

  • A bug in Benetl 5.0 installer for Windows has been solved.
  • Benetl is now running with postgreSQL 12 and MySQL 8.
  • For postgreSQL 12 the driver embedded is: postgresql-42.2.14.jar
  • For MySQL 8, you have to provide the driver mysql-connector-java-8.0.21.jar
  • In "benetl_my.xml" and "benetl_pg.xml" the tag "postgresql" is now "database" for the both files.
  • etlool_gui.bat and etltool_gui.sh are now running with debug mode activated.
  • Some new tests have been implemented.
  • Quality code improvement.

New in Benetl 5.0.0 (Mar 27, 2020)

  • This major version is bringing to ability to import JSON files as data.
  • A small improvment on xls file import has also been done.

New in Benetl 4.9 (Oct 23, 2018)

  • Some code optimizations, tests coverage improvement.
  • Correcting one bug (dist function now returns result with a double type).
  • You should update.
  • Thanks for your interest.

New in Benetl 4.8 (Jun 28, 2017)

  • Some code optimizations, tests coverage improvement.
  • Now supporting Java 1.8.
  • Correcting one bug.

New in Benetl 4.7 (Aug 9, 2016)

  • Some code optimizations, performance and tests coverage improvement.
  • Correcting one bug in debug mode.
  • Correcting one bug in logging system.

New in Benetl 4.6 (May 14, 2015)

  • Some optimizations and performance improvement.

New in Benetl 4.5 (May 14, 2015)

  • This version is correcting two bugs:
  • Trouble with double parsing when data contains ',' as float separator
  • Divide function now accepts negative operand and shows an error when divide by 0
  • Part operator brings a new function: fact.
  • New error messages provided.
  • More than 100 tests passed.

New in Benetl 4.4 (Apr 13, 2014)

  • This version is correcting two bugs:
  • Trouble with double parsing when data contains ',' as float separator
  • Divide function now accepts negative operand and shows an error when divide by 0
  • Part operator brings a new function: fact.
  • New error messages provided.
  • More than 100 tests passed.

New in Benetl 4.4 (Jun 11, 2013)

  • This version brings much better peformances with a new functionality: batch mode.
  • In the GUI you can set the number of lines to be commited in a same transaction.
  • This versions is correcting two bugs:
  • The last line read was forgotten we re-run an EtlTool (bug brought by version 4.3).
  • The last line read was read again if its position in the file is equal to first line to read position, when re-run an EtlTool.
  • Some GUI improvement and new tests added.

New in Benetl 4.3 (Mar 28, 2013)

  • This version brings a new way of reading "control_file.xml" files, several code corrections
  • This versions is correcting two bugs:
  • Trouble with entity_id when inserting raw data
  • Trouble with sql script creation when setting "none"

New in Benetl 4.2 (Oct 29, 2012)

  • This version brings several code corrections and performance improvement.
  • A new error is handled when a date is prior to 1970.
  • In this case, this error is counted in rejected lines but not shown in the log file.

New in Benetl 4.1 (Oct 1, 2012)

  • This version brings GUI improvement: control of field names and table (EtlTool) name.
  • With this version, it is now possible to use > and < with "if" operator on a part formula.
  • This version brings some code correction and improvement.

New in Benetl 4.0 (Mar 9, 2012)

  • This version brings you the opportunity to manipulate structured data lines without separators.
  • If every lines have the same structure and no separators, with "part" formula you can use extra fields, regular expressions, substrings, on these lines.

New in Benetl 3.9 (Nov 10, 2011)

  • This version is correcting two bugs in GUI and brings code improvement

New in Benetl 3.8 (Oct 31, 2011)

  • This version supports postgreSQL driver 9.0, tested on postgreSQL 9.1.
  • This version supports MySQL official driver (not provided).

New in Benetl 3.7 (Oct 31, 2011)

  • This version brings new controls and messages in the GUI.
  • This version brings improvements and a bug correction in GUI.

New in Benetl 3.6 (Oct 31, 2011)

  • This version brings new controls and messages in the GUI.
  • Important : when you change the name of a field, don't forget to type "enter" to continue.
  • It is now possible to define a specific database url / user / password per EtlTool (instead of using benetl_pg.xml / benetl_my.xml of Benetl folder).

New in Benetl 3.5 (Oct 31, 2011)

  • This version brings the conditional operator "if" in "part formula".
  • This is bringing much more possibilities of transformation to Benetl.
  • Please read documentation about "part formula".
  • This version corrects several bugs.

New in Benetl 3.4 (Oct 31, 2011)

  • This version is correcting a bug with time functions (yesterday, today, tomorrow) in "part formula".
  • These functions are now using datetime format.

New in Benetl 3.3 (Oct 31, 2011)

  • "Extra" fields: it is now possible to add new fields ("extra" fields) to your EtlTool in order to do "part formula".
  • It means that you can keep all your original data and you do transformations ("part formula") in a field which is not initialy containing data.
  • No data is now lost in the transformation of your data.
  • The log file is now providing the elapsed time to parse each data file and the number of rejected lines of the parsed data file.

New in Benetl 3.2 (Oct 31, 2011)

  • Support Java SE 6 and is using memory arguments for JVM.

New in Benetl 3.1 (Oct 31, 2011)

  • Automatically translate it with the date format you have chosen.

New in Benetl 3.0 (Oct 31, 2011)

  • Support of MySQL database.
  • It has been tested on a 5.4 MySQL database, using old_password function for user login.
  • This new version is correcting several bugs:
  • - correcting a bug with entities groups names
  • - correcting a bug (since 2.7) with creation script
  • - correcting a bug in labels for connection trouble