How is your experience with the OutSystems Community?
csv-column-validator
Service icon

CSV Column Validator

Stable version 1.0.1 (Compatible with OutSystems 11)
Uploaded
 on 9 Oct (2 weeks ago)
 by 
0.0
 (0 ratings)
csv-column-validator

CSV Column Validator

Compatible with:
Created on OutSystems 11

Version 1.0.1

Stable
Current
See documentation
Uploaded on 9 Oct (2 weeks ago) by 
Compatible with:
Version 11
Database:
All
Release notes:

Release Notes

New Features

  • Added ValidateCSVData to validate CSV data rows using configurable validation rules.

  • Added required-field validation to identify empty values in mandatory columns.

  • Added regular expression (Regex) validation to check values against specified formats.

  • Added detailed validation errors, including row number, column name, value, error type, error message, and regex pattern.

  • Added total rows, valid rows, and invalid rows count outputs.

  • Added configurable maximum validation error limits to control the number of returned errors.

  • Added an error truncation indicator when the maximum validation error limit is reached.

  • Enhanced CSV parsing to support quoted values and multiline records.

Existing Features

  • Retained ValidateCSVColumns for validating CSV headers against required columns.

  • Continued support for configurable delimiters, case-sensitive or case-insensitive matching, column-name trimming, and missing or unexpected column reporting.

Demo Application

  • Updated the demo application to demonstrate CSV column validation and data validation scenarios.

Application Objects:
CSV Column Validator has 0 AOs.

Version 1.0.0

Stable
See documentation
Uploaded on 29 Sep (4 weeks ago) by 
Compatible with:
Version 11
Database:
All
Application Objects:
CSV Column Validator has 0 AOs.