Commander4j Changelog

What's new in Commander4j 10.29

Apr 6, 2024
  • Primarily updates to the Weight Checks module.
  • Some bug fixes.

New in Commander4j 10.27 (Mar 31, 2024)

  • Update to email libraries and misc bug fixes.

New in Commander4j 10.25 (Mar 24, 2024)

  • Main update included in this release is better handling of diaglog box's on multi screen displays.
  • Weight Check Reports now has a enhanced selection criteria feature for sample points.

New in Commander4j 10.24 (Mar 13, 2024)

  • Minor change to the Weight Checks data capture screen.
  • Updates to 3rd party libraries

New in Commander4j 10.23 (Feb 18, 2024)

  • Update to 3rd party libraries and minor updates to some desktop screens.

New in Commander4j 10.20 (Feb 4, 2024)

  • Minor bug fixes, update to 3rd party libraries and bundled java

New in Commander4j 10.19 (Nov 23, 2023)

  • Minor update to label reports and updated dependencies

New in Commander4j 10.18 (Oct 27, 2023)

  • Updates to Quality Module.

New in Commander4j 10.17 (Oct 13, 2023)

  • Updated JasperReports

New in Commander4j 10.16 (Sep 24, 2023)

  • Updated support for Enterprise Browser.

New in Commander4j 10.13 (Aug 28, 2023)

  • Bug fix to schema script for 1 view.

New in Commander4j 10.12 (Aug 15, 2023)

  • Bug fix to schema script for 1 view

New in Commander4j 10.11 (Aug 11, 2023)

  • Bug fixes

New in Commander4j 10.10 (Aug 4, 2023)

  • Contains mainly updates to the database scripts held in xml files to ensure that table and view names use a consistent uppercase and lowercase format. This is needed for mySQL on linux platforms.

New in Commander4j 10.02 (Jul 30, 2023)

  • Updated Pallet Sorting Module functionality
  • Bug Fixes and Reporting Enhancements

New in Commander4j 10.0 (Jul 18, 2023)

  • Java 17 release

New in Commander4j 9.70 (Jul 2, 2023)

  • Update to 3rd party libraries.

New in Commander4j 9.61 (Apr 23, 2023)

  • [Installer] Bundled Java updated to 11.0.19

New in Commander4j 9.46 (Oct 31, 2022)

  • 0002114: [3rd Party Library Updates] Update JasperReports Library to version 6.20.0
  • 0002118: Correct SQL statement used by QM Panel Enquiries screen for mySQL and Oracle

New in Commander4j 9.43 (Aug 15, 2022)

  • 0002091: [Servlet (Apache Tomcat)] Servlet does not work with Apache Tomcat 10

New in Commander4j 9.36 (Apr 8, 2022)

  • [3rd Party Library Updates] Update Jasper Reports Library to 6.19

New in Commander4j 9.34 (Feb 6, 2022)

  • Commander4j Version 9.34 contains log4j 2.17.1 patched version. This version is not effected by (CVE-2021-44228)

New in Commander4j 9.22 (Nov 10, 2021)

  • Update 3rd party libraries

New in Commander4j 9.14 (Jul 30, 2021)

  • 0001975: [Scanner] Create Despatch on Scanner with MySQL database encountering null string exception
  • 0001974: [New Feature Requests] Add function to Despatch Screen to allow pick list to be imported from XML file.

New in Commander4j 9.12 (Jul 5, 2021)

  • [Database] Add indexes to APP_WASTE_LOG table (dgarratt)
  • 0001958: [Waste Recording] Scanner option always blanks out Process Order when a data validation error is detected during Submit (write) (dgarratt)
  • [Software Deployment] Bundled Java updated to openjdk version "11.0.11" LTS OpenJDK Runtime Environment Zulu11.48+21-CA (build 11.0.11+9-LT (dgarratt)
  • [Desktop] Add option to table popup menu's which will permit field value to be copied to clipboard. (dgarratt)

New in Commander4j 9.08 (Jun 19, 2021)

  • [3rd Party Library Updates] Oracle JDBC Driver updated to Version 21.1
  • [3rd Party Library Updates] MS SQL JDBC Driver Update to Version 9.2.1
  • [3rd Party Library Updates] Update MySQL JDBC Driver to version 8.0.24
  • [3rd Party Library Updates] Update JasperReports Library to version 6.17 (Java 11 Release)

New in Commander4j 9.06 (Jun 19, 2021)

  • [3rd Party Library Updates] Update Cups4j to version 0.7.8
  • [Desktop] Modifications to Waste Module - Add Tare

New in Commander4j 9.04 (Jun 19, 2021)

  • [Software Deployment] Install4j updated to version 9.0.2
  • [3rd Party Library Updates] Cups4j Updated to version 0.7.8

New in Commander4j 9.03 (Jun 19, 2021)

  • [Email Notifications] Automated emails not working since updating to Java 11

New in Commander4j 9.02 (Jun 19, 2021)

  • [Software Deployment] Java runtime updated - changed from AdoptOpen to Zulu for Apple Silicon support

New in Commander4j 8.10 (Apr 21, 2021)

  • [3rd Party Library Updates] Update mySQL JDBC driver to version 8.0.22
  • [3rd Party Library Updates] Update MS SQL Server JDBC driver to version 8.4.1
  • [Software Deployment] Update Bundled Java to OpenJDK 8 (275)

New in Commander4j 8.08 (Dec 31, 2020)

  • 0001876: [New Feature Requests] Add resource selection criteria to Pallet Admin screen.
  • 0001878: [Database] Ensure that all mySQL functions use include DETERMINISTIC type settings so no exceptions are generated during schema creation.
  • 0001875: [New Feature Requests] Amend Label History screen so that number of records retrieved can be configured and is not hard coded to 50 rows
  • 0001874: [3rd Party Library Updates] Update JasperReports library to 6.15.0

New in Commander4j 8.05 (Sep 10, 2020)

  • 0001816: [3rd Party Library Updates] Update JasperReports Library to version 6.13.0

New in Commander4j 8.04 (Jul 5, 2020)

  • [3rd Party Library Updates] Update Install4j to version 8.0.7

New in Commander4j 8.02 (May 13, 2020)

  • [Desktop] Correct bug in unit of measure maintenance screen which saved description in upper case
  • [Installer] Install4j updated to version 8.0.6 (dgarratt)
  • [Database] Amend schema creation scripts for Oracle databases to remove quotes and eliminate case sensitive table name issues.
  • [Scanner] Add scanner function to allow recording of waste

New in Commander4j 8.01 (May 1, 2020)

  • [Database] Case sensitive table name issue in Waste view selection and erroneous .toUpper in JDBQuery
  • [Scanner] Update Cups4j used by servlet scanner app and add additional dependencies

New in Commander4j 8.00 (Apr 30, 2020)

  • [Database] Major overhaul of mySQL database support on Linux based systems.
  • [Software Deployment] First public release of Waste recording module
  • [3rd Party Library Updates] Update JSerial to version 2.62
  • [3rd Party Library Updates] Update Java JRE to jdk8u252-b09
  • [3rd Party Library Updates] Update mySQL JDBC driver to version 8.0.20

New in Commander4j 7.32 (Apr 10, 2020)

  • [Reports] Check all reports for font size issues. (dgarratt)
  • [3rd Party Library Updates] Update MS SQL JDBC driver to version 8.2.0 (dgarratt)
  • [Database] Amend database collation for all fields in table APP_WEIGHT_SAMPLE_DETAIL to database_default (dgarratt)
  • [Build Scripts] Update bundled java to OpenJDK Runtime Environment (AdoptOpenJDK)(build 1.8.0_242-b08) (dgarratt)

New in Commander4j 7.31 (Feb 28, 2020)

  • 0001743: [Installer] Change installer so that licence prompt does not appear during auto update, (dgarratt)

New in Commander4j 7.27 (Jan 3, 2020)

  • 0001722: [New Feature Requests] Extend batch number formatting to include PO_PLANT which is the plant determined from the PO Location
  • 0001706: [3rd Party Library Updates] Update JasperReports Library to version 6.11.0
  • 0001701: [Database] Much improved support for Oracle databases. Min version now 12c
  • 0001700: [Clone Utility] Improve copy of text field with no data
  • 0001697: [Database] Amend Oracle Row Limit from RowNum to FETCH FIRST xxx Syntax

New in Commander4j 7.26 (Jan 3, 2020)

  • 0001685: [3rd Party Library Updates] Update mySQL Jdbc connector to version 8.0.18
  • 0001684: [Desktop] Export to Excel problem with PATH being converted to lower case as well as filename - error invalid path
  • 0001683: [Desktop] Fix to printer enumeration generating exception when description is null

New in Commander4j 7.25 (Dec 7, 2019)

  • [OS Specific Issues] Error loading reports on linux as filename returned from modules is lower case a some reports include upper case chars
  • [Reports] Pallet Report Pallet Label A5 has problem with SSCC font wrapping - text field too small.

New in Commander4j 7.11 (Jul 13, 2019)

  • [Desktop] Add 3rd party open source information to help menu.
  • [3rd Party Library Updates] Update JasperReports Library to version 6.9.0

New in Commander4j 6.09 (May 22, 2019)

  • [Database] Add new column PREFIX_CODE to Production Line database and include in views for auto labeller
  • [Database] mySQL Connection Timout parameter added to jdbc connection string
  • [3rd Party Library Updates] Update mySQL Jdbc connector to version 8.0.16
  • [3rd Party Library Updates] Update ms sql server Jdbc connector to version 7.2.2
  • [Security] Add host (server name) to welcome screen.

New in Commander4j 6.04 (Mar 31, 2019)

  • 0001516: [3rd Party Library Updates] Update JasperReports library to version 6.7.1
  • 0001518: [Label Printing] New functions available within label template files to permit pallet weigh to be calculated and printed.
  • 0001517: [Interfaces] Update to inbound file processing file filter

New in Commander4j 6.03 (Mar 31, 2019)

  • 0001511: [3rd Party Library Updates] Update mySQL jdbc driver to version 8.0.15
  • 0001508: [Software Deployment] Update install4j to version 7.0.10
  • 0001497: [3rd Party Library Updates] Update MS SQL JDBC driver to version 7.2.1 for Java 8
  • 0001496: [3rd Party Library Updates] Revert SQL Server JDBC driver to version 7.0.0
  • 0001473: [3rd Party Library Updates] Update MS SQL JDBC driver to version 7.2 for Java 8
  • 0001470: [Scanner] Target Apache Tomcat 8.5.37 when building b4web.war
  • 0001469: [Desktop] Remove any journey assigned to despatch when despatch is deleted.

New in Commander4j 6.02 (Feb 10, 2019)

  • 0001449: [Installer] Java 1.8.0 (202) now bundled with installer
  • 0001464: [Desktop] Unable to assign "NO JOURNEY" to a despatch
  • 0001463: [Desktop] mySQL specific error using journey ref on screen lookup due to use of view rather than table.

New in Commander4j 6.01 (Feb 10, 2019)

  • 0001445: [Installer] Install4j updated to version 7.0.9
  • 0001442: [New Feature Requests] Add popup dynamic lookup option on Batch Admin screen to view Pallet Admin and Pallet History Admin

New in Commander4j 6.00 (Feb 10, 2019)

  • 0001431: [Interfaces] Add from and to GLN Location data to Equipment Tracking message
  • 0001424: [Database] Correct join issue with view_pallet_history_expiry in mysql database
  • 0001425: [Desktop] Amend logon error message to ensure it is a foreground dialog box with focus
  • 0001426: [Desktop] Change desktop table / grid look and feed by improving header.
  • 0001427: [Installer] Amend install4j so that the jvm memory paramters -Xms256m -Xmx1024m are removed, Not needed in Java 8

New in Commander4j 5.64 (Feb 10, 2019)

  • 0001421: [Desktop] Add popup to table in Process Order Admin to load Pallet History for selected Material
  • 0001422: [Desktop] Add popup to table in Process Order Admin to load Pallet Admin for selected Material
  • 0001420: [Desktop] Add popup to table in Material Admin to load Pallet Admin for selected Material
  • 0001419: [Desktop] Add popup to table in Material Admin to load Pallet History for selected Material
  • 0001418: [Database] Add index on Pallet History table for field MATERIAL
  • 0001416: [Database] Add index on Pallet History table for field PROCESS_ORDER

New in Commander4j 5.63 (Nov 20, 2018)

  • 0001408: [Desktop] Duplicate search criteria on Process Order screen for Customer ID
  • 0001412: [New Feature Requests] Add customer search to Pallet History screen
  • 0001410: [Database] Increase column MESSAGE_ERROR in SYS_INTERFACE_LOG to 200 characters
  • 0001407: [3rd Party Library Updates] Update MS SQL Server JDBC driver to version 7.0.0
  • 0001406: [3rd Party Library Updates] mySQL JDBC updated to 8.0.13
  • 0001405: [Database] Correct error in VIEW_QM_RESULTS for mySQL Schema
  • 0001395: [Reports] Update Jasperreports library to version 6.7.0
  • 0001404: [Software Deployment] Bundled java now updated to 8 (1.9.2.)
  • 0001403: [New Feature Requests] Add option to copy/clone Process Order to admin screen.
  • 0001398: [Desktop] Add options to Process Order table popup menu to access Material and Location

New in Commander4j 5.60 (Aug 16, 2018)

  • 0001352: [Database] Add option to flag Material record as either Enabled or Disabled so obsolete materials can be filtered out.
  • 0001347: [3rd Party Library Updates] mySQL JDBC driver updated to 8.0.12

New in Commander4j 5.59 (Jul 30, 2018)

  • 0001330: [Setup] Fix schema export report in Setup4j (dgarratt)
  • 0001326: [Setup] Correct bug in setup4j and jdbc connect string function to include non default port for SQL Server (dgarratt)
  • 0001329: [Desktop] Fix display of about logo which has hard coded path (dgarratt)

New in Commander4j 5.57 (Jul 23, 2018)

  • [New Feature Requests] Add functionality to copy pallets from one commander4j database to another. (dgarratt)
  • [Database] Column PRINT_COPIES in table APP_LABEL_DATA changed to INT from VARCHAR (SQL Server Only) (dgarratt)
  • [Interfaces] Include Layers in CSV export (dgarratt)
  • [New Feature Requests] Add Layers calculation and database column to table APP_LABEL_DATA for Pallet only type transactions. (dgarratt)
  • [Security] Apply permission to Process Order Label print option. (dgarratt)
  • [New Feature Requests] Improved layout and filter capability for Production Line Admin screen. (dgarratt)

New in Commander4j 5.55 (Jul 23, 2018)

  • [Label Printing] Change layout of Process Order barcode (dgarratt)
  • [Desktop] Move the setting of the printer data modified flag to the assignment function in JDialogAssignLabelDataToLine (dgarratt)
  • [Interfaces] Remove generic outbound label data interface as it's a duplicate of individual printer interfaces. (dgarratt)
  • [Interfaces] Write label data csv file using temp suffix of .out to prevent early processing by labeller service. (dgarratt)
  • [3rd Party Library Updates] Update JasperReports from 6.5.1 to 6.6.0 (dgarratt)

New in Commander4j 5.53 (Jul 23, 2018)

  • [Label Printing] Create 2 Case labels for ZPL compatible printers (dgarratt)
  • [Label Printing] Add PART_NO field from extension table to VIEW_LABEL_DATA view. (dgarratt)
  • [Database] Ensure that nanoseconds are removed before saving batch expiry dates to the APP_MATERIAL_BATCH table (dgarratt)
  • [Setup] Add functionality to check for updates to hosts file from remote url. (dgarratt)
  • [3rd Party Library Updates] Update Apache Commons Lang to commons-lang3-3.7.jar (dgarratt)

New in Commander4j 5.52 (May 3, 2018)

  • 0001234: [Database] jdbc connection string for mysql not including port number if non default value specified. (dgarratt)
  • 0001233: [New Feature Requests] Add Help button to Setup4j (dgarratt)
  • 0001232: [Desktop] Enable beep warning sound when running desktop and setup programs when error dialog appears (dgarratt)
  • 0001231: [New Feature Requests] Add buttons on Setup4j to validate paths (dgarratt)
  • 0001145: [New Feature Requests] Add new attribute to Material Master data which is used to indicate if 2nd barcode needs to be validated during Prod Confirm (dgarratt)
  • 0001230: [3rd Party Library Updates] Update bundled java to 8 (1.8.0_172) (dgarratt)
  • 0001229: [3rd Party Library Updates] Update Microsoft JDBC drivers to mssql-jdbc-6.4.0.jre8.jar (dgarratt)
  • 0001228: [3rd Party Library Updates] Oracle JDBC updated to version 12.2.0.1 (dgarratt)
  • 0001227: [3rd Party Library Updates] mysql jdbc library updated to mysql-connector-java-8.0.11.jar (dgarratt)
  • 0001226: [Database] Add support for mySQL version 8.x (dgarratt)
  • 0001219: [New Feature Requests] Add independent version check and auto update of hosts file. (dgarratt)
  • 0001225: [Setup] Add option to Hosts Config (Setup4j) to allow program to open files from user specified locations. (dgarratt)
  • 0001222: [Desktop] Error determining override to label module id (dgarratt)
  • 0001212: [Desktop] Material Master main screen does not reset module override values when new material is selected. (dgarratt)

New in Commander4j 5.42 (Apr 16, 2018)

  • [Clone Utility] Clone utility is not closing all connections on completion and cannot be run twice in succession. (dgarratt)
  • [Installer] include install4j.jar in distribution but remove from manifest.mf (dgarratt)
  • [Interfaces] Remove characters used by OS as path separators from labeller id's when building output filenames (dgarratt)
  • [New Feature Requests] Add option to schedule interface maintenance task for specific time of day (dgarratt)
  • [New Feature Requests] Journey selection dialog to automatically filter by despatch destination location id (dgarratt)
  • [New Feature Requests] Enhance message recovery thread to filter files by file extensions suitable for appropriate file types. (dgarratt)
  • [Software Deployment] Java updated to version 1.8.0_162 (dgarratt)
  • [Installer] Install4j updated to version 7.04 (dgarratt)
  • [New Feature Requests] Material Locations Admin - provide combo box of valid locations when adding new record. (dgarratt)
  • [3rd Party Library Updates] JasperReports Library updated to version 6.5.1 (dgarratt)

New in Commander4j 5.41 (Apr 16, 2018)

  • [Interfaces] Incoming Material Batch XPath code has typo in XML structure (dgarratt)
  • [3rd Party Library Updates] Update mySQL JDBC driver from mysql-connector-java-5.1.43-bin to mysql-connector-java-5.1.45-bin (dgarratt)
  • [3rd Party Library Updates] Update Microsoft JDBC from sqljdbc42.jar to mssql-jdbc-6.2.2.jre8.jar (dgarratt)
  • [3rd Party Library Updates] Update jackcess-2.0.5 to jackcess-2.1.9 (dgarratt)
  • [3rd Party Library Updates] Update from commons-email-1.3.3 to commons-email-1.5 (dgarratt)
  • [3rd Party Library Updates] Update commons-io-2.4 to commons-io-2.6 (dgarratt)
  • [3rd Party Library Updates] Update commons-text-1.1 to commons-text-1.2 (dgarratt)
  • [3rd Party Library Updates] Update JasperReports library to version 6.5.0 (dgarratt)
  • [3rd Party Library Updates] Update OpenCSV to version 4.1 (dgarratt)

New in Commander4j 5.40 (Jan 14, 2018)

  • [Scanner] Add new pallet completion option to scanner menu which requires case label validation. (dgarratt)
  • [Scanner] Add new option to scanner menu to permit operator to verify GTIN barcodes on case and pallet labels are consistent (dgarratt)
  • [Reports] Change app ident for Case/Tray Jasper Reports so that EAN is type 01 not 02 (dgarratt)
  • [Interfaces] Inbound Journey messages with wrong location don't display correct message in interface log (dgarratt)
  • [3rd Party Library Updates] JasperReports updated to version 6.4.3 (dgarratt)
  • [Software Deployment] Bundled Java updated to Java 8 (1.8 152) (dgarratt)
  • [New Feature Requests] Add data archive routine to delete old data from APP_LABEL_DATA table. (dgarratt)
  • [New Feature Requests] Add data archive routine to delete pallet data over nominated age. (dgarratt)

New in Commander4j 5.39 (Dec 13, 2017)

  • [Desktop] Add config file to customise application name, web links and support contact email
  • [Desktop] Do not display host selection dialog if only 1 host defined.
  • [Master Data] Create demo data folders and interfaces which can be enabled to populate an empty database
  • [New Feature Requests] New inbound interface to create Locations required.

New in Commander4j 5.38 (Oct 11, 2017)

  • [Interfaces] Improve email exception message when incoming prod dec has a batch number field which contains too many chars (dgarratt)
  • [Scanner] Remove trailing spaces from the journey ref field when saved. (dgarratt)
  • [Database] APP_LABEL_DATA - PROD_QUANTITY and BASE_QUANTITY being transposed when populating via case labelling. (dgarratt)
  • [Label Printing] pack_label_01.jrxml and pack_label_02.jrxml amendments in issue 0001046 (dgarratt)
  • [Label Printing] Zebra_300dpi_Pack_Label_01.lbl and Zebra_300dpi_Pack_Label_02.lbl amendments in issue 0001046 (dgarratt)
  • [Installer] Install4j updated to 7.02 (dgarratt)
  • [Security] Wrong permission name assigned to user reports Save button (dgarratt)
  • [Label Printing] Add "Assign to Labeller" option to Finished Goods - Pallet Labeling screen. (dgarratt)
  • [Reports] Include a new user defined report as standard to Export Despatch data to Excel - DESPATCH_EXP (dgarratt)
  • [Build Scripts] Oracle schema version 103 contains a hard coded schema (owner) name which needs to be removed. (dgarratt)
  • [Software Deployment] Update Bundled Java runtime to 1.8.0_144 (dgarratt)

New in Commander4j 5.37 (Aug 7, 2017)

  • 0001001: [Clone Utility] Clone has not copied nvarchar fields from MS SQL to mysql (dgarratt)
  • 0001000: [Installer] JVM command line parameters has wrong path to log4j.xml (dgarratt)
  • 0000738: [Desktop] Add new button to Module Admin screen to test selected modules help page - invocation of correct Wiki Page (dgarratt)
  • 0000299: [New Feature Requests] Include despatch number in email exception relating to Equipment Tracking warning messages (dgarratt)
  • 0000034: [Desktop] Restrict edit Expiry Date by a permission (dgarratt)
  • 0000738: [Desktop] Add new button to Module Admin screen to test selected modules help page - invocation of correct Wiki Page (dgarratt)
  • 0000999: [Scanner] Update target version of Apache Tomcat to 8.5.16 (dgarratt)
  • 0000998: [Translations] Refresh Hungarian Translations in Database (dgarratt)
  • 0000997: [Translations] Refresh Polish Translations in Database (dgarratt)
  • 0000995: [Build Scripts] Upgrade bundled Java to Java 8 Update 141 (dgarratt)
  • 0000994: [3rd Party Library Updates] Update mySQL jdbc driver to 5.1.43 (dgarratt)
  • 0000991: [Security] Create 2 new groups JOURNEY_PRINT and JOURNEY_ADMIN during update to version 5.37 Schema 106 (dgarratt)
  • 0000990: [Scanner] Journey Error Message not cleared from Scanner screen when correct value entered. (dgarratt)
  • 0000977: [Build Scripts] Install4j updated to version 7.0 (dgarratt)
  • 0000971: [Software Deployment] Amend install4j update process so that the "silent update" does not prompt user at all. (dgarratt)
  • 0000989: [Build Scripts] Install4j updated to version 7.01 (dgarratt)
  • 0000982: [Build Scripts] Verify and correct differences in database (data) populated during initial database creation. (dgarratt)
  • 0000969: [Reports] Create new report for security audit (dgarratt)
  • 0000984: [Database] Column 'resource_key' in table SYS_MODULES needs to be uppercase in MS SQL Schema. (dgarratt)
  • 0000976: [Interfaces] Create Interface Log Archive job definitions during schema 106 upgrade. 30 Day retention period. (dgarratt)
  • 0000979: [New Feature Requests] Add the ability to specify mixed printer types for a single report. (dgarratt)
  • 0000981: [Translations] Refresh Dutch Translations in Database (dgarratt)
  • 0000980: [Translations] Refresh Italian Translations in database (dgarratt)
  • 0000970: [Translations] Refresh French Translations to database (dgarratt)
  • 0000967: [Translations] Refresh Spanish Translations in database (dgarratt)
  • 0000968: [3rd Party Library Updates] Upgrade Jasper reports library to 6.4.1 (dgarratt)
  • 0000974: [3rd Party Library Updates] Update calls to Apache POI to use new methods used by updated libraries included in JasperReports 6.4.1 (dgarratt)

New in Commander4j 5.35 (May 26, 2017)

  • [3rd Party Library Updates] Update Oracle JDBC driver to 12c Release 2 (12.2.0.1 (dgarratt) - resolved.
  • [Desktop] Sample Label printing does not clear down user defined input fields if executions of user functions fails to find data. (dgarratt) - resolved.
  • [Software Deployment] Update bundled Java 8 to 131 (8u131) (dgarratt) - resolved.
  • [Desktop] Add new field to QM Select Lists called "Visible" to permit old codes to be suppressed from drop down boxes without deleting. (dgarratt) - resolved.
  • [Desktop] Optimise QM Sample Results Update screen to avoid delay redrawing table when user has entered invalid Process Order Number (dgarratt) - resolved.
  • [3rd Party Library Updates] mySQL JDBC driver updated to version 5.1.41 (dgarratt) - resolved.
  • [Desktop] Add Write Off Reference to Master Holds Header and Reports (dgarratt) - resolved.
  • [Desktop] Add new option to Analyse Quality Results to Menu (dgarratt) - resolved.
  • [3rd Party Library Updates] Update Microsoft SQL JDBC driver to Version 6.0 Jan 2017 Release (dgarratt) - resolved.

New in Commander4j 5.34 (May 26, 2017)

  • (Released 2017-04-01)
  • [Desktop] Add WRITE_OFF_REF field to Master Hold screen and report. (dgarratt) - resolved.
  • [Interfaces] Amend DESADV output for Despatch so that JOURNEY REF has auto generated unique value if not specified by user (dgarratt) - resolved.
  • [Database] Correct column USER_REPORT_ID which has incorrect size in Oracle schema - Table SYS_USER_REPORTS (dgarratt) - resolved.
  • [Desktop] Modify all Excel Export calls on desktop screens to refresh table data after export. (dgarratt) - resolved.
  • [Desktop] Add "Limit" to SQL select on Batch Admin Screen (dgarratt) - resolved.
  • [Database] Add column WRITE_OFF_REF to the APP_MHN table (dgarratt) - resolved.
  • Database] Add new columns USER_DATA_3 and USER_DATA_4 to the table APP_QM_SAMPLE (dgarratt) - resolved.
  • [Reports] Create new User Defined Report type of SYSTEM (dgarratt) - resolved.
  • [Desktop] Add "Limit" to SQL select on Material Admin Screen (dgarratt) - resolved.

New in Commander4j 5.32 (Apr 3, 2017)

  • Released on 2017-01-10
  • 0000904: [Database] Schema creation and sql scripts have case errors which are apparent when mysql server is running under Linux. (dgarratt) - resolved.
  • 0000903: [Interfaces] Extend interface and database to accommodate extra data from Atlas (dgarratt) - resolved.
  • 0000902: [Desktop] When deleting a unconfirmed despatch which has a journey ref assigned make sure journey is released. (dgarratt) - resolved.
  • 0000901: [Software Deployment] Java 1.8.0_121 bundled with application. (dgarratt) - resolved.

New in Commander4j 5.30 (Jan 10, 2017)

  • 0000895: [New Feature Requests] Enhancement to Commander Customer Table (dgarratt) - resolved.
  • Commander4j - 5.28 (Released 2016-11-11)

New in Commander4j 5.28 (Jan 10, 2017)

  • 0000874: [Desktop] Dropdown combo box width wrong in Panel data entry table/grid (dgarratt)
  • 0000873: [Desktop] Enhance Pallet and Tray Labelling by optionally determining batch suffix via Process Order Resource using lookup table. (dgarratt)
  • 0000872: [Desktop] Add missing icons to Lookup buttons (various screens) (dgarratt)
  • 0000871: [Desktop] Add new Process Order Resource Lookup table with batch suffix default value (dgarratt)
  • 0000869: [Desktop] Add Resource Lookup buttons to Process Order screens (Admin & Properties) (dgarratt)
  • 0000868: [Desktop] Define missing language text setting for Material Location Properties screen (dgarratt)
  • 0000870: [Desktop] Correct background colour for Resource Properties and Material Location Properties Screen. (dgarratt)
  • 0000865: [Interfaces] Prevent inbound pallet status change from triggering outbound status change message (dgarratt)

New in Commander4j 5.27 (Oct 25, 2016)

  • [Software Deployment] Bundled Java updated to version 1.8.0_112
  • [New Feature Requests] Button to be added to Desktop Despatch screen to remove currently assigned Journey Ref
  • [Interfaces] Suppress creation of outbound DESADV message if Despatch contains no pallets.
  • [Database] Amend database function to round up number of layers on pallet when result is not an integer.
  • [3rd Party Library Updates] Update MS SQL jdbc driver to 4.2
  • [3rd Party Library Updates] Update JasperReports to version 6.3.1.
  • [3rd Party Library Updates] Update mysql driver to version 5.1.40

New in Commander4j 5.25 (Aug 2, 2016)

  • [Label Printing] Add Intermec Fingerprint label printing as an alternative to Zebra ZPL (dgarratt).

New in Commander4j 5.23 (Aug 2, 2016)

  • [Software Deployment] If user selects installer with bundled jre force that JRE to be installed used even if system has JRE with major version already (dgarratt).

New in Commander4j 5.21 (Aug 2, 2016)

  • [Reports] Upgrade JasperReports library to version 6.2.2 (dgarratt).
  • [Desktop] Color of checkbox wrong on Despatch screen. (dgarratt)

New in Commander4j 5.19 (Aug 2, 2016)

  • [Reports] Exporting audit log to Excel with MS SQL Server database does not export columns of varchar2 (dgarratt).
  • [Desktop] Desktop (Swing) popup calendar does not work is regional settings has a month representation < 3 characters. (dgarratt)

New in Commander4j 5.18 (Nov 18, 2015)

  • Important big fix related to security.

New in Commander4j 5.17 (Nov 11, 2015)

  • [Security] Setting "Password Change Read" at same time as creating new user account does not work
  • [Desktop] QC Dictionary Item Properties - combo box for alignment not showing options correctly.
  • [Desktop] Combobox List width not sizing to accommodate wide items in QC Sample Results screen - Windows Only

New in Commander4j 5.16 (Nov 11, 2015)

  • [Desktop] Password complexity error message does not wrap new lines correctly

New in Commander4j 5.13 (Nov 11, 2015)

  • [Security] Special handling of user "interface" required to accommodate password complexity
  • [Security] Delete user function fails with missing SQL statement when run against MS SQL database

New in Commander4j 5.12 (Nov 11, 2015)

  • [Software Deployment] Java SE 8 [1.8.0_50] now bundled with application - resolved.

New in Commander4j 5.11 (Jul 30, 2015)

  • [Setup] When building schema for mySQL on Linux OS there are errors relating to mixed case table and view names (dgarratt) - resolved.

New in Commander4j 5.10 (Jul 30, 2015)

  • Workstation Validation flag causing null exception when loading Tray/Case label line properties. (dgarratt) - resolved.
  • [Security] Empty warning message when user account locked due to excess number of bad password attempts. (dgarratt) - resolved.

New in Commander4j 5.03 (Jul 30, 2015)

  • [Scanner] Update web application to Java 8 and Tomcat 8 (dgarratt) - resolved.
  • [Software Deployment] Updated to Java 8 (1.8) as minimum required version. (dgarratt) - resolved.

New in Commander4j 5.02 (Jul 30, 2015)

  • [Security] When updating to version 5.x from previous version all current passwords should be converted to lower case (known state) (dgarratt) - resolved.

New in Commander4j 5.01 (Jul 30, 2015)

  • [Setup] SQL update for MS SQL database schema version 93 has syntax error (dgarratt) - resolved. - 0000751: [3rd Party Library Updates] install4j updated to version 6.03 (dgarratt) - resolved.

New in Commander4j 5.00 (Jun 26, 2015)

  • [Security] Add timed account auto-unlock facility - configurable reset time - resolved.
  • [Security] Add option to store user passwords within database using a encrypted format. - resolved.
  • [3rd Party Library Updates] JasperReports updated to version 6.1.0 - resolved.
  • [Database] Increase size of TEXT field in SYS_LANGUAGE from 150 to 250 chars to accommodate multi line messages for Password errors - resolved.
  • [Security] Add user disabled option in addition to account locked flag. - resolved.
  • [Security] Ensure password cannot contain user id - resolved.

New in Commander4j 4.60 (Dec 31, 2014)

  • [Desktop] Unable to rename user id. - resolved.
  • [3rd Party Library Updates] Update jasperreports library to version 6.0.0 - resolved.

New in Commander4j 4.58 (Nov 22, 2014)

  • [New Feature Requests] Data Archive feature required. (dgarratt) - resolved.
  • [Setup] Prevent Setup4j from applying updates when target database is newer than setup program (dgarratt) - resolved.
  • [Security] Record workstation that user uses when logging into application against users record. Add workstation_id to users report. (dgarratt) - resolved.
  • [Security] New Login Mode needed PASSTHROUGH_FALLBACK to compliment current modes LOCAL and PASSTHROUGH (dgarratt) - resolved.

New in Commander4j 4.57 (Nov 22, 2014)

  • [Desktop] Syntax in SQL update command blocking reset/resend of Label Data (dgarratt) - resolved.
  • [Desktop] Despatch confirmation common code not updating despatch confirmation date - error manifested with desktop app only (dgarratt) - resolved.
  • [Desktop] Population of available resources on the Production Line Properties screen not working, (dgarratt) - resolved.
  • [Desktop] Checkbox backgroud is white instead of grey when run on Windows platform (dgarratt) - resolved.
  • [Label Printing] Auto Labeller Lines screen has Resend button to re-process data - not working. (dgarratt) - resolved.

New in Commander4j 4.56 (Nov 22, 2014)

  • [Label Printing] Trap null values (strings) being returned from database when evaluating functions in label layouts (dgarratt) - resolved.
  • [Interfaces] Additional selection criteria and columns added to Interface Log screen (dgarratt) - resolved.
  • [Website] New downloads page added with links to SoftPedia, MacInformer and SourceForge (dgarratt) - resolved.
  • [New Feature Requests] Add new function DATATIME for label processing function which allows field name an format spec to be passed to it (dgarratt) - resolved.
  • [Interfaces] CSV File creating routine needs updating to use Labeller ID AND Group ID to retrieve labeller data and build export filenames, (dgarratt) - resolved.
  • [Reports] Archive report not included in build 4.56 (dgarratt) - resolved.
  • [New Feature Requests] Add CUSTOMER ID search criteria to Process Order Admin screen. (dgarratt) - resolved.

New in Commander4j 4.55 (Oct 17, 2014)

  • [3rd Party Library Updates] Incorrect jar files referenced in manifest causing version 4.53 not to start. (dgarratt)

New in Commander4j 4.54 (Oct 3, 2014)

  • [3rd Party Library Updates] Incorrect jar files referenced in manifest causing version 4.53 not to start. (dgarratt) - resolved.

New in Commander4j 4.53 (Oct 3, 2014)

  • [New Feature Requests] Amend Pallet & Pack Labelling screens so that manually typed process orders now warn if order not in Ready/Running status. - resolved.
  • [Interfaces] Add check for 0 byte files to inbound interface validation - resolved.
  • [Interfaces] Add disk free space into Daily Interface Status Reports - resolved.
  • [New Feature Requests] Add new auto archive feature to backup directories which will delete files after x-days - resolved.
  • [Desktop] Material UOM Admin table grid has wrong background colour - resolved.
  • [Desktop] Material UOM Admin screen has Help button mislabeled as Add, - resolved.
  • [New Feature Requests] Enhance inbound file interface to sort files by date/time modified before processing - resolved.
  • [3rd Party Library Updates] Update JasperReports to 5.6.1 - resolved.
  • [Desktop] Icon file contains a minor white line across bottom edge which needs correcting - resolved.
  • [Desktop] Type of CheckBox's on Location Properties is wrong and shows background colour as white. - resolved.
  • [Desktop] Default status (enabled/disabled) for new Locations needs to be Enabled. - resolved.
  • [3rd Party Library Updates] Update Apache Commons Libraries - resolved.
  • [3rd Party Library Updates] Update CSV and MSAccess Libraries - resolved. [3rd Party Library Updates] Update mySQL JDBC library - resolved.

New in Commander4j 4.52 (Sep 22, 2014)

  • [Desktop] Refresh all language translations in database and insert any missing values. (dgarratt) - resolved.

New in Commander4j 4.51 (Sep 22, 2014)

  • [Database] Oracle table SYS_PRINTERS uses wrong data type for field PORT - should be varchar2(10) (dgarratt) - resolved.
  • [Desktop] Pallet History and Pallet Enquiry screens not generating correct SQL with Oracle Databases to limit number of rows returned. (dgarratt) - resolved.
  • [Email Notifications] Simplify the end of day email reports to be only 1 email instead of the current 3 (dgarratt) - resolved.
  • [Reports] Modify Despatch Reporting (dgarratt) - resolved.

New in Commander4j 4.50 (Aug 12, 2014)

  • [Scanner] Add password change option to Scanner Menu
  • [New Feature Requests] Migrate source to Java 1.7 code base. Discontinue support for Java 1.6

New in Commander4j 2.82 (Mar 12, 2010)

  • Support for multiple languages via database include. EN & NL included by default.

New in Commander4j 2.64 RC4 (Mar 12, 2010)

  • Updated JasperReports, Bug Fixes and database schema changes.

New in Commander4j 2.50 (Mar 12, 2010)

  • Interface module now installs and runs as a Windows Service.

New in Commander4j 2.40 (Mar 12, 2010)

  • New JasperReports Library. JSmooth application launcher (wrapper) exe.

New in Commander4j 2.29 (Mar 12, 2010)

  • Additional functionality added to interfacing module.

New in Commander4j 2.25 (Mar 12, 2010)

  • Change to Label Content and Warnings suppressed for MQ recovery threads.

New in Commander4j 2.24 (Mar 12, 2010)

  • Bugfix release with Active MQ support added.

New in Commander4j 2.15 (Mar 12, 2010)

  • Updated screens with popup menus and new version of Jasper Reports

New in Commander4j 2.00 (Mar 12, 2010)

  • Bug Fix version resolves issues with database creation and update scripts.

New in Commander4j 1.98 (Mar 12, 2010)

  • Separate Print and Confirm for Label Genration and Production Declaration.

New in Commander4j 1.97 (Mar 12, 2010)

  • Barcodes now generated by the Barcode4j library.

New in Commander4j 1.93 (Mar 12, 2010)

  • Jasper Reports Support Updated

New in Commander4j 1.91 (Mar 12, 2010)

  • Updated Database Installation routine

New in Commander4j 1.80 (Mar 12, 2010)

  • Updated database routines and corrected bug with selecting network printers

New in Commander4j 1.72 (Mar 12, 2010)

  • Added Excel Export function to screens.

New in Commander4j 1.70 (Mar 12, 2010)

  • Tablular data grids upgraded to page live data as required. More efficient.

New in Commander4j 1.61 (Mar 12, 2010)

  • Corrected issue with barcode printing when fixed legth data fields were invalid.

New in Commander4j 1.60 (Mar 12, 2010)

  • Change to Host and Database Connection as a result of Servlet Developments

New in Commander4j 1.57 (Mar 12, 2010)

  • Fixed bug in setup program saving new config.

New in Commander4j 1.56 (Mar 12, 2010)

  • Updated setup/installer with Vista support.

New in Commander4j 1.55 (Mar 12, 2010)

  • Update to JasperReports 2.01

New in Commander4j 1.54 (Mar 12, 2010)

  • Batch maintenance screen updated. Additional Demo's added

New in Commander4j 1.53 (Mar 12, 2010)

  • Updated Help Files

New in Commander4j 1.51 (Mar 12, 2010)

  • Display update bug corrected in Despatch Confirmation.

New in Commander4j 1.5 (Mar 12, 2010)

  • Pallet History Added.

New in Commander4j 1.42 (Mar 12, 2010)

  • Addional functionality relating to conversion factors.

New in Commander4j 1.4 (Mar 12, 2010)

  • Support for MS SQL Server Added

New in Commander4j 1.3 (Mar 12, 2010)

  • Problem with XML Host Config Corrected.

New in Commander4j 1.2 (Mar 12, 2010)

  • Removed dependancy on DOM4J library.

New in Commander4j 1.1d (Mar 12, 2010)

  • Java 6 Supported

New in Commander4j 1.1c (Mar 12, 2010)

  • Added Despatch Form

New in Commander4j 1.1a (Mar 12, 2010)

  • Amended SQL Processor to remove Tabs from Strings

New in Commander4j 1.1 (Mar 12, 2010)

  • Amended SQL Properties to support Schema Name.

New in Commander4j 1.0h (Mar 12, 2010)

  • Updated JDBC drivers for mySQL 5 and Oracle 10g