.svg?42cceeb)
Odoo Implementation
Data Cleaning | Data Cleaning Tool | Data Cleaning Extension | Find And Merge Duplicate Data
by Technoverse Systems https://www.technoversesystems.com
Odoo
$ 15.35
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Data Recycle (data_recycle)
• Discuss (mail) |
| Lines of code | 698 |
| Technical Name |
ur_data_cleaning |
| License | LGPL-3 |
| Website | https://www.technoversesystems.com |
| Versions | 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Data Recycle (data_recycle)
• Discuss (mail) |
| Lines of code | 698 |
| Technical Name |
ur_data_cleaning |
| License | LGPL-3 |
| Website | https://www.technoversesystems.com |
| Versions | 17.0 18.0 19.0 |
Data Cleaning Extension
rule based data cleaning for Odoo with two core areas: Field Cleaning and Recycle Records. In Field Cleaning, you create a rule for a specific model (such as Contact), activate it, and add multiple rule lines via Add a line to target individual fields (Name, Email, Tax ID, Phone, Mobile, City, etc.) with actions like Trim Spaces (Superfluous or All Spaces) and Format Phone; you can run the job with the Clean button, monitor the Records counter, choose Manual or Automatic mode, and notify selected users on a schedule. In Recycle Records, you configure how records are archived or deleted by selecting the model, choosing Manual or Automatic recycle mode, picking the recycle action (Archive or Delete), optionally including already archived items, defining the domain with Select, notifying users at a set frequency, checking the Records counter, and applying the rule instantly with Run Now; a list view centralizes all recycle rules with columns for Name, Model, Recycle Mode, Recycle Action, and Active for quick management. Together these screens let you add granular field-fix rules and automate or manually execute archiving/deletion, giving clear control over what is cleaned and when.
Video Details
Key Features
Model Specific Field Cleaning Rules
Define cleaning rules per model and fix fields like Name, Email, Phone, Tax ID, Mobile, and City with precision.
Manual & Scheduled Cleaning Jobs
Run cleaning instantly using the Clean button or automate it with scheduled execution and user notifications.
Recycle Records Management
Configure rules to archive or permanently delete records using manual or automatic recycle modes.
Domain Based Record Targeting
Select exactly which records are affected using domain filters, record counters, and optional archived data inclusion.
Centralized Rule Monitoring
View and manage all cleaning and recycle rules from a single dashboard for better control and transparency.
Multiple Cleaning Actions
Apply actions such as trimming extra spaces (superfluous or all) and formatting phone numbers consistently.
Create a New Recycling Rule
Navigate to Configuration > Recycle Records and click on the New button to start creating a record cleaning rule.
Select the Target Model
From the Model dropdown menu, select the specific document type (e.g., Contact, Lead) where you want to apply this rule.
Define Action and Time Criteria
Choose the Recycle Action (Archive or Delete) and set the Time Field criteria to filter records based on their age or activity.
Set Execution Mode and Run
Select the Recycle Mode (Manual or Automatic) and click the Run Now button to trigger the rule immediately.
Review and Validate Records
The system will display identified records. Review the list and click Validate to confirm the action or Discard to skip specific records.
Access Field Cleaning Configuration
Go to the Configuration menu and select Field Cleaning to manage text formatting and standardization rules.
Add a New Cleaning Rule
Inside the configuration form, click on Add a line to define a specific cleaning operation for your data fields.
Configure Field Actions
In the pop-up window, select the Field To Clean and choose the desired Action (e.g., Trim Spaces, All Uppercase) to standardize the data.
Run Manual Field Cleaning
Once the rules are configured (e.g., Trimming spaces for the City field), click the Clean button to immediately scan the database for records that need formatting.
Review and Validate Changes
The system displays a list of records with Current and Suggested values. Click Validate to apply the correction or Discard to reject the suggestion.
FAQ
The Recycle Records feature allows you to set rules (e.g., leads older than 1 year) to automatically archive or delete outdated records, ensuring your system runs smoothly without manual cleanup.
Yes, with Field Cleaning, you can create rules to automatically correct case sensitivity (e.g., changing 'john doe' to 'John Doe') and fix phone number formats across your entire database.
The module includes a Trim Spaces function. This detects and removes superfluous spaces (leading, trailing, or double spaces) from fields like Email or Tax ID, preventing validation errors.
Absolutely. You can set the Cleaning Mode to Manual. This generates a list of suggested changes which a manager can review, and then choose to either Validate (apply) or Discard (ignore) them one by one.
Release 19.0.1.0.0
20 December, 2026
Add
- Initial Commit
Our Services
Odoo Customization
Support & Maintenance
Migration Services
Third Party Integration
AI & Business Integration
Odoo Training
Mobile Apps
Suggested Products
....
Please log in to comment on this module