Upload the Filter Definitions through the Command Line

To upload the Filter Definitions through the Command Line, follow these steps:

  1. Copy the modified XLS file to the $FIC_HOME/utility/FilterUpload directory in the OFSAA Installation.
  2. Run the Shell Script Utility from the $FIC_HOME/ficdb/bin directory as shown in the following:
    ./FilterUploadUtility.sh <infodom> <userid> <UNIQUE_IDENTIFIER>
    For example:
    ./FilterUploadUtility.sh INFODOM USER UNIQUE_IDENTIFIER_1111
    The parameter [UNIQUE_IDENTIFIER] is optional and it helps users trace issues registered in the Database Table that is mapped to the UNIQUE_IDENTIFIER.
    The XLS is uploaded and the Filter Definitions are saved post validation.
    The respective errors and logs are available in the log files and the Config Schema. You can filter them by UNIQUE_IDENTIFIER and view them.
    The Table names with reference to the logs are: AAI_UTILS_AUDIT and AAI_UTILS_AUDIT_DETAILS.