RPA Log Hub

Automation has become increasingly vital to businesses looking to optimize their processes and gain a competitive edge amidst today's steadily innovating technology climate. Leading RPA provider UiPath boasts powerful toolsets designed for seamless task automation tailored to organizations' unique needs. Yet by integrating the incredibly versatile and widely-used programming language Python alongside these tools, companies get access to enhanced levels of efficiency and innovation beyond what standard UIPath implementation achieves alone fully explains this blog post which scrutinizes how such integration works wonders when it comes down to automating tasks. Understanding UiPath and Python Integration:  UiPath is renowned for its visual workflow designer, which allows users to create automation workflows without the need for extensive coding knowledge. However, there are instances where Python's robust libraries and advanced capabilities are beneficial for complex automatio...

Hi, Looking for professional RPA experts to work with? You came to the right place. We can do any type of automations like Web Automation, Excel Automation, SAP Automation, Desktop Applications Automation, Citrix Automation. Along with that we will give you extended support to run your code on your machine so that you will not face any type of issues.  We can also help you to learn UiPath so that from the next time you are also capable enough to start building your own bots. Feel free to reach out, fill the contact form on this blog or send an email to  snbhardwaj1994@gmail.com. Thanks!

You can do Excel Automation in UiPath in four different ways: Using UiPath Activities. Using LinQ. Using Macros (VBA). Using Excel as a Database. Lets go with one by one : Using UiPath Activities Excel Application Scope: In this You can use Read Range Activity to read all the data into the DataTable. You can use the Read Cell Activity to read the data one by one into the Generic Format. You can use Loops on your DataTable. You can Filter DataTable Activity to filter out your data. Workbook: Even if excel is not installed in your system, then also you can use these activities to read or write excel. Using  LINQ You can use LinQ queries to Filter out the data directly on DataTable or List. In this case you cannot use Read Cell Activity. Read More About LinQ from here: Click here LinQ Syntax . LinQ Queries Used for Filter Out the Data . Using Macros (VBA) You can use macros also, not for Excel but you can do any type of work from Macros. VBA code is easy like a E...

Sometimes, we come across the situation where we have to send the email to some group and then they will cross check some data or fixing from their side and reply back on the same email with their approval, then only you have to proceed forward. In that case we can configure our code in such a way that it will check the outlook emails to wait for approval email to come. We are assuming that currently the wait time is 10 minutes and after that we will send the email again to the team/group and we will keep sending the email until they provide us approval. So, accordingly you can change your scenario or you can do little changes in this easy logic. The whole logic will look like this, its very simple and easy to understand. 1. First send the email to the concerned team and set the time after 10 minutes in one variable. Now we will check this variable with the current time to get to know that we have waited for 10 minutes or not. 2. Then we will assign on new List of Mail messages and wil...

To do excel formatting, there is no specific activities available in UiPath, so either you have to go for VBA or Vb.Net to get the required formatting. Both methods are good and fast. Lets see how we can write a simple code to do our formatting. First of all, if you are using this  Microsoft.Office.Interop.Excel in UiPath , then there are chances that it will show you error, so you have to install this. First to go to Manage Packages and install this: If still shows error then open your .xaml file in Notepad and paste this below line along with another assemblies present in file: Now you are ready to use below Code, Use Invoke Code activity and paste this entire code into that and run. FullFilePath,  SheetName----  Replace these with your File Path and Sheet Name, you can also make them as Argument and use that variable in place of this. '--------------Code------------------ Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Ex...

As you already have seen the situation where multiple users are logged in on single VDI. On this situation when we use Kill Activity directly to kill the process forcefully then it kills all processes without checking the user details. So we are writing small code so which you can use in your KillAllProcess workflow of Re-framework. It will kill processes for logged in users and plays a vital role when running Bots in High Density Environment on Servers or standalone systems. It works as per below: It will get the process session Id as Process_Username. It will get the current user session Id as Current_user. Then Check the If condition that Process Name is Equals to your Input process Name and Process_Username=Current_user Then it will pass process variable into the Kill Activity to kill that process. 1. Get Processes Activity , Output Variable: ActiveProcesses 2. Use For Each Loop and Pass the Above variable inside it and make the TypeArgument as System.Diagnostic.Process 3. Insi...

Robotic Process Automation is the technology that allows anyone today to configure a “robot” to emulate and integrate the actions of a human interacting within digital systems to execute a business process. As demand is increasing so, we have to update ourselves with latest trending questions in the market. So lets look at some basic Questions related to RPA UiPath. What is RPA? Automating the rule based tasks. What is RPA LIFE CYCLE? Analysis & L4 (Process Maps) Development Unit Testing User Acceptance Testing (UAT) Production Deployment Maintenance & Support How many types of variable present in UiPath? String, Int32, Double, Data Table, Array, List ,Generic Value, Boolean. For more variable you can click browse for types in variable panel. What are some common properties present in UiPath Activities? ContinueOnError DelayAfter DelayBefore TimeoutMS WaitForReady Difference between Full & partial Selector. Full selectors:  Contain all the elements needed to identi...

We will use this method in UiPath to access the Excel as a Database and for that we need OLEDB Engine. You can download it from here : So what is OLE DB ? OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB), an API designed by Microsoft, allows accessing data from a variety of sources in a uniform manner. Follow these steps to setup connection and used the excel as a database: First of all, use the Activity Connect to Configure Connection and create its variable "conn" FileName: Full Path of Excel File  Connection String: Provider=Microsoft.ACE.OLEDB.12.0; Data Source=FileName; Extended Properties='Excel 12.0 XML;HDR=YES;ReadOnly=False'  Provider Name: System.Data.OleDb HDR=Yes -- Indicates that the first row contains column names.  Then use the Activity Execute Query and pass the connection String variable in its existing Connection and write query like this. Then you can write the dat...

LinQ used on DataTable to Filter One Column and Copy the Data into DataTable : dataTable.Select.where(Function(x) (x.Item("Column1").ToString.ToLower.Contains("Value"))).copyToDatatable. LinQ used on DataTable to Filter More than one Column and Copy the Data into DataTable: dataTable.Select.where(Function(x)(x.Item("Column1").ToString.ToLower.Contains("Value1") Or x.Item("Column2").ToString.ToLower.Contains("Value2"))).copyToDatatable. LinQ used on DataTable to one Column and Copy the Data into List of DataRows: dataTable.Select.Where(Function(x) (x.Item("Column1").ToString.ToLower.Contains("Value"))).ToList() LinQ used on DataTable to one Column and Copy the Data into List/DataTable: dataTable.Select("[Column]='Value'") LinQ used on DataTable to one Column and check whether value present in that Column or not: dataTable.AsEnumerable().Any(Function(x) x("Column...

LINQ means Language Integrated Query. Import the System.Linq namespace and it provides many extension methods. LINQ enables you to query data from a SQL Server database, XML, in-memory arrays and collections, ADO.NET datasets, or any other remote or local data source that supports LINQ. We are going to understand the basic Syntax of LINQ query to Filter One Column of Excel. For Example:  We have an Excel Sheet, which we already read by using activity ' Read Range in UiPath ' then all the data come into DataTable  ( Display Info in Tabular form Or Combination of Rows and Columns) DataTable.Select.Where(Function(x) x.Item("ColumnName").ToString.Trim.ToLower.Equals("y")) Now, Let's understand this LinQ query step by step: DataTable: The Excel you read comes into DataTable variable. Select: It Defines the results to return from the Query. Where: Specifies the Filtering Condition for the Query. Function(x): An anonymous (unnamed) ...

A custom format string consists of one or more custom date and time format specifiers. Any string that is not a standard date and time format string is interpreted as a custom date and time format string. In this, we will cover some formats to COnvert the Date and Time from Different Formats to our format. This is a variable, I am using "vDatVariable= Generic". Convert.ToDateTime(vDatVariable.toString).toString("dd MMM yyyy") Now.toString("dd MM yyyy") First Format: The Date you are fetching, coming in this format Second Format: The format you want. DateTime.ParseExact(vDatVariable.ToString,"dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy") DateTime.ParseExact(vDatVariable.ToString,"dd-MMM-yyyy", System.Globalization.DateTimeFormatInfo.InvariantInfo,Globalization.DateTimeStyles.None).ToString("MM/dd/yyyy") For More Info Refer this Link: Click here...

As UiPath  already has so many things to teach on their website, also they have UiPath Academy to teach you everything related to UiPath  but for that you have to see each and every video on academy and then quickly pass the test to get certified.  I go through that course of UiPath academy that takes lot of my time but i learnt so may things and  i am very thankful for that, in the end they showed me some recap Pdf's of what i learnt in my whole course, and i.e. Quick Recap Chapters where i just have to read points and within minutes i can quickly revise all the things. I dont have to wait to go on internet to find some basic solutions, i juts have to read them to know the solution of my problem. And for beginners these are must to read before having hand's on experience on UiPath tool. I am just sharing the whole recap slides and you can easily download from here. Quick Fast Guide For UiPath Thankyou so much.

UiPath which is a best example of industry automation systems, is a leading Robotic Process Automation vendor providing a complete software platform to help organizations efficiently to automate business processes. The most powerful RPA platform for fast and highly scalable automation. Basically it provides us platform to create virtual robots to automate your boring work like data entry, not just data entry but it already reach to many extent. UiPath is easy to use and learn-able for beginner like us , it has easily understandable activities or recorders to record our task and use that again and again. It can finish your day work with in few minutes ,it velocity, flexibility moreover its scalability that can easily impress us in seconds. You can deploy these uipath with 3rd party apps too. Their highly visual process designer equips employees for fast and easy configuration of robotic workflows. Simply drag-and-drop activities into the workflow or use the recorder to get it go...

In Today's time,  the development of technologies made it possible to introduce industry automation systems into almost all  fields. Industry automation enhances labor efficiency and allows cutting net cost and improving product quality. Moreover, it extends the equipment service life, saves consumables and raw materials, and improves production safety as a whole. The main objectives of the industry automation system introduction: lesser influence of human factor to technological process; improved production reliability; increased production speed and quality; prevention of emergency situations; improved production control. There are so many tools present in the market right now , some are : Blue Prism UI Path Automation Tool Automation Anywhere Tool We will talk about this later on, but for now the future will be going to change, will definitely decrease the human labor. Get ready for the change.