Enabling VBScripting and Database Lookups in Imaging Scan Workstation

From Support

As of V1.0.86 The RJS Imaging Scan Workstation now supports VB Scripting when an item is selected from a pulldown for an index key. There is also a lookup button that is supported when VB script is enabled in File/Settings. The lookup button calls a VBScript routine that can call the generic RJS ADO Table Browser component we wrote to handle the lookups.

Note: To use the new lookup functionality and VBScripting functionality, you need to install the full V1.0.86 install for the RJS Imaging Scan Workstation.

Note: You must enable VB Scripting from the File/Settings menu.

The RJS ADO Table browser is a generic ODBC lookup program that can run an SQL against any ODBC/ADO database and displays the data in a generic query window where the user can search the table with filter criteria or can double-click to select a vaule from the list. THE RJS ADO Table browser is an ActiveX component so it can be used with WebDocs Scan Workstation or with any other application that can call ActiveX components. You can define two search fields and any number of columns to be displayed depending on your SQL query SELECT.

The VB Script macro code for the Scan Workstation lives in a file named: C:\Program Files\RJSIMGSCAN.BAS

After you install the scan workstation update, please review the VB scripting code in the RJSIMGSCAN.BAS file.

If you don't know VB scripting, someone from RJS support may need to work with you.

The RJS Script Editor can also be launched from the Tools menu for editing VB scripts. It can also be launched from the scan workstation program group.

Any modifications to RJSIMGSCAN.BAS take effect immediately, so no compiling is needed.

The following event functions get called from the scan workstation:

1.) RunIndexFieldClick - This function gets called any time an index field is clicked. It gets passed all the index fields and can return the field unmodified or the user can modify as many as needed.

Example: If a folder of Accounts Payable is selected, you can force Keyword1 to be "AP" or something like that.

Your imagination is the only limit on what can be done to modify the index field upon selection.

2.) RunIndexFieldLookup - This function gets called any time the field lookup button is clicked for an index field. It gets passed all the index fields and can return the fields unmodified or the user can modify as many as needed.

Example: If KEYWORD3 is clicked, you can call a customer lookup and then return the lookup value to the scan workstation via the return fields array.

Your imagination is the only limit on what can be done to modify the index field upon lookup value selection.

3.) RJSADODatabaseLookup - This is a generic wrapper function to call the RJS ADO Table Browser program for database lookups.

All parameters for RJSADODatabaseLookup are documented within the RJSIMGSCAN.BAS file.

This is the only function you'll ever need to know to do generic database lookups with the scan workstation.

Please contact RJS Software Systems support for any assistance getting started with the new VB Scripting and Database Lookup functionality with the RJS Imaging Scan Workstation.