⚡Quick Form Fill Automation

Quick Form Fill Automation is a Python automation that reads a database from an Excel file, opens a browser using Selenium, and automatically registers products. This project aims to save time and reduce errors in the product registration process.

📑 Table of Contents

• Key Features
• Demonstration Video
• How It Works
• Tools and Technologies Used
• Project Dependencies
• Prerequisites
• Installation Instructions
  • Clone this Repository
  • Navigate to the project directory
  • Create and activate a virtual environment
    • First, install the virtualenv library
    • Then, create a virtual environment named venv
      • Linux or macOS
      • Windows
    • Activate the virtual environment
      • Linux or macOS
      • Windows
  • Install dependencies
  • Run the project

🚀 Key Features

• Product Data Reading: The automation is capable of reading product data from an Excel file.
• Browser Initialization: It initiates a web browser (such as Chrome or Firefox) using Selenium.
• Automatic Form Filling: The automation automatically fills in the fields of a product registration form.
• Process Automation: By automating the form filling process, it saves time and reduces errors, making the process more efficient and reliable.

📹 Demonstration Video

quick-form-fill-demonstration-video.mp4

💡 How It Works

1. Initial Setup: The automation utilizes Selenium, a web browser automation tool, and pandas, a Python library for data manipulation, to perform tasks.
2. Browser Initialization: Firstly, the script initiates a web browser (Chrome, in this case) using Selenium's webdriver.
3. Accessing the Page: The browser navigates to the local URL where the product registration form is hosted http://localhost:3000/.
4. Reading Data: Product data is read from an Excel file named data.xlsx using the pandas library and stored in a DataFrame.
5. Product Iteration: For each row in the DataFrame, the script fills in the fields of the product registration form with the corresponding data.
6. Submitting Data: After filling the fields with the data for each product, the script submits the registration form.
7. Completion: After registering all the products, the browser is closed.

🔧 Tools and Technologies Used

• Python: A flexible and popular programming language, recognized for its ease and readability. It's utilized for automation development.
• Selenium: Implemented for automating web browsers, facilitating interaction with web elements and simulating user activities.
• Pandas: Utilized for efficient data manipulation, allowing the automation to manage product data from a Python-based Excel file.
• Excel: A common format for storing product data, using Excel files, which are widely accessible and suitable for tabular data storage.
• Time: The Time module in Python is a powerful tool that provides a wide range of functions to manage time-related tasks efficiently.

🔗 Project Dependencies

This automation depends on two additional projects:

1. Quick Form Fill Backend

   • This backend project provides the necessary API endpoints and handles the server-side logic required by the automation.
   • Ensure you follow the installation and setup instructions provided in the README.md of the backend repository to get it up and running.

2. Quick Form Fill Frontend

   • This frontend project provides the user interface where the forms are located and filled by the automation.
   • Ensure the frontend project is properly set up and running according to its documentation.

Ensure both the backend and frontend projects are running and accessible before using the Quick Form Fill automation.

📋 Prerequisites

• Git: A widely adopted distributed version control system.
• Python: A versatile, multipurpose programming language.
• Pip: A package manager for installing and handling Python libraries.

📝 Installation Instructions

1. Clone the Repository

git clone https://github.com/esperanca-leonardo/quick-form-fill-automation.git

2. Navigate to the Project Directory

cd quick-form-fill-automation

3. Create and activate a virtual environment

• 3.1. First, install the virtualenv library

  pip install virtualenv

• 3.2. Then, create a virtual environment named venv

  • Linux or macOS

    virtualenv venv

  • Windows

    python -m virtualenv venv

• 3.3. Activate the virtual environment

  • Linux or macOS

    source venv/bin/activate

  • Windows

    .\venv\Scripts\activate.bat

4. Install dependencies

Make sure you have Python and pip installed on your system. Then, install the project dependencies using pip

pip install -r requirements.txt

5. Run the project

Execute the project using the following command

python main.py