Overview
The Extrator de Tarefas Auvo application processes CSV and Excel files exported from Auvo. This guide explains how to prepare and upload your files for task extraction.Supported File Formats
The application accepts the following file formats:- CSV files (
.csv) - Excel 97-2003 (
.xls) - Excel 2007+ (
.xlsx)
The application automatically skips the first 5 rows of your file, as Auvo reports typically contain header information in these rows.
File Requirements
Required Columns
Your Auvo export must contain the following columns:- Data - Date of the service order
- Cliente - Client name
- Endereco - Service address
- OS Digital - Digital service order number/link
- Relato - Service report description (this is where keywords are searched)
The application specifically searches for keywords in the Relato column to identify tasks that require action.
How to Upload Files
Export from Auvo
Export your service order report from Auvo in CSV or Excel format. Ensure the export includes all required columns mentioned above.
Navigate to Home Page
Open the Extrator de Tarefas Auvo application in your browser. You’ll see the main upload interface with a file selection button.
Select Your File
Click on the file input field labeled “Arquivo do Auvo” and select your CSV or Excel file from your computer.
Process the Report
Click the “Processar Relatório” button to upload and process your file. The application will:
- Read the file contents
- Skip the first 5 header rows
- Search for configured keywords in the “Relato” column
- Generate statistics and filter results
Upload Process Details
Backend Processing
When you upload a file, the application performs the following operations (handled by the/upload route in app.py:124):
- File Validation - Checks that a file was selected and has a valid extension
- Format Detection - Automatically detects whether the file is CSV or Excel
- Data Loading - Reads the file using pandas, skipping the first 5 rows
- Keyword Filtering - Searches the “Relato” column for configured keywords
- Statistics Generation - Calculates total records, matches found, and occurrence rate
- Temporary Storage - Saves filtered results to a temporary CSV file for export functionality
File Size Considerations
There is no explicit file size limit, but very large files (>10MB) may take longer to process. The application loads the entire file into memory for processing.
Troubleshooting Upload Issues
Error: “Nenhum arquivo selecionado”
This error appears if you click “Processar Relatório” without selecting a file first. Make sure to choose a file before submitting.Error: “Por favor, selecione um arquivo .csv, .xls ou .xlsx”
You’ve selected a file with an unsupported format. Only CSV and Excel files are accepted.Error: “Erro ao processar o arquivo”
This general error can occur for several reasons:- The file structure doesn’t match the expected Auvo format
- Required columns (Data, Cliente, Endereco, OS Digital, Relato) are missing
- The file is corrupted or cannot be read
- The Excel file is password-protected
File Persistence
Uploaded files are stored temporarily in the server’stemp/ folder as CSV files. These temporary files:
- Have unique UUID-based filenames to prevent conflicts
- Are used for generating Excel and PDF exports
- Remain available during your browser session
- Should be re-uploaded if your session expires
The application stores only the filename in your session, not the actual file data, to keep session storage efficient.
Next Steps
After successfully uploading your file:- View your results in the interactive table
- Configure keywords to refine your search
- Export reports to Excel or PDF format
Related Routes
POST /upload- Main file upload handler (app.py:124)GET /- Home page with upload form (app.py:104)