Overview
Keywords are the search terms used to identify tasks that require action in the “Relato” (report) column of your Auvo files. By customizing these keywords, you can tailor the extraction to your specific business needs.Default Keywords
The application comes with a default set of keywords commonly used to identify tasks requiring action:- solicitar peça
- quebrado
- quebrada
- quebrados
- orçamento
- danificada
- danificado
- danificados
- danificadas
- trocar cabo
- soldar
- trocar
- instalar
Keywords are case-insensitive, meaning “QUEBRADO”, “quebrado”, and “Quebrado” will all match.
Accessing the Configuration Page
Navigate to Configuration
From the home page, click the “Configurar Palavras-chave” button. This will take you to the
/config route.How to Modify Keywords
Edit the Keyword List
In the text area, modify your keywords. Each keyword should be separated by a comma.
Use Suggested Keywords
The configuration page provides quick-add badges for common keywords:
- vazamento
- rompido
- sem comunicação
- ajustar
- conector
Save Changes
Click the “Salvar Alterações” button to save your keywords. You’ll be redirected back to the home page.
Keyword Configuration Details
How Keywords Are Stored
Keywords are stored in your browser’s session storage (handled by Flask sessions). This means:- Keywords persist across page navigation during your session
- Keywords are browser-specific (not shared between devices)
- Keywords reset if you clear your browser cookies/session
- Each user can have different keyword configurations
Your keyword configuration is stored server-side in the session but tied to your browser session cookie. If you close your browser or the session expires, keywords may revert to defaults.
Backend Processing
When you save keywords (viaPOST /config in app.py:108):
- The form data is received as a comma-separated string
- The string is split by commas:
request.form.get('keywords', '').split(',') - Each keyword is trimmed of whitespace:
[k.strip() for k in keywords] - Empty keywords are filtered out
- The cleaned list is stored in the session:
session['custom_keywords']
How Keywords Are Applied
During file processing (app.py:137):
- Keywords are retrieved from the session
- A regex pattern is built:
regex_busca = '|'.join(palavras_chave) - The pattern searches the “Relato” column using pandas:
- All matching rows are included in the results
Keywords use regex “OR” logic (separated by
|), meaning a row matches if it contains ANY of the configured keywords.Best Practices for Keywords
Use Specific Terms
Choose keywords that specifically indicate action is needed: ✅ Good: “solicitar peça”, “quebrado”, “orçamento necessário” ❌ Avoid: “cliente”, “instalação” (too generic)Include Variations
Include singular, plural, and gender variations for Portuguese:Use Multi-Word Phrases
You can use phrases with spaces:Consider Your Business Context
Tailor keywords to your specific industry and service types: For HVAC services:Testing Your Keywords
Review Statistics
On the results page, check the “Ocorrências por Palavra-chave” section to see which keywords found matches.
Viewing Active Keywords
After processing a file, the results page displays:- Total keywords used: Shown in the “Palavras Ativas” statistics card
- Keywords with matches: Listed in the “Ocorrências por Palavra-chave” section with match counts
- Full keyword list: Displayed at the bottom of the results page with an edit button
Only keywords that found at least one match appear in the “Ocorrências por Palavra-chave” breakdown.
Troubleshooting
No Results Found
If your processed file returns zero results:- Verify your keywords match the actual terms in the “Relato” column
- Check for typos in your keyword configuration
- Remember that keywords are matched against complete words/phrases
- Consider adding variations or broader terms
Too Many Results
If you’re getting irrelevant matches:- Use more specific keywords or phrases
- Remove overly broad terms
- Consider the context in which keywords appear in your reports
Keywords Not Saving
If your keywords aren’t persisting:- Ensure cookies are enabled in your browser
- Check that you’re clicking “Salvar Alterações” before leaving the page
- Verify the Flask secret key is configured (required for sessions)
Related Routes
GET /config- Display configuration form (app.py:108)POST /config- Save keyword configuration (app.py:110)POST /upload- Uses configured keywords to process files (app.py:124)
Next Steps
- Upload files to test your keywords
- View results to see keyword statistics
- Export reports with keyword information included