Skip to main content

​
What is Extrator de Tarefas Auvo?

Extrator de Tarefas Auvo is a Flask-based web application designed to streamline the analysis of task reports exported from the Auvo system. It automatically filters tasks based on configurable keywords and provides organized results with statistics and export capabilities.
This tool is specifically designed to work with CSV and Excel files exported from the Auvo task management system.

​
Key Features

The application provides a comprehensive set of features for task analysis:

File Upload

Upload task reports in CSV, XLS, or XLSX formats directly through the web interface.

Keyword Filtering

Filter tasks using customizable keywords like “quebrado” (broken), “trocar peça” (replace part), and more.

Interactive Visualization

View filtered results in an interactive table with dynamic search capabilities.

Statistics Dashboard

Get instant insights including total records, tasks found, and occurrence rates.

Export Options

Download filtered results in Excel (.xlsx) or PDF formats for reporting.

Processing History

Track the last 10 processed files during your session with detailed statistics.

​
Who Is This For?

This application is ideal for:
  • Field Service Managers: Quickly identify tasks requiring parts replacement, repairs, or follow-up actions
  • Operations Teams: Monitor task patterns and filter reports for specific issue types
  • Maintenance Coordinators: Track tasks involving equipment failures or service requests
  • Auvo Users: Anyone working with Auvo task exports who needs efficient filtering and reporting

​
How It Works

The application follows a simple workflow:
1

Upload Report

Upload your CSV or Excel file exported from Auvo (the application automatically skips the first 5 header rows)
2

Process & Filter

The system filters tasks based on keywords in the “Relato” (Report) column
3

View Results

Review filtered tasks in an organized table showing Date, Client, Address, Digital OS, and Report
4

Export Data

Download results as Excel spreadsheets with statistics or formatted PDF reports

​
Technology Stack

The application is built with modern, reliable technologies:
  • Backend: Python 3.10+ with Flask web framework
  • Data Processing: Pandas for efficient CSV/Excel manipulation
  • PDF Generation: WeasyPrint for professional report formatting
  • Frontend: HTML5, CSS3, Bootstrap 5, and JavaScript for responsive UI
  • Session Management: Flask sessions for maintaining user state

​
Default Keywords

The application comes pre-configured with Portuguese keywords commonly found in maintenance and service tasks: 
[
  'solicitar peça',    # request part
  'quebrado',          # broken (masculine)
  'quebrada',          # broken (feminine)
  'quebrados',         # broken (plural masculine)
  'orçamento',         # budget/quote
  'danificada',        # damaged (feminine)
  'danificado',        # damaged (masculine)
  'danificados',       # damaged (plural masculine)
  'danificadas',       # damaged (plural feminine)
  'trocar cabo',       # replace cable
  'soldar',            # solder
  'trocar',            # replace
  'instalar'           # install
]
You can customize these keywords through the application’s configuration page to match your specific filtering needs.

​
Next Steps

Installation

Set up the application in your local environment

Quick Start

Process your first file in minutes

Build docs developers (and LLMs) love

Get started for freeTalk to us