CSV Validator 1.4.0

This release has following enhancements and bug fixes

New Features:
• Added the ability to drag and drop CSV and CSVS files anywhere on the window
• Added assisted file path substitution feature that will search CSV for the parent folder in the “identifier” column of the CSV and use it to populate the “from:” box for you
• Added ability to validate metadata only for quicker validation

Enhancements:
• Added ability to configure the maximum number of characters allowed in a cell; default is 4096
• Updated the bundled JRE version from JRE 11 to JRE 21
• GUI-Specific - Made the Output report box responsive to window resizing
• GUI-Specific - Dialog box will remember the last picked file’s location and set it globally initially, but not for subsequent selections. For e.g., selecting a CSV from directory X will set the starting location for the CSVS to directory X but if you navigate to another directory to select a CSVS, CSV Validator will remember that new directory.
• GUI-Specific - “Add File path substitution” dialog box now excludes files from selection and only shows folders.
• GUI-Specific - Added “Remove File Path Substitution” button
• GUI-Specific – Can remove multiple file path substitution rows by either highlighting them all with your mouse or keyboard (Shift + Up arrow) and then clicking the “Remove File Path Substitution” button
• GUI-Specific - Made number of lines of errors that are displayed in the output, configurable.
• GUI-Specific - “Save” dialog now suggests a file name in the “Save as” box, appended with the date at which you pressed the button to it in order to prevent overwriting.
• GUI-Specific - Results box is now larger
• GUI-Specific - “Save” Button is now “Save Results” for clarity
• GUI-Specific - Added tooltips to the “Validate” buttons

Bug Fixes:
• Fixed error that occurs if the schema is referencing a column in the CSV that doesn’t exist
• Number of rows reported will be accurate, even if there are line breaks in a cell
• GUI-specific – An “Open” dialog box is used now when selecting a file instead of the “Save” one
• GUI-specific - Fixed error message that occurs if “Validate” button is pressed without selecting a CSV/CSVS; now nothing will happen
• GUI-specific - Fix for window getting larger/smaller when you open/close the settings

CSV Validator 1.3.0

This release has following enhancements and bug fixes

Enhancements:

• New distribution package with launch scripts and 64 bit JRE (Java 11) included for Windows OS
• Ability to configure heap memory in the launch scripts
• Added skipping of UTF8 BOM
• Safer handling of streams in withReader
• Imporved Streams handling further for BOM
• Switch to UniVocity CSV Parser for better performance when reading CSV
• If a file can't be saved, show a dialog message box that tells the user
• Applied extension filter on file chooser to make it more user friendly

Bugfixes:

• Fix for OutOfMemoryError failure when processing huge csv file
• Show Save Dialog (not Open Dialog) when Saving a file
• Removed circular referencing which was causing the main frame to be recreated
• Corrected the use of "noExt" as mentioned in the schema
• Better error messages for invalid column references in concat
• Fix for malformed error message with switch rules

1.3.0-RC3

This release candidate has all the functionality as it was in 1.3.0-RC2. In addition it has the ability to set higher amount of heap memory when using the package with bundled JRE. This has been achieved by using a 64 bit JRE in the distribution.

1.3.0-RC2

This release candidate has exact same functionality as 1.3.0-RC1-1 and also has a bugfix where the GUI was not showing details of failures caused by schema validation directives such as @totalColumns

1.3.0-RC1-1

This pre-release has following enhancements and bug fixes

Enhancements:

• New distribution package with launch scripts and JRE (Java 11) included for Windows OS
• Ability to configure heap memory in the launch scripts
• Added skipping of UTF8 BOM
• Safer handling of streams in withReader
• Imporved Streams handling further for BOM
• Switch to UniVocity CSV Parser for better performance when reading CSV
• If a file can't be saved, show a dialog message box that tells the user
• Applied extension filter on file chooser to make it more user friendly
• Added a Docker Image build for the Command Line tool

Bugfixes:

• Fix for OutOfMemoryError failure when processing huge csv file
• Show Save Dialog (not Open Dialog) when Saving a file
• Removed circular referencing which was causing the main frame to be recreated
• Corrected the use of "noExt" as mentioned in the schema
• Better error messages for invalid column references in concat
• Fix for malformed error message with switch rules

CSV Validator 1.2-RC4

1. Incorporates a fix for the Save Dialog in the GUI. #334
2. Reinstates Java 7 build compatibility. #335
3. Fixes an AbstractMethodException issue with competing Scala Parser Combinator library versions. #337

It is otherwise identical to the 1.2-RC3 release.

The maven artifacts are available here (the main executables are attached below for convenience)

CSV Validator 1.2-RC3

TODO

CSV Validator 1.1.5

This release incorporates the performance and memory usage improvements contributed by @JessFlan in PR #135.

The 1.1 release integrated the new features of CSV Schema Language 1.1, along with some UI improvements such as showing the actual number of lines of a CSV file that have been validated (also available as a command line option).

The Schema Language Specification includes a what's new section for a quick intro to the new features.

For convenience we provide downloads of the CSV Validator UI application and the CSV Validator Command Line application. See the installation and usage instructions for further information.

As of release 1.1, the Java 6 JVM is no longer supported.

The Maven artifacts can be found here.

CSV Validator 1.2-RC2

The 1.2 release will include new features in the draft CSV Schema Language 1.2, so far this is limited to the URL Decode Expression, though there are some other suggested additions (see the 1.2 milestone in the csv-schema repo) that are not yet in the draft.

This release candidate also includes performance and memory usage improvements from #135 by @JessFlan.

It is otherwise identical to the 1.1 branch.

The maven artifacts are available here (the main executables are attached below for convenience)

CSV Validator 1.2-RC1

The 1.2 release will include new features in the draft CSV Schema Language 1.2, so far this is limited to the URL Decode Expression, though there are some other suggested additions (see the Issues tab of the csv-schema repository) that are not yet in the draft.

This release candidate should be robust as it stands, it is named as a release candidate only because CSV Schema Language 1.2 is not yet finalised.

The Maven artifacts can be found here.