- Release Notes
- Getting Started
- Tutorials
- Automation Projects
- Creating Automations
- Automation Basics
- Object Repository
- Automation Best Practices
- Tutorial: Creating a Pivot Table
- Tutorial: Iterating Through Rows in a Table
- Tutorial: Comparing Excel Files and Emailing Reconciliation Errors
- Tutorial: Extracting Data From Automated Emails and Moving It to a Desktop Application
- Tutorial: Filtering Data in Excel
- Tutorial: Formatting Cells
- Tutorial: Adding Information About the Files in a Folder to an Excel File
- Tutorial: Adding Your Own Formulas to the Project Notebook
- PowerPoint Automation
- Data Automation
- Common Activities
- Google Workspace Automation
- OneDrive & SharePoint Automation
- Troubleshooting
Using the Data Manager
The Data Manager panel allows you to manage various types of data in your automation project. This data includes:
- Variables - Store data of different types and pass it between activities in a project.
- Arguments - Store data of different types and pass it between workflows and apps.
- Resources - Excel resources and activities that add files, email accounts, applications, or browsers to the project.
-
The following resources from Orchestrator, provided that the Robot is connected to Orchestrator.
- Processes - A process represents a package version linked to a particular folder. When you deploy a new process, it becomes available for all accounts that have access to that Orchestrator folder.
- Assets - Assets usually represent shared variables or credentials that can be used in different automation projects. They allow you to store specific information so that the Robots can easily access it.
- Queues - Container that enables you to hold an unlimited number of items. Queue items can store multiple types of data, such as invoice information or customer details, and enable you to create large automation projects underlined by complex logic.
- Connections - Links between your automation and external applications.
- New - Contains the New Variable and New Argument options.
- Expand All - Expands all of the categories in the Data Manager.
- Collapse All - Collapses all of the categories in the Data Manager.
- Refresh - Refreshes the Data Manager and reloads the data into it.
- Group items by scope - Groups your variables in the panel depending on the scope assigned to them.
- Sync with active scope - When an active scope is in focus, for example, a Use Excel File activity is selected, it only displays the variables with the matching scope assigned to them.
- Data manager filters - Lets you select what data is visible in the panel.
- In the Data Manager, select New > New Variable.
-
Indicate the name, data type, scope, and default value for the variable.
The scope can be set to Main (available in the entire project) or to any container activity within the project. The default value is Main.
Note: The scope of a variable determines the area in the workflow where it can be used. For example, having the scope set toMainallows the variable to be used in the entire project, while having a container activity set as a scope makes the variable available only within that container activity and the activities added inside.
Alternatively, you can create variables directly from the panel using the in-line option or from the Set Variable Value activity.
Creating variables in bulk
To create multiple variables at once, right-click Variables in the Data Manager, and then select Bulk Create Variables. In the Variables Panel window, click New and add the details for each variable you want to add.
Editing a variable
- Open the Data Manager panel.
- Expand the Variables node and then the node of the variable.
-
Edit any of the following: name, data type, scope, default value.
Sorting and filtering variables
You can sort variables by right-clicking the Variables section in the panel and selecting Sort by and then the criteria for the filter. The available options are: Default, Name, Type, and Scope.
Removing a variable
- Open the Data Manager panel.
- Expand the Variables node, then right-click a variable and select Delete Variable.
Alternatively, select the variable and press Delete on your keyboard.
Converting a variable to an argument
- Open the Data Manager panel.
- Under Variables, right-click a variable to open the context menu.
- Select Convert to Argument.
The newly converted argument can be found in the Arguments section of the panel.
Finding all the references to a variable
- Open the Data Manager panel.
- Under Variables, right-click a variable to open the context menu.
-
Select Find References.
The Find references panel opens and displays all references to the variable in the project.
- In the Data Manager, select New > New Argument.
-
Indicate the name, direction, data type, whether it is required, and the default value.
By default, all new arguments are of String type and have an In direction.
Alternatively, you can create arguments directly from the panel using the in-line option.
Creating arguments in bulk
To create multiple variables at once, right-click Arguments in the Data Manager, and then select Bulk Create Argument. In the Arguments window, click New and add the details for each argument you want to add.
Editing an argument
- Open the Data Manager panel.
- Expand the Arguments node and then the node of the argument.
-
Edit any of the following: name, direction, data type, whether it is required, default value.
Sorting arguments
You can sort arguments by right-clicking the Arguments section and selecting Sort by and then the criteria for the filter. The available options are: Default, Name, Type, and Direction.
Removing arguments
- Open the Data Manager panel.
- Under Arguments, right-click an argument to open the context menu.
- Select Delete.
Alternatively, select the argument and press Delete on your keyboard.
Converting an argument to a variable
- Open the Data Manager panel.
- Under Arguments, right-click an argument to open the context menu.
- Select Convert to Variable.
The newly converted variable can be found in the Variables section of the panel.
Finding all the references to an argument
- Open the Data Manager panel.
- Under Arguments, right-click an argument to open the context menu.
-
Select Find References.
The Find references panel opens and displays all references to the argument in the project.
You can copy and paste arguments or variables within the task. Right-click a variable or argument and select Copy. To paste it, right-click in the Data Manager panel and select Paste.
When a variable or argument with the same name already exists, a number is added to the duplicate's name. For example, if a variable with the name number already exists, the copied variable is renamed to number_1.
Alternatively, you can use the CTRL + C and CTRL + V keyboard shortcuts to copy and paste variables and arguments.
You can add annotations to your variables and argument to provide context or just to better keep track of the purpose and contents of those variables or arguments.
To add an annotation:
- Open the Data Manager panel.
- Right-click an argument or variable to open the context menu.
- Select Add Annotation.
-
Type in the text and click the pin icon.
Note:- Pinned annotations are displayed under the variable or argument in the panel when expanded.
- Arguments and variables with unpinned annotations have an icon displayed next to them.
- The pinned status of annotations is saved when the project is closed or published as a template.
To edit or remove annotations, right-click an argument or variable and select either Edit Annotation or Remove Annotation.
Alternatively, you can edit pinned annotations by clicking them in the panel and changing the text.
In Windows - Legacy and Windows projects, you can view and manage resources such as Excel files, email accounts, Word documents, PowerPoint presentations, applications, and browsers.
- Open the Data Manager panel.
- Expand the Resources node.
-
You have the following options
- To go to the activity where a resource is defined, double-click the entry in the Data Manager.
- To open a file added to the automation or the folder containing the file, right-click an Excel, PowerPoint, or Word file resource, and then select Open or Open file location. This option is not available when working with remote files (e. g. SharePoint).
The Data Manager displays Orchestrator resources (processes, assets, and queues) available in the currently selected Orchestrator folder. The panel displays resources from both classic and modern folders. Read more about folders.
If the Robot connected to Orchestrator is of type Standard, then the Data Manager panel can display only the Classic folder which has this Robot provisioned. If the Robot is of type Floating, then the panel displays all Classic and Modern folders that this Robot has access to. Read more about creating Robots in Orchestrator here.
To use a process, asset, or queue, drag-and-drop it from the Data Manager into the Designer panel. A set of activities is suggested depending on the resource type, and selecting one adds the activity to the project preconfigured to use the selected resource. For example, if you drag-and-drop a process, the Add Activity search bar is displayed with the suggested activities Invoke Process, Start Job, and Run Parallel Process. Selecting Invoke Process adds the activity with the folder path and process name fields configured with the data of the process.
You can manage the Orchestrator resources as follows:
- Right-click any resource under Assets, Queues, and Processes to access the context menu where you have the option to open the resource in Orchestrator or copy the name and use it in activities that interact with such resources.
-
To update Orchestrator resources, click the Refresh button at the top of the Data Manager panel.
Note:- When using a classic,
manually provisioned robot, it must be granted
Viewpermissions for the corresponding resources (that is, Assets, Queues, and Processes) to appear in the panel. Read more about setting up Roles and permissions in Orchestrator. - If there are both classic and modern folders in Orchestrator and you are connected to Orchestrator using a robot from a modern folder (you signed in to your account or connected using a machine template key), the processes in the classic folders are not available in the Data Manager panel. To have access to the processes from a classic folder, connect to Orchestrator using a classic robot with a standard machine key connection.
- When using a classic,
manually provisioned robot, it must be granted
- Open the Data Manager panel.
- Expand the Connections node to view a list of connections used in the project.
-
Expand the node of a connection to view a list of activities where it is used in the project.
Note: Connections are displayed in the Data Manager for certain activities and are displayed only after you save the project.
