S04P02 Calculating Loss Invoices

This project is my solution in Windows Legacy (Deprecated), C# to the Calculating Loss Invoices practice found in section 04 practice 02 of the UiPath - RPA Developer Foundation course.

Getting Started

After making a pull request or downloading the project, open the Main.xaml in UiPath Studio. The robot can be run with the play button in the ribbon and the result can be seen in output panel.

Practice Requirements

Check the invoices issued to bankruptcy clients

Check which of the invoices in an Excel file were issued to clients in bankruptcy and calculate the sum of the invoices to be recorded as loss.

Input files:

• Invoices (.xlsx)
• Clients (.csv)

Details

Course: UiPath - RPA Developer Foundation

Section: 04 Excel And Data Tables

Practice: 02 Calculating Loss Invoices

Project Format: Windows Legacy (Deprecated), C#

GitHub: https://github.com/ShonHarsh/RPADev-S04P02-CalculatingLossInvoices-WindowsLegacy

Sample Output

07/30/2021 16:13:27 => [Debug] Execution started for project: RPADev-S04P02-CalculatingLossInvoices
07/30/2021 16:13:29 => [Info] RPADev-S04P02-CalculatingLossInvoices execution started
07/30/2021 16:13:33 => [Debug] Agitude 750
07/30/2021 16:13:33 => [Debug] Cryptomba 730
07/30/2021 16:13:33 => [Debug] Epiloo 2180
07/30/2021 16:13:33 => [Debug] Teamatix 350
07/30/2021 16:13:33 => [Debug] Travels Print 570
07/30/2021 16:13:33 => [Debug] Unit&Products Inc. 1305
07/30/2021 16:13:33 => [Debug] The total amount lost from all invoices: 5885
07/30/2021 16:13:33 => [Info] RPADev-S04P02-CalculatingLossInvoices execution ended in: 00:00:03

Notes

The ForEach loop TypeArgument must be set to the System.Collections.Generic.KeyValuePair.

Architecture Requirements

A standard UiPath, Studio to Orchestrator cloud setup is the base of operation. It is easy to setup and free.

1. An Orchestrator connection - Visit https://cloud.uipath.com/ and authenticate or sign up.
2. UiPath Studio is used to run the robot. Note that Studio Web can be used directly in Orchestrator but I recommend installing the Studio IDE application.

Git Notes

Clone the project to develop or change it.

git clone https://github.com/ShonHarsh/RPADev-S04P02-CalculatingLossInvoices-WindowsLegacy

Links

• UiPath Automation Platform
• UiPath Studio
• Pulsar (Atom Successor) - Used for all my README.md files
• Shon Harsh Website 127.0.0.1
• This.GitHub
• LinkedIn

RPS Developer Foundation Sections

1. Get Started With RPA Development

2. Variables, Data Types And Control Flow In Studio

   P01 RPADev-S02P01-ForEachIfStatement [C#] [VB] [Windows Legacy]

   P02 RPADev-S02P02-GenericValue [C#] [VB] [Windows Legacy]

   P03 RPADev-S02P03-Switch [C#] [VB] [Windows Legacy]

3. Data Manipulation In Studio

   P01 RPADev-S03P01-Lists [C#] [VB] [Windows Legacy]

   P02 RPADev-S03P03-Dictionaries-Integers [C#] [VB] [Windows Legacy]

   P03 RPADev-S03P04-Dictionaries-Doubles [C#] [VB] [Windows Legacy]

   P04 RPADev-S03P05-InputValidation [C#] [VB] [Windows Legacy]

   P05 RPADev-S03P06-ReplacingPlaceholders [C#] [VB] [Windows Legacy]

   P06 RPADev-S03P07-ExtractEmailAddress [C#] [VB] [Windows Legacy]

   P07 RPADev-S03P08-ExtractEmailAddressRegEx [C#] [VB] [Windows Legacy]

4. Excel And Data Tables With Studio

   P01 RPADev-S04P01-CalculatingSums [C#] [VB] [Windows Legacy]

   P02 RPADev-S04P02-CalculatingLossInvoices [C#] [VB] [Windows Legacy]

   P03 RPADev-S04P03-CalculatingPercentagesOfExpenses [C#] [VB] [Windows Legacy]

5. UI Automation With Studio

   P01 RPADev-S05P01-PasswordGenerator [C#] [VB] [Windows Legacy]

   P02 RPADev-S05P02-TheRPAChallenge [C#] [VB] [Windows Legacy]

   P03 RPADev-S05P03-InputActions [C#] [VB] [Windows Legacy]

   P04 RPADev-S05P04-OutputActions [C#] [VB] [Windows Legacy]

   P05 RPADev-S05P05-DataScraping [C#] [VB] [Windows Legacy]

6. Selectors In Studio

   P01 RPADev-S06P01-GetAndSortData [C#] [VB] [Windows Legacy]

   P02 RPADev-S06P02-SetData [C#] [VB] [Windows Legacy]

   P03 RPADev-S06P03-Highlight-TypeItems [C#] [VB] [Windows Legacy]

7. Project Organization In Studio

   P02 RPADev-S07P02-StateMachines [C#] [VB] [Windows Legacy]

   P03 RPADev-S07P03-FixMyWorkflow [C#] [VB] [Windows Legacy]

   P04 RPADev-S07P04-Libraries [C#] [VB] [Windows Legacy]

8. Error And Exception Handling In Studio

9. Debugging In Studio

10. PDF Automation In Studio

11. Email Automation With Studio

12. Orchestrator For RPA Developers

13. Robotic Enterprise Framework Overview