Robotic Process Automation (RPA) with OpenRPA

Focused View

Marcelo Cruz

5:10:58

120 View

1. Introduction

1. Whats RPA.mp4

03:30

2.1 OpenRPA download.html

2. OpenRPA installation.mp4

03:59

3. Our first robot.mp4

08:52

4.1 First Robot.zip

4. Download robot.html

5. Course outline.mp4

03:47

6. Resources.mp4

02:48

2. The basics

1. Exploring OpenRPA.mp4

06:03

2. Toolbox and activities.mp4

04:39

3. Snippets.mp4

01:46

4. Variables.mp4

18:18

5. Arguments.mp4

12:14

6. Logs.mp4

04:21

7. Recorder.mp4

04:35

8. Quizz.html

3. Robot 2 - Web Form Filling

1. Overview.mp4

01:35

2.1 Users.xlsx

2. Read Excel file.mp4

04:43

3.1 Web Form.html

3. Open browser.mp4

04:59

4. For each row.mp4

06:37

5. Fill form fields.mp4

08:48

6. Submit form.mp4

03:43

7. Quizz.html

8.1 Robot 2 - Web Form Filling.zip

8. Download robot.html

4. Robot 3 - Email Automation

1. Overview.mp4

01:45

2. Get Outlook emails.mp4

03:29

3. Get email details.mp4

03:42

4. Move each email.mp4

11:24

5. Reply to each email.mp4

03:07

6. Send email.mp4

03:39

7. Quizz.html

8.1 Robot 3 - Email Automation.zip

8. Download robot.html

5. Robot 4 - Web Data Scraping

1. Overview.mp4

00:59

2.1 Books to Scrape website.html

2. Open website.mp4

03:11

3. Scrape each book.mp4

05:27

4. Scrape book details.mp4

13:21

5. Data scraping across multiple pages.mp4

11:10

6. Create data table.mp4

02:11

7. Add row to data table.mp4

02:29

8. Write data table on Excel file.mp4

02:25

9. Quizz.html

10.1 Robot 4 - Web Data Scraping.zip

10. Download robot.html

6. Robot 5 - Invoices Data Scraping

1. Overview.mp4

01:10

2.1 Invoices.zip

2. Get invoices.mp4

08:28

3. For each invoice.mp4

02:38

4. Read invoice text.mp4

03:05

5.1 Regex article.html

5. Scrape invoice fields using regex.mp4

17:48

6. Export data to Excel.mp4

11:53

7. Quizz.html

8.1 Robot 5 - Invoice Data Extraction.zip

8. Download robot.html

7. Robot 6 - RPA Challenge

1. Understanding the challenge.mp4

03:47

2.1 RPA Challenge.html

2. Download challenge file.mp4

08:02

3. Starting the challenge.mp4

02:06

4. Fill challenge fields.mp4

12:23

5.1 Robot 6 - RPA Challenge.zip

5. Download robot.html

8. Robot 7 - Loans Application Project

1.1 LoanRequests.xlsx

1.2 Project Document.html

1. Project explanation.mp4

05:21

2. Solution - Part 1.mp4

15:25

3. Solution - Part 2.mp4

19:26

4.1 Robot 7 - Loan Application.zip

4. Download robot.html

9. BONUS - OpenFlow Introduction

1.1 OpenFlow documentation.html

1. Overview.mp4

01:28

2. Exploring OpenFlow.mp4

06:20

3. Execute Workflow.mp4

02:31

4. Add and Retrieve Credentials.mp4

05:35

10. BONUS - Node-RED Introduction

1.1 Node-RED documentation.html

1. Overview.mp4

01:32

2. Exploring Node-RED.mp4

03:02

3. Schedule robot execution.mp4

05:22

11. BONUS SECTION

1. Bonus.html

Description

Learn how to create RPA automations with OpenRPA, a free open-source RPA tool for individual and business use

What You'll Learn?

Understand RPA
OpenRPA download and installation
Learn the core basics (variables, arguments, flow control and much more)
Use with confidence the most used activities
Develop 7 RPA robots across different scenarios, from web automation to documents processing
Project to test and apply knowledge acquired along the course

Who is this for?

RPA Developers curious about open-source RPA

RPA Learners and Enthusiasts

Anyone wanting to save time, reduce errors, and improve efficiency by automating common computer tasks

More details

Description
Welcome to Robotic Process Automation (RPA) with OpenRPA course, where you will learn what you need to get started in RPA (Robotic Process Automation) with OpenRPA.
We will get started by finding out what RPA is, and then we will download and install OpenRPA. Once we have it installed, we will create our first robot. After that, we will explore the tool to get an understanding of how to use OpenRPA. Once we have learned the basics, we will develop robots that involve different automation scenarios, from web automation to data scraping. In this course we will develop the following robots:
Robot 2 - Web Form Completion
The robot extracts information from an Excel file, and after reading it, it will opens browser on a form page. For each line extracted from the Excel file, the robot will insert the data of each line in the respective form fields and submit.

Robot 3 - Email Automation
The robot will get emails from an Outlook account, and for each email, depending on the content, it will move the email to a specific Outlook folder. After moving a certain email, it will respond to it informing that the email was processed. After all the emails received have been processed, the robot will send an email to a certain recipient to inform that the processing has been completed.

Robot 4 - Web Data Scraping
The robot will launch the browser at a online store that contains books listed across multiple pages. The robot will extract the title and price of each book up to a certain page. After extraction, the information extracted from each book will be written in an Excel file.

Robot 5 - Documents Processing
Imagine that an employee's job is to copy text from a PDF invoice into an excel spreadsheet and then repeat this task hundreds of times a day. Not only is this work extremely tedious and boring, mistakes are also likely to be made during the task. This robot fully automates this process by cycling through each PDF file in a given directory, extracting certain information from each invoice and writing the information into a spreadsheet.

Robot 6 - RPA Challenge
The robot will perform the RPA Challenge. It will extract information from a spreadsheet provided on the challenge page, and for each line on the spreadsheet, the robot will have to insert the line data in the challenge form fields, which change position after a record is submitted.

Robot 7 - Loans Application (Final Project)
This will be the final project we will do, where will be explained and proposed an exercise to solve. The project consists of creating a robot that will extract loan requests from a spreadsheet. After obtaining the requests from the spreadsheet, the robot will open the browser on a page that allows it to simulate the processing of loan requests. The robot will have a form to insert information about the loan request, which is present in each line of the worksheet. After submitting an application, there will be two possible outcomes, the loan application being approved or rejected. If approved, the robot will have to extract the loan's interest rate and loan ID, values â€‹â€‹that only appear when an application is approved. If the request is rejected, the robot will have no information to extract. After each request has been processed, the robot will write the status of the loan request, the interest rate and the loan ID on the spreadsheet.

The robots developed during the course will be made available for download.
The last two sections of the course will include an introduction to OpenFlow and Node-RED, tools that can work with OpenRPA.
At the end of the course, you will have the most important notions and knowledge of how to develop RPA automations with OpenRPA!
Who this course is for:
RPA Developers curious about open-source RPA
RPA Learners and Enthusiasts
Anyone wanting to save time, reduce errors, and improve efficiency by automating common computer tasks

User Reviews

Rating

average 0

Total votes0

Focused display

RPA Robotic Process Automation

Robotics

Marcelo Cruz

Instructor's Courses

Hi! My name is Marcelo and I am an experienced RPA developer for over 3 years, having already developed automation for several large companies and today works for a bank , developing and monitoring RPA automations.I am really enthusiastic about RPA (Robotic Process Automation) and I will do my best to add value to you. I have also my YouTube channel, where topics and tutorials related to RPA are covered. I will inspire and teach of thousands of people to leave as their repetitive tasks for software robots, to have more free time for something that is more important.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.