/
Verification Modes

Verification Modes

Method: setVerificationMode( String mode, String fullyQualifiedLogfilePath )

  • FAIL - fail if a VerificationException is thrown

  • IGNORE - continue processing

  • LOG - Allows the complete CSV file to be processed, without failing, and all verification exceptions to be written to a comma delimited logfile. This allows you to review all verification issue in one run, or more than one run by clicking the Stop button to end script execution. NOTE: If a 

table = new CSVTable( "c:/fileView/name/name.csv", processors ) table.setVerificationMode( "log", "d:/andi/verification/nameverificationErrors.txt" )

Functions which throw the standard VerificationException will log to the file defined in the setVerificationMode method in the following format. Use these messages to fix data errors not corrected by extensions and/or processors. 

2023-05-22 07:40:56.038,1344188314,,FileViewTable_0001,,515951,2,26252769:26252815,Column value contains non-ascii character at index <2> 2023-05-22 07:40:56.038,1344188314,,FileViewTable_0001,,515995,2,26255003:26255049,Column value contains non-ascii character at index <2> 2023-05-22 07:40:56.053,1344188314,,FileViewTable_0001,,516766,2,26293942:26293993,Column value contains non-ascii character at index <5> 2023-05-22 07:40:56.053,1344188314,,FileViewTable_0001,,517045,2,26307905:26307948,Column value contains non-ascii character at index <2> 2023-05-22 07:40:56.069,1344188314,,FileViewTable_0001,,517224,2,26316852:26316893,Column value contains non-ascii character at index <2> 2023-05-22 07:40:56.069,1344188314,,FileViewTable_0001,,517676,2,26339703:26339748,Column value contains non-ascii character at index <2>