Abhishek M.SDec. 17, 2020
Odoo 14 includes a new Data Cleaning app. This app allows for automated cleansing, merging, and removal of duplicated data. A data cleaning app is to clean away all unnecessary documents and data from the server. Data cleaning is the process of preparing data by removing or modifying data that is incorrect, incomplete, irrelevant, duplicated, or improperly formatted. This data is usually not necessary or helpful when doing analyzes, as it might hinder the process or provide inaccurate results. With Odoo 14, you can use a fully operational and revolutionary data cleaning app.
Data Cleaning is the process of removing unwanted data. All data duplication includes customer contact, details,field details, etc fall under the data cleaning app. Odoo makes data cleaning a simple task for all by configuring deduplication and field cleaning. This module checks the redundancy of data and gives suggestion for deleting and merging those data. Modules have rules and according to that rule, duplicate data’s are removed. Also data merging is done automatically to a single record or it can be done manually too.
Odoo data cleaning app is integrated with Customer relationship management,Documents,Contacts, and many other modules. This will help you to avoid the messing up of documents due to duplication.
By using this blog, you can understand the operation of the Data cleaning application.
The “DATA CLEANING” app is accessed from the Odoo app menu by pressing Data cleaning icon
Press the data cleaning icon, Dashboard of data cleaning app. Dashboard display a list of duplicated documents. On the left side of dashboard, rules are found.
To configure rules, first you have to go to configuration from the menu bar.Once you click configuration from the menu bar, you will find a drop-down menu for Rules.
The configuration rules are set in two ways:
1. Deduplication
2. Field Cleaning
Deduplication Rules
By clicking Deduplication rules, it will open a new window where you can set the deduplication rules by choosing the different rules. Deduplication Rules consists of Conatcts,CRM Tag,Country,Country State,Industry, Lead Oppurtunity, etc.
First , click create button in duplication rule. You will get a new window.
Then , check the required fields in new window.
Here you can select the Model and choose different options. Deduplication rule are selected and set whether you want to merge the documents automatically or manually. By adding users in notify users option, you can also decide if you want to notify the user. Also this window lets you decide the interval to get a notification on deduplication. After entering the details,click on the save button.
After the saving this rule, press deduplicate button.
Once you press the deduplicate button, you are taken to the duplicates.
Field cleaning rules are to clean the field. In field cleaning rules, you can tick the required columns and go ahead with creating field cleaning rules.
First , you have to create a new rule. So press the create button.
Once you click the create button . You will get a new window
After filling up the details , press the save button.
After pressing clean button , it will shows the contact names.
if we press the validate button for any record names listed here. It trims the space between the names. For example, here Record Id with 59 is selected.
After clicking validate, then the record name will be seen like the image below
In conclusion, this is how Data Cleaning App in Odoo 14 Enterprise works.