[RPA_UiPath_Project] Today’s ticket ranking list

RPA_Client Wants

Today’s ticket ranking list

1. Email

  • Using categories from the client’s email
  • Current the categories that the client wants:  전체, 스포츠, 콘서트, 뮤지컬, 캠핑
  • There might be no category on the website. In this case, need Exception
  • Sending the end data with Excel to the client by email.

2. Robotic Enterprise Framework

  • Exception
  • Leave RPA result with Excel

Create a separate Excel sheet for the RPA Result. If there is no category on the website that the client wants, make sure to leave “Fail”. The rest should be marked as “Success”.

3. Data Extract

4. Attended bot

  • it means it will be working at the same PC

Triggers

Timezone : (UTC+09:00) Seoul
Frequency : Daily
Repeat every 1 day(s) at 13:00

5. Project duration : 2 days

————————————————————————————–

Goal

  • Making simple, fast and reasonable logic.
  • making use of config.xlsx as much as possible

Website analysis

Web analysis for crawling with uipath(RPA)
Web analysis for crawling with uipath(RPA)
  • After analyzing the web site(html, css), I planed two data tables.
  • For the categories, I used For Each UiElement activity.
  • The date and Location were extracted at once. So, I needed string manipulation.
  • They don’t have some categories that the client wants.

 

Ticket ranking_Crawling, UiPath
Ticket ranking_Crawling, UiPath

Robotic Enterprise Framework (REF)

Initialization

REF, Initialization (uipath/RPA)
REF, Initialization (uipath/RPA)
  • Getting Email subject and body for using Transaction List (Categories)
  • Create Data Tables needed in the project. In this case, RPA result DT and Extract Data DT
  • Initialization of almost all variables in the initial stage
  • Mail.body string manipulation for the Transaction List (Categories)

Get transaction data

REF, Get transaction Data with List (uipath/RPA)
REF, Get transaction Data with List (uipath/RPA)
  • Getting transaction data with List and string which is Transaction Item

Process Transaction

REF, Process Transaction (uipath/RPA)
REF, Process Transaction (uipath/RPA)
  • Counting success or fail transaction and leaving the transaction item in Excel sheet named RPA result.
  • Web crawling with For Each UiElement activity
  • Building Business exception with Rethrow about the categories that the web doesn’t have

End process

REF, End Process (uipath/RPA)
REF, End Process (uipath/RPA)
  • Recording the RPA result DT into Excel.
  • Attaching files into email.
  • Using String.Format for mail.subject and mail.body

Trigger

    • Publishing the package with UIpath Studio
Attended Robot:Making use of package (Uipath Studio)
Attended Robot:Making use of package (Uipath Studio)
  • Installing the packing with UIpath Assistant
Attended Robot: Installing the package (Uipath Studio)
Attended Robot: Installing the package (Uipath Studio)
  • Setting the trigger with UIpath Orchestrator

 

Setting the trigger with UIpath Orchestrator
Setting the trigger with UIpath Orchestrator

 

 

See other RPA(UIpath) Projects >> https://eunice0121.com/category/rpa-uipath/rpa_project/

Official UiPath website >> https://www.uipath.com/ko/rpa/robotic-process-automation