Book Image

Robotic Process Automation Projects

By : Nandan Mullakara, Arun Kumar Asokan
Book Image

Robotic Process Automation Projects

By: Nandan Mullakara, Arun Kumar Asokan

Overview of this book

Robotic Process automation helps businesses to automate monotonous tasks that can be performed by machines. This project-based guide will help you progress through easy to more advanced RPA projects. You’ll learn the principles of RPA and how to architect solutions to meet the demands of business automation, along with exploring the most popular RPA tools - UiPath and Automation Anywhere. In the first part, you’ll learn how to use UiPath by building a simple helpdesk ticket system. You’ll then automate CRM systems by integrating Excel data with UiPath. After this, the book will guide you through building an AI-based social media moderator using Google Cloud Vision API. In the second part, you’ll learn about Automation Anywhere's latest Cloud RPA platform (A2019) by creating projects such as an automated ERP administration system, an AI bot for order and invoice processing, and an automated emergency notification system for employees. Later, you’ll get hands-on with advanced RPA tasks such as invoking APIs, before covering complex concepts such as Artificial Intelligence (AI) and machine learning in automation to take your understanding of RPA to the next level. By the end of the book, you’ll have a solid foundation in RPA with experience in building real-world projects.
Table of Contents (14 chapters)

Extracting user details from PDF

We will now extract all the text in the PDF file:

  1. We'll start by adding a Step action within the Try block and call it Read PDF to logically separate these steps. Within this Step action, extract the text in PDF to a Table variable so that we can loop through the content. To do that, first extract the PDF text to a temporary text file. Add the PDF Extract text action and set the PDF path to the desktop PDF file that we created. Set the Text type to Structured text and set Export data to text file to Temp.txt, as shown here: 

  1. Over the next few steps, we will read the data from the temporary text file (Temp.txt) and assign it to a Table variable. This is so that we can loop through the text data and manipulate it:
    • Let's add the CSV/TXT Open action. Choose a Session name (such as S1), set the File path to Temp.txtand select Tab for Delimiter
    • Next, add the CSV/TXT Read action...