1. Do we need excel installed on the system when we use the workbook read range activity?
2. What are pdf activities used to get text from an image?
Read PDF Text
Read PDF with OCR
3. 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.
4. What is the Queue? Use the case of Queue?
- The 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.
5. What are the 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.
- 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
6. What are the Queue and Transactions?
The queue is a 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 the process
7. Difference between RPA and BPM?
||Software bots are configured to complete monotonous tasks that humans would normally do
||Encompasses a wide range of software technology components such as workflow engine, business analytics, etc., to improve business performance.
||Minimizes manual/ repetitive/rule-based tasks that do not require complex decision making
||remove bottlenecks and shorter process cycle times, and improves productivity business-wide
||Non-disruptive works across an organization’s existing processes and applications
||A longer-term effort that requires dedicated technical resources depending on process complexity and depth of integrations.
||Returns can be acquired quickly and cost-effectively.
||Wide gains can be achieved in overall productivity
||Less expensive when compared to BPM
||BPM is expensive for enterprise applications.
8.If there is a System exception in GetTransition Data State in REFramework? Which state in the 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 be processed, the So End Process state is executed.
9. What is the Credentials Manager? How it is used in Project?
In Windows, you can view and manage your network-based login 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.
10. 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.
11.If suppose there are 2 excel and Each Excel contains 1000 records each. If Suppose 100 records are added into Another Second Excel? How would you Compare and Fetch 100 Records from Excel?
- Using Macro or Compare each row of one excels with each row of other excel.
- Creating a comparison macro for an 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 in A excel as database inner join between two sheets.
12. What is FTE?
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.
13. What is the 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.
14. I am your client, you give me two workflows one with activities and one with using a recording. Which one do you suggest using and why?
I will suggest workflow with activities. Because in the 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.
15. Suppose there is url that is dynamic? How would automate Url in UiPath Studio? What is the 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
<html app=’chrome.exe’ title=’*’ /> <Webctrl aaname=’*’ tag =’SPAN’/>
16. 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
17. Explain the main components of the 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 that 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 Robots page 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 Transactions page 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.
18. How many .xaml have you created for your project? How would publish multiple Processes to Orchestrator?
The Answer to the Question depends on the candidate Project and the number of processes that the user creates for the Project. Orchestrator will trigger based on the reference xaml given in the project.json file.
- Main: The entry point of the automation project. It consists of a .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.
- If you want to change the entry point of the xaml file you can change it in this project.json file.
- ‘Project.json’ is an automatically generated file that is included in the folder of each automation project made in Studio. The file holds information about the project dependencies.
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.
19. 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 the process one by one. If the machine is 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 that 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.