Pipelet ValidateActiveDataFile

Validates the given active data CSV file and returns a status reporting the results of the validation. If the validation operation executed without any process error, regardless of whether or not the CSV file is valid, then the pipelet returns next. If the given file does not exist in the given path the pipelet exits in a pipelet error. The status contains the status of the validation.

Group:

ImpEx

Flags:

Error Connector

Input Parameters

File : String Required

The path to the active data CSV file to be validated. Note: The path need to be relative to "impex/src/".

Output Parameters

ErrorCount : Integer : Optional

The number of validation errors that occured during the validation process.

LogFileName : String : Optional

The name of the log file that is created and used for the validation process.

Status : Status : Optional

Status object representing the result of the validation operation. The status property (Status.status) will be set to 0 if the validation executed without any process errors or 1 otherwise. The code property (Status.code) will be set to one of the following values:

IMPEX-0 = Successful.
IMPEX-105 = CSV file not found.
IMPEX-110 = I/O error occured when reading the CSV file.
IMPEX-170 = General I/O error occurred.
IMPEX-250 = Validation error.

The Status object will always contain the following detail:

"LogFileName" = (String) The log file name.

If no process error occurred then the status object will also contain the following details:

"ValidationErrorCount" = (Integer) The error count.
"ValidationWarningCount" = (Integer) The warning count.

WarningCount : Integer : Optional

The number of validation warnings that occured during the validation process.

Statistics : ActiveDataCSVStatistics : Optional

Statistics describing the content of the CSV file that was validated.