CMPG-323-Project-4---30332338 README FILE

Overview

Testing is a critical aspect of any solution, and it can be approached from various perspectives, including internal development team testing and business user acceptance testing (UAT). User Acceptance Testing, often referred to as UAT, plays a pivotal role in most development lifecycles as it serves as the ultimate 'go/no-go' decision point. UAT is primarily concerned with ensuring that the input provided to a solution yields the expected output. If the solution does not produce the desired output, it must be adjusted and retested before it can proceed to production.

Robotic Process Automation (RPA) involves using technology to replicate human tasks, particularly those related to front-end or User Interface (UI) automation. RPA is commonly used to automate repetitive and time-consuming tasks, freeing up human resources to focus on more complex and creative tasks.

In the context of the web application developed in Project 3, before deploying it to production, it must undergo UAT. During UAT, a team of testers works with a test dataset containing input and expected output data. Testers input each dataset record into the web application's fields and verify that the expected output is generated. In this case, the expected output would be a new record displayed on the web application after adding the item. Automating this highly repetitive process with RPA is both efficient and recommended.

Requirements

Functional Requirements

Functional requirements define the specific functionality a system must possess and how those functions should be executed.

Non-Functional Requirements

Non-functional requirements encompass aspects of a solution that impact the system's quality attributes or platform. These requirements support the implementation of functional requirements in line with good software practices.

Project Tasks

GitHub Administration

• Create and Configure GitHub Repository

  • Create a repository named 'CMPG 323 Project 4 - '
  • Create a ReadME.md file to describe the project and guide stakeholders on how to use the report.

• Project Progress

  • Ensure that the solution is committed and pushed to source control throughout the project.
  • Update the GitHub project iteratively to demonstrate project progress.

    ---

    Project Setup

    ---

• Create the Project

  • Clone your GitHub repository.
  • Install UiPath Studio.
  • Create a new UiPath process named 'Connected Office Web Application – User Acceptance Testing.'

    ---

    User Acceptance Testing

    ---

• Read the input data

  • Read data from Excel into a data table in UiPath.
  • Verify that the data is correctly readable and iterable in UiPath.

• UI Automation

  • For each record in the data table, navigate to the URL in the browser where data can be entered to create a new record.
  • Populate the web application fields with data from each record to create a new record on the web application.
  • Click the 'submit' button on the web application to create a new record.
  • Navigate to the URL to view the newly created record on the web application.

• Record Results

  • If the item was created successfully, update the data table record to indicate a successful test.
  • If the item was not created, update the data table to depict a failed test.
  • Update the Excel spreadsheet with the testing results in the 'Test Results' column (update with TRUE or FALSE).

    ---

    Project Close-out

    ---

• Deploy Solution

  • Publish the UiPath solution to the UiPath Orchestrator.

    ---

    Achievements

    ---

    1. Build your first Power Automate for desktop flow

2. Introduction to UiPath Document Understanding

3. Advanced UI Automation in Studio

4. Coded Automation for Testing

Referancing

1. 14 September Weekly Virtual Class Automation Introduction (2023) YouTube. Available at: https://www.youtube.com/watch?v=wi18JuLhZ74&t=2420s (Accessed: 19 October 2023).
2. RPA Uipath full course | RPA uipath tutorial for beginners | RPA course | RPA tutorial | Simplilearn (2021) YouTube. Available at: https://www.youtube.com/watch?v=kg15yZiBGxE (Accessed: 19 October 2023).
3. RPA: What is RPA | did you know RPA | RPA tutorial | what is robotic process automation how it works (2022) YouTube. Available at: https://www.youtube.com/watch?v=hrgcnFBVmYA (Accessed: 19 October 2023).
4. How to generate a random number in Uipath (2021) YouTube. Available at: https://www.youtube.com/watch?v=HTQDyRAZ31s&t=73s (Accessed: 19 October 2023). 5.Uipath read excel & enter the data into web form uipath RPA tutorial how to do automate google forms (2022) YouTube. Available at: https://www.youtube.com/watch?v=1JxR96chSzk&t=477s (Accessed: 19 October 2023).
5. Fill data from Excel on Web Form - Uipath RPA Tutorial (2021) YouTube. Available at: https://www.youtube.com/watch?v=vnhWtP0Z5uQ (Accessed: 19 October 2023).
6. Uipath Studio: Your first process automation (2020) YouTube. Available at: https://www.youtube.com/watch?v=OyQAhrcBr9U (Accessed: 19 October 2023).
7. Automating complex excel processes and data table through RPA #UIP (2017) YouTube. Available at: https://www.youtube.com/watch?v=Ed3hYpKofts (Accessed: 19 October 2023).
8. Uipath - how to add data to a new Excel column - full tutorial (2020) YouTube. Available at: https://www.youtube.com/watch?v=DTKyWrgDDDg (Accessed: 19 October 2023).
9. Uipath tutorial day 1 : Introduction to uipath (2018) YouTube. Available at: https://www.youtube.com/watch?v=AIV7NJ1giEQ&list=PLZVSOFwGx4zCM6aramn0opSVWDNVBL-PP (Accessed: 19 October 2023).