Automated Data Entry for Company Systems

This project automates the process of logging into a company's system and entering product data. It leverages Python libraries such as pyautogui for simulating keyboard and mouse actions, and pandas for reading data from CSV files. Features

Automated System Login: Opens the company system in a browser, enters login credentials, and navigates to the appropriate section.
Data Entry Automation: Reads data from a CSV file and inputs it into the system's fields, including product code, brand, type, category, unit price, cost, and observations.
Error Handling: Skips empty observations (obs) fields during data entry.

Requirements

Python 3.x
Libraries:
    pyautogui
    pandas

Install the required libraries with:

pip install pyautogui pandas

Usage

Place the produtos.csv file in the same directory as the script. The file should have the following columns:
    codigo
    marca
    tipo
    categoria
    preco_unitario
    custo
    obs

Update the pg.click(x, y) and pg.write() coordinates and values in the script to match your system's layout and input fields.

Run the script:

python automation_script.py

How It Works

System Access:
    Opens the browser and navigates to the system login page.
    Inputs email and password.
    Navigates to the data entry page.

Data Input:
    Reads product data from produtos.csv.
    Inputs data field by field for each product.
    Handles observations (obs) field conditionally.

Example CSV File

codigo,marca,tipo,categoria,preco_unitario,custo,obs 12345,BrandA,Type1,CategoryX,10.50,5.00,Special note 67890,BrandB,Type2,CategoryY,15.75,7.50,

Notes

Adjust time delays (time.sleep) as needed for system responsiveness.
Ensure the browser and system layout match the script's configurations.

Disclaimer

This script is designed for educational purposes. Ensure compliance with company policies and permissions before automating system interactions.