› Reference › Kofax RPA Limitations

Kofax RPA Limitations

The following section describes some limitations of the Kofax RPA product.

General

When collecting a large number of data elements, we recommend you to structure your robot for a divide-and-conquer approach, so that each run of the robot collects only a portion of the data elements.

Browser

  • The web pages downloaded using Make Snapshot are a representation of the content and styles downloaded from the internal browser in Kofax RPA. When viewing the downloaded pages in a desktop browser, they may render differently from viewing the original web page in that browser.

Excel

  • When looping over a global Excel variable, certain steps are not allowed inside the loop, that is after the loop step. This is dynamically enforced, in other words the error does not occur until the steps are executed. The following steps will always refuse to work on a global variable that the robot loops over inside the loop: Insert Rows, Insert Columns, Remove Rows, Remove Columns and Set Sheet Name.

  • Excel modification is memory intensive and might not work on large Excel documents. The limit may depend on many factors, for example, available memory on a design platform or a server platform, how many modifications the robot does, and so on. Therefore it is not possible to give precise criteria for when an Excel document is too large for Kofax RPA to handle.

  • Formats specified in the built-in Excel may not be displayed in the same way as in Microsoft Excel due to the use of Apache POI.

  • Formula support. See the Apache POI website for details on formula support in Excel.

  • Supported functions. See Supported Features in Excel and the Apache POI website for details on supported functions and function limitations.

  • Unsupported features

    • Manipulating array/table formulas (In Excel, formulas that look like "{=...}" as opposed to "=...")

    • Region operators: union, intersection

    • Parsing of previously uncalled add-in functions

    • Preservation of whitespace in formulas (when POI manipulates them)

    • Font changes, for example bold, size, etc.

    • Background color in cell

    • External file references from formulas

    • Excluding hidden values

    • Converting strings to a date with the FLOOR, HOUR, and MINUTE functions. Only decimal values are supported.

  • Sometimes, when your robot performs some actions on a very large Excel document, the processing may become slow after several hundred iterations. To speed up the process, use the following settings in your robot for Excel processing:

    • Use Global variable

    • Do not use the Ignore and Continue error handling

    • Do not run your robot in Design mode

      Caution:

      With all the above-mentioned conditions, if an error occurs when working with Excel, the variable value is set to empty. You will need to inspect your robot to make sure you use the supported Excel capabilities and correct the error to have a valid value in your variable.

See Supported Features in Excel for more information.

Execution Mode

The following list contains steps that are not available in the Smart Re-execution mode.

  • Call REST Web Service (old version)

  • Call Web Service (old version)

  • Clear Web Storage

  • Divide Tag (old version)

  • Divide Text

  • Divide Text (old version)

  • Execute SQL (old version)

  • Extract from Excel (old version)

  • Extract from PDF (old version)

  • Extract Image

  • For Each File (old version)

  • Hide Tag

  • Insert Tag

  • Load Data (old version)

  • Make Snapshot

  • Normalize Table

  • Query Database (old version)

  • Remove Table Rows

  • Remove Tag Range

  • Remove Tags (old version)

  • Replace Tag

  • Rewrite Page

  • Rewrite Style Sheet

  • Set Top Tag (old version)

  • Transpose Table

  • Unhide Tag

Kofax RPA Kapplets

The following list contains features that are not available in Kofax RPA Kapplets.

  • Import and export Kofax RPA Kapplet backups

  • Adding OAuth robots to Kapplets

Using Kapplets with robots containing big volume data output is not recommended.

Data Converters
  • If you convert data using JavaScript, polyfills cannot be used since this conversion uses the classic JavaScript engine. For more information about polyfills, see Predefined JavaScript Polyfills.
Date Converters
  • When the year is entered with two digits, the century cut-off of 2029 is used.

    Example

    09/10/30 becomes 1930-09-10 00:00:00.0

    09/10/29 becomes 2029-09-10 00:00:00.0

  • The day in a date is validated only if it amounts to 32 or over. When under 32, the day is converted to a corresponding day in the following month.

    Example

    2020-02-30 becomes 2020-03-01

    2020-02-31 becomes 2020-03-02

    2020-02-32 leads to error

Robot documentation
The following list contains features that are not available in the robot documentation.
  • Information on Connectors used by the robot is not included in the robot documentation.