- What is difference between workbook read range and excel read range?
Excel read range must be used in Excel Application Scope only whereas Workbook Read range do not need Excel sheet to be opened.
To use excel read range activity we must have MS Excel installed on the machine whereas we don’t need excel installed for workbook read range.
⦁ Do we need excel installed on system when we use workbook read range activity?
No.
⦁ What are pdf activities used to get text from an image?
⦁ Read PDF Text
⦁ Read PDF with OCR
⦁ What is switch flow?
A Flowchart specific activity that splits the control flow into three or more branches, out of which a single one is executed based on a specified condition.
124 What is Queue? Use case of Queue?
Queue is a list of items that you want to be processed by Robots. When you create a queue in Orchestrator, it is empty. To populate the queue with items, change their status and process them, you have to use activities from Studio.
A queue is a 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. This information can be processed in other systems – SAP or Salesforce, for instance.
The Queues page enables you to create queues, view information about queue items (such as average execution time and the total number of successful transactions), display charts with the transaction status progress over time.
Queues enable you to create large automation projects underlined by complex logic. For example, you can create a process that collects all invoice information and creates a queue item for each piece of data to store it. Subsequently, you can create another process that gathers the information from Orchestrator, and uses it to perform additional tasks, such as paying the invoices in a different application, postponing their payment according to their due date or value, sending emails to the accounting team every time a bill is paid, etc.
- What are activities used in Queues?
The following activities from Studio are used with queues:
Add Queue Item– populates the queue with items and defines a time frame when these items must be processed. By default, when an item is added to the queue its status is New.
Get Transaction Item – gets an item from the queue so that you can process it (start the transaction) and sets its status to In Progress.
Set Transaction Status– changes the status of the transaction item to Failed (with an Application or Business Exception) or Successful. Application Exceptions should be used when the app you are automating fails, while Business Exceptions should be used when a certain queue item value does not meet a business requirement.
Note:
Only items that fail with an Application Exception are retried (if you also configure the Auto-Retry options in the queue, in Orchestrator).
⦁ Add Transaction Item– adds an item in the queue, starts the transaction and sets the status to In Progress.
⦁ Postpone Transaction Item– adds time parameters between which a transaction must be
processed (not before Defer Date and no later than Due Date).
All these activities are part of the Core activities package, and can be found in the Activities panel, under Orchestrator > Queues.
By default, the queue items that have been processed successfully are archived on a daily basis, while the others remain in the queue so that you can decide what to do with them
- What is Queue and Transaction?
Queue are type of Data and Transactions are Data for the Processing
For e.g., Queue – is Invoice Number – String type and Transactions are “INV132” each time Transactions will be updated once it completed process
- Difference between RPA and BPM
Function RPA
Software bots are configured to complete
monotonous tasks that humans would
Technology normally do
BP
Enc
tech
eng
bus
Automation focus Minimizes manual/ repetitive/rule-based tasks
that do not require complex decision making
Deployment effort Non-disruptive works across an organization’s
existing processes and applications
Business impact Returns can be acquired quickly and cost-
effectively.
Cost Less expensive when compared to BPM.
- If there is a System exception in GetTransition Data State in REFramework? Which
state in REFramework stage would be executed next and Why?
If There is a System Exception in GetTransition Data State in ReFramework, End Process State is executed next because as there will be no data to processed, So End Process state is executed.
- What is Credentials Manager? How it is used in Project?
In Windows, you can view and manage your network-based logon credentials (i.e., usernames and passwords) using Credential Manager.
With UiPath, you can automate the process of creating, querying and deleting the credentials through some dedicated activities.
To get credentials from the windows credential manager, you have to use the Get Secure Credential activity.
- Which desktop application have you automated in UiPath?
⦁ Automatic Data Entry into ExpenseIt Application from CSV file.
⦁ Moving Files and Folder Automation
⦁ PDF Data Extraction
⦁ Automation of Order Management System application.
⦁ Automation of CRM AnyTeller Application
⦁ Automation of Inflow Inventory System Automation.
- If suppose there are 2 excel and Each Excel contains 1000 records each. If Suppose 100 records is added into Another Second Excel? How would you Compare and Fetch 100
Records from Excel?
Using Macro or Compare each row of one excel with each row of other excel.
Creating a comparison macro for excel file will be easier
Simply picking one record of excel file A and compare it with all the records of excel file B.
Using Vlookup Option
You can do it AA excel as database inner join between two sheets.
- What is FTE
rem
time
wid
A lo tech com
Wid
pro
BPM
Full-time equivalent (FTE): the amount of work a full-time employee does in a department, or on a certain project.
It is nothing but the number of employees who are doing manual activities and if you implement RPA how many FTE you will save.
- What is difference between mainframe and non-frame Mainframe applications:
It’s a single screen and keyboard-based application.
There are separate set in-built commands supported by Blue Prism especially for mainframe applications
Non-mainframe applications:
It includes multiple screens
Control moves from one screen to another screen.
- I am your client, you give me two workflows one with activities and one with using recording. Which one you suggest me to use and why?
I will suggest workflow with activities
Because in recording we can’t get exact selectors, if we get exact selectors then we have to do all selectors as a dynamic one… So it would be better to go with workflow with activities.
- Suppose there is url which is dynamic? How would automate Url in UiPath Studio?
What is solution for dynamic url?
Use UiExplorer to get the exact selector and use dynamic selector using *, in url element for changing value.
And also you can use screen scraping to get the value.
For Example-:
In aaname you can assign as *
aaname=’*’ and title also *
Use the below selector
- How will you handle Credentials?
⦁ By using Credential manager – a window based application to save user credentials in secured
⦁ By storing in – Orchestrator as Credential – variable type
⦁ Just prompting as input box using – Get Secure text activity
- Explain main components of Orchestrator?
⦁ Processes: A process represents the association between a package and an environment. Each time a package is linked to an environment, it is automatically distributed to all the Robot machines that belong to that environment.
⦁ Assets: Assets usually represent shared variables or credentials that can be used in different automation projects. They give you the opportunity to store specific information so that the Robots can easily have access to it.
⦁ Queues: A queue is a container that enables you to hold an unlimited number of items. New queues created in Orchestrator are empty by default and can store multiple types of data.
⦁ Schedules: Schedules enable you to execute jobs in a pre-planned manner, at regular intervals on Robots. Input values for processes which support input and output parameters can be managed at this level as well
⦁ Robots: A Robot is an execution host that runs processes built in UiPath Studio. The Robotspage enables you to add robots, edit them, view their status and other settings.
⦁ Jobs: A job is the execution of a process on one or multiple Robots. After creating a process, the next step is to execute it by creating a job. When creating a new job, you can assign it to specific Robots.
⦁ Transactions: The Transactionspage displays the transactions from a given queue. It also shows their statuses, the dates when they should be processed, the Robot that processed them, and the type of exception thrown or assigned reference, if any.
- How many .xaml have you created for your project? How would publish multiple
Process to Orchestrator?
The Answer to Question depends on candidate Project and number of processes that user creates for the Project.
Orchestrator will trigger based on the reference xaml given in project.jason file.
Main
The entry point of the automation project. It consists of an .xaml file. The default name is “Main.xaml”. It is displayed both as the title of the Designer panel and in the Properties panel in Studio. If you want to execute a different project first, change the value of this parameter to the name of the .xaml file to be processed.
Note : If your automation project contains multiple files, each of them should be linked to
the Main.xaml file through the Invoke Workflow File activity . This is especially useful when the project is published to Orchestrator and sent to a Robot, as the Robot executes only the file provided in this parameter.
if you want to change entry point of xaml file you can change in this project.jason file. ‘Project.json’ is an automatically generated file which is included in the folder of each automation project made in Studio. The file holds information about the project dependencies.
- Suppose there are 5 different Processes, how would you schedule all these processes
in Orchestrator?
We can schedule all 5 processes for one machine, One by one.. It will start process one by one.
If machine are different then 5 Processes can be scheduled simultaneously.
Schedules enable you to execute jobs in a pre planned manner, at regular intervals on Robots. Input values for processes which support input and output parameters can be managed at this level as well. You can assign Robots to perform different schedules according to the following options:
⦁ All Robots– Schedules are executed by all the Robots in a specific environment.
⦁ Specific Robots– Schedules are executed by the Robots selected by the user.
⦁ Allocate dynamically– Define how many times a process is to be executed according to the given schedule. This option enables you to utilize your resources to their greatest extent. As soon as a
Robot becomes Available, it executes the indicated process according to the provided schedule. The Schedules page enables you to create new schedules. It also displays all previously created schedules, which can be further edited, enabled, or disabled.
You can view the jobs started by a specific schedule on the Jobs window, by selecting More Actions > View jobs. A scheduled job can also be stopped after a custom amount of time with the Stop or Kill options on the Actions tab.
- What are Credentials? How credentials are used in your project?
Credentials are one of Asset types used in Orchestrator. They are used to store credentials in Orchestrator. Credentials contains usernames and passwords that the Robot requires to execute particular processes, such as login details for SAP or SalesForce and gmail credentials.
The Get Asset and Get Credential activities used in Studio request information from Orchestrator about a specific asset, according to a provided AssetName. If the AssetName provided in Studio coincides with the name of an asset stored in the Orchestrator database, and the Robot has the required permissions, the asset information is retrieved and used by the Robot when executing the automation project.
- What is LINQ? Use case of Linq?
LINQ (Language Integrated Query) is uniform query syntax in C# and VB.NET to retrieve data from different sources and formats. We can retrieve data from list, arrays, datatables. It is integrated in C# or VB, thereby eliminating the mismatch between programming languages and databases, as well as providing a single querying interface for different types of data sources.
⦁ For example, SQL is a Structured Query Language used to save and retrieve data from a database. In the same way, LINQ is a structured query syntax built in C# and VB.NET to retrieve data from different types of data sources such as collections, ADO.Net DataSet, XML Docs, web service and
MS SQL Server and other databases.
LINQ queries return results as objects. It enables you to uses object-oriented approach on the result set and not to worry about transforming different formats of results into objects.
⦁ Use case of LINQ in UiPath LINQ Usage
LINQ queries return results as objects. It enables you to uses object-oriented approach on the result set and not to worry about transforming different formats of results into objects.
The following example demonstrates a simple LINQ query that gets all strings from an array which contains ‘a’.
Example: LINQ Query to Array
// Data source
string[] names = {“Bill”, “Steve”, “James”, “Mohan” };
// LINQ Query
var myLinqQuery = from name in names
where name.Contains(‘a’)
select name;
// Query execution
foreach(var name in myLinqQuery)
Console.Write(name + ” “);
Try it
In the above example, string array names is a data source. The following is a LINQ query which is assigned to a variable myLinqQuery.
from name in names
where name.Contains(‘a’)
select name;
The above query uses query syntax of LINQ.
- Suppose there are 1000 rows and 50 columns, Suppose I want to select any random
row data? How it can be done?
Assign dtVariable = new DataTable
Initializing your DataTable variable
[Build your data table process]
Assign intRandom = new Random().Next(0, dtVariable.Rows.Count – 1)
This will give you a randomly generated number between 0 – N, where N = number of rows in your datatable (i.e., a data table of 10 rows will result in a count of 10)
We subtract 1 because dtVariable.Rows.Count starts at 1, whereas dtVariable.Rows(index) starts at 0 (i.e., a data table of 10 rows will result in an index max of 9).
Assign rowRandom = dtVariable.Rows(intRandom) This will output a DataRow at random of DataRow type.
- What are dynamic selectors? Types of Dynamic Selectors used in UiPath?
⦁ The selector is a string of characters (VB expression) used to identify objects on the screen. The selector is one of the properties of UI activities and has an XML format. All the activities in UiPath Studio related to graphical elements have the selector property.
⦁ The solution to this problem is to:
⦁ Build better selectors
⦁ Use WildCard
⦁ To see the better and dynamic attributes compare the selectors and make dynamic them using wildcard operators and identify reliable selectors using UIExplorer.
⦁ Selectors attributes part contains all the attributes of an object. Not all can be added or removed from your selector string, because not all of them are useful for identifying a certain object.
⦁ The most important thing when choosing selectors is to pick those which always have a constant value. If the value of an attribute changes, then the selector will not be able to correctly identify the
element.
Attributes may change their values from time to time when the application’s UI changes. When this happens, part of the dynamic attributes often remain unchanged and we somehow have to specify the variable parts. This can be done using wildcards:
1.* star means zero or more characters can be there. Example: title=’* – Notepad’.
2.? question mark means exactly one character. Example: title=‘Expl?rer’.
A direct consequence when using wildcards is the increased probability of there being more and more nodes matching the Selector.
- If you do not have excel installed on your system. How would you use excel activity in
UiPath Studio?
We can use Excel activity Workbook Read Range without installing Excel on System. As we don’t need excel installed for workbook read range activity.
UiPath Studio offers you the possibility to work with Excel using specialized activities. These activities are stored in the UiPath Excel activities package. The Excel package can be downloaded from “Manage Packages” but it’s by default installed when you install UiPath Studio.
Through this app integration approach you are able to read/write Excel documents.
Good points for not using the Excel application:
⦁ You don’t need to install/buy Microsoft Excel
⦁ Excel application will not pop up on your desktop
⦁ Suitable for robots that run on a machine that doesn’t have a user interface.
- What is port number of POP3 Gmail/ IMAP Gmail?
⦁ Port number of POP3 Gmail is-: 993
⦁ By default, the POP3protocol works on two ports:
⦁ Port 110– this is the default POP3 unencrypted portPort 995 – this is the port you need to use if you want to connect using POP3 securely
⦁ By default, the IMAPprotocol works on two ports:
⦁ Port 143– this is the default IMAP unencrypted portPort 993 – this is the port you need to use if you want to connect using IMAP securely.
- What is Port number of Smtp Gmail?
⦁ SMTP Port– 587 (default Google SMTP port).
⦁ Outgoing Mail (SMTP) Server-: ⦁ gmail.com
⦁ Requires SSL: Yes
⦁ Requires TLS: Yes (if available)
⦁ Requires Authentication: Yes
⦁ Port for SSL: 465
⦁ Port for TLS/STARTTLS: 587
- If suppose there is Image in PDF which is of 120 dp, how would extract data from that
Image? Which automation would be used?
To extract data from Image of Size 120 dp from PDF we need to use Read PDF with OCR activity, and automation we need to use is PDF Automation.
We can also use Microsoft OCR activity to extract extract exact data from Image of the PDF file.
- If Suppose there are 2 excels, how would merge 2 excel data into one?
- Firstly we need to use Read Range to read the 2 excel files,
- Then we need to use merge data table activity to merge the data table.
- Then we need to use the resultant data table to make the merged excel file using WriteRange activity.
Fig no-: Merge Two DataTable using UiPath
- If you have 1000 of data in queue and there are 5 robots you want to distribute data
among them, how you can do it without using queue activity
To distribute 1000 records of data in queue on 5 robots among them without using queue activity, we need to set up an Excel or CSV file that is in a shared location accessible by all your bots. Then have a column for Status, and as a bot processes each row, they update that column to “In Progress” and save the file. Bots should only process rows if column <> “In Progress”. We need to add other columns for tracking and logging, such as Transaction IDs, Bot Name, Fail Reason, etc.
- I have process of two different version how will you identify them at the time of deploying?
⦁ To identify the process of two different versions at time of deploying we can identify by publishing Process from Studio and we can choose the project version number.
⦁ Also, within orchestrator, the package number will match the version number of published Process from Studio.
⦁ Based on its version number we can identify it. At the time of publishing project from Uipath Studio and it show new version number.
- Can you update credentials stored in Assets in Orchestrator from UiPath Studio? If yes then how you can update credentials?
⦁ We can update Credentials stored in Assets in Orchestrator but not at runtime. We can update Credentials manually before scheduling bot.
⦁ We can allow user to update only specific assets. You can create a custom user role and give him
permissions only to asset editing, though. This is done through the /roles route on Orchestrator. UiPath.Core.Activities.SetCredential
⦁ Enables you to update the value of an indicated credential asset, that is already available in Orchestrator, be it a global or a Per Robot asset. Please note that to execute this
activity, the Robotrole needs to have Edit permissions on assets. The activity runs under the Robot which executes it.
- How you can create bubble sort in uipath?
We can use Sort method available in Arrays methods. This is workflow for sorting data using array-:
Fig no-: 157 a) Sorting Using Invoke Workflow Activity
Fig no-: 157 (b) After Sorting Login Workflow.
- Explain Uipath lifecycle?
A typical life cycle of UiPath RPA has 4 phases. Analysis, Bot Development, Testing, and Support & Maintenance.
⦁ Analysis– Business teams & RPA Architects work together to analyze a business process for RPA development.
⦁ Bot Development– Developer teams start working on developing the automated workflows for the requirements in a distinct development environment.
⦁ Testing– Run testing cycles such as SDLC to analyze the quality and correct defects.
⦁ Support & Maintenance-After the development & testing phases, a bot enters the maintenance phases in which it provides continuous support and helps in the immediate defect resolution.
- What is macros in UiPath?
Macro is a piece of programming code that runs in Excel environment and helps automate routine tasks. In a layman’s language, a macro is a recording of your routine steps in Excel that you can replay using a single button.
Execute Macro UiPath.Excel.Activities.ExecuteMacro
⦁ Execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook.
Changes are immediately saved. Can only be used in the Excel Application Scope
Properties
Input
MacroName – The name of the macro to be executed. Only String variables and strings are supported.
Note:
⦁ Macro Parameters– Enables you to pass parameters when executing the macro. This field supports only IEnumerable
- What is difference between workbook read range and excel read range?
Excel read range must be used in Excel Application Scope only whereas Workbook Read range do not need Excel sheet to be opened.
To use excel read range activity we must have MS Excel installed on the machine whereas we don’t need excel installed for workbook read range.
⦁ Do we need excel installed on system when we use workbook read range activity?
No.
⦁ What are pdf activities used to get text from an image?
⦁ Read PDF Text
⦁ Read PDF with OCR
⦁ What is switch flow?
A Flowchart specific activity that splits the control flow into three or more branches, out of which a single one is executed based on a specified condition.
- What is Queue? Use case of Queue?
Queue is a list of items that you want to be processed by Robots. When you create a queue in Orchestrator, it is empty. To populate the queue with items, change their status and process them, you have to use activities from Studio.
A queue is a 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. This information can be processed in other systems – SAP or Salesforce, for instance.
The Queues page enables you to create queues, view information about queue items (such as average execution time and the total number of successful transactions), display charts with the transaction status progress over time.
Queues enable you to create large automation projects underlined by complex logic. For example, you can create a process that collects all invoice information and creates a queue item for each piece of data to store it. Subsequently, you can create another process that gathers the information from Orchestrator, and uses it to perform additional tasks, such as paying the invoices in a different application, postponing their payment according to their due date or value, sending emails to the accounting team every time a bill is paid, etc.
- What are activities used in Queues?
The following activities from Studio are used with queues:
Add Queue Item– populates the queue with items and defines a time frame when these items must be processed. By default, when an item is added to the queue its status is New.
Get Transaction Item – gets an item from the queue so that you can process it (start the transaction) and sets its status to In Progress.
Set Transaction Status– changes the status of the transaction item to Failed (with an Application or Business Exception) or Successful. Application Exceptions should be used when the app you are automating fails, while Business Exceptions should be used when a certain queue item value does not meet a business requirement.
Note:
Only items that fail with an Application Exception are retried (if you also configure the Auto-Retry options in the queue, in Orchestrator).
⦁ Add Transaction Item– adds an item in the queue, starts the transaction and sets the status to In Progress.
⦁ Postpone Transaction Item– adds time parameters between which a transaction must be
processed (not before Defer Date and no later than Due Date).
All these activities are part of the Core activities package, and can be found in the Activities panel, under Orchestrator > Queues.
By default, the queue items that have been processed successfully are archived on a daily basis, while the others remain in the queue so that you can decide what to do with them
- What is Queue and Transaction?
Queue are type of Data and Transactions are Data for the Processing
For e.g., Queue – is Invoice Number – String type and Transactions are “INV132” each time Transactions will be updated once it completed process
- Difference between RPA and BPM
Function RPA
Software bots are configured to complete
monotonous tasks that humans would
Technology normally do
BP
Enc
tech
eng
bus
Automation focus Minimizes manual/ repetitive/rule-based tasks
that do not require complex decision making
Deployment effort Non-disruptive works across an organization’s
existing processes and applications
Business impact Returns can be acquired quickly and cost-
effectively.
Cost Less expensive when compared to BPM.
- If there is a System exception in GetTransition Data State in REFramework? Which
state in REFramework stage would be executed next and Why?
If There is a System Exception in GetTransition Data State in ReFramework, End Process State is executed next because as there will be no data to processed, So End Process state is executed.
- What is Credentials Manager? How it is used in Project?
In Windows, you can view and manage your network-based logon credentials (i.e., usernames and passwords) using Credential Manager.
With UiPath, you can automate the process of creating, querying and deleting the credentials through some dedicated activities.
To get credentials from the windows credential manager, you have to use the Get Secure Credential activity.
- Which desktop application have you automated in UiPath?
⦁ Automatic Data Entry into ExpenseIt Application from CSV file.
⦁ Moving Files and Folder Automation
⦁ PDF Data Extraction
⦁ Automation of Order Management System application.
⦁ Automation of CRM AnyTeller Application
⦁ Automation of Inflow Inventory System Automation.
- If suppose there are 2 excel and Each Excel contains 1000 records each. If Suppose 100 records is added into Another Second Excel? How would you Compare and Fetch 100
Records from Excel?
Using Macro or Compare each row of one excel with each row of other excel.
Creating a comparison macro for excel file will be easier
Simply picking one record of excel file A and compare it with all the records of excel file B.
Using Vlookup Option
You can do it AA excel as database inner join between two sheets.
- What is FTE
rem
time
wid
A lo tech com
Wid
pro
BPM
Full-time equivalent (FTE): the amount of work a full-time employee does in a department, or on a certain project.
It is nothing but the number of employees who are doing manual activities and if you implement RPA how many FTE you will save.
- What is difference between mainframe and non-frame Mainframe applications:
It’s a single screen and keyboard-based application.
There are separate set in-built commands supported by Blue Prism especially for mainframe applications
Non-mainframe applications:
It includes multiple screens
Control moves from one screen to another screen.
- I am your client, you give me two workflows one with activities and one with using recording. Which one you suggest me to use and why?
I will suggest workflow with activities
Because in recording we can’t get exact selectors, if we get exact selectors then we have to do all selectors as a dynamic one… So it would be better to go with workflow with activities.
- Suppose there is url which is dynamic? How would automate Url in UiPath Studio?
What is solution for dynamic url?
Use UiExplorer to get the exact selector and use dynamic selector using *, in url element for changing value.
And also you can use screen scraping to get the value.
For Example-:
In aaname you can assign as *
aaname=’*’ and title also *
Use the below selector
- How will you handle Credentials?
⦁ By using Credential manager – a window based application to save user credentials in secured
⦁ By storing in – Orchestrator as Credential – variable type
⦁ Just prompting as input box using – Get Secure text activity
- Explain main components of Orchestrator?
⦁ Processes: A process represents the association between a package and an environment. Each time a package is linked to an environment, it is automatically distributed to all the Robot machines that belong to that environment.
⦁ Assets: Assets usually represent shared variables or credentials that can be used in different automation projects. They give you the opportunity to store specific information so that the Robots can easily have access to it.
⦁ Queues: A queue is a container that enables you to hold an unlimited number of items. New queues created in Orchestrator are empty by default and can store multiple types of data.
⦁ Schedules: Schedules enable you to execute jobs in a pre-planned manner, at regular intervals on Robots. Input values for processes which support input and output parameters can be managed at this level as well
⦁ Robots: A Robot is an execution host that runs processes built in UiPath Studio. The Robotspage enables you to add robots, edit them, view their status and other settings.
⦁ Jobs: A job is the execution of a process on one or multiple Robots. After creating a process, the next step is to execute it by creating a job. When creating a new job, you can assign it to specific Robots.
⦁ Transactions: The Transactionspage displays the transactions from a given queue. It also shows their statuses, the dates when they should be processed, the Robot that processed them, and the type of exception thrown or assigned reference, if any.
- How many .xaml have you created for your project? How would publish multiple
Process to Orchestrator?
The Answer to Question depends on candidate Project and number of processes that user creates for the Project.
Orchestrator will trigger based on the reference xaml given in project.jason file.
Main
The entry point of the automation project. It consists of an .xaml file. The default name is “Main.xaml”. It is displayed both as the title of the Designer panel and in the Properties panel in Studio. If you want to execute a different project first, change the value of this parameter to the name of the .xaml file to be processed.
Note : If your automation project contains multiple files, each of them should be linked to
the Main.xaml file through the Invoke Workflow File activity . This is especially useful when the project is published to Orchestrator and sent to a Robot, as the Robot executes only the file provided in this parameter.
if you want to change entry point of xaml file you can change in this project.jason file. ‘Project.json’ is an automatically generated file which is included in the folder of each automation project made in Studio. The file holds information about the project dependencies.
- Suppose there are 5 different Processes, how would you schedule all these processes
in Orchestrator?
We can schedule all 5 processes for one machine, One by one.. It will start process one by one.
If machine are different then 5 Processes can be scheduled simultaneously.
Schedules enable you to execute jobs in a pre planned manner, at regular intervals on Robots. Input values for processes which support input and output parameters can be managed at this level as well. You can assign Robots to perform different schedules according to the following options:
⦁ All Robots– Schedules are executed by all the Robots in a specific environment.
⦁ Specific Robots– Schedules are executed by the Robots selected by the user.
⦁ Allocate dynamically– Define how many times a process is to be executed according to the given schedule. This option enables you to utilize your resources to their greatest extent. As soon as a
Robot becomes Available, it executes the indicated process according to the provided schedule. The Schedules page enables you to create new schedules. It also displays all previously created schedules, which can be further edited, enabled, or disabled.
You can view the jobs started by a specific schedule on the Jobs window, by selecting More Actions > View jobs. A scheduled job can also be stopped after a custom amount of time with the Stop or Kill options on the Actions tab.
- What are Credentials? How credentials are used in your project?
Credentials are one of Asset types used in Orchestrator. They are used to store credentials in Orchestrator. Credentials contains usernames and passwords that the Robot requires to execute particular processes, such as login details for SAP or SalesForce and gmail credentials.
The Get Asset and Get Credential activities used in Studio request information from Orchestrator about a specific asset, according to a provided AssetName. If the AssetName provided in Studio coincides with the name of an asset stored in the Orchestrator database, and the Robot has the required permissions, the asset information is retrieved and used by the Robot when executing the automation project.
- What is LINQ? Use case of Linq?
LINQ (Language Integrated Query) is uniform query syntax in C# and VB.NET to retrieve data from different sources and formats. We can retrieve data from list, arrays, datatables. It is integrated in C# or VB, thereby eliminating the mismatch between programming languages and databases, as well as providing a single querying interface for different types of data sources.
⦁ For example, SQL is a Structured Query Language used to save and retrieve data from a database. In the same way, LINQ is a structured query syntax built in C# and VB.NET to retrieve data from different types of data sources such as collections, ADO.Net DataSet, XML Docs, web service and
MS SQL Server and other databases.
LINQ queries return results as objects. It enables you to uses object-oriented approach on the result set and not to worry about transforming different formats of results into objects.
⦁ Use case of LINQ in UiPath LINQ Usage
LINQ queries return results as objects. It enables you to uses object-oriented approach on the result set and not to worry about transforming different formats of results into objects.
The following example demonstrates a simple LINQ query that gets all strings from an array which contains ‘a’.
Example: LINQ Query to Array
// Data source
string[] names = {“Bill”, “Steve”, “James”, “Mohan” };
// LINQ Query
var myLinqQuery = from name in names
where name.Contains(‘a’)
select name;
// Query execution
foreach(var name in myLinqQuery)
Console.Write(name + ” “);
Try it
In the above example, string array names is a data source. The following is a LINQ query which is assigned to a variable myLinqQuery.
from name in names
where name.Contains(‘a’)
select name;
The above query uses query syntax of LINQ.
- Suppose there are 1000 rows and 50 columns, Suppose I want to select any random
row data? How it can be done?
Assign dtVariable = new DataTable
Initializing your DataTable variable
[Build your data table process]
Assign intRandom = new Random().Next(0, dtVariable.Rows.Count – 1)
This will give you a randomly generated number between 0 – N, where N = number of rows in your datatable (i.e., a data table of 10 rows will result in a count of 10)
We subtract 1 because dtVariable.Rows.Count starts at 1, whereas dtVariable.Rows(index) starts at 0 (i.e., a data table of 10 rows will result in an index max of 9).
Assign rowRandom = dtVariable.Rows(intRandom) This will output a DataRow at random of DataRow type.
- What are dynamic selectors? Types of Dynamic Selectors used in UiPath?
⦁ The selector is a string of characters (VB expression) used to identify objects on the screen. The selector is one of the properties of UI activities and has an XML format. All the activities in UiPath Studio related to graphical elements have the selector property.
⦁ The solution to this problem is to:
⦁ Build better selectors
⦁ Use WildCard
⦁ To see the better and dynamic attributes compare the selectors and make dynamic them using wildcard operators and identify reliable selectors using UIExplorer.
⦁ Selectors attributes part contains all the attributes of an object. Not all can be added or removed from your selector string, because not all of them are useful for identifying a certain object.
⦁ The most important thing when choosing selectors is to pick those which always have a constant value. If the value of an attribute changes, then the selector will not be able to correctly identify the
element.
Attributes may change their values from time to time when the application’s UI changes. When this happens, part of the dynamic attributes often remain unchanged and we somehow have to specify the variable parts. This can be done using wildcards:
1.* star means zero or more characters can be there. Example: title=’* – Notepad’.
2.? question mark means exactly one character. Example: title=‘Expl?rer’.
A direct consequence when using wildcards is the increased probability of there being more and more nodes matching the Selector.
- If you do not have excel installed on your system. How would you use excel activity in
UiPath Studio?
We can use Excel activity Workbook Read Range without installing Excel on System. As we don’t need excel installed for workbook read range activity.
UiPath Studio offers you the possibility to work with Excel using specialized activities. These activities are stored in the UiPath Excel activities package. The Excel package can be downloaded from “Manage Packages” but it’s by default installed when you install UiPath Studio.
Through this app integration approach you are able to read/write Excel documents.
Good points for not using the Excel application:
⦁ You don’t need to install/buy Microsoft Excel
⦁ Excel application will not pop up on your desktop
⦁ Suitable for robots that run on a machine that doesn’t have a user interface.
- What is port number of POP3 Gmail/ IMAP Gmail?
⦁ Port number of POP3 Gmail is-: 993
⦁ By default, the POP3protocol works on two ports:
⦁ Port 110– this is the default POP3 unencrypted portPort 995 – this is the port you need to use if you want to connect using POP3 securely
⦁ By default, the IMAPprotocol works on two ports:
⦁ Port 143– this is the default IMAP unencrypted portPort 993 – this is the port you need to use if you want to connect using IMAP securely.
- What is Port number of Smtp Gmail?
⦁ SMTP Port– 587 (default Google SMTP port).
⦁ Outgoing Mail (SMTP) Server-: ⦁ gmail.com
⦁ Requires SSL: Yes
⦁ Requires TLS: Yes (if available)
⦁ Requires Authentication: Yes
⦁ Port for SSL: 465
⦁ Port for TLS/STARTTLS: 587
- If suppose there is Image in PDF which is of 120 dp, how would extract data from that
Image? Which automation would be used?
To extract data from Image of Size 120 dp from PDF we need to use Read PDF with OCR activity, and automation we need to use is PDF Automation.
We can also use Microsoft OCR activity to extract extract exact data from Image of the PDF file.
- If Suppose there are 2 excels, how would merge 2 excel data into one?
- Firstly we need to use Read Range to read the 2 excel files,
- Then we need to use merge data table activity to merge the data table.
- Then we need to use the resultant data table to make the merged excel file using WriteRange activity.
Fig no-: Merge Two DataTable using UiPath
- If you have 1000 of data in queue and there are 5 robots you want to distribute data
among them, how you can do it without using queue activity
To distribute 1000 records of data in queue on 5 robots among them without using queue activity, we need to set up an Excel or CSV file that is in a shared location accessible by all your bots. Then have a column for Status, and as a bot processes each row, they update that column to “In Progress” and save the file. Bots should only process rows if column <> “In Progress”. We need to add other columns for tracking and logging, such as Transaction IDs, Bot Name, Fail Reason, etc.
- I have process of two different version how will you identify them at the time of deploying?
⦁ To identify the process of two different versions at time of deploying we can identify by publishing Process from Studio and we can choose the project version number.
⦁ Also, within orchestrator, the package number will match the version number of published Process from Studio.
⦁ Based on its version number we can identify it. At the time of publishing project from Uipath Studio and it show new version number.
- Can you update credentials stored in Assets in Orchestrator from UiPath Studio? If yes then how you can update credentials?
⦁ We can update Credentials stored in Assets in Orchestrator but not at runtime. We can update Credentials manually before scheduling bot.
⦁ We can allow user to update only specific assets. You can create a custom user role and give him
permissions only to asset editing, though. This is done through the /roles route on Orchestrator. UiPath.Core.Activities.SetCredential
⦁ Enables you to update the value of an indicated credential asset, that is already available in Orchestrator, be it a global or a Per Robot asset. Please note that to execute this
activity, the Robotrole needs to have Edit permissions on assets. The activity runs under the Robot which executes it.
- How you can create bubble sort in uipath?
We can use Sort method available in Arrays methods. This is workflow for sorting data using array-:
Fig no-: 157 a) Sorting Using Invoke Workflow Activity
Fig no-: 157 (b) After Sorting Login Workflow.
- Explain Uipath lifecycle?
A typical life cycle of UiPath RPA has 4 phases. Analysis, Bot Development, Testing, and Support & Maintenance.
⦁ Analysis– Business teams & RPA Architects work together to analyze a business process for RPA development.
⦁ Bot Development– Developer teams start working on developing the automated workflows for the requirements in a distinct development environment.
⦁ Testing– Run testing cycles such as SDLC to analyze the quality and correct defects.
⦁ Support & Maintenance-After the development & testing phases, a bot enters the maintenance phases in which it provides continuous support and helps in the immediate defect resolution.
- What is macros in UiPath?
Macro is a piece of programming code that runs in Excel environment and helps automate routine tasks. In a layman’s language, a macro is a recording of your routine steps in Excel that you can replay using a single button.
Execute Macro UiPath.Excel.Activities.ExecuteMacro
⦁ Execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook.
Changes are immediately saved. Can only be used in the Excel Application Scope
Properties
Input
MacroName – The name of the macro to be executed. Only String variables and strings are supported.
Note:
⦁ Macro Parameters– Enables you to pass parameters when executing the macro. This field supports only IEnumerable
⦁ Macro Parameters– Enables you to pass parameters when executing the macro. This field supports only IEnumerable
Excel read range must be used in Excel Application Scope only whereas Workbook Read range do not need Excel sheet to be opened.
To use excel read range activity we must have MS Excel installed on the machine whereas we don’t need excel installed for workbook read range.
⦁ Do we need excel installed on system when we use workbook read range activity?
No.
⦁ What are pdf activities used to get text from an image?
⦁ Read PDF Text
⦁ Read PDF with OCR
⦁ What is switch flow?
A Flowchart specific activity that splits the control flow into three or more branches, out of which a single one is executed based on a specified condition.
- What is Queue? Use case of Queue?
Queue is a list of items that you want to be processed by Robots. When you create a queue in Orchestrator, it is empty. To populate the queue with items, change their status and process them, you have to use activities from Studio.
A queue is a 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. This information can be processed in other systems – SAP or Salesforce, for instance.
The Queues page enables you to create queues, view information about queue items (such as average execution time and the total number of successful transactions), display charts with the transaction status progress over time.
Queues enable you to create large automation projects underlined by complex logic. For example, you can create a process that collects all invoice information and creates a queue item for each piece of data to store it. Subsequently, you can create another process that gathers the information from Orchestrator, and uses it to perform additional tasks, such as paying the invoices in a different application, postponing their payment according to their due date or value, sending emails to the accounting team every time a bill is paid, etc.
- What are activities used in Queues?
The following activities from Studio are used with queues:
Add Queue Item– populates the queue with items and defines a time frame when these items must be processed. By default, when an item is added to the queue its status is New.
Get Transaction Item – gets an item from the queue so that you can process it (start the transaction) and sets its status to In Progress.
Set Transaction Status– changes the status of the transaction item to Failed (with an Application or Business Exception) or Successful. Application Exceptions should be used when the app you are automating fails, while Business Exceptions should be used when a certain queue item value does not meet a business requirement.
Note:
Only items that fail with an Application Exception are retried (if you also configure the Auto-Retry options in the queue, in Orchestrator).
⦁ Add Transaction Item– adds an item in the queue, starts the transaction and sets the status to In Progress.
⦁ Postpone Transaction Item– adds time parameters between which a transaction must be
processed (not before Defer Date and no later than Due Date).
All these activities are part of the Core activities package, and can be found in the Activities panel, under Orchestrator > Queues.
By default, the queue items that have been processed successfully are archived on a daily basis, while the others remain in the queue so that you can decide what to do with them
- What is Queue and Transaction?
Queue are type of Data and Transactions are Data for the Processing
For e.g., Queue – is Invoice Number – String type and Transactions are “INV132” each time Transactions will be updated once it completed process
- Difference between RPA and BPM
Function RPA
Software bots are configured to complete
monotonous tasks that humans would
Technology normally do
BP
Enc
tech
eng
bus
Automation focus Minimizes manual/ repetitive/rule-based tasks
that do not require complex decision making
Deployment effort Non-disruptive works across an organization’s
existing processes and applications
Business impact Returns can be acquired quickly and cost-
effectively.
Cost Less expensive when compared to BPM.
- If there is a System exception in GetTransition Data State in REFramework? Which
state in REFramework stage would be executed next and Why?
If There is a System Exception in GetTransition Data State in ReFramework, End Process State is executed next because as there will be no data to processed, So End Process state is executed.
- What is Credentials Manager? How it is used in Project?
In Windows, you can view and manage your network-based logon credentials (i.e., usernames and passwords) using Credential Manager.
With UiPath, you can automate the process of creating, querying and deleting the credentials through some dedicated activities.
To get credentials from the windows credential manager, you have to use the Get Secure Credential activity.
- Which desktop application have you automated in UiPath?
⦁ Automatic Data Entry into ExpenseIt Application from CSV file.
⦁ Moving Files and Folder Automation
⦁ PDF Data Extraction
⦁ Automation of Order Management System application.
⦁ Automation of CRM AnyTeller Application
⦁ Automation of Inflow Inventory System Automation.
- If suppose there are 2 excel and Each Excel contains 1000 records each. If Suppose 100 records is added into Another Second Excel? How would you Compare and Fetch 100
Records from Excel?
Using Macro or Compare each row of one excel with each row of other excel.
Creating a comparison macro for excel file will be easier
Simply picking one record of excel file A and compare it with all the records of excel file B.
Using Vlookup Option
You can do it AA excel as database inner join between two sheets.
- What is FTE
rem
time
wid
A lo tech com
Wid
pro
BPM
Full-time equivalent (FTE): the amount of work a full-time employee does in a department, or on a certain project.
It is nothing but the number of employees who are doing manual activities and if you implement RPA how many FTE you will save.
- What is difference between mainframe and non-frame Mainframe applications:
It’s a single screen and keyboard-based application.
There are separate set in-built commands supported by Blue Prism especially for mainframe applications
Non-mainframe applications:
It includes multiple screens
Control moves from one screen to another screen.
- I am your client, you give me two workflows one with activities and one with using recording. Which one you suggest me to use and why?
I will suggest workflow with activities
Because in recording we can’t get exact selectors, if we get exact selectors then we have to do all selectors as a dynamic one… So it would be better to go with workflow with activities.
- Suppose there is url which is dynamic? How would automate Url in UiPath Studio?
What is solution for dynamic url?
Use UiExplorer to get the exact selector and use dynamic selector using *, in url element for changing value.
And also you can use screen scraping to get the value.
For Example-:
In aaname you can assign as *
aaname=’*’ and title also *
Use the below selector
- How will you handle Credentials?
⦁ By using Credential manager – a window based application to save user credentials in secured
⦁ By storing in – Orchestrator as Credential – variable type
⦁ Just prompting as input box using – Get Secure text activity
- Explain main components of Orchestrator?
⦁ Processes: A process represents the association between a package and an environment. Each time a package is linked to an environment, it is automatically distributed to all the Robot machines that belong to that environment.
⦁ Assets: Assets usually represent shared variables or credentials that can be used in different automation projects. They give you the opportunity to store specific information so that the Robots can easily have access to it.
⦁ Queues: A queue is a container that enables you to hold an unlimited number of items. New queues created in Orchestrator are empty by default and can store multiple types of data.
⦁ Schedules: Schedules enable you to execute jobs in a pre-planned manner, at regular intervals on Robots. Input values for processes which support input and output parameters can be managed at this level as well
⦁ Robots: A Robot is an execution host that runs processes built in UiPath Studio. The Robotspage enables you to add robots, edit them, view their status and other settings.
⦁ Jobs: A job is the execution of a process on one or multiple Robots. After creating a process, the next step is to execute it by creating a job. When creating a new job, you can assign it to specific Robots.
⦁ Transactions: The Transactionspage displays the transactions from a given queue. It also shows their statuses, the dates when they should be processed, the Robot that processed them, and the type of exception thrown or assigned reference, if any.
- How many .xaml have you created for your project? How would publish multiple
Process to Orchestrator?
The Answer to Question depends on candidate Project and number of processes that user creates for the Project.
Orchestrator will trigger based on the reference xaml given in project.jason file.
Main
The entry point of the automation project. It consists of an .xaml file. The default name is “Main.xaml”. It is displayed both as the title of the Designer panel and in the Properties panel in Studio. If you want to execute a different project first, change the value of this parameter to the name of the .xaml file to be processed.
Note : If your automation project contains multiple files, each of them should be linked to
the Main.xaml file through the Invoke Workflow File activity . This is especially useful when the project is published to Orchestrator and sent to a Robot, as the Robot executes only the file provided in this parameter.
if you want to change entry point of xaml file you can change in this project.jason file. ‘Project.json’ is an automatically generated file which is included in the folder of each automation project made in Studio. The file holds information about the project dependencies.
- Suppose there are 5 different Processes, how would you schedule all these processes
in Orchestrator?
We can schedule all 5 processes for one machine, One by one.. It will start process one by one.
If machine are different then 5 Processes can be scheduled simultaneously.
Schedules enable you to execute jobs in a pre planned manner, at regular intervals on Robots. Input values for processes which support input and output parameters can be managed at this level as well. You can assign Robots to perform different schedules according to the following options:
⦁ All Robots– Schedules are executed by all the Robots in a specific environment.
⦁ Specific Robots– Schedules are executed by the Robots selected by the user.
⦁ Allocate dynamically– Define how many times a process is to be executed according to the given schedule. This option enables you to utilize your resources to their greatest extent. As soon as a
Robot becomes Available, it executes the indicated process according to the provided schedule. The Schedules page enables you to create new schedules. It also displays all previously created schedules, which can be further edited, enabled, or disabled.
You can view the jobs started by a specific schedule on the Jobs window, by selecting More Actions > View jobs. A scheduled job can also be stopped after a custom amount of time with the Stop or Kill options on the Actions tab.
- What are Credentials? How credentials are used in your project?
Credentials are one of Asset types used in Orchestrator. They are used to store credentials in Orchestrator. Credentials contains usernames and passwords that the Robot requires to execute particular processes, such as login details for SAP or SalesForce and gmail credentials.
The Get Asset and Get Credential activities used in Studio request information from Orchestrator about a specific asset, according to a provided AssetName. If the AssetName provided in Studio coincides with the name of an asset stored in the Orchestrator database, and the Robot has the required permissions, the asset information is retrieved and used by the Robot when executing the automation project.
- What is LINQ? Use case of Linq?
LINQ (Language Integrated Query) is uniform query syntax in C# and VB.NET to retrieve data from different sources and formats. We can retrieve data from list, arrays, datatables. It is integrated in C# or VB, thereby eliminating the mismatch between programming languages and databases, as well as providing a single querying interface for different types of data sources.
⦁ For example, SQL is a Structured Query Language used to save and retrieve data from a database. In the same way, LINQ is a structured query syntax built in C# and VB.NET to retrieve data from different types of data sources such as collections, ADO.Net DataSet, XML Docs, web service and
MS SQL Server and other databases.
LINQ queries return results as objects. It enables you to uses object-oriented approach on the result set and not to worry about transforming different formats of results into objects.
⦁ Use case of LINQ in UiPath LINQ Usage
LINQ queries return results as objects. It enables you to uses object-oriented approach on the result set and not to worry about transforming different formats of results into objects.
The following example demonstrates a simple LINQ query that gets all strings from an array which contains ‘a’.
Example: LINQ Query to Array
// Data source
string[] names = {“Bill”, “Steve”, “James”, “Mohan” };
// LINQ Query
var myLinqQuery = from name in names
where name.Contains(‘a’)
select name;
// Query execution
foreach(var name in myLinqQuery)
Console.Write(name + ” “);
Try it
In the above example, string array names is a data source. The following is a LINQ query which is assigned to a variable myLinqQuery.
from name in names
where name.Contains(‘a’)
select name;
The above query uses query syntax of LINQ.
- Suppose there are 1000 rows and 50 columns, Suppose I want to select any random
row data? How it can be done?
Assign dtVariable = new DataTable
Initializing your DataTable variable
[Build your data table process]
Assign intRandom = new Random().Next(0, dtVariable.Rows.Count – 1)
This will give you a randomly generated number between 0 – N, where N = number of rows in your datatable (i.e., a data table of 10 rows will result in a count of 10)
We subtract 1 because dtVariable.Rows.Count starts at 1, whereas dtVariable.Rows(index) starts at 0 (i.e., a data table of 10 rows will result in an index max of 9).
Assign rowRandom = dtVariable.Rows(intRandom) This will output a DataRow at random of DataRow type.
- What are dynamic selectors? Types of Dynamic Selectors used in UiPath?
⦁ The selector is a string of characters (VB expression) used to identify objects on the screen. The selector is one of the properties of UI activities and has an XML format. All the activities in UiPath Studio related to graphical elements have the selector property.
⦁ The solution to this problem is to:
⦁ Build better selectors
⦁ Use WildCard
⦁ To see the better and dynamic attributes compare the selectors and make dynamic them using wildcard operators and identify reliable selectors using UIExplorer.
⦁ Selectors attributes part contains all the attributes of an object. Not all can be added or removed from your selector string, because not all of them are useful for identifying a certain object.
⦁ The most important thing when choosing selectors is to pick those which always have a constant value. If the value of an attribute changes, then the selector will not be able to correctly identify the
element.
Attributes may change their values from time to time when the application’s UI changes. When this happens, part of the dynamic attributes often remain unchanged and we somehow have to specify the variable parts. This can be done using wildcards:
1.* star means zero or more characters can be there. Example: title=’* – Notepad’.
2.? question mark means exactly one character. Example: title=‘Expl?rer’.
A direct consequence when using wildcards is the increased probability of there being more and more nodes matching the Selector.
- If you do not have excel installed on your system. How would you use excel activity in
UiPath Studio?
We can use Excel activity Workbook Read Range without installing Excel on System. As we don’t need excel installed for workbook read range activity.
UiPath Studio offers you the possibility to work with Excel using specialized activities. These activities are stored in the UiPath Excel activities package. The Excel package can be downloaded from “Manage Packages” but it’s by default installed when you install UiPath Studio.
Through this app integration approach you are able to read/write Excel documents.
Good points for not using the Excel application:
⦁ You don’t need to install/buy Microsoft Excel
⦁ Excel application will not pop up on your desktop
⦁ Suitable for robots that run on a machine that doesn’t have a user interface.
- What is port number of POP3 Gmail/ IMAP Gmail?
⦁ Port number of POP3 Gmail is-: 993
⦁ By default, the POP3protocol works on two ports:
⦁ Port 110– this is the default POP3 unencrypted portPort 995 – this is the port you need to use if you want to connect using POP3 securely
⦁ By default, the IMAPprotocol works on two ports:
⦁ Port 143– this is the default IMAP unencrypted portPort 993 – this is the port you need to use if you want to connect using IMAP securely.
- What is Port number of Smtp Gmail?
⦁ SMTP Port– 587 (default Google SMTP port).
⦁ Outgoing Mail (SMTP) Server-: ⦁ gmail.com
⦁ Requires SSL: Yes
⦁ Requires TLS: Yes (if available)
⦁ Requires Authentication: Yes
⦁ Port for SSL: 465
⦁ Port for TLS/STARTTLS: 587
- If suppose there is Image in PDF which is of 120 dp, how would extract data from that
Image? Which automation would be used?
To extract data from Image of Size 120 dp from PDF we need to use Read PDF with OCR activity, and automation we need to use is PDF Automation.
We can also use Microsoft OCR activity to extract extract exact data from Image of the PDF file.
- If Suppose there are 2 excels, how would merge 2 excel data into one?
- Firstly we need to use Read Range to read the 2 excel files,
- Then we need to use merge data table activity to merge the data table.
- Then we need to use the resultant data table to make the merged excel file using WriteRange activity.
Fig no-: Merge Two DataTable using UiPath
- If you have 1000 of data in queue and there are 5 robots you want to distribute data
among them, how you can do it without using queue activity
To distribute 1000 records of data in queue on 5 robots among them without using queue activity, we need to set up an Excel or CSV file that is in a shared location accessible by all your bots. Then have a column for Status, and as a bot processes each row, they update that column to “In Progress” and save the file. Bots should only process rows if column <> “In Progress”. We need to add other columns for tracking and logging, such as Transaction IDs, Bot Name, Fail Reason, etc.
- I have process of two different version how will you identify them at the time of deploying?
⦁ To identify the process of two different versions at time of deploying we can identify by publishing Process from Studio and we can choose the project version number.
⦁ Also, within orchestrator, the package number will match the version number of published Process from Studio.
⦁ Based on its version number we can identify it. At the time of publishing project from Uipath Studio and it show new version number.
- Can you update credentials stored in Assets in Orchestrator from UiPath Studio? If yes then how you can update credentials?
⦁ We can update Credentials stored in Assets in Orchestrator but not at runtime. We can update Credentials manually before scheduling bot.
⦁ We can allow user to update only specific assets. You can create a custom user role and give him
permissions only to asset editing, though. This is done through the /roles route on Orchestrator. UiPath.Core.Activities.SetCredential
⦁ Enables you to update the value of an indicated credential asset, that is already available in Orchestrator, be it a global or a Per Robot asset. Please note that to execute this
activity, the Robotrole needs to have Edit permissions on assets. The activity runs under the Robot which executes it.
- How you can create bubble sort in uipath?
We can use Sort method available in Arrays methods. This is workflow for sorting data using array-:
Fig no-: 157 a) Sorting Using Invoke Workflow Activity
Fig no-: 157 (b) After Sorting Login Workflow.
- Explain Uipath lifecycle?
A typical life cycle of UiPath RPA has 4 phases. Analysis, Bot Development, Testing, and Support & Maintenance.
⦁ Analysis– Business teams & RPA Architects work together to analyze a business process for RPA development.
⦁ Bot Development– Developer teams start working on developing the automated workflows for the requirements in a distinct development environment.
⦁ Testing– Run testing cycles such as SDLC to analyze the quality and correct defects.
⦁ Support & Maintenance-After the development & testing phases, a bot enters the maintenance phases in which it provides continuous support and helps in the immediate defect resolution.
- What is macros in UiPath?
Macro is a piece of programming code that runs in Excel environment and helps automate routine tasks. In a layman’s language, a macro is a recording of your routine steps in Excel that you can replay using a single button.
Execute Macro UiPath.Excel.Activities.ExecuteMacro
⦁ Execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook.
Changes are immediately saved. Can only be used in the Excel Application Scope
Properties
Input
MacroName – The name of the macro to be executed. Only String variables and strings are supported.
Note:
⦁ Macro Parameters– Enables you to pass parameters when executing the macro. This field supports only IEnumerable
- What is difference between workbook read range and excel read range?
Excel read range must be used in Excel Application Scope only whereas Workbook Read range do not need Excel sheet to be opened.
To use excel read range activity we must have MS Excel installed on the machine whereas we don’t need excel installed for workbook read range.
⦁ Do we need excel installed on system when we use workbook read range activity?
No.
⦁ What are pdf activities used to get text from an image?
⦁ Read PDF Text
⦁ Read PDF with OCR
⦁ What is switch flow?
A Flowchart specific activity that splits the control flow into three or more branches, out of which a single one is executed based on a specified condition.
- What is Queue? Use case of Queue?
Queue is a list of items that you want to be processed by Robots. When you create a queue in Orchestrator, it is empty. To populate the queue with items, change their status and process them, you have to use activities from Studio.
A queue is a 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. This information can be processed in other systems – SAP or Salesforce, for instance.
The Queues page enables you to create queues, view information about queue items (such as average execution time and the total number of successful transactions), display charts with the transaction status progress over time.
Queues enable you to create large automation projects underlined by complex logic. For example, you can create a process that collects all invoice information and creates a queue item for each piece of data to store it. Subsequently, you can create another process that gathers the information from Orchestrator, and uses it to perform additional tasks, such as paying the invoices in a different application, postponing their payment according to their due date or value, sending emails to the accounting team every time a bill is paid, etc.
- What are activities used in Queues?
The following activities from Studio are used with queues:
Add Queue Item– populates the queue with items and defines a time frame when these items must be processed. By default, when an item is added to the queue its status is New.
Get Transaction Item – gets an item from the queue so that you can process it (start the transaction) and sets its status to In Progress.
Set Transaction Status– changes the status of the transaction item to Failed (with an Application or Business Exception) or Successful. Application Exceptions should be used when the app you are automating fails, while Business Exceptions should be used when a certain queue item value does not meet a business requirement.
Note:
Only items that fail with an Application Exception are retried (if you also configure the Auto-Retry options in the queue, in Orchestrator).
⦁ Add Transaction Item– adds an item in the queue, starts the transaction and sets the status to In Progress.
⦁ Postpone Transaction Item– adds time parameters between which a transaction must be
processed (not before Defer Date and no later than Due Date).
All these activities are part of the Core activities package, and can be found in the Activities panel, under Orchestrator > Queues.
By default, the queue items that have been processed successfully are archived on a daily basis, while the others remain in the queue so that you can decide what to do with them
- What is Queue and Transaction?
Queue are type of Data and Transactions are Data for the Processing
For e.g., Queue – is Invoice Number – String type and Transactions are “INV132” each time Transactions will be updated once it completed process
- Difference between RPA and BPM
Function RPA
Software bots are configured to complete
monotonous tasks that humans would
Technology normally do
BP
Enc
tech
eng
bus
Automation focus Minimizes manual/ repetitive/rule-based tasks
that do not require complex decision making
Deployment effort Non-disruptive works across an organization’s
existing processes and applications
Business impact Returns can be acquired quickly and cost-
effectively.
Cost Less expensive when compared to BPM.
- If there is a System exception in GetTransition Data State in REFramework? Which
state in REFramework stage would be executed next and Why?
If There is a System Exception in GetTransition Data State in ReFramework, End Process State is executed next because as there will be no data to processed, So End Process state is executed.
- What is Credentials Manager? How it is used in Project?
In Windows, you can view and manage your network-based logon credentials (i.e., usernames and passwords) using Credential Manager.
With UiPath, you can automate the process of creating, querying and deleting the credentials through some dedicated activities.
To get credentials from the windows credential manager, you have to use the Get Secure Credential activity.
- Which desktop application have you automated in UiPath?
⦁ Automatic Data Entry into ExpenseIt Application from CSV file.
⦁ Moving Files and Folder Automation
⦁ PDF Data Extraction
⦁ Automation of Order Management System application.
⦁ Automation of CRM AnyTeller Application
⦁ Automation of Inflow Inventory System Automation.
- If suppose there are 2 excel and Each Excel contains 1000 records each. If Suppose 100 records is added into Another Second Excel? How would you Compare and Fetch 100
Records from Excel?
Using Macro or Compare each row of one excel with each row of other excel.
Creating a comparison macro for excel file will be easier
Simply picking one record of excel file A and compare it with all the records of excel file B.
Using Vlookup Option
You can do it AA excel as database inner join between two sheets.
- What is FTE
rem
time
wid
A lo tech com
Wid
pro
BPM
Full-time equivalent (FTE): the amount of work a full-time employee does in a department, or on a certain project.
It is nothing but the number of employees who are doing manual activities and if you implement RPA how many FTE you will save.
- What is difference between mainframe and non-frame Mainframe applications:
It’s a single screen and keyboard-based application.
There are separate set in-built commands supported by Blue Prism especially for mainframe applications
Non-mainframe applications:
It includes multiple screens
Control moves from one screen to another screen.
- I am your client, you give me two workflows one with activities and one with using recording. Which one you suggest me to use and why?
I will suggest workflow with activities
Because in recording we can’t get exact selectors, if we get exact selectors then we have to do all selectors as a dynamic one… So it would be better to go with workflow with activities.
- Suppose there is url which is dynamic? How would automate Url in UiPath Studio?
What is solution for dynamic url?
Use UiExplorer to get the exact selector and use dynamic selector using *, in url element for changing value.
And also you can use screen scraping to get the value.
For Example-:
In aaname you can assign as *
aaname=’*’ and title also *
Use the below selector
- How will you handle Credentials?
⦁ By using Credential manager – a window based application to save user credentials in secured
⦁ By storing in – Orchestrator as Credential – variable type
⦁ Just prompting as input box using – Get Secure text activity
- Explain main components of Orchestrator?
⦁ Processes: A process represents the association between a package and an environment. Each time a package is linked to an environment, it is automatically distributed to all the Robot machines that belong to that environment.
⦁ Assets: Assets usually represent shared variables or credentials that can be used in different automation projects. They give you the opportunity to store specific information so that the Robots can easily have access to it.
⦁ Queues: A queue is a container that enables you to hold an unlimited number of items. New queues created in Orchestrator are empty by default and can store multiple types of data.
⦁ Schedules: Schedules enable you to execute jobs in a pre-planned manner, at regular intervals on Robots. Input values for processes which support input and output parameters can be managed at this level as well
⦁ Robots: A Robot is an execution host that runs processes built in UiPath Studio. The Robotspage enables you to add robots, edit them, view their status and other settings.
⦁ Jobs: A job is the execution of a process on one or multiple Robots. After creating a process, the next step is to execute it by creating a job. When creating a new job, you can assign it to specific Robots.
⦁ Transactions: The Transactionspage displays the transactions from a given queue. It also shows their statuses, the dates when they should be processed, the Robot that processed them, and the type of exception thrown or assigned reference, if any.
- How many .xaml have you created for your project? How would publish multiple
Process to Orchestrator?
The Answer to Question depends on candidate Project and number of processes that user creates for the Project.
Orchestrator will trigger based on the reference xaml given in project.jason file.
Main
The entry point of the automation project. It consists of an .xaml file. The default name is “Main.xaml”. It is displayed both as the title of the Designer panel and in the Properties panel in Studio. If you want to execute a different project first, change the value of this parameter to the name of the .xaml file to be processed.
Note : If your automation project contains multiple files, each of them should be linked to
the Main.xaml file through the Invoke Workflow File activity . This is especially useful when the project is published to Orchestrator and sent to a Robot, as the Robot executes only the file provided in this parameter.
if you want to change entry point of xaml file you can change in this project.jason file. ‘Project.json’ is an automatically generated file which is included in the folder of each automation project made in Studio. The file holds information about the project dependencies.
- Suppose there are 5 different Processes, how would you schedule all these processes
in Orchestrator?
We can schedule all 5 processes for one machine, One by one.. It will start process one by one.
If machine are different then 5 Processes can be scheduled simultaneously.
Schedules enable you to execute jobs in a pre planned manner, at regular intervals on Robots. Input values for processes which support input and output parameters can be managed at this level as well. You can assign Robots to perform different schedules according to the following options:
⦁ All Robots– Schedules are executed by all the Robots in a specific environment.
⦁ Specific Robots– Schedules are executed by the Robots selected by the user.
⦁ Allocate dynamically– Define how many times a process is to be executed according to the given schedule. This option enables you to utilize your resources to their greatest extent. As soon as a
Robot becomes Available, it executes the indicated process according to the provided schedule. The Schedules page enables you to create new schedules. It also displays all previously created schedules, which can be further edited, enabled, or disabled.
You can view the jobs started by a specific schedule on the Jobs window, by selecting More Actions > View jobs. A scheduled job can also be stopped after a custom amount of time with the Stop or Kill options on the Actions tab.
- What are Credentials? How credentials are used in your project?
Credentials are one of Asset types used in Orchestrator. They are used to store credentials in Orchestrator. Credentials contains usernames and passwords that the Robot requires to execute particular processes, such as login details for SAP or SalesForce and gmail credentials.
The Get Asset and Get Credential activities used in Studio request information from Orchestrator about a specific asset, according to a provided AssetName. If the AssetName provided in Studio coincides with the name of an asset stored in the Orchestrator database, and the Robot has the required permissions, the asset information is retrieved and used by the Robot when executing the automation project.
- What is LINQ? Use case of Linq?
LINQ (Language Integrated Query) is uniform query syntax in C# and VB.NET to retrieve data from different sources and formats. We can retrieve data from list, arrays, datatables. It is integrated in C# or VB, thereby eliminating the mismatch between programming languages and databases, as well as providing a single querying interface for different types of data sources.
⦁ For example, SQL is a Structured Query Language used to save and retrieve data from a database. In the same way, LINQ is a structured query syntax built in C# and VB.NET to retrieve data from different types of data sources such as collections, ADO.Net DataSet, XML Docs, web service and
MS SQL Server and other databases.
LINQ queries return results as objects. It enables you to uses object-oriented approach on the result set and not to worry about transforming different formats of results into objects.
⦁ Use case of LINQ in UiPath LINQ Usage
LINQ queries return results as objects. It enables you to uses object-oriented approach on the result set and not to worry about transforming different formats of results into objects.
The following example demonstrates a simple LINQ query that gets all strings from an array which contains ‘a’.
Example: LINQ Query to Array
// Data source
string[] names = {“Bill”, “Steve”, “James”, “Mohan” };
// LINQ Query
var myLinqQuery = from name in names
where name.Contains(‘a’)
select name;
// Query execution
foreach(var name in myLinqQuery)
Console.Write(name + ” “);
Try it
In the above example, string array names is a data source. The following is a LINQ query which is assigned to a variable myLinqQuery.
from name in names
where name.Contains(‘a’)
select name;
The above query uses query syntax of LINQ.
- Suppose there are 1000 rows and 50 columns, Suppose I want to select any random
row data? How it can be done?
Assign dtVariable = new DataTable
Initializing your DataTable variable
[Build your data table process]
Assign intRandom = new Random().Next(0, dtVariable.Rows.Count – 1)
This will give you a randomly generated number between 0 – N, where N = number of rows in your datatable (i.e., a data table of 10 rows will result in a count of 10)
We subtract 1 because dtVariable.Rows.Count starts at 1, whereas dtVariable.Rows(index) starts at 0 (i.e., a data table of 10 rows will result in an index max of 9).
Assign rowRandom = dtVariable.Rows(intRandom) This will output a DataRow at random of DataRow type.
- What are dynamic selectors? Types of Dynamic Selectors used in UiPath?
⦁ The selector is a string of characters (VB expression) used to identify objects on the screen. The selector is one of the properties of UI activities and has an XML format. All the activities in UiPath Studio related to graphical elements have the selector property.
⦁ The solution to this problem is to:
⦁ Build better selectors
⦁ Use WildCard
⦁ To see the better and dynamic attributes compare the selectors and make dynamic them using wildcard operators and identify reliable selectors using UIExplorer.
⦁ Selectors attributes part contains all the attributes of an object. Not all can be added or removed from your selector string, because not all of them are useful for identifying a certain object.
⦁ The most important thing when choosing selectors is to pick those which always have a constant value. If the value of an attribute changes, then the selector will not be able to correctly identify the
element.
Attributes may change their values from time to time when the application’s UI changes. When this happens, part of the dynamic attributes often remain unchanged and we somehow have to specify the variable parts. This can be done using wildcards:
1.* star means zero or more characters can be there. Example: title=’* – Notepad’.
2.? question mark means exactly one character. Example: title=‘Expl?rer’.
A direct consequence when using wildcards is the increased probability of there being more and more nodes matching the Selector.
- If you do not have excel installed on your system. How would you use excel activity in
UiPath Studio?
We can use Excel activity Workbook Read Range without installing Excel on System. As we don’t need excel installed for workbook read range activity.
UiPath Studio offers you the possibility to work with Excel using specialized activities. These activities are stored in the UiPath Excel activities package. The Excel package can be downloaded from “Manage Packages” but it’s by default installed when you install UiPath Studio.
Through this app integration approach you are able to read/write Excel documents.
Good points for not using the Excel application:
⦁ You don’t need to install/buy Microsoft Excel
⦁ Excel application will not pop up on your desktop
⦁ Suitable for robots that run on a machine that doesn’t have a user interface.
- What is port number of POP3 Gmail/ IMAP Gmail?
⦁ Port number of POP3 Gmail is-: 993
⦁ By default, the POP3protocol works on two ports:
⦁ Port 110– this is the default POP3 unencrypted portPort 995 – this is the port you need to use if you want to connect using POP3 securely
⦁ By default, the IMAPprotocol works on two ports:
⦁ Port 143– this is the default IMAP unencrypted portPort 993 – this is the port you need to use if you want to connect using IMAP securely.
- What is Port number of Smtp Gmail?
⦁ SMTP Port– 587 (default Google SMTP port).
⦁ Outgoing Mail (SMTP) Server-: ⦁ gmail.com
⦁ Requires SSL: Yes
⦁ Requires TLS: Yes (if available)
⦁ Requires Authentication: Yes
⦁ Port for SSL: 465
⦁ Port for TLS/STARTTLS: 587
- If suppose there is Image in PDF which is of 120 dp, how would extract data from that
Image? Which automation would be used?
To extract data from Image of Size 120 dp from PDF we need to use Read PDF with OCR activity, and automation we need to use is PDF Automation.
We can also use Microsoft OCR activity to extract extract exact data from Image of the PDF file.
- If Suppose there are 2 excels, how would merge 2 excel data into one?
- Firstly we need to use Read Range to read the 2 excel files,
- Then we need to use merge data table activity to merge the data table.
- Then we need to use the resultant data table to make the merged excel file using WriteRange activity.
Fig no-: Merge Two DataTable using UiPath
- If you have 1000 of data in queue and there are 5 robots you want to distribute data
among them, how you can do it without using queue activity
To distribute 1000 records of data in queue on 5 robots among them without using queue activity, we need to set up an Excel or CSV file that is in a shared location accessible by all your bots. Then have a column for Status, and as a bot processes each row, they update that column to “In Progress” and save the file. Bots should only process rows if column <> “In Progress”. We need to add other columns for tracking and logging, such as Transaction IDs, Bot Name, Fail Reason, etc.
- I have process of two different version how will you identify them at the time of deploying?
⦁ To identify the process of two different versions at time of deploying we can identify by publishing Process from Studio and we can choose the project version number.
⦁ Also, within orchestrator, the package number will match the version number of published Process from Studio.
⦁ Based on its version number we can identify it. At the time of publishing project from Uipath Studio and it show new version number.
- Can you update credentials stored in Assets in Orchestrator from UiPath Studio? If yes then how you can update credentials?
⦁ We can update Credentials stored in Assets in Orchestrator but not at runtime. We can update Credentials manually before scheduling bot.
⦁ We can allow user to update only specific assets. You can create a custom user role and give him
permissions only to asset editing, though. This is done through the /roles route on Orchestrator. UiPath.Core.Activities.SetCredential
⦁ Enables you to update the value of an indicated credential asset, that is already available in Orchestrator, be it a global or a Per Robot asset. Please note that to execute this
activity, the Robotrole needs to have Edit permissions on assets. The activity runs under the Robot which executes it.
- How you can create bubble sort in uipath?
We can use Sort method available in Arrays methods. This is workflow for sorting data using array-:
Fig no-: 157 a) Sorting Using Invoke Workflow Activity
Fig no-: 157 (b) After Sorting Login Workflow.
- Explain Uipath lifecycle?
A typical life cycle of UiPath RPA has 4 phases. Analysis, Bot Development, Testing, and Support & Maintenance.
⦁ Analysis– Business teams & RPA Architects work together to analyze a business process for RPA development.
⦁ Bot Development– Developer teams start working on developing the automated workflows for the requirements in a distinct development environment.
⦁ Testing– Run testing cycles such as SDLC to analyze the quality and correct defects.
⦁ Support & Maintenance-After the development & testing phases, a bot enters the maintenance phases in which it provides continuous support and helps in the immediate defect resolution.
- What is macros in UiPath?
Macro is a piece of programming code that runs in Excel environment and helps automate routine tasks. In a layman’s language, a macro is a recording of your routine steps in Excel that you can replay using a single button.
Execute Macro UiPath.Excel.Activities.ExecuteMacro
⦁ Execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook.
Changes are immediately saved. Can only be used in the Excel Application Scope
Properties
Input
MacroName – The name of the macro to be executed. Only String variables and strings are supported.
Note:
⦁ Macro Parameters– Enables you to pass parameters when executing the macro. This field supports only IEnumerable
- What is difference between workbook read range and excel read range?
Excel read range must be used in Excel Application Scope only whereas Workbook Read range do not need Excel sheet to be opened.
To use excel read range activity we must have MS Excel installed on the machine whereas we don’t need excel installed for workbook read range.
⦁ Do we need excel installed on system when we use workbook read range activity?
No.
⦁ What are pdf activities used to get text from an image?
⦁ Read PDF Text
⦁ Read PDF with OCR
⦁ What is switch flow?
A Flowchart specific activity that splits the control flow into three or more branches, out of which a single one is executed based on a specified condition.
- What is Queue? Use case of Queue?
Queue is a list of items that you want to be processed by Robots. When you create a queue in Orchestrator, it is empty. To populate the queue with items, change their status and process them, you have to use activities from Studio.
A queue is a 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. This information can be processed in other systems – SAP or Salesforce, for instance.
The Queues page enables you to create queues, view information about queue items (such as average execution time and the total number of successful transactions), display charts with the transaction status progress over time.
Queues enable you to create large automation projects underlined by complex logic. For example, you can create a process that collects all invoice information and creates a queue item for each piece of data to store it. Subsequently, you can create another process that gathers the information from Orchestrator, and uses it to perform additional tasks, such as paying the invoices in a different application, postponing their payment according to their due date or value, sending emails to the accounting team every time a bill is paid, etc.
- What are activities used in Queues?
The following activities from Studio are used with queues:
Add Queue Item– populates the queue with items and defines a time frame when these items must be processed. By default, when an item is added to the queue its status is New.
Get Transaction Item – gets an item from the queue so that you can process it (start the transaction) and sets its status to In Progress.
Set Transaction Status– changes the status of the transaction item to Failed (with an Application or Business Exception) or Successful. Application Exceptions should be used when the app you are automating fails, while Business Exceptions should be used when a certain queue item value does not meet a business requirement.
Note:
Only items that fail with an Application Exception are retried (if you also configure the Auto-Retry options in the queue, in Orchestrator).
⦁ Add Transaction Item– adds an item in the queue, starts the transaction and sets the status to In Progress.
⦁ Postpone Transaction Item– adds time parameters between which a transaction must be
processed (not before Defer Date and no later than Due Date).
All these activities are part of the Core activities package, and can be found in the Activities panel, under Orchestrator > Queues.
By default, the queue items that have been processed successfully are archived on a daily basis, while the others remain in the queue so that you can decide what to do with them
- What is Queue and Transaction?
Queue are type of Data and Transactions are Data for the Processing
For e.g., Queue – is Invoice Number – String type and Transactions are “INV132” each time Transactions will be updated once it completed process
- Difference between RPA and BPM
Function RPA
Software bots are configured to complete
monotonous tasks that humans would
Technology normally do
BP
Enc
tech
eng
bus
Automation focus Minimizes manual/ repetitive/rule-based tasks
that do not require complex decision making
Deployment effort Non-disruptive works across an organization’s
existing processes and applications
Business impact Returns can be acquired quickly and cost-
effectively.
Cost Less expensive when compared to BPM.
- If there is a System exception in GetTransition Data State in REFramework? Which
state in REFramework stage would be executed next and Why?
If There is a System Exception in GetTransition Data State in ReFramework, End Process State is executed next because as there will be no data to processed, So End Process state is executed.
- What is Credentials Manager? How it is used in Project?
In Windows, you can view and manage your network-based logon credentials (i.e., usernames and passwords) using Credential Manager.
With UiPath, you can automate the process of creating, querying and deleting the credentials through some dedicated activities.
To get credentials from the windows credential manager, you have to use the Get Secure Credential activity.
- Which desktop application have you automated in UiPath?
⦁ Automatic Data Entry into ExpenseIt Application from CSV file.
⦁ Moving Files and Folder Automation
⦁ PDF Data Extraction
⦁ Automation of Order Management System application.
⦁ Automation of CRM AnyTeller Application
⦁ Automation of Inflow Inventory System Automation.
- If suppose there are 2 excel and Each Excel contains 1000 records each. If Suppose 100 records is added into Another Second Excel? How would you Compare and Fetch 100
Records from Excel?
Using Macro or Compare each row of one excel with each row of other excel.
Creating a comparison macro for excel file will be easier
Simply picking one record of excel file A and compare it with all the records of excel file B.
Using Vlookup Option
You can do it AA excel as database inner join between two sheets.
- What is FTE
rem
time
wid
A lo tech com
Wid
pro
BPM
Full-time equivalent (FTE): the amount of work a full-time employee does in a department, or on a certain project.
It is nothing but the number of employees who are doing manual activities and if you implement RPA how many FTE you will save.
- What is difference between mainframe and non-frame Mainframe applications:
It’s a single screen and keyboard-based application.
There are separate set in-built commands supported by Blue Prism especially for mainframe applications
Non-mainframe applications:
It includes multiple screens
Control moves from one screen to another screen.
- I am your client, you give me two workflows one with activities and one with using recording. Which one you suggest me to use and why?
I will suggest workflow with activities
Because in recording we can’t get exact selectors, if we get exact selectors then we have to do all selectors as a dynamic one… So it would be better to go with workflow with activities.
- Suppose there is url which is dynamic? How would automate Url in UiPath Studio?
What is solution for dynamic url?
Use UiExplorer to get the exact selector and use dynamic selector using *, in url element for changing value.
And also you can use screen scraping to get the value.
For Example-:
In aaname you can assign as *
aaname=’*’ and title also *
Use the below selector
- How will you handle Credentials?
⦁ By using Credential manager – a window based application to save user credentials in secured
⦁ By storing in – Orchestrator as Credential – variable type
⦁ Just prompting as input box using – Get Secure text activity
- Explain main components of Orchestrator?
⦁ Processes: A process represents the association between a package and an environment. Each time a package is linked to an environment, it is automatically distributed to all the Robot machines that belong to that environment.
⦁ Assets: Assets usually represent shared variables or credentials that can be used in different automation projects. They give you the opportunity to store specific information so that the Robots can easily have access to it.
⦁ Queues: A queue is a container that enables you to hold an unlimited number of items. New queues created in Orchestrator are empty by default and can store multiple types of data.
⦁ Schedules: Schedules enable you to execute jobs in a pre-planned manner, at regular intervals on Robots. Input values for processes which support input and output parameters can be managed at this level as well
⦁ Robots: A Robot is an execution host that runs processes built in UiPath Studio. The Robotspage enables you to add robots, edit them, view their status and other settings.
⦁ Jobs: A job is the execution of a process on one or multiple Robots. After creating a process, the next step is to execute it by creating a job. When creating a new job, you can assign it to specific Robots.
⦁ Transactions: The Transactionspage displays the transactions from a given queue. It also shows their statuses, the dates when they should be processed, the Robot that processed them, and the type of exception thrown or assigned reference, if any.
- How many .xaml have you created for your project? How would publish multiple
Process to Orchestrator?
The Answer to Question depends on candidate Project and number of processes that user creates for the Project.
Orchestrator will trigger based on the reference xaml given in project.jason file.
Main
The entry point of the automation project. It consists of an .xaml file. The default name is “Main.xaml”. It is displayed both as the title of the Designer panel and in the Properties panel in Studio. If you want to execute a different project first, change the value of this parameter to the name of the .xaml file to be processed.
Note : If your automation project contains multiple files, each of them should be linked to
the Main.xaml file through the Invoke Workflow File activity . This is especially useful when the project is published to Orchestrator and sent to a Robot, as the Robot executes only the file provided in this parameter.
if you want to change entry point of xaml file you can change in this project.jason file. ‘Project.json’ is an automatically generated file which is included in the folder of each automation project made in Studio. The file holds information about the project dependencies.
- Suppose there are 5 different Processes, how would you schedule all these processes
in Orchestrator?
We can schedule all 5 processes for one machine, One by one.. It will start process one by one.
If machine are different then 5 Processes can be scheduled simultaneously.
Schedules enable you to execute jobs in a pre planned manner, at regular intervals on Robots. Input values for processes which support input and output parameters can be managed at this level as well. You can assign Robots to perform different schedules according to the following options:
⦁ All Robots– Schedules are executed by all the Robots in a specific environment.
⦁ Specific Robots– Schedules are executed by the Robots selected by the user.
⦁ Allocate dynamically– Define how many times a process is to be executed according to the given schedule. This option enables you to utilize your resources to their greatest extent. As soon as a
Robot becomes Available, it executes the indicated process according to the provided schedule. The Schedules page enables you to create new schedules. It also displays all previously created schedules, which can be further edited, enabled, or disabled.
You can view the jobs started by a specific schedule on the Jobs window, by selecting More Actions > View jobs. A scheduled job can also be stopped after a custom amount of time with the Stop or Kill options on the Actions tab.
- What are Credentials? How credentials are used in your project?
Credentials are one of Asset types used in Orchestrator. They are used to store credentials in Orchestrator. Credentials contains usernames and passwords that the Robot requires to execute particular processes, such as login details for SAP or SalesForce and gmail credentials.
The Get Asset and Get Credential activities used in Studio request information from Orchestrator about a specific asset, according to a provided AssetName. If the AssetName provided in Studio coincides with the name of an asset stored in the Orchestrator database, and the Robot has the required permissions, the asset information is retrieved and used by the Robot when executing the automation project.
- What is LINQ? Use case of Linq?
LINQ (Language Integrated Query) is uniform query syntax in C# and VB.NET to retrieve data from different sources and formats. We can retrieve data from list, arrays, datatables. It is integrated in C# or VB, thereby eliminating the mismatch between programming languages and databases, as well as providing a single querying interface for different types of data sources.
⦁ For example, SQL is a Structured Query Language used to save and retrieve data from a database. In the same way, LINQ is a structured query syntax built in C# and VB.NET to retrieve data from different types of data sources such as collections, ADO.Net DataSet, XML Docs, web service and
MS SQL Server and other databases.
LINQ queries return results as objects. It enables you to uses object-oriented approach on the result set and not to worry about transforming different formats of results into objects.
⦁ Use case of LINQ in UiPath LINQ Usage
LINQ queries return results as objects. It enables you to uses object-oriented approach on the result set and not to worry about transforming different formats of results into objects.
The following example demonstrates a simple LINQ query that gets all strings from an array which contains ‘a’.
Example: LINQ Query to Array
// Data source
string[] names = {“Bill”, “Steve”, “James”, “Mohan” };
// LINQ Query
var myLinqQuery = from name in names
where name.Contains(‘a’)
select name;
// Query execution
foreach(var name in myLinqQuery)
Console.Write(name + ” “);
Try it
In the above example, string array names is a data source. The following is a LINQ query which is assigned to a variable myLinqQuery.
from name in names
where name.Contains(‘a’)
select name;
The above query uses query syntax of LINQ.
- Suppose there are 1000 rows and 50 columns, Suppose I want to select any random
row data? How it can be done?
Assign dtVariable = new DataTable
Initializing your DataTable variable
[Build your data table process]
Assign intRandom = new Random().Next(0, dtVariable.Rows.Count – 1)
This will give you a randomly generated number between 0 – N, where N = number of rows in your datatable (i.e., a data table of 10 rows will result in a count of 10)
We subtract 1 because dtVariable.Rows.Count starts at 1, whereas dtVariable.Rows(index) starts at 0 (i.e., a data table of 10 rows will result in an index max of 9).
Assign rowRandom = dtVariable.Rows(intRandom) This will output a DataRow at random of DataRow type.
- What are dynamic selectors? Types of Dynamic Selectors used in UiPath?
⦁ The selector is a string of characters (VB expression) used to identify objects on the screen. The selector is one of the properties of UI activities and has an XML format. All the activities in UiPath Studio related to graphical elements have the selector property.
⦁ The solution to this problem is to:
⦁ Build better selectors
⦁ Use WildCard
⦁ To see the better and dynamic attributes compare the selectors and make dynamic them using wildcard operators and identify reliable selectors using UIExplorer.
⦁ Selectors attributes part contains all the attributes of an object. Not all can be added or removed from your selector string, because not all of them are useful for identifying a certain object.
⦁ The most important thing when choosing selectors is to pick those which always have a constant value. If the value of an attribute changes, then the selector will not be able to correctly identify the
element.
Attributes may change their values from time to time when the application’s UI changes. When this happens, part of the dynamic attributes often remain unchanged and we somehow have to specify the variable parts. This can be done using wildcards:
1.* star means zero or more characters can be there. Example: title=’* – Notepad’.
2.? question mark means exactly one character. Example: title=‘Expl?rer’.
A direct consequence when using wildcards is the increased probability of there being more and more nodes matching the Selector.
- If you do not have excel installed on your system. How would you use excel activity in
UiPath Studio?
We can use Excel activity Workbook Read Range without installing Excel on System. As we don’t need excel installed for workbook read range activity.
UiPath Studio offers you the possibility to work with Excel using specialized activities. These activities are stored in the UiPath Excel activities package. The Excel package can be downloaded from “Manage Packages” but it’s by default installed when you install UiPath Studio.
Through this app integration approach you are able to read/write Excel documents.
Good points for not using the Excel application:
⦁ You don’t need to install/buy Microsoft Excel
⦁ Excel application will not pop up on your desktop
⦁ Suitable for robots that run on a machine that doesn’t have a user interface.
- What is port number of POP3 Gmail/ IMAP Gmail?
⦁ Port number of POP3 Gmail is-: 993
⦁ By default, the POP3protocol works on two ports:
⦁ Port 110– this is the default POP3 unencrypted portPort 995 – this is the port you need to use if you want to connect using POP3 securely
⦁ By default, the IMAPprotocol works on two ports:
⦁ Port 143– this is the default IMAP unencrypted portPort 993 – this is the port you need to use if you want to connect using IMAP securely.
- What is Port number of Smtp Gmail?
⦁ SMTP Port– 587 (default Google SMTP port).
⦁ Outgoing Mail (SMTP) Server-: ⦁ gmail.com
⦁ Requires SSL: Yes
⦁ Requires TLS: Yes (if available)
⦁ Requires Authentication: Yes
⦁ Port for SSL: 465
⦁ Port for TLS/STARTTLS: 587
- If suppose there is Image in PDF which is of 120 dp, how would extract data from that
Image? Which automation would be used?
To extract data from Image of Size 120 dp from PDF we need to use Read PDF with OCR activity, and automation we need to use is PDF Automation.
We can also use Microsoft OCR activity to extract extract exact data from Image of the PDF file.
- If Suppose there are 2 excels, how would merge 2 excel data into one?
- Firstly we need to use Read Range to read the 2 excel files,
- Then we need to use merge data table activity to merge the data table.
- Then we need to use the resultant data table to make the merged excel file using WriteRange activity.
Fig no-: Merge Two DataTable using UiPath
- If you have 1000 of data in queue and there are 5 robots you want to distribute data
among them, how you can do it without using queue activity
To distribute 1000 records of data in queue on 5 robots among them without using queue activity, we need to set up an Excel or CSV file that is in a shared location accessible by all your bots. Then have a column for Status, and as a bot processes each row, they update that column to “In Progress” and save the file. Bots should only process rows if column <> “In Progress”. We need to add other columns for tracking and logging, such as Transaction IDs, Bot Name, Fail Reason, etc.
- I have process of two different version how will you identify them at the time of deploying?
⦁ To identify the process of two different versions at time of deploying we can identify by publishing Process from Studio and we can choose the project version number.
⦁ Also, within orchestrator, the package number will match the version number of published Process from Studio.
⦁ Based on its version number we can identify it. At the time of publishing project from Uipath Studio and it show new version number.
- Can you update credentials stored in Assets in Orchestrator from UiPath Studio? If yes then how you can update credentials?
⦁ We can update Credentials stored in Assets in Orchestrator but not at runtime. We can update Credentials manually before scheduling bot.
⦁ We can allow user to update only specific assets. You can create a custom user role and give him
permissions only to asset editing, though. This is done through the /roles route on Orchestrator. UiPath.Core.Activities.SetCredential
⦁ Enables you to update the value of an indicated credential asset, that is already available in Orchestrator, be it a global or a Per Robot asset. Please note that to execute this
activity, the Robotrole needs to have Edit permissions on assets. The activity runs under the Robot which executes it.
- How you can create bubble sort in uipath?
We can use Sort method available in Arrays methods. This is workflow for sorting data using array-:
Fig no-: 157 a) Sorting Using Invoke Workflow Activity
Fig no-: 157 (b) After Sorting Login Workflow.
- Explain Uipath lifecycle?
A typical life cycle of UiPath RPA has 4 phases. Analysis, Bot Development, Testing, and Support & Maintenance.
⦁ Analysis– Business teams & RPA Architects work together to analyze a business process for RPA development.
⦁ Bot Development– Developer teams start working on developing the automated workflows for the requirements in a distinct development environment.
⦁ Testing– Run testing cycles such as SDLC to analyze the quality and correct defects.
⦁ Support & Maintenance-After the development & testing phases, a bot enters the maintenance phases in which it provides continuous support and helps in the immediate defect resolution.
- What is macros in UiPath?
Macro is a piece of programming code that runs in Excel environment and helps automate routine tasks. In a layman’s language, a macro is a recording of your routine steps in Excel that you can replay using a single button.
Execute Macro UiPath.Excel.Activities.ExecuteMacro
⦁ Execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook.
Changes are immediately saved. Can only be used in the Excel Application Scope
Properties
Input
MacroName – The name of the macro to be executed. Only String variables and strings are supported.
Note:
⦁ Macro Parameters– Enables you to pass parameters when executing the macro. This field supports only IEnumerable
Thanks for sharing your thoughts on 온라인카지노.
Regards