-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathindex.html
More file actions
306 lines (278 loc) · 17.1 KB
/
index.html
File metadata and controls
306 lines (278 loc) · 17.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>RPA Camp</title>
<link rel="stylesheet" href="https://stackedit.io/style.css" />
</head>
<body class="stackedit">
<div class="stackedit__left">
<div class="stackedit__toc">
<ul>
<li><a href="#rpa-camp">RPA Camp</a>
<ul>
<li><a href="#what-is-rpa">What is RPA?</a></li>
<li><a href="#why-rpa">Why RPA?</a></li>
<li><a href="#why-uipath">Why UiPath?</a></li>
<li><a href="#components-of-uipath">Components of UiPath</a></li>
<li><a href="#things-to-know-prior-to-automation">Things to know!</a></li>
</br>
<li><a href="#RPA-Challenge"><strong>RPA Challenge</strong></a></li></br>
<li><a href="#Day-1-----Recording">Day1 - Web Recording</a></li>
<li><a href="#Day-2-----Scraping">Day2 - Web Scraping</a></li>
<li><a href="#Day-3-----Leapyear">Day3 - Leap Year</a></li>
<li><a href="#Day-4-----ConditionalStatement">Day4 - Conditional Statement</a></li>
<li><a href="#Day-5-----StudentDetails">Day5 - Student Details</a></li>
<li><a href="#Day-6&7-----EmployeeDetails">Day6 & 7 - Employee Details</a></li>
<li><a href="#Day-8-----DynamicFilesHandling">Day8 - File Handling</a></li>
<li><a href="#Day-9-----MobileDetails">Day9 - Mobile Details</a></li>
<li><a href="#Day-10-----DataConversion">Day10 - Data Conversion</a></li>
<li><a href="#Day-11-----PanAadhar">Day11 - Pan & Aadhar Validation</a></li>
<li><a href="#Day-12&13-----ScripDetails">Day12 & 13 - Scrip Details</a></li>
<li><a href="#Day-14&15-----CSV">Day14 & 15 - Working with CSV Files</a></li>
<li><a href="#Day-16&17-----Compare">Day16 & 17 - Compare a Product on Different Websites</a></li>
<li><a href="#Day-18&19-----WindowsForms">Day18 & 19 - Working with Windows Forms</a></li>
<li><a href="#Day-20&21-----InvoiceDetails">Day20 & 21 - Invoice Details</a></li>
<li><a href="#Day-22&23-----QRCode">Day22 & 23 - QR Code Generation</a></li>
<li><a href="#Day-24&25-----Word">Day24 & 25 - Appoinment Letter Generation</a></li>
<li><a href="#Day-26,27&28-----Random">Day26, 27 & 28 - Random Number - Guess Game</a></li>
<li><a href="#Day-29&30-----Python">Day29 & 30 - Working with Python Scripts</a></li>
<li><a href="#Day-31,32&33-----Macro">Day31, 32 & 33 - Excel Macro</a></li>
<li><a href="#Day-34&35-----SubMenu">Day34 & 35 - Working with Sub Menus</a></li>
<li><a href="#Day-36,37&38-----Challenge">Day36, 37 & 38 - Dynamic Fields</a></li>
<li><a href="#Day-39,40,41&42-----Whatsapp">Day39, 40, 41 & 42 - Sending messages through WhatsApp</a></li>
<li><a href="#Day-43,44,45&46-----WebApp">Day43, 44, 45 & 46 - Building Web Application using UiPath</a></li>
<li><a href="#Day-47,48,49&50-----MiniProject">Day47, 48, 49 & 50 - Attended & Unattended Bot</a></li>
</ul>
</li>
</ul>
</div>
</div>
<div class="stackedit__right">
<div class="stackedit__html">
<h1 id="rpa-camp">RPA Camp</h1>
<h2 id="what-is-rpa"><em>What is RPA?</em></h2>
<p>Robotic Process Automation or RPA handles repetitive business processes using software robots to perform tasks and trigger error-free responses 24/7. It’s a type of software that enables <em><strong>automation of even complex digital processes</strong></em> by performing them much in the way that human users would perform them.</p>
<h2 id="why-rpa"><em>Why RPA?</em></h2>
<p>A career in RPA is considered to be very effective and the emerging graduates can easily expect a major share of employment opportunities across the world. Also, pay packages with good skill-sets in this field are relatively higher when compared to other fields. RPA is implemented in various sectors like Education, Banking and Finance, Insurance, Health care and Manufacturing etc., across the world. Types of applications automated using RPA are as Windows, Web, SAP and Mainframe etc.</p>
<h2 id="why-uipath"><em>Why UiPath?</em></h2>
<p><strong><a href="https://www.uipath.com/">UiPath</a></strong> is a <em>Windows-based desktop</em> Robotic Process Automation software tool architects to automate business processes within Enterprises. This tool enables organizations to execute processes more efficiently by <em>automating monotonous and repetitive tasks</em>.</p>
<h2 id="components-of-uipath"><em>Components of UiPath</em></h2>
<ul>
<li><strong>UiPath Studio</strong></li>
</ul>
<p>An advance tool that enables you to design automation processes in a visual manner, through diagrams.</p>
<ul>
<li><strong>UiPath Robot</strong></li>
</ul>
<p>Executes the processes built in studio, as a human does. Robots can work unattended (run without human supervision) or as assistants (a human trigger the process).</p>
<ul>
<li><strong>UiPath Orchestrator</strong></li>
</ul>
<p>A web application that enables you to deploy, schedule, monitor and manage Robots and Processes, while business exception handling is available through centralized work queues.</p>
<h2 id="things-to-know-prior-to-automation"><em>Things to know prior to Automation</em></h2>
<ul>
<li><strong>Workflow Types and Activities</strong></li>
</ul>
<p>Multiple types of workflows are available in Studio (sequences, flowcharts and transactional business processes) that help you build your automation workflow according to your needs. <a href="https://docs.uipath.com/activities/docs/workflow-system">more…</a></p>
<ul>
<li><strong>Recorder Functionality</strong></li>
</ul>
<p>The easiest manner to create workflows is by using the record feature. Four types of recordings are available: <em>Basic, Desktop, Web and Citrix.</em> The first two can help you automate desktop applications, while the others enable you to properly handle web apps and virtual environments. <a href="https://www.uipath.com/developers/video-tutorials/recording">more…</a></p>
<ul>
<li><strong>Selectors</strong></li>
</ul>
<p>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. <a href="https://docs.uipath.com/studio/docs/about-selectors">more…</a></p>
<h1 id="RPA-Challenge"><strong>RPA Challenge</strong></h1>
<h2 id="Day-1-----Recording"><strong>Day 1</strong> - <em>Web Recording</em></h2>
<ul>
<li>Login to Amazon.in with Credentials</li>
<li>Search about “iPhone”, scrap the required data</li>
<li>Save the data in notepad with the file name as “iPhone.txt” in Desktop</li>
<li>Logout from the website. </li>
</ul>
<h2 id="Day-2-----Scraping"><strong>Day 2</strong> - <em>Web Scraping</em></h2>
<ul>
<li>Open the browser, Go to "https://cutt.ly/CoronaCountIndia" </li>
<li>Scrap the coronavirus details using "Data Scraping" (Refer below mentioned screenshot)</li>
<li>Save the data in excel format in Desktop</li>
<li>Close the browser. </li>
<p><img src="https://raw.githubusercontent.com/Pavithratrdev/RPATraining/master/CoronaCount.JPG" alt="Corona Count"></p>
</ul>
<h2 id="Day-3-----Leapyear"><strong>Day 3</strong> - <em>Leap Year</em></h2>
<ul>
<li>Get "Year" as a dynamic input (At run time)</li>
<li>Find whether year is leap year or not</li>
<li>If it is leap year then bot should stop the execution</li>
<li>Else continue the process, until it is leap year.</li>
</ul>
<h2 id="Day-4-----ConditionalStatement"><strong>Day 4</strong> - <em>Conditional Statement</em></h2>
<ul>
<li>Ask for favourite programming language (At run time)</li>
<li>Use Switch in Sequence and Flow switch in Flowchart</li>
<li>Display the result accordingly.</li>
<p>Note : Use Integer Data type in both cases.</p>
</ul>
<h2 id="Day-5-----StudentDetails"><strong>Day 5</strong> - <em>Student Details</em></h2>
<ul>
<li>Populate student details using "Build Data Table" activity</li>
<li>Build with following columns as Roll No, Student Name, Marks in English, Marks in Tamil, Marks in Maths</li>
<li>Calculate total marks for each student using "For Each Row" activity</li>
<li> Display output student wise</li>
<p>Note : Minimum 5 student details and 3 Marks.</p>
</ul>
<h2 id="Day-6&7-----EmployeeDetails"><strong>Day 6 & 7</strong> - <em>Employee Details</em></h2>
<ul>
<li>Get Employee ID, Name and Salary from user dynamically</li>
<li>Populate data in datatable (Add Column and Add Row in Datatable)</li>
<li>Save the data in excel format with the file name as "Employee.xlsx" in desktop</li>
<li>Send E-mail with excel file as attachment.</li>
</ul>
<h2 id="Day-8-----DynamicFilesHandling"><strong>Day 8</strong> - <em>File Handling</em></h2>
<ul>
<li>1. Ask user to select the files dynamically, Move the files from one folder to another folder</li>
<li>2. Select a file from a path, rename and save it in a new folder</li>
</ul>
<h2 id="Day-9-----MobileDetails"><strong>Day 9</strong> - <em>Mobile Details</em></h2>
<ul>
<li>Read two different excel files with the Columns S.No, Mobile Name and Price</li>
<li>Join/Merge the data</li>
<li>Filter the mobiles, price less than Rs.8000</li>
<li>Display the output in ascending order (Name wise)</li>
<li>Display the output in descending order (Price wise)</li>
</ul>
<h2 id="Day-10-----DataConversion"><strong>Day 10</strong> - <em>Data Conversion</em></h2>
<ul>
<li>Create excel file with students details (Columns - Roll No, Student Name, Mobile No)</li>
<li>Copy the data of each student from excel</li>
<li>Paste the data in notepad student wise with comma seperator ((ie) One notepad per student)</li>
<li>Student name should be the name of each file</li>
</ul>
<h2 id="Day-11-----PanAadhar"><strong>Day 11</strong> - <em>Pan & Aadhar Validation</em></h2>
<ul>
<li>Get Pancard and Aadhar number as input from the user</li>
<li>Validate both for length and pattern using regex</li>
<li>If it is valid details save it in notepad </li>
<li>Else pop-up the message as "Invalid details".</li>
</ul>
<h2 id="Day-12&13-----ScripDetails"><strong>Day 12 & 13</strong> - <em>Scrip Details</em></h2>
<ul>
<li>Go to "https://www.bseindia.com/"</li>
<li>Scrap/Get the details like Previous close, Current Price , Open details, ISIN for 5 Scrips</li>
<li>Save the details in excel file uisng "Workbook activty".</li>
<p>Note : Use build data table (or) write the row wise details in excel.</p>
</ul>
<h2 id="Day-14&15-----CSV"><strong>Day 14 & 15</strong> - <em>Working with CSV Files</em></h2>
<ul>
<li>Create CSV file for college details with columns like S.No, College Name, City, State</li>
<li>Append new college details dynamically</li>
<li>Ask user for preferred location</li>
<li>Based on the location search and display near by colleges</li>
<p>Note : Search criteria should be based on city, Display more than one college, if multiple colleges are located in same city.</p>
</ul>
<h2 id="Day-16&17-----Compare"><strong>Day 16 & 17</strong> - <em>Compare a Product on Different Websites</em></h2>
<ul>
<li>Ask user for a product</li>
<li>Search the product details in both Flipkart and Amazon</li>
<li>Compare price of the product entered by the user</li>
<li>Suggest the best offer</li>
<li>Write the details in excel/notepad and send the attachment in E-mail</li>
</ul>
<h2 id="Day-18&19-----WindowsForms"><strong>Day 18 & 19</strong> - <em>Working with Windows Forms</em></h2>
<ul>
<li>Download the "WindowsForms.zip" file from the link <a href="https://raw.githubusercontent.com/Pavithratrdev/RPATraining/master/WindowsForms.zip">Download Windows Forms</a></li>
<li>Fill the Student Details</li>
<li>Submit the Details</li>
<li>Email the Excel file.</li>
<p> Note : Excel file will be generated in downloads folder by default</p>
</ul>
<h2 id="Day-20&21-----InvoiceDetails"><strong>Day 20 & 21</strong> - <em>Invoice Details</em></h2>
<ul>
<li>Download the "WebHostLimited.pdf & BharatElectricals.pdf" file from the link <a href="https://raw.githubusercontent.com/Pavithratrdev/RPATraining/master/WebHostLimited.pdf">
Download Web Host Invoice</a> and <a href="https://raw.githubusercontent.com/Pavithratrdev/RPATraining/master/BharatElectricals.pdf">Download Bharat Electricals Invoice</a></li>
<li>Read Invoice Number, Invoice Date and Billed Address</li>
<li>Create a google form to upload the same.</li>
<p> Note : Create new invoices uisng "BharatElectricals.pdf" which is in editable format</p>
</ul>
<h2 id="Day-22&23-----QRCode"><strong>Day 22 & 23</strong> - <em>QR Code Generation</em></h2>
<ul>
<li>Create excel file with the columns Client ID, Client Name and Email ID</li>
<li>Read the excel file</li>
<li>Go to "https://www.the-qrcode-generator.com/" and build QR code based on Client ID & Name</li>
<li>Save the generated file in "PNG" format</li>
<li>Send the QR Code as attachment to respective Email IDs.</li>
</ul>
<h2 id="Day-24&25-----Word"><strong>Day 24 & 25</strong> - <em>Appoinment Letter Generation</em></h2>
<ul>
<li>Download "AppoinmentLetter.docx" file from the link <a href="https://raw.githubusercontent.com/Pavithratrdev/RPATraining/master/AppoinmentLetter.docx"> Download Appointment Letter </a></li>
<li>Create excel file with the columns Date, Address, Applicant Name, Company Name, Job Title, Starting Date and Email ID (Minimum for 3 employees)</li>
<li>Read the excel file</li>
<li>Fill the respectve field details in word file using "Word Activities"</li>
<li>Save and Email the files.</li>
</ul>
<h2 id="Day-26,27&28-----Random"><strong>Day 26, 27 & 28</strong> - <em>Random Number - Guess Game</em></h2>
<ul>
<li>Use "State Machine" for the task (Refer below screenshot)</li>
<li>Generate the Random Number (Use predefined function)</li>
<li>Ask user to enter the guess number</li>
<li>If random number and guess number are same, then bot should display "Matched" and stop</li>
<li>Else if guess number is lesser or greater than random number then bot should ask to enter next number.</li>
</ul>
<p><img src="https://raw.githubusercontent.com/Pavithratrdev/RPATraining/master/StateMachine.JPG" alt="State Machine"></p>
<h2 id="Day-29&30-----Python"><strong>Day 29 & 30</strong> - <em>Working with Python Scripts</em></h2>
<ul>
<li>Addition & Subtraction using Python activities</li>
<li>Display the result to the user.</li>
</ul>
<h2 id="Day-31,32&33-----Macro"><strong>Day 31, 32 & 33</strong> - <em>Excel Macro</em></h2>
<ul>
<li>Create an excel with the columns S.No, Product Name, Cost Price and Selling Price</li>
<li>Use "Excel Macro" activities for the task</li>
<li>Compare cost and selling price, calculate profit or loss</li>
<li>Shade the header row with orange color</li>
<li>If profit then apply green color or loss then apply red color for the respective column.</li>
</ul>
<h2 id="Day-34&35-----SubMenu"><strong>Day 34 & 35</strong> - <em>Working with Sub Menus</em></h2>
<ul>
<li>Go to "https://www.oyorooms.com/"</li>
<li>Select city based on your preference</li>
<li>Select location (Refer below screenshot as sample)</li>
<li>Scrap the details like Hotel name, Price etc.,</li>
<li>Write the details in excel and Email the same.</li>
</ul>
<p><img src="https://raw.githubusercontent.com/Pavithratrdev/RPATraining/master/Hotel.png" alt="Hotel Booking"></p>
<h2 id="Day-36,37&38-----Challenge"><strong>Day 36, 37 & 38</strong> - <em>Dynamic Fields</em></h2>
<ul>
<li>Go to "http://www.rpachallenge.com/"</li>
<li>The fields will change position on the screen after every submission</li>
<li>Create excel file with the fields as same as in the website</li>
<li>Upload details and submit (Mimimum 3 times).</li>
</ul>
<h2 id="Day-39,40,41&42-----Whatsapp"><strong>Day 39, 40, 41 & 42</strong> - <em>Sending messages through WhatsApp</em></h2>
<ul>
<li>Create excel file with the columns as Name, Mobile No, Department and Status (Minimun 5 details, Indefault "Status" Column should be empty)</li>
<li>Save the content regarding "Diwali wishes" in text file (ie., notepad) which is to be shared</li>
<li>Go to "https://web.whatsapp.com/", WhatsApp API to send messages</li>
<li>Send message (saved in notepad) through "WhatsApp web API" to the contacts in excel file</li>
<li>Finally update status in excel file (Yes - Sucessfully sent or No - Not sent due to wrong number/Not a WhatsApp number etc.,). </li>
</ul>
<h2 id="Day-43,44,45&46-----WebApp"><strong>Day 43, 44, 45 & 46</strong> - <em>Building Web Application using UiPath</em></h2>
<ul>
<li>Design your custom input form (web application) using UiPath</li>
<li>Enter the details in input form</li>
<li>Split and Save the data in excel (Minimun 3 rows, update the same excel file)</li>
<li>Send the excel file in Email.</li>
<p> Note : We have 2 methods to do above task, mandatory to try both the methods and upload the source code </p>
</ul>
<h2 id="Day-47,48,49&50-----MiniProject"><strong>Day 47, 48, 49 & 50</strong> - <em>Attended & Unattended Bot</em></h2>
<ul>
<li>Build your own process (Any Combination of Excel/Web/Windows Client/PDF/Word etc., automation)</li>
<li>Run as Attended and Unattended Bot (Both are mandatory)</li>
<li>Display the output.</li>
<p> Note : Process should be like Mini Project </p>
</ul>
</div>
</div>
</body>
</html>