Validation performs an extended check of index values by matching them to external data (from files or databases) and/or by applying a specialized algorithm (for calculating checksums). Index values failing this validation will be rejected.
The left side of the Properties of ... window lists all configuration options available for this item, the right side shows the options chosen so far. By highlighting one of the options and operating the green left or right arrow buttons, the option can be moved back and forth between the left column (available options) and the right column (selected options). If an option is highlighted in the right column (selected options), it may be moved up or down the list by operating the green up or down arrows. This changes the sequence in which the options are executed (processing will proceed from the top of the list).
Any items in the right column (selected options) will also appear in the configuration tree (far left), where they can be highlighted for further configuration.
Validation in the database
Compares the current index value with all entries contained in a specific database table column.
Database provider
Choose the type of database connection required (Currently, only ODBC is available).
ODBC-Source
Enter the name of the target database.
Table
Enter the name of the database table.
Search column
Enter the name of the table column.
Validation in text file (CSV/TAB)
Validation is performed using values from a table contained in an external text-file. The current index value is matched with all values from a specific table column. Values within table rows need to be delimited with either a comma or semi-colon (CSV-format) or with a tab-character (TAB-format).
File path
Full directory path and file name of the text file.
Type
Specifiy the type of the of text file (i.e. the delimiter used): Comma-separated (CSV) or TAB-separated (TAB).
Header
If the table has a header-row containing names for all table columns, turn this option on (checkbox ticked). If there is no such header-row (and the first row contains data), turn this option off (remove checkmark). This option determines whether a column name (on) or a column number (off) needs to be entered as Search column, below.
Search column
If the Header option (see above) is turned on, enter the exact name of the search column, as specified in the header row. If the Header option is turned off, you will need to enter the number of the search column, instead (columns are numbered from left to right).
Validierung in XML file
Validation is performed using values contained in an external XML-file.
Pfad der Datei
Full directory path and file name of the XML-file.
Name of the XML element
Enter the exact name of the XML element containing the list of values to be checked against.
Validation checksum
Specialized algorithms (hard-coded into CROSSCAP Enterprise) are used to calculate and verify index value checksums.
Three different algorithms are currently available:
