5c9d5821-93f0-48ba-9aca-4e75c6088a22.jpeg

a6e5b969-be6e-4756-ae53-47d3cb899ca4.png

This Activity Pack contains the Activities mentioned below:

**Scope**

*   This activity is a container for all other activities in this package

**Read With Filter**

*   Select all or particular columns in output datatable
*   Can use conditions with multiple operators to get only filtered data
*   Can retrieve data after sorting on columns
*   Get Top rows from the table

**Insert Row**

*   Using this activity we can insert a row in the targeted Excel sheet

**Update Rows**

*   Update your Excel sheet based on the condition or update all rows

**Get Sheet Names**

*   This activity returns an array of all the Excel sheets in the targeted Excel file

**Get Column Names**

*   This activity returns an array of all the column in the targeted Excel sheet

This package provides activities to automate Excel using OLEDB

The package provides two activities:

*   convert MailMessage objects to .MSG files .
*   convert .EML files to .MSG files. 

The conversion from MailMessage to .MSG files has limitations in the form that HTML embedded images and objects are displayed as clickable links, while .EML to MSG parsing works.

this is a set of activities that enable the conversion of Mail Message Objects and .eml format mails to .msg format mails.

Three basic Kibana Dashboards (Execution, Operations, and Queue Transaction) Metrics with single click Install Utility Tool that helps you get started with UiPath Dashboards

These three Dashboards provide 14 visualisations combined:

1.  Operational\_Metrics : Provides 4 visualisations:
2.  Default\_Pie\_Split\_Process\_Runs\_Per\_Robot: Helps Visualise all the process run divided across the robots.
3.  Default\_Count\_Process\_Run\_Per\_Robot: Helps visualise the robots running split by processes
4.  Default\_Runtime\_Metrics: Gives the Total Runtime, Max. Runtime, Min. Runtime and Avg. Execution Time of the processes
5.  Default\_Process\_Execution\_Time\_Per\_Robot: Provides each bot's Utilisation.
6.  Execution\_Metrics: Provides 4 Visualisations:
7.  Default\_Execution\_Rate\_Per\_Robot: Gives execution count over time for each robot
8.  Default\_Execution\_Rate\_Per\_Process: Gives execution count over time for each process.
9.  Default\_Error\_Rate\_Per\_Robot: Gives error count over time for each robot
10.  Default\_Error\_Rate\_Per\_Process: Gives error count over time for each process
11.  Queue\_Transaction\_Metrics: Provides 6 Visualisations:
12.  Default\_Transaction\_Status\_Per\_Robot\_Per\_Queue: Status of the Transaction run per robot split by queue. 
13.  Default\_Execution\_Rate\_By\_Robot\_And\_Queue: Transaction Execution by bots distributed per queue over time
14.  default\_Transaction\_Rate\_Per\_Queue: Rate of transaction execution per queue. 
15.  Default\_Failure\_Rate\_Per\_Queue: Rate of transaction failure per queue.
16.  Default\_Exception\_Count\_Per\_Queue: Exception count and split by type for each queue
17.  Default\_Utilisation\_Rate\_By\_Queue: Time spent Default\_Utilisation\_Rate\_By\_Queue
18.  There is a Utility Tool Called Kibana Importer which you can use to Import the dashboards to the user's kibana setup
19.  The given dashboards cover all the basic visualisations one needs to get started with UiPath specific monitoring and anlytics.

Execution, Operations, and Queue Transaction Kibana Dashboard

About me