Documentation

Push Column Edit Settings

How to send data to other applications after a custom column has been edited

What are Push column edit settings?
Push settings are utilized to send an edited column's data to an external application, such as an SQL database,
web service, custom application, or column within IntelliCabinet.

SQL Settings

How to define SQL push settings
SQL push settings allow you to send edited data to an SQL server. The following example demonstrates
sample settings for pushing data to a MYSQL server.
The Server Driver is the Java Class driver name, com.mysql.jdbc.Driver for example.
The Connection URL is the Java URL connection string for the SQL Server, jdbc:mysql://192.168.2.1:3306/databasename?user=username&password=passwd&useOldAliasMetadataBehavior=true for example.
The SQL Statement is the SQL query to perform once a column as been edited, UPDATE TableName set Title="$COLUMN_VALUE[Title]" WHERE UID=$COLUMN_VALUE[UID]; for example. The $COLUMN_VALUE variable can be any column for the edited cell's row. You can also send cabinet properties with the variable $CAB_PROP[Property Name] or column settings with the $COLUMN_SETTING[Column Name] variable.
* View the Java JDBC api documentation and standard SQL query language online for additional details on these industry standard settings.

URL Settings

How to define URL push settings
URL push settings allow you to send edited data to web services, such as php or asp scripts.
The Delimiter is for executing multiple web server scripts, ; for example.
Example URL setting, http://www.mywebsite.com/update.php?action=update_field&table_name=mytable&field_name=Title&field_value=$ENCODE[$COLUMN_VALUE[Title]]&id=$ENCODE[$COLUMN_VALUE[Path]] The variable $ENCODE should be utilized to encode the data within its brackets to the standard URL encoding. The $COLUMN_VALUE variable can be any column for the edited cell's row. You can also send cabinet properties with the variable $CAB_PROP[Property Name] or column settings with the $COLUMN_SETTING[Column Name] variable.
* This example assumes you have knowledge of web services and URL variables.

Command Settings

How to define Command push settings
Command push settings allow you to send edited data to an OS application, Java or C# for example.
Example Command setting

java mypushcommand "$COLUMN_VALUE[Title]" "$COLUMN_VALUE[Path]"

The $COLUMN_VALUE variable can be any column for the edited cell's row. You can also send cabinet properties with the variable $CAB_PROP[Property Name] or column settings with the $COLUMN_SETTING[Column Name] variable.
* This example defines executing a java program and passing it parameters with the column values.

File Column Settings

How to define File Column push settings
File Column push settings allow you to copy the edited data to another column within IntelliCabinet.
To use this feature you would need to copy a file within folder of the owning cabinet by highlighting the file that you want to push the edited data to then selecting Copy from the poppup context menu. You would then open the Push dialog and select the Paste Copied button. This will fill in the read only fields with the copied file information. When the column data is edited the edited data would then be pushed to the column name entered for the Column Name field shown in the image above.
Dynamic From Editing File:
Toggle on Dynamic From Editing File when you want the Push To File Column's File Name to be dynamically defined by the editing file.
Dynamic From Column Name Value:
The Dynamic From Column Name Value toggle is for setting the file(s) and column to push the data to dynamically from the variables within the editing cells row's value within the defined Column Name field.
Example 1 - value of the selected row's Column Name field

col:Title=My Album;col:Changed By=Dan;set:Comment

* This example looks up all rows within the active folder that have My Album as the value for the Title column and Dan as the value for the Changed By column, then pushes the edited data to the Comment column for all of the rows that matched the My Album and Dan criteria.
Example 2 - value of the selected row's Column Name field

col:Title=My Album;col:Changed By=Dan;set:Comment,col:Title=No Album;col:Changed By=Ben;set:Comment

* This example looks up all rows within the active folder that have My Album as the value for the Title column and Dan as the value for the Changed By column, then pushes the edited data to the Comment column for all of the rows that matched the My Album and Dan criteria. Then also performs the same actions to the next statement that is delimited by a comma, for No Album and Ben. Note that when utilizing the dynamic feature the data must be pushed to files residing within the same folder.