RPA with UiPath

The Context
To understand the basics of robotic process automation, enroll and learn through
the course Automatix-tool of RPA.

In this course, you will be learning about UiPath (an RPA product):

Basic Concepts of UiPath

Automation of Excel and Data tables

Recording and Selectors

Input and Output Methods of UiPath

Image and text automation

Automation of Mail and PDF

User Events in UiPath

Project organization in UiPath

Exceptions and Debugging

----------------------------------------------------------------------------------
What is UiPath ?
What is UiPath ?
UiPath is an RPA tool used for Windows desktop automation. It features three main
products:

UiPath Studio

UiPath Robot

UiPath Orchestrator

You will be learning about each of them in the upcoming cards.

----------------------------------------------------------------------------------
Products of UiPath
Products of UiPath
UiPath Studio - It is the designer tool used to create diagrams for business
processes.

UiPath Robot - It executes the process built on the UiPath studio (similar to a
person).

It works either as an assistant or in a completely autonomous mode.

UiPath Orchestrator - It is a web-based management platform that enables remote

controlling, monitoring, release management and centralized scheduling of robots
and processes.
----------------------------------------------------------------------------------
Types of Supported Projects
What is a project?

It contains steps for the automation process. You can create a project by using
three types:
Sequence

This is the smallest type of project and it follows a linear way of execution.

They can be reused.

Flowchart

It is similar to sequence, but it has multiple branching logical operators.

They can be used for large jobs as well as small projects.

State Machines

It has a finite number of states in its execution.

It has two states initial and final state.

----------------------------------------------------------------------------------
Panels
Panels
Few important panels available in UiPath are listed here:

Activities panel - It contains all the activities that are required for automating
different applications.

Properties panel - In this panel, you can change the properties of the selected
attribute.

Designer panel - It displays the current automation project and enables you to make
changes to it.

Project panel - It is used to view the contents of the current project.

In the upcoming topics, you will be visually learning about these panels in detail.
----------------------------------------------------------------------------------
Introduction
In the following cards, you will be learning about:

Workflow and Activities

Variables
Control flow
Control flow activities
Flowchart
Sequence
State diagram
----------------------------------------------------------------------------------
Workflow
Workflow

It is the visual interface used to design and set up an automation process.

A workflow is generally made by using:

Sequences

Flowcharts

Diagrams
They can be developed with little or no programming knowledge.
----------------------------------------------------------------------------------
Activities
Activities

Activities are the actions performed by a robot during the workflow.

One can create an activity by searching for it and then you can either drag and
drop or copy and paste.
It is the building block of process automation.
Around 300 activities are present in the studio, and they are used to interact with
the web browsers, terminals, databases, PDF's, email accounts and so on.
----------------------------------------------------------------------------------
Variables
Variables
They allow the user to manipulate, store and transmit the data from one activity to
the another.

Name, scope, type, and value are the key features of variables.

The data of that particular variable is stored in the value.

The region where the variable is visible and can be accessed is called "scope".
----------------------------------------------------------------------------------
Generic Value Variable
It is a unique variable which makes basic activities easier.

It represents the basic data including text, date/time or numbers

Advantages

Developers can focus on the flow without worrying about the data type.
Disadvantages

It cannot access the default methods that are applicable to specific variable
types.
----------------------------------------------------------------------------------
Advice
It is a good practice to provide meaningful variable names because it helps in
debugging and also to identify its purpose easily.
----------------------------------------------------------------------------------
Types of Variables
The following variables are available to deal with the various types of data in the
UiPath:

Integer - Deals with the whole numbers

String - Text of any kind

Boolean - It has two possible values true or false

Generic - It stores any kind of data like numbers and text in a wide range

Array of - A list of any type

Renaming a variable in the variables pane propagates the changes throughout your
project.
----------------------------------------------------------------------------------
Default Value
Default value is assigned to the variable until you assign a new value.
----------------------------------------------------------------------------------
Control Flow
Control Flow
It points to the order in which specific actions are executed in the automation
process.

A good control flow is obtained by proper use of variables and activities.

All these activities are found under workflow => control flow.

These activities help to define the rules and automate the conditional statements
within the project.
----------------------------------------------------------------------------------
Control Flow Activities
Control Flow Activities
Below are some of the activities in control flow.

Assign activity

It helps in assigning the value to a variable and incrementing it inside a loop.

Delay activity

It is used to pause the automation for a particular amount of time (hh:mm: ss).

It helps in the projects where time plays a major role, such as waiting for a
particular application to give exact output.

Do While activity

It executes actions first and repeats until the condition is met.

This activity helps in executing the array or process multiple times.

Click the link to know more about control flow activities.

----------------------------------------------------------------------------------
Branching, Flow Chart, and Sequence
Branching, Flow Chart, and Sequence
Branching

It helps to automate the workflow.

If an activity has more than one condition, branching helps in getting the output
depending on the condition.
Flow Chart

It is a diagrammatical representation of a problem, and it provides multiple

branching operators.

It breaks large jobs to small jobs they can be reused in other projects.

Sequence

Set of steps to complete a process.

These can be the part of flowcharts or state diagrams and can be used multiple
times.
----------------------------------------------------------------------------------
Control Flow: Hands-On Task
Create a flow chart with a number guessing game.
The Robot will generate a random number and the user has to guess that number using
Input Dialog Activity.

It should Indicate whether the number is greater, lesser or equal to the guessed
number.

You can try the above task by installing the windows UiPath community edition.
----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
Intro
In the previous topics, you have learned about the Basics of UiPath, Control flow,
and it's Activities.

In the upcoming Cards, you will learn about Data Manipulation, it plays a crucial
role in Dealing with data for UiPath
----------------------------------------------------------------------------------
Prelude
You have been assigned with the task of splitting a given list of student names
into individual components as a first and last name.

Is there a fast and easy way to get this task done repetitively on an ongoing
basis?

Don't worry at the end of this topic. You will learn to deal with such scenarios.
----------------------------------------------------------------------------------
Data Manipulation
It is the process of changing the data either by adding, removing or updating the
data

Variables used in UiPath is categorized into one of the three types.

Scalar - It deals with Numbers, characters and Boolean.

Collections - They are used to extract the data from orchestrator queues like
Arrays, lists, dictionaries, and strings.

Tables - These are two-dimensional structures, and the data is indexed using rows
and columns.

You can filter table rows by using the Select method.

----------------------------------------------------------------------------------
Collections
These are the collections of characters.

Array

It is fixed in size.

It has methods which are handy.

List

Flexible in size.

Advanced Methods.

Dictionary
It allows the user to check by name rather than the index.

They are used to pull the data from orchestrator queues.

----------------------------------------------------------------------------------
Terminology of UiPath for Excel
Workbook - A collection of spreadsheets used to organize tabular data.

Worksheet - A single sheet in a spreadsheet with rows and columns.

Cell - Storage unit for data in a spreadsheet.

Range - Block or group of cells in the spreadsheet.

Container - It gives the context for the button or field you like to use.
----------------------------------------------------------------------------------
Excel and Data Tables
Excel and Data Tables
Data tables are the spreadsheets with rows and columns, and with or without
headers.

Excel Application scope is used to do excel activities and it is available in

activities panel.

Workbook is a variable in the properties panel, which gets automatically filled

after selecting the excel file, and it can be changed dynamically.
----------------------------------------------------------------------------------
Visible Checkbox
Visible Checkbox
It tells the UiPath to read the excel files whether by using Microsoft Excel or
direct access.

If Checked:

Requires Microsoft Excel to be installed.

Visible Real-time changes and debugging can be done easily.

Multiple processes can use the same file.

If Unchecked:

Does not require MS Excel.

Works only in .xlsx format.

Only one process can use the file.

----------------------------------------------------------------------------------
Excel Activities
Excel Activities
Below are some of the activities that you frequently use in Excel.

Read Range - It reads the portion of excel and stores it in a data table.

Write Range - It is similar to the Read Range action, except it needs the data
table to write into the file. It will overwrite the previous entries.

Append Range - It adds data to the existing data without overwriting.

Sort table - Sorts the table from spreadsheet depending on the value of the column.
Read cell - It reads the value of excel and stores it in a variable, but it can be
used only in Excel application scope.

Write cell - It writes the value or formula into specified spreadsheet cell or
range.
----------------------------------------------------------------------------------
Data Table Activities
Below are some of the activities that you will frequently use in data tables

For Each row - It executes actions for each row in the data table.

Output data table - It writes the data table to the string using CSV Format.

Get Row Item - It gets the value from data row depending on the column specified.

Add data row - It adds the row to the specified table.

Build Data table - Creates the table depending on the specified schema.
----------------------------------------------------------------------------------
Excel: Hands-On Task
Create an excel sheet with multiple columns and perform the following activities in
it.

Read Range

Write Range

Read cell and

Write cell

You can try the above task by installing the Windows UiPath community edition.
----------------------------------------------------------------------------------
Recording
Recording
Recording helps in saving a lot of time for automating the business process.

It captures everything and transforms it into sequences.

A quick view on the business process can be done.

Types of Recordings

Basic - It is suitable for single activities.

Desktop - Used for recording desktop apps.

Web - It is used for recording web browsers and apps.

Citrix - Virtual environments or SAP is recorded by using Citrix.

----------------------------------------------------------------------------------
Automatic Recording
It helps in providing the skeleton structure for the process.

Automatically Generated Activities:

click - It is generated when you click a button.

type into - Typing into an editable text item generates this activity.

select item - When you select an item from combo box or list.

check - When a radio button or checkbox is clicked.

----------------------------------------------------------------------------------
Manual Recording
Particular types of recordings cannot be handled by the automatic header.

They are called as manual recordings or single actions.

You can use both manual and automatic recordings to obtain full automation.

Types of Manual recordings

Open and close of apps and browsers.

Getting text and scraping screens.
Text or image-based UI actions.
You will learn about scraping in the upcoming topics.
----------------------------------------------------------------------------------
Best Practice
Use comments/annotations to explain complex logic.

Use appropriate workflow names to understand their purpose.

----------------------------------------------------------------------------------
Why Selectors?
To automate specific actions in the UI, some RPA tools identify the elements based
on screen position. This approach is not at all dependable.

To overcome this problem, UiPath uses Selectors.

----------------------------------------------------------------------------------
Selectors - Intro
Selectors - Intro
Selectors are used to find the UI elements in applications.

They identify the elements by storing the GUI of elements, and its parents by using
the XML format.

It is built of one or more XML formats with attributes and tags.

Selectors are mostly generated by the UiPath studio if the web pages have a static
UI.

In some scenarios, you have to generate your own selectors because some web apps
may have volatile values.
----------------------------------------------------------------------------------
Structure of Selector
<node_1/><node_2/><node_3>.....<node_n/>
node_1 is basically root node, and it represents the application's top window.

node_n represents the last node that you have chosen.

All the previous nodes of the last node are called parents of that particular node.
----------------------------------------------------------------------------------
Structure of Attribute
Structure of Attribute
<ui_system attr_name_1='attr_value_1' ../>
Every node has attributes that explain about the specific level of an application.
Every attribute has some constant value.

If the value changes every time, you start the app, and then selector may face a
problem to identify the UI element.

So, it is a good practice to check the application whether selectors can be used.
----------------------------------------------------------------------------------
Selectors with Wildcards
Wildcard

These are the symbols that replace zero or multiple numbers of characters.
They are helpful when we are changing the data dynamically.
Symbols Used

Asterisk(*) - It replaces multiple or zero characters.

Question mark(?) - It replaces a single character.

----------------------------------------------------------------------------------
Full Selector and Partial Selector
Full selector

It starts with the top-level window (Main window) and contains all the information.

Basic Recorder Generates it.

It is recommended when switching between multiple windows.

Partial selector

It excludes the top-level window.

Generated by Desktop Recorder.

The partial selector is enclosed in a container which contains a full selector with
top-level window.

Recommended when doing multiple actions in the same window.

----------------------------------------------------------------------------------
UiExplorer
UiExplorer
It is a visual tool that helps to create a custom selector for specified UI
elements.

It shows the properties of the elements and their values.

It adds/removes the parent elements from the selectors.

It helps in validating the selectors in real time.

----------------------------------------------------------------------------------
Finding Elements
Here are some of the elements for finding the elements

Find Element

It helps in finding a particular element and saves it.

If it is not available, it renders an error.

Element Exists
It checks whether the element is available and returns a boolean value.
Find Children

It helps in retrieving a collection of elements at once.

----------------------------------------------------------------------------------
Hands-on Task
It's time for a task!

Create an automated environment where you can give input as city name and output
should be the latitude and longitude of that city.

You can try the above task by installing the Windows UiPath community edition.
----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
UI Elements
The GUI (Graphical User Interface) elements in the application are called UI
elements like windows, checkbox, list.

In order to achieve faster automation, it is better to know how to interact with

them.

The interaction with UI is categorized into Input and Output.

It helps in better understanding about actions for different scenarios and the
technology behind them.
----------------------------------------------------------------------------------
UI Activities Properties
There are multiple properties under the UI automation category:

Continue on error - It specifies whether the automation should continue whether it

throws an error.

Inside a try catch, if this property is set to true, no errors are caught during
execution.

Delay after - Adds a Pause when the activity is done (in milliseconds).

Delay before - It adds a pause before the activity (in milliseconds).

WaitForReady - It waits until the target element loads completely.

Target - It identifies the element on where the activity is running.

----------------------------------------------------------------------------------
Input Methods
Input Methods
They help the robot to directly interact with web application or web page.

For click and type actions there are three types of methods which differ in
compatibility and capability :

Simulate type/click
Windows messages
Default
Among the three, Simulate type/click is fastest, if you don't prefer keyboard
shortcuts.

If it is not suited then try Windows messages method and choose default at last
option because it is slowest among the three.
----------------------------------------------------------------------------------
Properties of Input
Input methods can be changed at any point of time from the properties panel.

If simulate Type or SendWindowsMessages properties are not checked then the default
method is applied.

The default uses hardware driver to click/type in an application.

SendWindowsMessage works by sending specific messages to the target application.

----------------------------------------------------------------------------------
Output Methods
Output Methods
They refer to an activity where output should be obtained from UI elements or
documents like Pdf's.

They are also called as screen scraping methods.

Three types of screen scraping methods:

FullText - It is fast and accurate but cannot extract screen coordinates.

Native - Slower than FullText and it can extract screen coordinates.

OCR (Optical Character Recognition) - It is not 100% accurate, and it is the only
one that provides support for Citrix.
----------------------------------------------------------------------------------
Screen Scraping
Screen Scraping
It enables to extract data from various sources (click on Design ribbon --> wizards
--> screen scraper wizard).

Each type of screen scraping comes with different options.

For Example,

OCR scraping method supports two OCR Engines:

Google OCR

Microsoft OCR
----------------------------------------------------------------------------------
Relative Scraping
Relative Scraping
It helps to retrieve text from UI elements by using OCR.

The UI elements are identified by using image recognition activities.

This is helpful in extracting the data from virtual environments.

Selectors cannot be used in Virtual Environments because we are using visual labels
of UI elements.

To choose scrape relative, you have to click

Citrix recording wizard --> Screen scraping --> Scrape relative.

----------------------------------------------------------------------------------
In the next set of cards, you are going to learn about
Image and text automation

Image activities

Text activities

OCR activities
----------------------------------------------------------------------------------
Image and Text Automation - Intro
These are useful in the Citrix environments where UI automation doesn't work.

UiPath studio provides keyboard and mouse activities like hovering and clicking for
image and text automation.

OCR uses screen scraping to identify UI elements.

Image automation directly works with images to identify UI elements.

Everything is considered an image while automating virtualized environments.

----------------------------------------------------------------------------------
Image Activities
They simulate the human behavior by identifying the UI elements as images.

Click image, Double click image, Hover image - These are fast and reliable but if
the background or color changes, they fail to recognize.

Find Image - It finds the UI element depending on the image provided to it. Once
the image is found, it returns the clipping region of the element.

Image Exists - Used to check whether the image is available.

On Image Appear - It waits for a particular image to appear. They are mainly used
in virtual environments.

On Image Vanish - It waits for a particular image to disappear.

----------------------------------------------------------------------------------
Text Activities
They help to get the text from UI elements, and the coordinates for UI elements.

Double click text, click the text and hover text - Useful to click the text inside
the element or hover over it.

Find Text Position - This helps in locating the UI elements based on the position
when there is no option to get them.

Get Full Text - This helps in getting the Full text from UI element by using
FullTextScreenScrappingMethod.

Get visible text - It also helps in extracting data from UI element, but it uses
NativeScreenScrappingMethod.

Extract Structured data- It extracts the data from an indicated table.

TextExists - It is used to check whether the text exists and returns a boolean
value depending on output.
----------------------------------------------------------------------------------
Mouse and Keyboard Activities
Mouse and Keyboard Activities
They are helpful in creating the automation which needs human behavior.
Technologies used are:

Double click, click, and hover - These activities are used to mimic human behavior.

Type Into - Useful in sending keystrokes to UI element.

Type secure text - Secure text is sent to UI elements.

Send Hot Key - Useful in sending keyboard shortcuts to the UI element.

Set Focus - It sets the keyboard focus to a particular element.

----------------------------------------------------------------------------------
OCR Activities
They use the elements which are scannable in automation. It helps in simplifying
the process in virtual machine environments.

Double click OCR text, click OCR text, hover OCR text - These are helpful in doing
automation using OCR.

Find OCR text position - This helps in getting the location of UI element by using
text.

OCR Text exists - It checks for the text using OCR and returns a boolean value
depending on the availability of the text.

OCR Engines - They help in extracting the string and its location by using
different OCR engines.
----------------------------------------------------------------------------------
Citrix Automation
Citrix Automation
It is used to automate the Citrix environment.

Citrix environment is a virtual environment where the application runs on a server

and only the image of the application is streamed to the user.

Citrix automatic wizard is used to automate virtual environments.

----------------------------------------------------------------------------------
Hands-On Task
Hope you have learned about Image and Text automation. Now it's time to do a task.

Automate any web application using UiPath

You can try the above task by installing the Windows UiPath community edition.
----------------------------------------------------------------------------------
Mails and PDF
In the next set of cards, you are going to learn about the following topics.

Automation of mails

Input and output process related to mail automation

Automation-related to the mails

PDF automation

Automation-related to PDF's
----------------------------------------------------------------------------------
Mail Automation - Intro
Nowadays email is one of the most effective ways of communication.
UiPath has a set of features which helps in automation of sending and retrieving
emails.
----------------------------------------------------------------------------------
Email Interaction
Below are some of the methods to interact with the mail:

Save Mail Message - It is to save emails to the specified folder.

Save Attachments - It is used to save attachments of the mail to a specified

folder.

Get outlook mail messages - Used to get mail messages from outlook.

Move outlook mail messages - Used to move outlook messages to a particular folder.

Get POP3 mail message - Uses a POP3 mail to get the message from a specified
server.
----------------------------------------------------------------------------------
PDF Automation
PDF Automation
It is used to extract the data from PDF and XPS files and stores it into variables.

By using range property, you can find the pages of your wish.
----------------------------------------------------------------------------------
Activities of PDF
Below are the activities available in the UiPath:

Read PDF text - It reads the PDF text and stores it into a string variable.

Read PDF with OCR - It reads special characters from the PDF file and stores into
the variable using OCR technology.

Read XPS text - It is used to read the XPS text and store into variables.

Read XPS from OCR - It reads all the characters from OCR technology using OCR and
stores it into the string variable.
----------------------------------------------------------------------------------
Anchor Base
It is a container that searches for UI elements by using other UI elements as
Anchors.

This can be used only when reliable selectors are not available.

Activities

Here are some of the activities which are used with anchor base.

Find Element - It waits until the specified element appears on the screen. Once it
is found, it returns as UiElement variable.

Find Image - It searches for a particular image and returns the clipping region of
that image.
----------------------------------------------------------------------------------
User Events
In the next set of cards, you are going to learn about:

Monitoring Ways
How is monitoring done in UiPath?

Monitor system Events

Monitor Elements, Image

Hot key trigger

----------------------------------------------------------------------------------
Monitoring Ways
Monitoring can be done in three ways:

By using wizards from the menu bar.

By using Activities related to monitoring.

With the help of predefined agent assistant from the start menu.
----------------------------------------------------------------------------------
Monitor System Events
It helps in capturing the system events regardless of the applications they are
interacting.

Example:

System keypress events

System mouse click events
It helps in monitoring the events based on file changes.

Example:

File system events

----------------------------------------------------------------------------------
Monitor Elements and Image
They help in capturing the keyboard events on a specific UI element.

Element keypress events

Element mouse click events

You can monitor mouse click on UI elements, where you only see images.

Image click events

----------------------------------------------------------------------------------
Hot Key Trigger
It monitors the system based on system-wide key events.

It can be used only to monitor events activity.

It takes input as a key.

Key (The key is monitored, and special keys are found under activity drop-down
list).
----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
Working with Project Organization
In the next set of cards, you are going to learn about:

Project overview

Automation standards
Invoke workflow

Advantages
----------------------------------------------------------------------------------
Introdution
Project Organization is one of the important factors in UiPath.

It improves the efficiency by reducing the time for debugging as well as

automation.

An organized project has the following standards:

Reliable, Efficient, Maintainable and Extensible

In the following card, you will be learning about each of them in detail.
----------------------------------------------------------------------------------
Automation Standards
Automation standards of UiPath:

Reliable - It helps in progress tracking, exception handling, recovery, and error

handling.

Efficient - It executes smoothly in the production environment.

Maintainable - It gives the clear structure and development standards.

Extensible - It is open to open new cases.

----------------------------------------------------------------------------------
Best Practices for Project Organization
Choose the layout properly.

Break the complex steps into simpler workflows.

Exception handling.

Make readable workflows.

Keep the project clean.

----------------------------------------------------------------------------------
Invoke Workflow
When a project is developed, it is difficult to test from top to bottom. So, it is
advisable to break it into the small process.

It is the activity used to break the complex workflow into smaller steps.

By breaking it into smaller activities, the user can focus on multiple activities.

Once testing is done, it is combined with the main workflow.

Data is passed between the workflows using Activities.

----------------------------------------------------------------------------------
Advantages
It keeps environment settings in a dedicated file.

Testing and Developing automation.

You can reuse the automated workflows across projects.

Collaborates by working on separate workflow files.
----------------------------------------------------------------------------------
Exceptions Intro
What happens when an exception or error is raised during the automation process?
Will the automation continue or will it stop the automation?

Read further to know about handling exceptions and errors in UiPath.

In this topic, you are going to learn about

Exceptions
Why are exceptions raised?
How to handle them?
Debugging and its techniques
How debugging can be done?
----------------------------------------------------------------------------------
Exceptions
These are raised if an error occurs in the automation.

UiPath has a debug component, which helps in debugging the automation.

It locates problems, in complex automation easily.

When an error occurs in the automation, UiPath workflow designer notifies and give
details about issues.
----------------------------------------------------------------------------------
Exception Handling
In order to run the automation process, it is necessary to handle the exceptions
which are raised during the execution.

They are handled in two ways:

It recovers and reports (Try/catch/Finally).

Suppress by using (ContinueOnError).

In the following cards, you are going to learn about them in detail.
----------------------------------------------------------------------------------
Exception Handling
Try/Catch/Finally

Exceptions raised due to coding and data errors are handled using this.

Try - It contains the activity

Catch - It is the exception handler.

Finally - It is executed irrespective of the top two.

ContinueOnError

If this property is set to true, error is ignored, and the workflow will continue.

If this property is false, the error is displayed.

----------------------------------------------------------------------------------
Common Exceptions
Index Out of Range

It occurs when you try to extract the data which is outside of its capacity.
Image Not Found

If the image is not available in the specified time maybe because of environment
settings or foreground display this exception is raised.
Can't find the UI Element corresponding to this selector

If the control present in selector does not match with any selector, then this
exception is raised.
----------------------------------------------------------------------------------
Debugging
It allows you to observe the execution of a project and find the errors.

It verifies the state of the project and the components to know where the project
went wrong.
----------------------------------------------------------------------------------
Debugging Techniques
Debug mode

Break

Highlight

Slowstep

View outline

Output

Log message

Message box
----------------------------------------------------------------------------------
Tracking
Execution status can be tracked by using Log message.
----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
Orchestrator - Introduction
Orchestrator - Introduction
It is a web application used to deploy, maintain and manage the robots and process.

It orchestrates the UiPath robots to run the repetitive business process.

----------------------------------------------------------------------------------
A Comparison
In this card, you are going to learn about the differences between Front Office
Robots and Back Office Robots.

Front Office Robots

Front Office Robots are linked to FTE (Full-Time Equivalent), and FTE is used for
activating subprocess or an entire process.

They are useful for manual and repetitive cases

Control towers and service desk professionals use this kind of Robots.

Back Office Robots

Back Office Robots are not linked to FTE and they can run independently of any
action.

They are useful for doing rule-based tasks and processing.

Financial and HR professionals use this kind of robots.
----------------------------------------------------------------------------------
Orchestrator Components
Web application - UI with which you are interacting for the automation process.

Deployment - It delivers the package versions to the assigned robots for execution.

Configuration - It maintains and develops orchestrator environment.

Queue - It ensures about the Queues and Queue items management.

Monitoring - It maintains user permissions and Robot Identification data.

Logging - The logs are indexed and stored in the SQL database and Elastic search.
----------------------------------------------------------------------------------
User Interface
User Interface
Here are some of the interfaces in UiPath Orchestrator

Dashboard - Charts and Statistics for Orchestrator components.

Alerts - A history of important events.

Settings - Application configuration.

Assets - Mentions about shared variables and configurations in the process.

Users - User Management.

Audit - Actions performed in Orchestrator are audited.

----------------------------------------------------------------------------------
Environments
Environments
It means a grouping of robots, used to deploy a process.

An Environment page displays all the created environments and helps you to manage
robots within them.

This page is filtered according to the type of environments (Dev, Test, and Prod).

You can access the page by

Robots page => View Environments

----------------------------------------------------------------------------------
Managing Environments
Managing Environments
Creating New Environment

Click Create Environment and then fill the details.

Name, Type is used to indicate how the environment is used, Description - why it is
used?

On clicking create, manage environment window is opened, from that, you can select
the robot you need.

Adding Robot to Existing Environment

Go to Environment page => Manage Robots Management window is displayed.

Check the robot you need and close the page, settings are automatically saved.

Removing Robot from Environment

Follow the same path mentioned above and uncheck the robot you don't need and close
the page.
Settings are automatically saved, and the corresponding robot is removed.
----------------------------------------------------------------------------------
Process
Process
This helps in deploying the packages to robot environments.

This helps in executing jobs faster.

If a package is linked to an environment, all the robots machines belong to that

environment are upgraded automatically.

If a newer version is available, an exclamation mark is shown in the process.

----------------------------------------------------------------------------------
Jobs
Jobs
A job is a manual or scheduled execution of a process on the robot.

You can check the jobs list in jobs page. They are available in reverse
chronological order.

You can start or terminate the job from jobs page.

Once the package is kept in the environment, it is executed by the assigned robots.

You can assign the robots from the Jobs page or else you can do it from Schedules
page.
----------------------------------------------------------------------------------
Logs
Logs
It displays all the logs that are generated by execution reports and robots.

They can be sent to SQL Database in local /Elastic Search. Both are set to default.

If there are million logs in SQL Database, it leads to performance issues. In that
case, the Elastic search is recommended.

Trace, Debug, Info, Warn, Error and Fatal are the levels in logging messages.

All logs are exported to .csv file by clicking export button, and filters can be
applied for them if needed.
----------------------------------------------------------------------------------
Assets
Assets
Assets help you to store information so that robots can access it easily.

They are stored in a encrypted format by using (AES 256 algorithm).

Assets page contains all shared variables used by robots in the process.

Assets can be obtained from studio through two activities - Get credentials and Get
Assets.
There are four types of assets:

Text, bool, Integer, and credential

Credential contains the username and passwords required for login processes.
----------------------------------------------------------------------------------
Hands-On Task
Are you ready to do some tasks:

Create an Environment with name "Fresco".

Check the logs.

Use Assets in the workflow.

Create a queue and add some items to it.

You can try the above task by installing the Windows UiPath community edition.
----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
SAP and Database
In this topic, you are going to learn about automating one of the largest ERP tool
'SAP' and about Database.

Connecting with SAP

SAP Activities

Connecting with Database

Database activities

SQL statements
----------------------------------------------------------------------------------
SAP
It is one of the largest ERP tools.

There are some elements in the SAP GUI, that is like in Citrix environments and
considered as a block.

This makes them impossible to use a simple recording or automate tool with SAP.
----------------------------------------------------------------------------------
Database
Database
UiPath uses the built in .Net framework capabilities.

It is compatible with several data services and providers.

Ways to connect to Database:

Connection string

Connection wizard
----------------------------------------------------------------------------------
UiPath Database Activities
UiPath Database Activities
Opening and closing connections
Acting inside transactions

Executing non-queries and queries

Inserting bulk data into the tables

----------------------------------------------------------------------------------
SQL Statements and Returned Values
Non-Query

Insert, Update, Delete - Number of rows modified

Other non-query - (-1)

Queries - Datatable

Bulk Insert - Number of rows affected

----------------------------------------------------------------------------------
UiPath Summary
Hope you enjoyed the course.

Now let's list down the takeaway points from this course.

UiPath Studio, Robot, and Orchestrator

Recordings in different environments
Selectors, Attributes and scraping methods
PDF and Excel Automation
Mail and SAP Automation
Exception Handling in UiPath
----------------------------------------------------------------------------------
----------------------------------------------------------------------------------
----------------------------------------------------------------------------------