Odoo Implementation
Data Cleaning | Data Cleaning Tool | Data Cleaning Extension | Find And Merge Duplicate Data
by Technoverse Systems https://www.technoversesystems.com$ 121.49
| 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 | Data Cleaning Tool | Data Cleaning Extension
Easily format and clean text data across multiple records. Quickly identify duplicate entries, compare details, and effortlessly merge them into a single, accurate record saving time and improving data consistency.
Data Cleaning Tool
This module adds 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.
From Configuration > Rules > Recycle Records and click on create button.
Recycle Records Rule form where the model is being selected (dropdown open). Enable the rule, choose the Recycle Mode (Manual or Automatic), set the Recycle Action (Archive or Delete), optionally include archived records, and add users to notify with a frequency. Use Select to define the record domain that will be recycled, Run Now to execute immediately, and the Records counter shows how many items match the rule.
Select Field Cleaning to access field-cleaning rules.
Add a line to add additional field-cleaning rules for the Contact model by selecting the target field and action (e.g., Trim Spaces, Format Phone).
The new rule line is added City (Contact) with action Trim Spaces (All Spaces). Click Clean to run the cleaning.
Configuration > Rules > Deduplication to manage merge rules per model. Click on create.
Select the target model (e.g., Contact); once selected, the Domain field becomes available to filter which records are checked, and the Duplicate Removal options for that model can be configured. .
Select the field that will identify duplicates (e.g., City, Company, Company Name, Complete Name). Each line pairs a chosen field with a Merge If condition (Exact Match shown) to decide when records should be merged.
Merge Action Manager list accessed via Configuration > Merge Action Manager. Use New to create a merge configuration; the list shows each model with Type, Transient Model, and Can Be Merged columns to control which models support merge operations.
Merge Action Manager form to configure a model for merging. Click Enable Merge to activate merging. In Model Description, set the Model technical name and Order (default sort), and optionally enable Transient Model, Has Mail Thread, Has Mail Activity, or Has Mail Blacklist. The Fields tab lists existing fields (e.g., x_name char) and lets you Add a line for new fields; other tabs cover Access Rights, Record Rules, Notes, and Views. Use Create a Menu to generate a menu entry for this model.
Our Services
Odoo Customization
Support & Maintenance
Migration Services
Third Party App Integration
Artificial Intelligence & Business Integration
Odoo Training
Mobile Apps
Please log in to comment on this module