Configuring External AutoFill Keyword Sets - AutoFill Keyword Sets - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - Essential - Premier - Standard - external - Standard - Essential - Premier

Prior to configuring External AutoFill Keyword Sets in the Configuration module, you must have several items available:

• Keyword Types configured that will accommodate the Keyword Values obtained from the external source. The Data Type selected for the Keyword Type must be valid for the external value (for example, if it is a Numeric (Up to 9 Digits), then the external value must be numeric and no more than nine digits.)

  Note:

  A varchar Data Type cannot have columns configured with a length of MAX. The maximum length allowed for a varchar column in an External AutoFill Keyword table is 255 characters.

• Date and Date & Time values must be presented in a military format (YYYY-MM-DD and YYYY-MM-DD HH:MM:SS, respectively). For example: Date: 2005-01-30 Date & Time: 2005-01-30 13:25:48

• Currency values must be presented in a general format of XXXXX.XX (or -XXXXX.XX for negative values)

  CAUTION:

  Currency symbols, such as $, should not be used.

• The AutoFill Keyword Set configured

In addition, you must configure external settings that provide communication information to the external database. The following options are available for providing communication information to the external database:

• VB Script

• SQL Select String (requires workstation connection to ODBC source)

  Note:

  VB Script and SQL Select String functionality are no longer recommended and may be removed in a future release. For more information, see SQL Select String Considerations or Creating a VB Script to Enable External AutoFill Keyword Sets.

• EIS Datasource

  Note:

  Select the EIS Datasource option to use the AutoFill Keyword Set with the Enterprise Integration Server. For more information, see the Enterprise Integration Server information contained in the documentation for your line-of-business system's integration with OnBase.

• Unity Script

  Note:

  Select the Unity Script option to configure the AutoFill Keyword Set to call a Unity script. Unity scripts can be created by accessing the Unity Scripts tab in OnBase Studio when you are licensed for the Unity Client. For more information on configuring Unity scripts, see the Studio documentation.

• WorkView Filter

• Hyland Integration Services

The query that will obtain Primary and Secondary Keyword Value information from the external database using one of the methods mentioned above must be available prior to configuring External Keyword Sets.