Local Files Usage in Robots

You can use Robots to load many types of files including HTML, Excel, CSV, and regular text files. This enables robots to extract data from a variety of sources.

  • The following file types can be loaded natively by robots: HTML, XML, Excel, and JSON.
  • Other file types can be loaded but are converted to HTML before being handled by the robot: plain text, CSV and PDF.

There are two procedures to load file types. If the file is located on the Internet, it is loaded using the Load Page action, specifying the URL of the file or using the Click action, clicking a link to the file. This automatically loads the file up in the page view. If the file is located on your system, load the file in the following way to ensure that the file is also available upon uploading the robot to the Management Console to be scheduled or added to a Kapplet.

All file types, except PDF, are loaded by the same procedure. To add a file to the robot, perform the following:

  1. In the Add Variable form, add a binary type variable to the robot.
    Note Other variable types such as PDF and HTML can also be used, but are not as flexible as the binary type and may not permit user input.
  2. Enter a name.
  3. In the Type and Initial/Test Values, select an option from the list.
  4. Select the Global and Use as Input options as required.
    Note The difference between checking and not checking Use as Input only matters if the robot is to be scheduled or used in a Kapplet in the Management Console. An input variable is definable by the user, and so the file will be interchangeable each time the robot is run. On the other hand, if the file should be the same each time the robot is run, there is no need to use an input variable.
  5. Click Load to load a test file, and then click OK.

    If you have not selected Use as Input, this test file is the final one.

    A variable with an attribute of the type binary is added to a robot. It is defined as an input variable to allow users to input other files in Kapplets and Schedules.

    A test file is loaded into the attribute.