Documentation

Advanced Folder Push Inserted and Removed File Settings


How to define the advanced folder Push Inserted or Push Removed File SQL settings
  • A) Enter the JDBC Server Driver and Connection URL. Refer to your JDBC driver documentation for the Driver and Connection URL syntax. You can connect up to 5 different JDBC drivers by placing the driver .jar file you obtained from the driver manufacturer in the JDBC folder located within the IntelliCabinet installation location, the installation location can be found in your Session Log from the Help menu. The driver file name must be renamed to jdbc1.jar jdbc2.jar jdbc3.jar jdbc4.jar or jdbc5.jar to be recognized.
  • B) The SQL Statement is where you will enter the SQL UPDATE or DELETE statement for updating the desired database table data.
  • How to define the advanced folder Push Inserted or Push Removed File URL setting
  • A) Enter a delimiter if you want to have multiple web services executed. For example, one web service may perform some update actions and another might be a common web service to send email notifications.
  • B) Enter the URL path to the web service that will perform actions when a folder file has been added or removed. The URL syntax must follow the standard internet URL encoding. To encode on the fly use the $ENCODE variable. Example:
  • http://mywebsite.com/update.php?action=update_field&table_name=issue_items&field_name=Category&field_value=$ENCODE[$COLUMN_VALUE[Category]]&id=$ENCODE[$COLUMN_VALUE[Path]]
    How to define the advanced folder Push Inserted or Push Removed File Command setting
  • A) Enter the command line to execute when a folder file has been added or removed.