Logistic tables

The translation table function (Logistics) offers endless possibilities for translating a value into other values. The function consists of a Catalog.

Some examples:

• Translating zip codes to counties or regions
• Translating Active Directory roles to roles in other applications or visa versa
• Translating names to suppliers

Overview Logistics

To see an overview of the Logistics tables created navigate to More > Logistics > Overview. Here you see a direct overview of the tables that have been created.

Values in Logistics tables can be imported from a CSV, as well as updated manually or later.

Create table

We are going to create a zip code translation table in our example, where we want zip codes to be translated into a province. From the spider menu, go to More > Logistics > Maintain and click on Add new.

Enter a clear name for the table and click on Save.

Manual import

We can now fill the table in 2 ways. Manually and through a CSV import. Click on the icon. We are going to add a value.

Click on Add new

In the fields we then fill in the "Source" and "Target" value. As an example zip code: 9765 will be associated with the province of Drenthe. Then click save to save it.

From this moment, the translation table is already available for the robot to use. The logistics table can be used process-independently.

Bulk import

The other option is to import a CSV. Navigate to the Logistics table created via More > Logistics > Maintain. Click on the icon of the table and select Upload CSV

If the CSV file contains columns (headers) (1), check CSV Contains Headers. Import the CSV file by dragging the file into it or click in the center of the screen (2) to import the file.

Tip

If your CSV contains headers, check this first. Then select the file.

A preview will then be displayed first. Click on Save to start the import.

Number of records

Starting from version 1.12.0, the preview also shows how many records are in the CSV. Only the first 10 are displayed on the preview screen.

Cancel import

Starting from version 1.12, the option to cancel the import has been added. This can be done by clicking (x) or by switching to another page, which will also stop the import.

If you navigate to another page, the import notification will remain visible in the top-right corner of the screen.

Import successfull.

Of course, the values can always be modified or added manually.

Then the Logistics table can be used by the robot within a process if needed.